Esempio n. 1
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();
        }
    }