public static List <RequestForUnlockingBO> GetRequestUnlockingList(int BranchID, int ModuleType, bool blnShowCancel, bool blnAllBranch)
{
var dbUtil = new DatabaseManager();
var MCs = new List <RequestForUnlockingBO>();
using (SqlConnection conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spGetRequestUnlockingList";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@intIDMasLocation", SqlDbType.SmallInt).Value = BranchID;
cmd.Parameters.AddWithValue("@intIDMasModuleLocking", SqlDbType.SmallInt).Value = ModuleType;
cmd.Parameters.AddWithValue("@blnShowCancel", SqlDbType.Bit).Value = blnShowCancel;
cmd.Parameters.AddWithValue("@blnAllBranch", SqlDbType.Bit).Value = blnAllBranch;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var mc = new RequestForUnlockingBO
{
ID = object.ReferenceEquals(reader["ID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["ID"]),
intIDMasLocation = object.ReferenceEquals(reader["intIDMasLocation"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasLocation"]),
intIDMasModuleLocking = object.ReferenceEquals(reader["intIDMasModuleLocking"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasModuleLocking"]),
strModuleLocking = object.ReferenceEquals(reader["strModuleLocking"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strModuleLocking"]),
strRequestor = object.ReferenceEquals(reader["strRequestor"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strRequestor"]),
datRequest = object.ReferenceEquals(reader["datRequest"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datRequest"]),
strRequestNo = object.ReferenceEquals(reader["strRequestNo"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strRequestNo"]),
datFrom = object.ReferenceEquals(reader["datFrom"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datFrom"]),
datTo = object.ReferenceEquals(reader["datTo"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datTo"]),
intIDMasUnlockingReason = object.ReferenceEquals(reader["intIDMasUnlockingReason"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDMasUnlockingReason"]),
strReason = object.ReferenceEquals(reader["strReason"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strReason"]),
datApprove = object.ReferenceEquals(reader["datApprove"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datApprove"]),
datExpire = object.ReferenceEquals(reader["datExpire"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datExpire"]),
strStatus = object.ReferenceEquals(reader["strStatus"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strStatus"]),
strApprover = object.ReferenceEquals(reader["strApprover"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strApprover"]),
blnApprove = object.ReferenceEquals(reader["blnApprove"], DBNull.Value) ? 0 : Convert.ToInt32(reader["blnApprove"]),
blnCancel = object.ReferenceEquals(reader["blnCancel"], DBNull.Value) ? 0 : Convert.ToInt32(reader["blnCancel"])
};
MCs.Add(mc);
}
return(MCs);
}
}
}
}
public static string ManageRequestForUnlocking(NameValueCollection querystring)
{
var r = new RequestForUnlockingBO();
UserProfile objUserProfile = WebCommon.GetUserProfile();
int ID;
DateTime dat;
r.ID = int.TryParse(querystring.Get("ID"), out ID) ? ID : 0;
r.intIDMasLocation = int.TryParse(querystring.Get("intIDMasLocation"), out ID) ? ID : 0;
r.intIDMasModuleLocking = int.TryParse(querystring.Get("intIDMasModuleLocking"), out ID) ? ID : 0;
r.strRequestNo = querystring.Get("strRequestNo");
r.intIDSecUser = Convert.ToInt32(objUserProfile.UserId);
r.datFrom = DateTime.TryParse(querystring.Get("datFrom"), out dat) ? dat.ToShortDateString() : string.Empty;
r.datTo = DateTime.TryParse(querystring.Get("datTo"), out dat) ? dat.ToShortDateString() : string.Empty;
r.intIDMasUnlockingReason = int.TryParse(querystring.Get("intIDMasUnlockingReason"), out ID) ? ID : 0;
string strMode = querystring.Get("strMode");
string param = WebCommon.ToXML(r);
return(RequestForUnlockingDAL.ManageRequestForUnlocking(param, strMode));
}
