public static List <ModLockModuleForm> GetModuleLockingGridData(int branchID, int modLock)
{
var dbUtil = new DatabaseManager();
var modLockModuleFormList = new List <ModLockModuleForm>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spGetModuleLockingGridData";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@intBranchID", branchID);
cmd.Parameters.AddWithValue("@intModLock", modLock);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var modLockModuleForm = new ModLockModuleForm {
ID = ReferenceEquals(reader["ID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["ID"]),
BranchName = ReferenceEquals(reader["strBranchName"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strBranchName"]),
ModuleTypeID = ReferenceEquals(reader["intIDModuleType"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDModuleType"]),
ModuleTypeName = ReferenceEquals(reader["strModuleName"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strModuleName"]),
DateFrom = ReferenceEquals(reader["datDateFrom"], DBNull.Value) ? string.Empty : Convert.ToString(reader["datDateFrom"]),
DateTo = ReferenceEquals(reader["datDateTo"], DBNull.Value) ? string.Empty : Convert.ToString(reader["datDateTo"]),
Username = ReferenceEquals(reader["strUserName"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strUserName"]),
UserID = ReferenceEquals(reader["intIDSecUsers"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intIDSecUsers"]),
BlnLockStatus = ReferenceEquals(reader["BlnLockStatus"], DBNull.Value) ? 0 : Convert.ToInt32(reader["BlnLockStatus"])
};
modLockModuleFormList.Add(modLockModuleForm);
}
return(modLockModuleFormList);
}
}
}
}
public static string Manage(NameValueCollection querystring)
{
int intParser;
UserProfile userProfile = WebCommon.GetUserProfile();
var ModLockModuleForm = new ModLockModuleForm
{
ID = int.TryParse(querystring.Get("ModuleLockingID"), out intParser) ? intParser : 0,
BranchID = int.TryParse(querystring.Get("BranchID"), out intParser) ? intParser : 0,
ModuleTypeID = int.TryParse(querystring.Get("ModuleTypeID"), out intParser) ? intParser : 0,
UserID = userProfile.UserId,
DateFrom = querystring.Get("DateFrom"),
DateTo = querystring.Get("DateTo"),
BlnLockStatus = int.TryParse(querystring.Get("LockStatusID"), out intParser) ? intParser : 0
};
string transType = querystring.Get("transType");
string param = WebCommon.ToXML(ModLockModuleForm);
return(ModuleLockingFormDAL.ManageModuleLockingForm(param, transType));
}
