public JsonResult PatchingPolicy(tblPatchingPolicy patching) { try { BLCustomer customerBL = new BLCustomer(); patching.CustomerID = SessionHelper.UserSession.CustomerID; customerBL.SavePatchingPolicy(patching); } catch { ModelState.AddModelError("", "Error occurred durung Customer Information save."); return Json(new { errors = KeyValue.GetErrorsFromModelState(ViewData) }); } return Json(new { success = true, Tab = "PP" }); }
// GET public ActionResult PatchingPolicy(int? CustomerID) { BLCustomer customerBL = new BLCustomer(); tblPatchingPolicy Patchpoly = customerBL.GetPatchingPolicy(CustomerID.Value); ViewBag.SearchTypes = LookUpData.GetPolicyType(); ViewBag.WeekOfMonth = LookUpData.GetWeekOfMonth(); ViewBag.time = LookUpData.GetFXTime(); ViewBag.MonthOfDay = LookUpData.GetMonthOfDay(); ViewBag.TimeZones = LookUpData.GetTimeZone(); ViewBag.Schedule = LookUpData.GetScheduleType(); ViewBag.OptionTypeBag = LookUpData.GetOptionType(); tblPatchingPolicy patchingPolicy = new tblPatchingPolicy(); if (Request.IsAjaxRequest()) return PartialView(Patchpoly); else return View(Patchpoly); }
public tblPatchingPolicy GetPatchingPolicyByID(int PatchingPolicyID) { int errorNum = 0; string errorDesc = ""; DataAccess.resetParams(); DataAccess.addSqlParam("@oCustomerID", ParameterDirection.Input, 16, MySqlDbType.Int32, 0); DataAccess.addSqlParam("@PatchingPolicyID", ParameterDirection.Input, 16, MySqlDbType.Int32, PatchingPolicyID); DataSet ds = DataAccess.ExecuteDataSet(GET_PATCHING, ref errorNum, ref errorDesc); tblPatchingPolicy rowDetails = new tblPatchingPolicy(); if (ds != null && ds.Tables.Count > 0) { DataTable dtCutomer = ds.Tables[0]; if (dtCutomer != null && dtCutomer.Rows.Count > 0) { DataRow dr = dtCutomer.Rows[0]; switch (Common.ConvertToInt(dr, "PatchingPolicyType")) { case 1: rowDetails.CustomerID = Common.ConvertToInt(dr, "oCustomerID"); rowDetails.PatchingPolicyIDWR = Common.ConvertToInt(dr, "PatchingPolicyID"); rowDetails.PolicyNameWR = Common.ConvertToString(dr, "PolicyName"); rowDetails.PatchingPolicyTypeIDWR = Common.ConvertToInt(dr, "PatchingPolicyType"); rowDetails.WindowStartTimeWR = Common.ConvertToString(dr, "WindowStartTime"); rowDetails.WindowEndTimeWR = Common.ConvertToString(dr, "WindowEndTime"); rowDetails.WindowTimeZoneWR = new TimeZoneFX(); rowDetails.WindowTimeZoneWR.ID = Common.ConvertToInt(dr, "WindowTimeZone"); rowDetails.WindowTimeZoneWR.Name = LookUpValue.GetTimeZone(rowDetails.WindowTimeZoneWR.ID.Value); // rowDetails.DefineScheduleTypeWR = new ScheduleType(); // rowDetails.DefineScheduleTypeWR.ID = Common.ConvertToInt(dr, "DefineScheduleType"); // rowDetails.DefineScheduleTypeWR.Name = LookUpValue.GetScheduleType(rowDetails.DefineScheduleTypeWR.ID.Value); rowDetails.WeekOfDayWR = new WeekOfDay(); rowDetails.WeekOfDayWR.ID = Common.ConvertToInt(dr, "WeekOfDay"); rowDetails.WeekOfDayWR.Name = LookUpValue.GetWeekOfDay(rowDetails.WeekOfDayWR.ID.Value); // rowDetails.MonthOfDayWR = new MonthOfDay(); // rowDetails.MonthOfDayWR.ID = Common.ConvertToInt(dr, "MonthOfDay"); // rowDetails.MonthOfDayWR.Name = LookUpValue.GetMonthOfDays(rowDetails.MonthOfDayWR.ID.Value); rowDetails.RebootPermissionWR = new OptionType(); rowDetails.RebootPermissionWR.ID = Common.ConvertToInt(dr, "RebootPermission"); rowDetails.RebootPermissionWR.Name = LookUpValue.GetOptionType(rowDetails.RebootPermissionWR.ID.Value); rowDetails.RebootWindowStartTimeWR = Common.ConvertToString(dr, "RebootWindowStartTime"); rowDetails.RebootWindowEndTimeWR = Common.ConvertToString(dr, "RebootWindowEndTime"); rowDetails.RebootWindowTimeZoneWR = new TimeZoneFX(); rowDetails.RebootWindowTimeZoneWR.ID = Common.ConvertToInt(dr, "RebootWindowTimeZone"); rowDetails.RebootWindowTimeZoneWR.Name = LookUpValue.GetTimeZone(rowDetails.RebootWindowTimeZoneWR.ID.Value); break; case 2: rowDetails.CustomerID = Common.ConvertToInt(dr, "oCustomerID"); rowDetails.PatchingPolicyIDSR = Common.ConvertToInt(dr, "PatchingPolicyID"); rowDetails.PolicyNameSR = Common.ConvertToString(dr, "PolicyName"); rowDetails.PatchingPolicyTypeIDSR = Common.ConvertToInt(dr, "PatchingPolicyType"); rowDetails.WindowStartTimeSR = Common.ConvertToString(dr, "WindowStartTime"); rowDetails.WindowEndTimeSR = Common.ConvertToString(dr, "WindowEndTime"); rowDetails.WindowTimeZoneSR = new TimeZoneFX(); rowDetails.WindowTimeZoneSR.ID = Common.ConvertToInt(dr, "WindowTimeZone"); rowDetails.WindowTimeZoneSR.Name = LookUpValue.GetTimeZone(rowDetails.WindowTimeZoneSR.ID.Value); // rowDetails.DefineScheduleTypeSR = new ScheduleType(); // rowDetails.DefineScheduleTypeSR.ID = Common.ConvertToInt(dr, "DefineScheduleType"); // rowDetails.DefineScheduleTypeSR.Name = LookUpValue.GetScheduleType(rowDetails.DefineScheduleTypeSR.ID.Value); rowDetails.WeekOfDaySR = new WeekOfDay(); rowDetails.WeekOfDaySR.ID = Common.ConvertToInt(dr, "WeekOfDay"); rowDetails.WeekOfDaySR.Name = LookUpValue.GetWeekOfDay(rowDetails.WeekOfDaySR.ID.Value); // rowDetails.MonthOfDaySR = new MonthOfDay(); // rowDetails.MonthOfDaySR.ID = Common.ConvertToInt(dr, "MonthOfDay"); // rowDetails.MonthOfDaySR.Name = LookUpValue.GetMonthOfDays(rowDetails.MonthOfDaySR.ID.Value); rowDetails.RebootPermissionSR = new OptionType(); rowDetails.RebootPermissionSR.ID = Common.ConvertToInt(dr, "RebootPermission"); rowDetails.RebootPermissionSR.Name = LookUpValue.GetOptionType(rowDetails.RebootPermissionSR.ID.Value); rowDetails.RebootWindowStartTimeSR = Common.ConvertToString(dr, "RebootWindowStartTime"); rowDetails.RebootWindowEndTimeSR = Common.ConvertToString(dr, "RebootWindowEndTime"); rowDetails.RebootWindowTimeZoneSR = new TimeZoneFX(); rowDetails.RebootWindowTimeZoneSR.ID = Common.ConvertToInt(dr, "RebootWindowTimeZone"); rowDetails.RebootWindowTimeZoneSR.Name = LookUpValue.GetTimeZone(rowDetails.RebootWindowTimeZoneSR.ID.Value); break; case 3: rowDetails.PatchingPolicyIDDND = Common.ConvertToInt(dr, "PatchingPolicyID"); rowDetails.PatchingPolicyTypeIDND = Common.ConvertToInt(dr, "PatchingPolicyType"); rowDetails.PolicyNameND = Common.ConvertToString(dr, "PolicyName"); rowDetails.WindowStartTimeND = Common.ConvertToString(dr, "WindowStartTime"); rowDetails.WindowEndTimeND = Common.ConvertToString(dr, "WindowEndTime"); rowDetails.WindowTimeZoneND = new TimeZoneFX(); rowDetails.WindowTimeZoneND.ID = Common.ConvertToInt(dr, "WindowTimeZone"); rowDetails.WindowTimeZoneND.Name = LookUpValue.GetTimeZone(rowDetails.WindowTimeZoneND.ID.Value); // rowDetails.DefineScheduleTypeND = new ScheduleType(); // rowDetails.DefineScheduleTypeND.ID = Common.ConvertToInt(dr, "DefineScheduleType"); // rowDetails.DefineScheduleTypeND.Name = LookUpValue.GetScheduleType(rowDetails.DefineScheduleTypeND.ID.Value); rowDetails.WeekOfDayND = new WeekOfDay(); rowDetails.WeekOfDayND.ID = Common.ConvertToInt(dr, "WeekOfDay"); rowDetails.WeekOfDayND.Name = LookUpValue.GetWeekOfDay(rowDetails.WeekOfDayND.ID.Value); // rowDetails.MonthOfDayND = new MonthOfDay(); // rowDetails.MonthOfDayND.ID = Common.ConvertToInt(dr, "MonthOfDay"); // rowDetails.MonthOfDayND.Name = LookUpValue.GetMonthOfDays(rowDetails.MonthOfDayND.ID.Value); rowDetails.RebootPermissionND = new OptionType(); rowDetails.RebootPermissionND.ID = Common.ConvertToInt(dr, "RebootPermission"); rowDetails.RebootPermissionND.Name = LookUpValue.GetOptionType(rowDetails.RebootPermissionND.ID.Value); rowDetails.RebootWindowStartTimeND = Common.ConvertToString(dr, "RebootWindowStartTime"); rowDetails.RebootWindowEndTimeND = Common.ConvertToString(dr, "RebootWindowEndTime"); rowDetails.RebootWindowTimeZoneND = new TimeZoneFX(); rowDetails.RebootWindowTimeZoneND.ID = Common.ConvertToInt(dr, "RebootWindowTimeZone"); rowDetails.RebootWindowTimeZoneND.Name = LookUpValue.GetTimeZone(rowDetails.RebootWindowTimeZoneND.ID.Value); break; } } } return rowDetails; }
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 int SavePatchingPolicy(tblPatchingPolicy patchingPolicy) { int errorNum = 0; string errorDesc = ""; DataAccess.resetParams(); DataAccess.addSqlParam("@PatchingPolicyID", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.PatchingPolicyIDWR); DataAccess.addSqlParam("@CustomerID", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.CustomerID); DataAccess.addSqlParam("@PatchingPolicyType", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.PatchingPolicyTypeIDWR = 1); DataAccess.addSqlParam("@PolicyName", ParameterDirection.Input, 50, MySqlDbType.VarChar, patchingPolicy.PolicyNameWR); DataAccess.addSqlParam("@WindowTimeZone", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.WindowTimeZoneWR.ID); // DataAccess.addSqlParam("@DefineScheduleType", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.DefineScheduleTypeWR.ID); // DataAccess.addSqlParam("@MonthOfDay", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.MonthOfDayWR.ID); DataAccess.addSqlParam("@WeekOfDay", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.WeekOfDayWR.ID); DataAccess.addSqlParam("@RebootPermission", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.RebootPermissionWR.ID); DataAccess.addSqlParam("@RebootWindowStartTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, patchingPolicy.RebootWindowStartTimeWR); DataAccess.addSqlParam("@RebootWindowEndTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, patchingPolicy.RebootWindowEndTimeWR); DataAccess.addSqlParam("@WindowStartTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, patchingPolicy.WindowStartTimeWR); DataAccess.addSqlParam("@WindowEndTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, patchingPolicy.WindowEndTimeWR); DataAccess.addSqlParam("@RebootWindowTimeZone", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.WindowTimeZoneWR.ID); DataAccess.addSqlParam("@Identity", ParameterDirection.InputOutput, 16, MySqlDbType.Int32); DataAccess.ExecuteNonQuery(SET_PatchingPolicy, ref errorNum, ref errorDesc); DataAccess.resetParams(); DataAccess.addSqlParam("@PatchingPolicyID", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.PatchingPolicyIDSR); DataAccess.addSqlParam("@CustomerID", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.CustomerID); DataAccess.addSqlParam("@PatchingPolicyType", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.PatchingPolicyTypeIDSR = 2); DataAccess.addSqlParam("@PolicyName", ParameterDirection.Input, 50, MySqlDbType.VarChar, patchingPolicy.PolicyNameSR); DataAccess.addSqlParam("@WindowTimeZone", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.WindowTimeZoneSR.ID); // DataAccess.addSqlParam("@DefineScheduleType", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.DefineScheduleTypeSR.ID); // DataAccess.addSqlParam("@MonthOfDay", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.MonthOfDaySR.ID); DataAccess.addSqlParam("@WeekOfDay", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.WeekOfDayWR.ID); DataAccess.addSqlParam("@RebootPermission", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.RebootPermissionSR.ID); DataAccess.addSqlParam("@RebootWindowStartTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, patchingPolicy.RebootWindowStartTimeSR); DataAccess.addSqlParam("@RebootWindowEndTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, patchingPolicy.RebootWindowEndTimeSR); DataAccess.addSqlParam("@WindowStartTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, patchingPolicy.WindowStartTimeSR); DataAccess.addSqlParam("@WindowEndTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, patchingPolicy.WindowEndTimeSR); DataAccess.addSqlParam("@RebootWindowTimeZone", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.RebootWindowTimeZoneSR.ID); DataAccess.addSqlParam("@Identity", ParameterDirection.InputOutput, 16, MySqlDbType.Int32); DataAccess.ExecuteNonQuery(SET_PatchingPolicy, ref errorNum, ref errorDesc); DataAccess.resetParams(); DataAccess.addSqlParam("@PatchingPolicyID", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.PatchingPolicyIDDND); DataAccess.addSqlParam("@CustomerID", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.CustomerID); DataAccess.addSqlParam("@PatchingPolicyType", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.PatchingPolicyTypeIDND = 3); DataAccess.addSqlParam("@PolicyName", ParameterDirection.Input, 50, MySqlDbType.VarChar, patchingPolicy.PolicyNameND); DataAccess.addSqlParam("@WindowTimeZone", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.WindowTimeZoneND.ID); // DataAccess.addSqlParam("@DefineScheduleType", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.DefineScheduleTypeND.ID); // DataAccess.addSqlParam("@MonthOfDay", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.MonthOfDayND.ID); DataAccess.addSqlParam("@WeekOfDay", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.WeekOfDayND.ID); DataAccess.addSqlParam("@RebootPermission", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.RebootPermissionND.ID); DataAccess.addSqlParam("@RebootWindowStartTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, patchingPolicy.RebootWindowStartTimeND); DataAccess.addSqlParam("@RebootWindowEndTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, patchingPolicy.RebootWindowEndTimeND); DataAccess.addSqlParam("@WindowStartTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, patchingPolicy.WindowStartTimeND); DataAccess.addSqlParam("@WindowEndTime", ParameterDirection.Input, 10, MySqlDbType.VarChar, patchingPolicy.WindowEndTimeND); DataAccess.addSqlParam("@RebootWindowTimeZone", ParameterDirection.Input, 16, MySqlDbType.Int32, patchingPolicy.WindowTimeZoneND.ID); DataAccess.addSqlParam("@Identity", ParameterDirection.InputOutput, 16, MySqlDbType.Int32); DataAccess.ExecuteNonQuery(SET_PatchingPolicy, ref errorNum, ref errorDesc); return Common.ConvertToInt(DataAccess.getSQLParam("@Identity").ToString()); }