Transaction on a form with "save" button from toolstrip... posible?

StrataFrame Forum

Back

Transaction on a form with "save" button from toolstrip... posible?

Author	Message
Fabian R Silva, -	Fabian R Silva, - posted 13 Years Ago Topic Details Share Topic
Group: StrataFrame Users Posts: 153, Visits: 1.2K	Greetings Strataframe Forum. I'm happy to be using StrataFrame again . my boss has renewed my license today, because that for one or another reasons we had to postpone the development of our system until this month after a long long time of inactivity. where... I will start with a question to wam up engines I'm building a "base" form to inherit from this in all my system's forms later. I see that the "Save" method of the form doen't allow to make a transaction automatically with all the BOs that are marked with "incluideInFormSave", then I suppose that if I have 2 BOs (Parent-Child) and the child have errors the Parent BO be saved and the child not.... (this is not transactional) I overrides the form's Save method and wrap the base save method with a transaction... it appears to work but I not sure if I doing it well. the code that I used is in the end of this post... I'm doing this OK or there is a better and automated way setting a property or something else that do it automatically? Thanks, Fabian. This is the wrapper code: /// <summary> /// Saves the changes of all business objects on the form marked with IncludeInFormSave. /// </summary> /// <returns></returns> public override SaveUndoResult Save() { if (!SaveWithTransaction) return base.Save(false, ""); //if not save with transaction call base routine to save each BO and return... // ---------------------------------------------------------------------------------- // If this form SaveWithTransaction continues here... SaveUndoResult saveUndoResult = SaveUndoResult.Success; //-- Add a try around the transaction processing // This enables the process to call TransactionRollback() // if anything bad happens during the transaction process. try { //-- Start the transaction BusinessLayer.TransactionBegin(DataSourceKey, IsolationLevel.ReadCommitted); //-- Save the business objects on the transaction saveUndoResult = base.Save(SaveWithTransaction); //<-- here I call that all the BOs be saved in the started transaction (not yet commited to DB) //-- When business objects are saved on the transaction, the pending changes to their internal DataTables are NOT saved until TransactionCommit() is called... // Call transaction commit and queries AND accept the pending changes on all of the business objects // that participated in the transaction. BusinessLayer.TransactionCommit(DataSourceKey); // IF the COMMIT IS succefull this line CLOSE the form WITH a DIALOGresult.OK, otherwise CATCH block IS executed AND rethrow the DB exception.... CloseFormWithDialogResult(DialogResult.OK); } catch (Exception ex) { //-- If an exception occurs during the saving of the records, then // abort the transaction. BusinessLayer.TransactionRollback(DataSourceKey); throw; } return saveUndoResult; } Tags Form Save Transactions
	Reply Like 3
Fabian R Silva, -	Fabian R Silva, - posted 13 Years Ago Post Details Share Post
Group: StrataFrame Users Posts: 153, Visits: 1.2K	somebody?
	Reply Like 2
Edhy Rijo	E Edhy Rijo posted 13 Years Ago Post Details Share Post
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	Hi Fabian, I am not a C# developer, but your code looks just fine. One thing to have in may is that when you have related business objects, if you issue a Save() in the child BO, this will automatically trigger a Save() in the parent in order to get the Parent PK Value to be saved in the child BO. I don't recall if that functionality can be overwritten but just in case, in your Save() method make sure you are saving the Parent BO first, then all the child BOs. Edhy Rijo
	Reply Like 2
Fabian R Silva, -	Fabian R Silva, - posted 12 Years Ago Post Details Share Post
Group: StrataFrame Users Posts: 153, Visits: 1.2K	thanks for the reply and advice on child BOs, As I'm using a wrapper and calling base.Save() like the overrided method, I suppose that it have to work as expected and the BO will manage relationships and save all BOs automatically. the diference is that I calling a begin and commit (or rollback) transaction in the override to make it work as a transaction, anything else works as usually using base.Save(). If I encounter problems later will report it in the forum asking for possible solutions. Kind regards and hope a good 2012 for you, all the forum users and all the world Edhy Rijo (11/8/2011) Hi Fabian, I am not a C# developer, but your code looks just fine. One thing to have in may is that when you have related business objects, if you issue a Save() in the child BO, this will automatically trigger a Save() in the parent in order to get the Parent PK Value to be saved in the child BO. I don't recall if that functionality can be overwritten but just in case, in your Save() method make sure you are saving the Parent BO first, then all the child BOs.
	Reply Like 2