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));
}
