public static UserIncharge DataRowToObject(DataRow dr)
{
UserIncharge TheUserIncharge = new UserIncharge();
TheUserIncharge.UserInchargeID = int.Parse(dr["UserInchargeID"].ToString());
TheUserIncharge.ParentUserID = int.Parse(dr["ParentUserID"].ToString());
TheUserIncharge.InChargeUserID = int.Parse(dr["InChargeUserID"].ToString());
TheUserIncharge.EffectiveDateFrom = DateTime.Parse(dr["EffectiveDateFrom"].ToString()).ToString(MicroConstants.DateFormat);
TheUserIncharge.EffectiveDateTo = DateTime.Parse(dr["EffectiveDateTo"].ToString()).ToString(MicroConstants.DateFormat);
TheUserIncharge.ReferenceLetterNumber = dr["ReferenceLetterNumber"].ToString();
TheUserIncharge.ReferenceLetterDate = DateTime.Parse(dr["ReferenceLetterDate"].ToString()).ToString(MicroConstants.DateFormat);
return(TheUserIncharge);
}
public int InsertUserIncharge(UserIncharge theUserIncharge)
{
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("@ParentUserID", SqlDbType.Int, theUserIncharge.ParentUserID));
InsertCommand.Parameters.Add(GetParameter("@InChargeUserID", SqlDbType.Int, theUserIncharge.InChargeUserID));
InsertCommand.Parameters.Add(GetParameter("@EffectiveDateFrom", SqlDbType.VarChar, theUserIncharge.EffectiveDateFrom));
InsertCommand.Parameters.Add(GetParameter("@EffectiveDateTo", SqlDbType.VarChar, theUserIncharge.EffectiveDateTo));
InsertCommand.Parameters.Add(GetParameter("@ReferenceLetterNumber", SqlDbType.VarChar, theUserIncharge.ReferenceLetterNumber));
InsertCommand.Parameters.Add(GetParameter("@ReferenceLetterDate", SqlDbType.VarChar, theUserIncharge.ReferenceLetterDate));
InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
InsertCommand.CommandText = "pADM_UsersIncharge_Insert";
ExecuteStoredProcedure(InsertCommand);
ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
public static int InsertUserIncharge(UserIncharge theUserIncharge)
{
return(USerProxyDataAccess.GetInstance.InsertUserIncharge(theUserIncharge));
}
public int InsertUserIncharge(UserIncharge theUserIncharge)
{
return(USerProxyIntegration.InsertUserIncharge(theUserIncharge));
}
