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(); } }
static void DoCommitInstall(System.Configuration.Install.Installer installer) { Hashtable savedData = new Hashtable(); try { installer.Install(savedData); } catch (SecurityException ex) { Assert.Inconclusive("In order to run the tests, please run Visual Studio as Administrator.\r\n{0}", ex.ToString()); } installer.Commit(savedData); }
private IEnumerable<KeyValuePair<string, long>> DoDelete(LocalDeleteDatabase db, BackendManager backend, IEnumerable<IRemoteVolume> deleteableVolumes, ref System.Data.IDbTransaction transaction) { // Mark all volumes as disposable foreach(var f in deleteableVolumes) db.UpdateRemoteVolume(f.Name, RemoteVolumeState.Deleting, f.Size, f.Hash, transaction); // Before we commit the current state, make sure the backend has caught up backend.WaitForEmpty(db, transaction); if (!m_options.Dryrun) { transaction.Commit(); transaction = db.BeginTransaction(); } return PerformDelete(backend, db.GetDeletableVolumes(deleteableVolumes, transaction)); }
static void DoCommitInstall(System.Configuration.Install.Installer installer) { Hashtable savedData = new Hashtable(); installer.Install(savedData); installer.Commit(savedData); }
public void DoRun(Database.LocalDeleteDatabase db, ref System.Data.IDbTransaction transaction, bool hasVerifiedBacked, bool forceCompact) { using(var backend = new BackendManager(m_backendurl, m_options, m_result.BackendWriter, db)) { if (!hasVerifiedBacked && !m_options.NoBackendverification) FilelistProcessor.VerifyRemoteList(backend, m_options, db, m_result.BackendWriter); var filesetNumbers = db.FilesetTimes.Zip(Enumerable.Range(0, db.FilesetTimes.Count()), (a, b) => new Tuple<long, DateTime>(b, a.Value)); var toDelete = m_options.GetFilesetsToDelete(db.FilesetTimes.Select(x => x.Value).ToArray()); if (toDelete != null && toDelete.Length > 0) m_result.AddMessage(string.Format("Deleting {0} remote fileset(s) ...", toDelete.Length)); var lst = db.DropFilesetsFromTable(toDelete, transaction).ToArray(); foreach(var f in lst) db.UpdateRemoteVolume(f.Key, RemoteVolumeState.Deleting, f.Value, null, transaction); if (!m_options.Dryrun) { transaction.Commit(); transaction = db.BeginTransaction(); } foreach(var f in lst) { if (m_result.TaskControlRendevouz() == TaskControlState.Stop) { backend.WaitForComplete(db, transaction); return; } if (!m_options.Dryrun) backend.Delete(f.Key, f.Value); else m_result.AddDryrunMessage(string.Format("Would delete remote fileset: {0}", f.Key)); } backend.WaitForComplete(db, transaction); var count = lst.Length; if (!m_options.Dryrun) { if (count == 0) m_result.AddMessage("No remote filesets were deleted"); else m_result.AddMessage(string.Format("Deleted {0} remote fileset(s)", count)); } else { if (count == 0) m_result.AddDryrunMessage("No remote filesets would be deleted"); else m_result.AddDryrunMessage(string.Format("{0} remote fileset(s) would be deleted", count)); if (count > 0 && m_options.Dryrun) m_result.AddDryrunMessage("Remove --dry-run to actually delete files"); } if (!m_options.NoAutoCompact && (forceCompact || (toDelete != null && toDelete.Length > 0))) { m_result.CompactResults = new CompactResults(m_result); new CompactHandler(m_backendurl, m_options, (CompactResults)m_result.CompactResults).DoCompact(db, true, ref transaction); } m_result.SetResults( from n in filesetNumbers where toDelete.Contains(n.Item2) select n, m_options.Dryrun); } }
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(); } }