Exemple #1
0
    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();
        }
    }
Exemple #2
0
    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();
        }
    }
Exemple #3
0
    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();
        }
    }
Exemple #5
0
    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();
        }
    }
Exemple #7
0
    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);
 }
Exemple #11
0
        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);
			}
        }
Exemple #12
0
    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();
        }
    }
Exemple #13
0
    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();
        }
    }