public int InsertUserOfficeAccess(UserOfficeAccess theUserOfficeAccess) { int ReturnValue = 0; SqlCommand InsertCommand = new SqlCommand(); InsertCommand.CommandType = CommandType.StoredProcedure; InsertCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; InsertCommand.Parameters.Add(GetParameter("@UserID", SqlDbType.Int, theUserOfficeAccess.UserID)); InsertCommand.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, theUserOfficeAccess.OfficeID)); InsertCommand.Parameters.Add(GetParameter("@CompanyID", SqlDbType.Int, theUserOfficeAccess.CompanyID)); InsertCommand.Parameters.Add(GetParameter("@CanAccessAllOffices", SqlDbType.Bit, theUserOfficeAccess.CanAccessAllOffices)); if (theUserOfficeAccess.EffectiveDateFrom != null) { InsertCommand.Parameters.Add(GetParameter("@EffectiveDateFrom", SqlDbType.VarChar, theUserOfficeAccess.EffectiveDateFrom)); } if (theUserOfficeAccess.EffectiveDateTo != null) { InsertCommand.Parameters.Add(GetParameter("@EffectiveDateTo", SqlDbType.VarChar, theUserOfficeAccess.EffectiveDateTo)); } InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); InsertCommand.CommandText = "pADM_UsersOfficewise_Insert"; ExecuteStoredProcedure(InsertCommand); ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString()); return(ReturnValue); }
public static List <UserOfficeAccess> GetUserListOfficewiseByUserID(int UserID) { List <UserOfficeAccess> UserOfficeList = new List <UserOfficeAccess>(); DataTable UserOfficeTable = UserOfficeAccessDataAccess.GetInstance.GetUserListOfficewiseByUserID(UserID); foreach (DataRow dr in UserOfficeTable.Rows) { UserOfficeAccess TheUserOffice = DataRowToObject(dr); UserOfficeList.Add(TheUserOffice); } return(UserOfficeList); }
public static UserOfficeAccess DataRowToObject(DataRow dr) { UserOfficeAccess TheUserOfficeAccess = new UserOfficeAccess(); TheUserOfficeAccess.UserOfficewiseID = int.Parse(dr["UserOfficewiseID"].ToString()); TheUserOfficeAccess.UserID = int.Parse(dr["UserID"].ToString()); TheUserOfficeAccess.UserName = dr["UserName"].ToString(); TheUserOfficeAccess.UserType = dr["UserType"].ToString(); TheUserOfficeAccess.UserReferenceID = int.Parse(dr["UserReferenceID"].ToString()); TheUserOfficeAccess.UserReferenceName = dr["UserReferenceName"].ToString(); TheUserOfficeAccess.OfficeID = int.Parse(dr["OfficeID"].ToString()); TheUserOfficeAccess.OfficeName = dr["OfficeName"].ToString(); TheUserOfficeAccess.CompanyID = int.Parse(dr["CompanyID"].ToString()); TheUserOfficeAccess.CompanyName = dr["CompanyName"].ToString(); TheUserOfficeAccess.CompanyAliasName = dr["CompanyAliasName"].ToString(); TheUserOfficeAccess.CanAccessAllOffices = bool.Parse(dr["CanAccessAllOffices"].ToString()); TheUserOfficeAccess.EffectiveDateFrom = DateTime.Parse(dr["EffectiveDateFrom"].ToString()).ToString(MicroConstants.DateFormat); if (!string.IsNullOrEmpty(dr["EffectiveDateTo"].ToString())) { TheUserOfficeAccess.EffectiveDateTo = DateTime.Parse(dr["EffectiveDateTo"].ToString()).ToString(MicroConstants.DateFormat); } return(TheUserOfficeAccess); }
public int InsertUserOfficeAccess(UserOfficeAccess theUserOfficeAccess) { return(UserOfficeAccessIntegration.InsertUserOfficeAccess(theUserOfficeAccess)); }
public static int InsertUserOfficeAccess(UserOfficeAccess theUserOfficeAccess) { return(UserOfficeAccessDataAccess.GetInstance.InsertUserOfficeAccess(theUserOfficeAccess)); }