// GET
public ActionResult MaintenancePolicy(int? MaintenancePolicyID)
{
BLCustomer MaintenanceBL = new BLCustomer();
tblMaintenancePolicy tblmaintenance = new tblMaintenancePolicy();
tblmaintenance = MaintenanceBL.GetMaintenance(MaintenancePolicyID.Value);
if (MaintenancePolicyID.Value == 0)
tblmaintenance.ScheduledStartDate = DateTime.Now;
ViewBag.WeekOfMonths = LookUpData.GetWeekOfMonth();
ViewBag.WeekOfDay = LookUpData.GetWeekOfDay();
ViewBag.time = LookUpData.GetFXTime();
ViewBag.MonthOfDay = LookUpData.GetMonthOfDay();
ViewBag.TimeZones = LookUpData.GetTimeZone();
ViewBag.ScheduleTypeM = LookUpData.GetScheduleType();
if (Request.IsAjaxRequest())
return PartialView("MaintenancePolicy", tblmaintenance);
else
return View("MaintenancePolicy", tblmaintenance);
}
public JsonResult MaintenancePolicy(tblMaintenancePolicy Manintenance)
{
try
{
BLCustomer customerBL = new BLCustomer();
Manintenance.CustomerID = SessionHelper.UserSession.CustomerID;
customerBL.SaveMaintenancePolicy(Manintenance);
}
catch
{
ModelState.AddModelError("", "Error occurred durung Customer Information save.");
return Json(new { errors = KeyValue.GetErrorsFromModelState(ViewData) });
}
return Json(new { success = true, Tab = "MP" });
}
// GET
public ActionResult MaintenancePolicy(int? MaintenancePolicyID)
{
BLCustomer MaintenanceBL = new BLCustomer();
tblMaintenancePolicy tblmaintenance = new tblMaintenancePolicy();
tblmaintenance = MaintenanceBL.GetMaintenance(MaintenancePolicyID.Value);
if (MaintenancePolicyID.Value == 0)
tblmaintenance.ScheduledStartDate = DateTime.Now;
List<KeyValue> lstKeyVal = new List<KeyValue>();
lstKeyVal.Add(new KeyValue() { Key = "Activity Name", Value = tblmaintenance.ActivityName });
lstKeyVal.Add(new KeyValue() { Key = "Define Regular Schedule", Value = tblmaintenance.ScheduleType.Name});
lstKeyVal.Add(new KeyValue() { Key = "Define Week Day (for weekly schedule)", Value = tblmaintenance.WeekOfDays.Name });
// lstKeyVal.Add(new KeyValue() { Key = "Define Month of Day (for Monthly Schedule)", Value = tblmaintenance.MonthOfDays.Name });
lstKeyVal.Add(new KeyValue()
{
Key = "Scheduled Time",
Value = tblmaintenance.ScheduledStartTime + " - " +
tblmaintenance.ScheduledEndTime + " " +
tblmaintenance.TimeZone.Name
});
lstKeyVal.Add(new KeyValue() { Key = "Start Date", Value = tblmaintenance.ScheduledStartDate.ToString("MM/dd/yyyy") });
if (Request.IsAjaxRequest())
return PartialView("Detail", lstKeyVal);
else
return View("Detail", lstKeyVal);
}
internal void FillDropDownList(ref List<tblMaintenancePolicy> Manitenancepoly, ref List<tblAccessPolicy> Accesspoly, ref List<tblAntiVirusPolicy> Antiviruspoly, ref List<tblBackUpPolicy> Backuppoly, ref List<tblPatchingPolicy> PatchingPoly, ref List<tbltoolInfomation> ToolInfoPoly)
{
int errorNum = 0;
string errorDesc = "";
DataAccess.resetParams();
DataAccess.addSqlParam("@ClientSiteDeviceID", ParameterDirection.Input, 16, MySqlDbType.Int32);
DataAccess.addSqlParam("@CustomerID", ParameterDirection.Input, 16, MySqlDbType.Int32, SessionHelper.UserSession.CustomerID);
DataSet ds = DataAccess.ExecuteDataSet(GET_CLIENT_SITE_DEVICE, ref errorNum, ref errorDesc);
Manitenancepoly = new List<tblMaintenancePolicy>();
Manitenancepoly.Add(new tblMaintenancePolicy() { MaintenancePolicyID = 0, ActivityName = "-- Select --" });
DataTable dttblmaintinance = ds.Tables[3];
if (dttblmaintinance != null && dttblmaintinance.Rows.Count > 0)
{
foreach (DataRow dPP in dttblmaintinance.Rows)
{
tblMaintenancePolicy tblmaintinance = new tblMaintenancePolicy();
tblmaintinance.MaintenancePolicyID = Common.ConvertToInt(dPP, "MaintenancePolicyID");
tblmaintinance.ActivityName = Common.ConvertToString(dPP, "ActivityName");
Manitenancepoly.Add(tblmaintinance);
}
}
ToolInfoPoly = new List<tbltoolInfomation>();
ToolInfoPoly.Add(new tbltoolInfomation() { ToolIDRT = 0, RMMTool ="-- Select --"});
DataTable dttbltoolinfomation = ds.Tables[1];
if (dttbltoolinfomation != null && dttbltoolinfomation.Rows.Count > 0)
{
// DataRow dTI = dttbltoolinfomation.Rows[1];
foreach (DataRow dTI in dttbltoolinfomation.Rows)
{
tbltoolInfomation toolInfo = new tbltoolInfomation();
toolInfo.ToolIDRT = Common.ConvertToInt(dTI, "ToolID");
toolInfo.RMMTool = Common.ConvertToString(dTI, "ToolInfomationName");
ToolInfoPoly.Add(toolInfo);
}
}
Accesspoly = new List<tblAccessPolicy>();
Accesspoly.Add(new tblAccessPolicy() { AccessPolicyID = 0, productname = "-- Select --" });
DataTable dttblAccpolicy = ds.Tables[4];
if (dttblAccpolicy != null && dttblAccpolicy.Rows.Count > 0)
{
foreach (DataRow dAP in dttblAccpolicy.Rows)
{
tblAccessPolicy tblaccess = new tblAccessPolicy();
tblaccess.AccessPolicyID = Common.ConvertToInt(dAP, "AccessPolicyID");
tblaccess.productname = Common.ConvertToString(dAP, "productname");
Accesspoly.Add(tblaccess);
}
}
PatchingPoly = new List<tblPatchingPolicy>();
PatchingPoly.Add(new tblPatchingPolicy() { PatchingPolicyIDWR = 0, PolicyNameND ="-- Select --"});
DataTable dttblPatchingpolicy = ds.Tables[2];
if (dttblPatchingpolicy != null && dttblPatchingpolicy.Rows.Count > 0)
{
// DataRow dTI = dttbltoolinfomation.Rows[1];
foreach (DataRow dPP in dttblPatchingpolicy.Rows)
{
tblPatchingPolicy tblpatch = new tblPatchingPolicy();
tblpatch.PatchingPolicyIDWR = Common.ConvertToInt(dPP, "PatchingPolicyID");
tblpatch.PolicyNameND = Common.ConvertToString(dPP, "PolicyNameND");
PatchingPoly.Add(tblpatch);
}
}
Antiviruspoly = new List<tblAntiVirusPolicy>();
Antiviruspoly.Add(new tblAntiVirusPolicy() { AntiVirusID = 0, PolicyName = "-- Select --" });
DataTable dttblAantivspolicy = ds.Tables[5];
if (dttblAantivspolicy != null && dttblAantivspolicy.Rows.Count > 0)
{
foreach (DataRow dAP in dttblAantivspolicy.Rows)
{
tblAntiVirusPolicy tblantivirus = new tblAntiVirusPolicy();
tblantivirus.AntiVirusID = Common.ConvertToInt(dAP, "AntiVirusID");
tblantivirus.PolicyName = Common.ConvertToString(dAP, "PolicyName");
Antiviruspoly.Add(tblantivirus);
}
}
Backuppoly = new List<tblBackUpPolicy>();
Backuppoly.Add(new tblBackUpPolicy() { BackUpPolicyID = 0, PolicyName = "-- Select --" });
DataTable dttblBackupspolicy = ds.Tables[6];
if (dttblBackupspolicy != null && dttblBackupspolicy.Rows.Count > 0)
{
foreach (DataRow dAP in dttblBackupspolicy.Rows)
{
tblBackUpPolicy tblbackup = new tblBackUpPolicy();
tblbackup.BackUpPolicyID = Common.ConvertToInt(dAP, "BackUpPolicyID");
tblbackup.PolicyName = Common.ConvertToString(dAP, "PolicyName");
Backuppoly.Add(tblbackup);
}
}
}
public List<tblMaintenancePolicy> GetMPIndex(int CustomerID, int pageNumber, int pageSize, int sortColumnIndex, string sortOrder, string searchText, ref int totalRecords)
{
int errorNum = 0;
string errorDesc = "";
DataAccess.resetParams();
DataAccess.addSqlParam("@oCustomerID", ParameterDirection.Input, 16, MySqlDbType.Int32, CustomerID);
DataAccess.addSqlParam("@pageNumber", ParameterDirection.Input, 16, MySqlDbType.Int32, pageNumber);
DataAccess.addSqlParam("@pageRecord", ParameterDirection.Input, 16, MySqlDbType.Int32, pageSize);
DataAccess.addSqlParam("@sortColumnIndex", ParameterDirection.Input, 16, MySqlDbType.Int32, sortColumnIndex);
DataAccess.addSqlParam("@searchOrder", ParameterDirection.Input, 4, MySqlDbType.VarChar, sortOrder);
DataAccess.addSqlParam("@searchText", ParameterDirection.Input, 100, MySqlDbType.VarChar, searchText);
DataSet ds = DataAccess.ExecuteDataSet(GET_MAINTENANCE, ref errorNum, ref errorDesc);
tblMaintenancePolicy maintenance = new tblMaintenancePolicy();
List<tblMaintenancePolicy> maintenances = new List<tblMaintenancePolicy>();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dtMaintenance = ds.Tables[0];
DataTable dtTotalRecords = ds.Tables[1];
totalRecords = Common.ConvertToInt(dtTotalRecords.Rows[0], "TotalRecords");
if (dtMaintenance != null && dtMaintenance.Rows.Count > 0)
{
foreach (DataRow dr in dtMaintenance.Rows)
{
maintenance = new tblMaintenancePolicy();
maintenance.WeekOfDays = new WeekOfDay();
maintenance.MonthOfDays = new MonthOfDay();
maintenance.TimeZone = new TimeZoneFX();
// maintenance.ScheduledEndTime = new FXTime();
// maintenance.ScheduledStartTime = new FXTime();
maintenance.ScheduleType = new ScheduleTypeMaintenancePolicy();
maintenance.CustomerID = Common.ConvertToInt(dr, "CustomerID");
maintenance.MaintenancePolicyID = Common.ConvertToInt(dr, "MaintenancePolicyID");
maintenance.ActivityName = Common.ConvertToString(dr, "ActivityName");
maintenance.ScheduleType.ID = Common.ConvertToInt(dr, "ScheduleType");
maintenance.ScheduleType.Name = LookUpValue.GetScheduleType(maintenance.ScheduleType.ID.Value);
maintenance.WeekOfDays.ID = Common.ConvertToInt(dr, "WeekOfDay");
maintenance.WeekOfDays.Name = LookUpValue.GetWeekOfDay(maintenance.WeekOfDays.ID.Value);
maintenance.MonthOfDays.ID = Common.ConvertToInt(dr, "MonthOfDay");
maintenance.MonthOfDays.Name = LookUpValue.GetMonthOfDays(maintenance.MonthOfDays.ID.Value);
maintenance.ScheduledStartTime = Common.ConvertToString(dr, "ScheduledStartTime");
// maintenance.ScheduledStartTime.Name = LookUpValue.GetFXTime(maintenance.ScheduledStartTime.ID.Value);
maintenance.ScheduledEndTime = Common.ConvertToString(dr, "ScheduledEndTime");
// maintenance.ScheduledEndTime.Name = LookUpValue.GetFXTime(maintenance.ScheduledEndTime.ID.Value);
maintenance.ScheduledStartDate = Common.ConvertToDateTime(dr, "ScheduledStartDate");
maintenance.TimeZone.ID = Common.ConvertToInt(dr, "TimeZone");
maintenance.WeekOfMonth = Common.ConvertToInt(dr, "WeekOfMonth");
maintenance.TimeZone.Name = LookUpValue.GetTimeZone(maintenance.TimeZone.ID.Value);
maintenances.Add(maintenance);
}
}
}
return maintenances;
}
public tblMaintenancePolicy GetMaintenance(int MaintenancePolicyID)
{
int errorNum = 0;
string errorDesc = "";
DataAccess.resetParams();
DataAccess.addSqlParam("@oMaintenancePolicyID", ParameterDirection.Input, 16, MySqlDbType.Int32, MaintenancePolicyID);
DataSet ds = DataAccess.ExecuteDataSet(GET_MAINTENANCEEDIT, ref errorNum, ref errorDesc);
tblMaintenancePolicy maintenance = new tblMaintenancePolicy();
if (ds != null && ds.Tables.Count > 0)
{
DataTable dtmaintenance = ds.Tables[0];
if (dtmaintenance != null && dtmaintenance.Rows.Count > 0)
{
DataRow dr = dtmaintenance.Rows[0];
maintenance.ScheduleType = new ScheduleTypeMaintenancePolicy();
maintenance.WeekOfDays = new WeekOfDay();
maintenance.MonthOfDays = new MonthOfDay();
maintenance.TimeZone = new TimeZoneFX();
maintenance.CustomerID = Common.ConvertToInt(dr, "CustomerID");
maintenance.MaintenancePolicyID = Common.ConvertToInt(dr, "MaintenancePolicyID");
maintenance.ActivityName = Common.ConvertToString(dr, "ActivityName");
maintenance.ScheduleType.ID = Common.ConvertToInt(dr, "ScheduleType");
maintenance.ScheduleType.Name = LookUpValue.GetScheduleType(maintenance.ScheduleType.ID.Value);
maintenance.WeekOfDays.ID = Common.ConvertToInt(dr, "WeekOfDay");
maintenance.WeekOfDays.Name = LookUpValue.GetWeekOfDay(maintenance.WeekOfDays.ID.Value);
// maintenance.MonthOfDays.ID = Common.ConvertToInt(dr, "MonthOfDay");
maintenance.ScheduledStartTime = Common.ConvertToString(dr, "ScheduledStartTime");
maintenance.ScheduledEndTime = Common.ConvertToString(dr, "ScheduledEndTime");
maintenance.ScheduledStartDate = Common.ConvertToDateTime(dr, "ScheduledStartDate");
maintenance.TimeZone.ID = Common.ConvertToInt(dr, "TimeZone");
maintenance.WeekOfMonth = Common.ConvertToInt(dr, "WeekOfMonth");
maintenance.TimeZone.Name = LookUpValue.GetTimeZone(maintenance.TimeZone.ID.Value);
// antiVirus.PatchingTimeZone.Name = LookUpValue.GetTimeZone(antiVirus.PatchingTimeZone.ID.Value);
}
}
return maintenance;
}
public int SaveMaintenancePolicy(tblMaintenancePolicy maintenancePolicy)
{
int errorNum = 0;
string errorDesc = "";
DataAccess.resetParams();
DataAccess.addSqlParam("@MaintenancePolicyID", ParameterDirection.Input, 16, MySqlDbType.Int32, maintenancePolicy.MaintenancePolicyID);
DataAccess.addSqlParam("@CustomerID", ParameterDirection.Input, 16, MySqlDbType.Int32, maintenancePolicy.CustomerID);
DataAccess.addSqlParam("@ActivityName", ParameterDirection.Input, 100, MySqlDbType.VarChar, maintenancePolicy.ActivityName);
DataAccess.addSqlParam("@ScheduleType", ParameterDirection.Input, 16, MySqlDbType.Int32, maintenancePolicy.ScheduleType.ID);
DataAccess.addSqlParam("@WeekOfDay", ParameterDirection.Input, 16, MySqlDbType.Int32, maintenancePolicy.WeekOfDays == null ? 0: maintenancePolicy.WeekOfDays.ID);
// DataAccess.addSqlParam("@MonthOfDay", ParameterDirection.Input, 16, MySqlDbType.Int32, maintenancePolicy.MonthOfDays.ID);
DataAccess.addSqlParam("@ScheduledStartTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, maintenancePolicy.ScheduledStartTime);
DataAccess.addSqlParam("@ScheduledEndTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, maintenancePolicy.ScheduledEndTime);
DataAccess.addSqlParam("@ScheduledStartDate", ParameterDirection.Input, 20, MySqlDbType.DateTime, maintenancePolicy.ScheduledStartDate);
DataAccess.addSqlParam("@WeekOfMonth", ParameterDirection.Input, 16, MySqlDbType.Int32, maintenancePolicy.WeekOfMonth);
DataAccess.addSqlParam("@TimeZone", ParameterDirection.Input, 16, MySqlDbType.Int32, maintenancePolicy.TimeZone.ID);
DataAccess.addSqlParam("@Identity", ParameterDirection.InputOutput, 16, MySqlDbType.Int32);
DataAccess.ExecuteNonQuery(SET_MaintenancePolicy, ref errorNum, ref errorDesc);
return Common.ConvertToInt(DataAccess.getSQLParam("@Identity").ToString());
}