public int SaveUser(UserUI objUI, System.Data.SqlClient.SqlTransaction objTrans) { int UserID = 0; bool flagTransation = true; UserDB objDB = new UserDB(); objDB.FullName = objUI.FullName; objDB.EmployeeCode = objUI.EmployeeCode; objDB.EmailID = objUI.EmailID; objDB.RoleID = objUI.RoleID; objDB.LoginID = objUI.LoginID; objDB.Password = objUI.Password; objDB.PhoneNo = objUI.PhoneNo; objDB.MobileNo = objUI.MobileNo; objDB.PermanentAddress = objUI.PermanentAddress; objDB.CurrentAddress= objUI.CurrentAddress; objDB.DateOfJoing = objUI.DateOfJoing; objDB.CheckID = objUI.CheckID; objDB.Id = objUI.Id; objDB.UserTypeID = objUI.UserTypeID; objDB.LevelID = objUI.LevelID; objDB.IsActive = objUI.IsActive; DataAccessLayer objDataAccess = new DataAccessLayer(); try { if (objTrans == null) { flagTransation = false; objDataAccess.GetConnection.Open(); SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction(); objTrans = objTransaction; } UserManager objManager = new UserManager(); UserID = objManager.SaveUser(objDB, objTrans); if (!flagTransation) objTrans.Commit(); return UserID; } catch (Exception ex) { if (!flagTransation) objTrans.Rollback(); throw ex; } finally { objDataAccess.GetConnection.Close(); } }
public int SaveDealer(DealerUI objUI, System.Data.SqlClient.SqlTransaction objTrans) { int DealerID = 0; bool flagTransation = true; DealerDB objDB = new DealerDB(); objDB.Code = objUI.Code; objDB.Dealer = objUI.Dealer; objDB.RegionID = objUI.RegionID; objDB.IsActive = objUI.IsActive; objDB.Id = objUI.Id; objDB.CheckID = objUI.CheckID; objDB.City = objUI.City; objDB.InstallerName = objUI.InstallerName; objDB.IsOperatingDealer = objUI.IsOperatingDealer; DataAccessLayer objDataAccess = new DataAccessLayer(); try { if (objTrans == null) { flagTransation = false; objDataAccess.GetConnection.Open(); SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction(); objTrans = objTransaction; } DealerManager objManager = new DealerManager(); DealerID = objManager.SaveDealer(objDB, objTrans); if (!flagTransation) objTrans.Commit(); return DealerID; } catch (Exception ex) { if (!flagTransation) objTrans.Rollback(); throw ex; } finally { objDataAccess.GetConnection.Close(); } }
public int SaveBudget(BudgetUI objUI, System.Data.SqlClient.SqlTransaction objTrans) { int ID = 0; bool flagTransation = true; BudgetDB objDB = new BudgetDB(); objDB.FinancialYear = objUI.FinancialYear; objDB.QuarterID = objUI.QuarterID; objDB.Budget = objUI.Budget; objDB.ModelGroupID = objUI.ModelGroupID; objDB.ModelCategoryID = objUI.ModelCategoryID; objDB.ModelClutchID = objUI.ModelClutchID; objDB.ModelSpecialID = objUI.ModelSpecialID; DataAccessLayer objDataAccess = new DataAccessLayer(); try { if (objTrans == null) { flagTransation = false; objDataAccess.GetConnection.Open(); SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction(); objTrans = objTransaction; } BudgetManager objManager = new BudgetManager(); ID = objManager.SaveBudget(objDB, objTrans); if (!flagTransation) objTrans.Commit(); return ID; } catch (Exception ex) { if (!flagTransation) objTrans.Rollback(); throw ex; } finally { objDataAccess.GetConnection.Close(); } }
public int SaveReworkCost(ReworkCostUI objUI, System.Data.SqlClient.SqlTransaction objTrans) { int ID = 0; bool flagTransation = true; ReworkCostDB objDB = new ReworkCostDB(); objDB.GroupID = objUI.GroupID; objDB.MonthID = objUI.MonthID; objDB.YearID = objUI.YearID; objDB.ReworkCost_I_Year = objUI.ReworkCost_I_Year; objDB.ReworkCost_II_Year = objUI.ReworkCost_II_Year; objDB.ModelCategoryID = objUI.ModelCategoryID; objDB.HMR_Range = objUI.HMR_Range; DataAccessLayer objDataAccess = new DataAccessLayer(); try { if (objTrans == null) { flagTransation = false; objDataAccess.GetConnection.Open(); SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction(); objTrans = objTransaction; } ReworkCostManager objManager = new ReworkCostManager(); ID=objManager.SaveReworkCost(objDB, objTrans); if (!flagTransation) objTrans.Commit(); return ID; } catch (Exception ex) { if (!flagTransation) objTrans.Rollback(); throw ex; } finally { objDataAccess.GetConnection.Close(); } }
public int Save(RoleUI objUI, System.Data.SqlClient.SqlTransaction objTrans) { int RoleID = 0; bool flagTransation = true; RoleDB objDB = new RoleDB(); objDB.Role = objUI.Role; objDB.IsActive = objUI.IsActive; objDB.Id = objUI.Id; objDB.CheckID = objUI.CheckID; DataAccessLayer objDataAccess = new DataAccessLayer(); try { if (objTrans == null) { flagTransation = false; objDataAccess.GetConnection.Open(); SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction(); objTrans = objTransaction; } RoleManager objManager = new RoleManager(); RoleID=objManager.SaveRole(objDB, objTrans); if (!flagTransation) objTrans.Commit(); return RoleID; } catch (Exception ex) { if (!flagTransation) objTrans.Rollback(); throw ex; } finally { objDataAccess.GetConnection.Close(); } }
public int Save( PriviledgeUI objUI, System.Data.SqlClient.SqlTransaction objTrans) { int PriviledgeID = 0; bool flagTransation = true; PriviledgeDB objDB = new PriviledgeDB(); objDB.RoleID = objUI.RoleID; objDB.FormID = objUI.FormID; objDB.viewing = objUI.viewing; DataAccessLayer objDataAccess = new DataAccessLayer(); try { if (objTrans == null) { flagTransation = false; objDataAccess.GetConnection.Open(); SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction(); objTrans = objTransaction; } PriviledgeManager objManager = new PriviledgeManager(); PriviledgeID = objManager.Save(objDB, objTrans); if (!flagTransation) objTrans.Commit(); return PriviledgeID; } catch (Exception ex) { if (!flagTransation) objTrans.Rollback(); throw ex; } finally { objDataAccess.GetConnection.Close(); } }
public int CheckMaterial(ModelUI objUI, System.Data.SqlClient.SqlTransaction objTrans) { int Flag = 0; bool flagTransation = true; ModelDB objDB = new ModelDB(); objDB.Material = objUI.Material; DataAccessLayer objDataAccess = new DataAccessLayer(); try { if (objTrans == null) { flagTransation = false; objDataAccess.GetConnection.Open(); SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction(); objTrans = objTransaction; } ModelManager objManager = new ModelManager(); Flag = objManager.CheckMaterial(objDB, objTrans); if (!flagTransation) objTrans.Commit(); return Flag; } catch (Exception ex) { if (!flagTransation) objTrans.Rollback(); throw ex; } finally { objDataAccess.GetConnection.Close(); } }
public static void Rollback_Without_Closing_Connection(System.Data.SqlClient.SqlTransaction i_trans) { try { i_trans.Rollback(); } catch { } }
public static void SafeTransRollback(System.Data.SqlServerCe.SqlCeTransaction trans) { try { trans.Rollback(); } catch (System.InvalidOperationException) { } }
public int SaveModelDetail(ModelUI objUI, System.Data.SqlClient.SqlTransaction objTrans) { int Flag = 0; bool flagTransation = true; ModelDB objDB = new ModelDB(); objDB.Material = objUI.Material; objDB.GroupID = objUI.GroupID; objDB.ModelCategoryID = objUI.ModelCategoryID; objDB.ModelSpecialID = objUI.ModelSpecialID; objDB.ClutchTypeID = objUI.ClutchTypeID; objDB.Description = objUI.Description; DataAccessLayer objDataAccess = new DataAccessLayer(); try { if (objTrans == null) { flagTransation = false; objDataAccess.GetConnection.Open(); SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction(); objTrans = objTransaction; } ModelManager objManager = new ModelManager(); Flag = objManager.SaveModelDetail(objDB, objTrans); if (!flagTransation) objTrans.Commit(); return Flag; } catch (Exception ex) { if (!flagTransation) objTrans.Rollback(); throw ex; } finally { objDataAccess.GetConnection.Close(); } }
public int SaveUserDetail(UserUI objUI, System.Data.SqlClient.SqlTransaction objTrans) { int UserID = 0; bool flagTransation = true; UserDB objDB = new UserDB(); objDB.UserID = objUI.UserID; //objDB.LevelID = objUI.LevelID; objDB.dRegionID = objUI.dRegionID; objDB.ReportsToID = objUI.ReportsToID; objDB.CheckID = objUI.CheckID; DataAccessLayer objDataAccess = new DataAccessLayer(); try { if (objTrans == null) { flagTransation = false; objDataAccess.GetConnection.Open(); SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction(); objTrans = objTransaction; } UserManager objManager = new UserManager(); UserID = objManager.SaveUserDetail(objDB, objTrans); if (!flagTransation) objTrans.Commit(); return UserID; } catch (Exception ex) { if (!flagTransation) objTrans.Rollback(); throw ex; } finally { objDataAccess.GetConnection.Close(); } }