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