// [Route("Edit")] public ActionResult Edit(int ID) { if (Convert.ToInt32(Session["SectionID"]) != 13) { List <tbl_Master_Role> RoleList = (List <tbl_Master_Role>)Session["RoleList"]; bool isAccessible = false; foreach (var item in RoleList) { if (item.FormName.ToLower() == "Delay Due to Plocy Issues".ToLower()) { //if (Convert.ToInt32(Session["SectionID"]) == 13 || Convert.ToInt32(Session["SectionID"]) == 1) { isAccessible = true; } } } if (!isAccessible) { return(RedirectToAction("Login", "Account")); } } AcfpolicyviewModel model = new AcfpolicyviewModel(); List <AcfpolicyviewModel> list = new List <AcfpolicyviewModel>(); try { // var _editPolicy = entities.acq_policy.Where(x => x.aon_id == ID && x.IsDeleted== false).FirstOrDefault(); var _editPolicy = entities.acq_policy.Where(x => x.policyid == ID && x.IsDeleted == false).FirstOrDefault(); var IndexData = entities.acq_policy.Select(s => new AcfpolicyviewModel { item_description = s.acq_project_master.item_description }).ToList(); IndexData.ForEach(f => { f.item_description = Cipher.Decrypt(f.item_description, password); model.item_description = f.item_description; }); var IndexData1 = entities.acq_policy.Select(s => new AcfpolicyviewModel { Categorisation = s.tbl_mst_Template.TaskDescription }).ToList(); //var IndexD = entities.acq_project_status_pendingstage.Where(s => s.TaskSlno == _editPolicy.stagid).Select(p => p.pending_in_stage).FirstOrDefault(); IndexData1.ForEach(f => { model.Categorisation = f.Categorisation; }); /* var IndexData2 = entities.acq_policy.Select(s => new AcfpolicyviewModel { Remarks = s.acq_project_master.Remarks }).ToList(); * IndexData.ForEach(f => * { * f.Remarks = Cipher.Decrypt(f.Remarks, password); * model.Remarks = f.Remarks; * });*/ int SectionID = Convert.ToInt32(Session["SectionID"]); model.tdate = _editPolicy.tdate; model.policyid = _editPolicy.policyid; model.stagid = _editPolicy.stagid; model.aon_id = _editPolicy.aon_id; model.fdate = _editPolicy.fdate; //model.Remarks = _editPolicy.Remarks; model.Remarks = Cipher.Decrypt(_editPolicy.Remarks, password); //string filepath = _editPolicy.pdfattachment.ToString(); /* * FileStream fs2 = new FileStream(Server.MapPath(filepath), FileMode.OpenOrCreate, FileAccess.Read); * StreamReader reader = new StreamReader(fs2); * string filePath = Cipher.Decrypt(reader.ReadToEnd(),password); * model.pdfattachment = filePath;*/ //var SectionID = Session["SectionID"]; List <tbl_mst_Template> Templateexists = entities.tbl_mst_Template.Where(x => x.IsActive == "Y").ToList(); ViewBag.TemplateexistsData = Templateexists; if ((int)SectionID == 8 || (int)SectionID == 13) { var projectList = entities.acq_project_master.Where(x => x.IsDeleted == false && (x.Service_Lead_Service == "AirForce" && x.System_case != "Y")).OrderBy(x => x.item_description).ToList(); ViewBag.ProjectList = projectList; if (projectList != null) { foreach (var item in projectList) { AcfpolicyviewModel obj = new AcfpolicyviewModel(); obj.stagid = item.aon_id; obj.item_description = Cipher.Decrypt(item.item_description, password); obj.Categorisation = item.Categorisation; list.Add(obj); } } } if ((int)SectionID == 9 || (int)SectionID == 13) { var projectList = entities.acq_project_master.Where(x => x.IsDeleted == false && (x.Service_Lead_Service == "Army" && x.System_case != "Y")).OrderBy(x => x.item_description).ToList(); if (projectList != null) { foreach (var item in projectList) { AcfpolicyviewModel obj = new AcfpolicyviewModel(); obj.stagid = item.aon_id; obj.item_description = Cipher.Decrypt(item.item_description, password); obj.Categorisation = item.Categorisation; list.Add(obj); } } } if ((int)SectionID == 10 || (int)SectionID == 13) { var projectList = entities.acq_project_master.Where(x => x.IsDeleted == false && (x.Service_Lead_Service.Contains("Navy") || x.Service_Lead_Service.Contains("ICG") || x.System_case == "Y")).OrderBy(x => x.item_description).ToList(); if (projectList != null) { foreach (var item in projectList) { AcfpolicyviewModel obj = new AcfpolicyviewModel(); obj.stagid = item.aon_id; obj.item_description = Cipher.Decrypt(item.item_description, password); obj.Categorisation = item.Categorisation; list.Add(obj); } } } var struid = ""; if (Session["SectionID"] != null) { struid = mService.SectionID(Session["SectionID"].ToString()); } List <MODListViewModel> list1 = new List <MODListViewModel>(); string query = ""; if (struid == "SuperAdmin") { struid = "%"; } else { } query = "SELECT DISTINCT TaskSlno, pending_in_stage" + " FROM dbo.acq_project_status_pendingstage" + " WHERE(TaskSlno NOT IN('2', '3')) and Service_Lead_Service like '" + struid + "'"; DataTable dt = return_datatable(query); if (dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { MODListViewModel obj2 = new MODListViewModel(); obj2.pending_in_stage = item["pending_in_stage"].ToString(); obj2.TaskSlno = Convert.ToInt32(item["TaskSlno"]); list1.Add(obj2); } } model.StageList = list1; //ViewBag.TemplateexistsData = model.StageList; model.ProjectList = list; // return View(model); } catch { } TempData["policyId"] = model.policyid; TempData["tdate"] = model.tdate; return(View(model)); }
public ActionResult Create() { // Project List Bind if (Convert.ToInt32(Session["SectionID"]) != 13) { List <tbl_Master_Role> RoleList = (List <tbl_Master_Role>)Session["RoleList"]; bool isAccessible = false; foreach (var item in RoleList) { if (item.FormName.ToLower() == "Delay Due to Plocy Issues".ToLower()) { // if (Convert.ToInt32(Session["SectionID"]) == 13 || Convert.ToInt32(Session["SectionID"]) == 1) { isAccessible = true; } } } if (!isAccessible) { return(RedirectToAction("Login", "Account")); } } List <AcfpolicyviewModel> list = new List <AcfpolicyviewModel>(); AcfpolicyviewModel model = new AcfpolicyviewModel(); var SectionID = Session["SectionID"]; List <tbl_mst_Template> Templateexists = entities.tbl_mst_Template.Where(x => x.IsActive == "Y").ToList(); ViewBag.TemplateexistsData = Templateexists; if ((int)SectionID == 8 || (int)SectionID == 13) { var projectList = entities.acq_project_master.Where(x => x.IsDeleted == false && (x.Service_Lead_Service == "AirForce" && x.System_case != "Y")).OrderBy(x => x.item_description).ToList(); ViewBag.ProjectList = projectList; if (projectList != null) { foreach (var item in projectList) { AcfpolicyviewModel obj = new AcfpolicyviewModel(); obj.stagid = item.aon_id; obj.item_description = Cipher.Decrypt(item.item_description, password); obj.Categorisation = item.Categorisation; list.Add(obj); } } } if ((int)SectionID == 9 || (int)SectionID == 13) { var projectList = entities.acq_project_master.Where(x => x.IsDeleted == false && (x.Service_Lead_Service == "Army" && x.System_case != "Y")).OrderBy(x => x.item_description).ToList(); if (projectList != null) { foreach (var item in projectList) { AcfpolicyviewModel obj = new AcfpolicyviewModel(); obj.stagid = item.aon_id; obj.item_description = Cipher.Decrypt(item.item_description, password); obj.Categorisation = item.Categorisation; list.Add(obj); } } } if ((int)SectionID == 10 || (int)SectionID == 13) { var projectList = entities.acq_project_master.Where(x => x.IsDeleted == false && (x.Service_Lead_Service.Contains("Navy") || x.Service_Lead_Service.Contains("ICG") || x.System_case == "Y")).OrderBy(x => x.item_description).ToList(); if (projectList != null) { foreach (var item in projectList) { AcfpolicyviewModel obj = new AcfpolicyviewModel(); obj.stagid = item.aon_id; obj.item_description = Cipher.Decrypt(item.item_description, password); obj.Categorisation = item.Categorisation; list.Add(obj); } } } var struid = ""; if (Session["SectionID"] != null) { struid = mService.SectionID(Session["SectionID"].ToString()); } List <MODListViewModel> list1 = new List <MODListViewModel>(); string query = ""; if (struid == "SuperAdmin") { struid = "%"; } else { } query = "SELECT DISTINCT TaskSlno, pending_in_stage" + " FROM dbo.acq_project_status_pendingstage" + " WHERE(TaskSlno NOT IN('2', '3')) and Service_Lead_Service like '" + struid + "'"; DataTable dt = return_datatable(query); if (dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { MODListViewModel obj2 = new MODListViewModel(); obj2.pending_in_stage = item["pending_in_stage"].ToString(); obj2.TaskSlno = Convert.ToInt32(item["TaskSlno"]); list1.Add(obj2); } } model.StageList = list1; // ViewBag.TemplateexistsData = model.StageList; model.ProjectList = list; TempData["ProjectList"] = list; return(View(model)); }