public int UpdateUserCompanyAccess(UserCompanyAccess theUserCompanyAccess) { int ReturnValue = 0; SqlCommand UpdateCommand = new SqlCommand(); UpdateCommand.CommandType = CommandType.StoredProcedure; UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; UpdateCommand.Parameters.Add(GetParameter("@UserID", SqlDbType.Int, theUserCompanyAccess.UserID)); UpdateCommand.Parameters.Add(GetParameter("@CompanyID", SqlDbType.Int, theUserCompanyAccess.CompanyID)); UpdateCommand.Parameters.Add(GetParameter("@RoleID", SqlDbType.Int, theUserCompanyAccess.RoleID)); if (theUserCompanyAccess.EffectiveDateFrom != null) { UpdateCommand.Parameters.Add(GetParameter("@EffectiveDateFrom", SqlDbType.VarChar, theUserCompanyAccess.EffectiveDateFrom)); } if (theUserCompanyAccess.EffectiveDateTo != null) { UpdateCommand.Parameters.Add(GetParameter("@EffectiveDateTo", SqlDbType.VarChar, theUserCompanyAccess.EffectiveDateTo)); } UpdateCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); UpdateCommand.CommandText = "pADM_UsersCompanywise_Update"; ExecuteStoredProcedure(UpdateCommand); ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString()); return(ReturnValue); }
public static UserCompanyAccess DataRowToObject(DataRow dr) { UserCompanyAccess TheUserCompanyAccess = new UserCompanyAccess(); TheUserCompanyAccess.UserCompanywiseID = int.Parse(dr["UserCompanywiseID"].ToString()); TheUserCompanyAccess.UserID = int.Parse(dr["UserID"].ToString()); TheUserCompanyAccess.UserName = dr["UserName"].ToString(); TheUserCompanyAccess.UserType = dr["UserType"].ToString(); TheUserCompanyAccess.UserReferenceID = int.Parse(dr["UserReferenceID"].ToString()); TheUserCompanyAccess.UserReferenceName = dr["UserReferenceName"].ToString(); TheUserCompanyAccess.CompanyID = int.Parse(dr["CompanyID"].ToString()); TheUserCompanyAccess.CompanyName = dr["CompanyName"].ToString(); TheUserCompanyAccess.CompanyAliasName = dr["CompanyAliasName"].ToString(); TheUserCompanyAccess.CompanyCode = dr["CompanyCode"].ToString(); TheUserCompanyAccess.RoleID = int.Parse(dr["RoleID"].ToString()); TheUserCompanyAccess.RoleDescription = dr["RoleDescription"].ToString(); TheUserCompanyAccess.EffectiveDateFrom = DateTime.Parse(dr["EffectiveDateFrom"].ToString()).ToString(MicroConstants.DateFormat); if (!string.IsNullOrEmpty(dr["EffectiveDateTo"].ToString())) { TheUserCompanyAccess.EffectiveDateTo = DateTime.Parse(dr["EffectiveDateTo"].ToString()).ToString(MicroConstants.DateFormat); } TheUserCompanyAccess.DateAdded = DateTime.Parse(dr["DateAdded"].ToString()).ToString(MicroConstants.DateFormat); return(TheUserCompanyAccess); }
public static List <UserCompanyAccess> GetUserCompanyWiseByUserID(int UserID) { List <UserCompanyAccess> UserCompanyAccessList = new List <UserCompanyAccess>(); DataTable UserCompanyAccessTable = UserCompanyAccessDataAccess.GetInstance.GetUserCompanyWiseByUserID(UserID); foreach (DataRow dr in UserCompanyAccessTable.Rows) { UserCompanyAccess TheUserCompanyAccessList = DataRowToObject(dr); UserCompanyAccessList.Add(TheUserCompanyAccessList); } return(UserCompanyAccessList); }
public int UpdateUserCompanyAccess(UserCompanyAccess theUserCompanyAccess) { return(UserCompanyAccessIntegration.UpdateUserCompanyAccess(theUserCompanyAccess)); }
public static int UpdateUserCompanyAccess(UserCompanyAccess theUserCompanyAccess) { return(UserCompanyAccessDataAccess.GetInstance.UpdateUserCompanyAccess(theUserCompanyAccess)); }