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();
        }
    }
        public static void Rollback_Without_Closing_Connection(System.Data.SqlClient.SqlTransaction i_trans)
        {
            try
            {
                i_trans.Rollback();
            }
            catch
            {

            }
        }
Exemple #9
0
 public static void SafeTransRollback(System.Data.SqlServerCe.SqlCeTransaction trans)
 {
     try
     {
         trans.Rollback();
     }
     catch (System.InvalidOperationException)
     {
     }
 }
Exemple #10
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 #11
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();
        }
    }