How to rollback and commit transection in Asp.net MVC
Example Of Rollback And Commit Transection In Asp.Net MVC ...
using (var _Context = new IRISDevMultiTenantEntities1())
{
using (DbContextTransaction dbTransection = _Context.Database.BeginTransaction()) // Create a object of DbContextTransaction
{
try
{
tblCompany obj = new tblCompany();
obj.Company_Name = CompanyName;
obj.Logo_Filename = null;
obj.Date_Created = DateTime.Now;
obj.Date_Last_Update = DateTime.Now;
obj.Last_Update_By_ID = Person_ID;
obj.IsPaid = false;
obj.HasAcceptedTermsandConditions = false;
_Context.tblCompanies.Add(obj);
_Context.SaveChanges();
var GetCreatedCompanyId = _Context.tblCompanies.Where(x => x.Company_Name == CompanyName && x.Last_Update_By_ID == Person_ID).FirstOrDefault();
if (GetCreatedCompanyId != null)
{
tblCompany_System_User tblCompany_System_User = new tblCompany_System_User();
tblCompany_System_User.Company_ID = GetCreatedCompanyId.Company_ID;
tblCompany_System_User.System_User_ID = SystemUser_ID;
tblCompany_System_User.IsPrimary = 1;
tblCompany_System_User.Start_Date = DateTime.Now;
tblCompany_System_User.End_Date = DateTime.MaxValue;
_Context.tblCompany_System_User.Add(tblCompany_System_User);
_Context.SaveChanges();
}
dbTransection.Commit(); // Commit Transection
}
catch (Exception ex)
{
dbTransection.Rollback(); // If Any type of exception arise then Rollback Transection
Utility.SendBugReport(ex, UserName, RequestURL);
}
}
}
Comments
Post a Comment