public ActionResult AcknowledgementForm() { BCBSClient client = new BCBSClient(); string customerlist = client.GetcustomerList(); if (!string.IsNullOrEmpty(customerlist)) { ViewBag.Customers = JsonConvert.DeserializeObject<List<CustomerModel>>(customerlist).Select(x => new { x.Id, x.Name }); } else { ViewBag.Customers = ""; } //string servicelist = client.GetServiceTypeList(); //if (!string.IsNullOrEmpty(servicelist)) //{ // ViewBag.Services = JsonConvert.DeserializeObject<List<ServiceModel>>(servicelist).Select(x => new { x.Id, x.Name }); //} //else //{ // ViewBag.Services = ""; //} string projectList = client.GetProjectList(); if (!string.IsNullOrEmpty(projectList)) { ViewBag.Projects = JsonConvert.DeserializeObject<List<ProjectModel>>(projectList).Select(x => new { x.Id, x.Name }); } else { ViewBag.Projects = ""; } return View(); }
public ActionResult Edit(long id) { BCBSClient client = new BCBSClient(); string customerlist = client.GetcustomerList(); ContractModel contract = new ContractModel(); contract.FromDate = DateTime.Now; contract.EndDate = DateTime.Now; if (!string.IsNullOrEmpty(customerlist)) { ViewBag.Customers = JsonConvert.DeserializeObject<List<CustomerModel>>(customerlist).Select(x => new { x.Id, x.Name }); } else { ViewBag.Customers = ""; } string projectList = client.GetProjectList(); if (!string.IsNullOrEmpty(projectList)) { ViewBag.Projects = JsonConvert.DeserializeObject<List<ProjectModel>>(projectList).Select(x => new { x.Id, x.Name }); } else { ViewBag.Projects = ""; } if (id > 0) { string ContractData = client.GetcontractById(id); if (!string.IsNullOrEmpty(ContractData)) { contract = JsonConvert.DeserializeObject<ContractModel>(ContractData); string servicelist = client.GetServiceTypesByProjectId(contract.ProjectId); if (!string.IsNullOrEmpty(servicelist)) { ViewBag.Services = JsonConvert.DeserializeObject<List<ServiceModel>>(servicelist).Select(x => new { x.Id, x.Name }); } else { ViewBag.Services = ""; } } else { TempData["Error"] = "Requested contract not available!!"; return RedirectToAction("Index", "Contract"); } } return View(contract); }
public ActionResult New() { BCBSClient client = new BCBSClient(); string customerlist = client.GetcustomerList(); ContractModel contract = new ContractModel(); contract.FromDate = DateTime.Now; contract.EndDate = DateTime.Now; contract.ContractCode = GenerateUniqueContractCode().ToUpper(); if (!string.IsNullOrEmpty(customerlist)) { ViewBag.Customers = JsonConvert.DeserializeObject<List<CustomerModel>>(customerlist).Select(x => new { x.Id, x.Name }); } else { ViewBag.Customers = ""; } //string servicelist = client.GetServiceTypeList(); //if (!string.IsNullOrEmpty(servicelist)) //{ // ViewBag.Services = JsonConvert.DeserializeObject<List<ServiceModel>>(servicelist).Select(x => new { x.Id, x.Name }); //} //else //{ // ViewBag.Services = ""; //} string projectList = client.GetProjectList(); if (!string.IsNullOrEmpty(projectList)) { ViewBag.Projects = JsonConvert.DeserializeObject<List<ProjectModel>>(projectList).Select(x => new { x.Id, x.Name }); } else { ViewBag.Projects = ""; } return View(contract); }
public ActionResult New() { BCBSClient client = new BCBSClient(); string customerlist = client.GetcustomerList(); string servicelist = client.GetServiceTypeList(); if (!string.IsNullOrEmpty(customerlist)) { ViewBag.Customers = JsonConvert.DeserializeObject<List<CustomerModel>>(customerlist).Select(x => new { x.Id, x.Name }); } else { ViewBag.Customers = ""; } if (!string.IsNullOrEmpty(servicelist)) { ViewBag.Services = JsonConvert.DeserializeObject<List<ServiceModel>>(servicelist).Select(x => new { x.Id, x.Name }); } else { ViewBag.Services = ""; } string projectList = client.GetProjectList(); if (!string.IsNullOrEmpty(projectList)) { ViewBag.Projects = JsonConvert.DeserializeObject<List<ProjectModel>>(projectList).Select(x => new { x.Id, x.Name }); } else { ViewBag.Projects = ""; } string contractList = client.GetcontractList(); if (!string.IsNullOrEmpty(contractList)) { ViewBag.Contracts = JsonConvert.DeserializeObject<List<ContractModel>>(contractList).Select(x => new { x.Id, x.ContractCode }); } else { ViewBag.Contracts = ""; } ViewBag.Months = new List<SelectListItem> { new SelectListItem { Text = "January", Value = "1" }, new SelectListItem { Text = "February", Value = "2" }, new SelectListItem { Text = "March", Value = "3" }, new SelectListItem{Text="April",Value="4"}, new SelectListItem{Text="May",Value="5"}, new SelectListItem{Text="June",Value="6"}, new SelectListItem{Text="July",Value="7"}, new SelectListItem{Text="August",Value="8"}, new SelectListItem{Text="September",Value="9"}, new SelectListItem{Text="October",Value="10"}, new SelectListItem{Text="November",Value="11"}, new SelectListItem{Text="December",Value="12"} }; string years = client.GetAccuralReportMonthYear(); List<MonthYear> ContractList = new List<MonthYear>(); if (!string.IsNullOrEmpty(years)) { ContractList = JsonConvert.DeserializeObject<List<MonthYear>>(years); int currentexist = ContractList.Where(x => x.Year == DateTime.Now.Year.ToString()).Count(); if (!(currentexist > 0)) { MonthYear monthYear = new MonthYear(); monthYear.Year = DateTime.Now.Year.ToString(); monthYear.Month = ""; ContractList.Add(monthYear); } } else { ContractList = JsonConvert.DeserializeObject<List<MonthYear>>(years); MonthYear monthYear = new MonthYear(); monthYear.Year = DateTime.Now.Year.ToString(); monthYear.Month = ""; ContractList.Add(monthYear); } ViewBag.Years = ContractList.GroupBy(cust => cust.Year).Select(grp => grp.First()); return View(); }
public JsonResult GetCustomerList() { try { BCBSClient client = new BCBSClient(); string result = client.GetcustomerList(); List<CustomerModel> CustomerList = JsonConvert.DeserializeObject<List<CustomerModel>>(result); return Json(CustomerList, JsonRequestBehavior.AllowGet); } catch (Exception ex) { return Json(ex.Message, JsonRequestBehavior.AllowGet); } }
public ActionResult ViewAcknowledgeForm(AcknowledgementModel avm, FormCollection fc) { bool isResult = false; if (avm.Id > 0) { BCBSClient client = new BCBSClient(); List<CustomerAcknowledgementServicesModel> ackService = new List<CustomerAcknowledgementServicesModel>(); string dataResult = client.GetAcknowledgementServicesbyAcknowledgemetnId(Convert.ToInt64(avm.Id)); if (!string.IsNullOrEmpty(dataResult)) { ackService = JsonConvert.DeserializeObject<List<CustomerAcknowledgementServicesModel>>(dataResult); } if (ackService.Count > 0) { foreach (CustomerAcknowledgementServicesModel ack in ackService) { string ContractCode = GenerateUniqueContractCode().ToUpper(); long id = client.Insertcontract(ack.CustomerId, ack.ServiceId, ack.FromDate, ack.EndDate, true, false, "Active", ack.Volume, ack.Total, ack.ProjectId, "", ContractCode, "", ack.FeesType); //long id = client.Insertcontract(ack.CustomerId, ack.ServiceId, ack.FromDate, ack.EndDate, true, false, "Active", "", ack.Total, ack.ProjectId, "", ContractCode, "", ""); if (id > 0) { isResult = true; } else { break; } } if (isResult == true) { long id = client.AcknowledgementApprove(Convert.ToInt64(avm.Id)); TempData["Message"] = "Acknowledgement Approved ! Contract Added Successfully!!"; return RedirectToAction("acknowledgements", "customer"); } else { string customerlist = client.GetcustomerList(); if (!string.IsNullOrEmpty(customerlist)) { ViewBag.Customers = JsonConvert.DeserializeObject<List<CustomerModel>>(customerlist).Select(x => new { x.Id, x.Name }); } else { ViewBag.Customers = ""; } string servicelist = client.GetServiceTypeList(); if (!string.IsNullOrEmpty(servicelist)) { ViewBag.Services = JsonConvert.DeserializeObject<List<ServiceModel>>(servicelist).Select(x => new { x.Id, x.Name }); } else { ViewBag.Services = ""; } string projectList = client.GetProjectList(); if (!string.IsNullOrEmpty(projectList)) { ViewBag.Projects = JsonConvert.DeserializeObject<List<ProjectModel>>(projectList).Select(x => new { x.Id, x.Name }); } else { ViewBag.Projects = ""; } } } } //BCBSClient client = new BCBSClient(); //string removedProjects = fc["RemovedProjects"].ToString(); //string removedServices = fc["RemovedServices"].ToString(); //List<string> removedProjectList = new List<string>(); //if (!string.IsNullOrEmpty(removedProjects)) //{ // removedProjectList = removedProjects.Split(',').ToList(); //} //List<string> removedServiceList = new List<string>(); //if (!string.IsNullOrEmpty(removedServices)) //{ // removedServiceList = removedServices.Split(',').ToList(); //} //long ackid = avm.Id; ////long ackId = client.InsertCustomerAcknoeledgement(avm.CustomerId); //if (ackid > 0) //{ // if (avm.Projects != null) // { // for (int i = 0; i < avm.Projects.Count(); i++) // { // if (removedProjectList.Count > 0) // { // var r = removedProjectList.Where(x => x.Equals(avm.Projects[i].Project.Id + "@" + i)); // if (r != null) // { // if (r.Count() > 0) // { // continue; // } // } // } // if (avm.Projects[i].Services != null) // { // for (int j = 0; j < avm.Projects[i].Services.Count; j++) // { // var r = removedServiceList.Where(x => x.Equals(i + "_" + j)); // if (r != null) // { // if (r.Count() > 0) // { // continue; // } // } // long ackserviceId = avm.Projects[i].Services[j].Id; // //long ackServiceId = client.InsertAcknowledgementServices(ackid, avm.Projects[i].Project.Id, avm.Projects[i].Services[j].Id, avm.Projects[i].Services[j].Total, avm.Projects[i].FromDate, avm.Projects[i].EndDate); // } // } // } // string fileName = "Ack_" + DateTime.Now.ToString("MM_dd_yyyy_HH_mm_ss"); // string retunfileName = CreateAcknowledgementExcel(avm, fileName, removedProjects, removedServices); // if (!string.IsNullOrEmpty(retunfileName)) // { // string path = Path.Combine(Server.MapPath("~/UploadDocuments/Acknowledgements"), retunfileName); // //return File(path, "text/csv", retunfileName); // } // else // { // TempData["Message"] = "Customer grand bill generated successfully..!"; // //string fileName = "SBF_" + invoiceModel.InvoiceNumber + "_" + DateTime.Now.ToString("MM-dd-yyyy"); // // // return RedirectToAction("acknowledgements", "customer"); // } // //TempData["Message"] = "Acknowledgement Bill generated successfully.."; // } //} return View(avm); }
public ActionResult ViewAcknowledgeForm(string Id) { BCBSClient client = new BCBSClient(); AcknowledgementModel avm = new AcknowledgementModel(); string customerlist = client.GetcustomerList(); if (!string.IsNullOrEmpty(customerlist)) { ViewBag.Customers = JsonConvert.DeserializeObject<List<CustomerModel>>(customerlist).Select(x => new { x.Id, x.Name }); } else { ViewBag.Customers = ""; } string servicelist = client.GetServiceTypeList(); if (!string.IsNullOrEmpty(servicelist)) { ViewBag.Services = JsonConvert.DeserializeObject<List<ServiceModel>>(servicelist).Select(x => new { x.Id, x.Name }); } else { ViewBag.Services = ""; } string projectList = client.GetProjectList(); if (!string.IsNullOrEmpty(projectList)) { ViewBag.Projects = JsonConvert.DeserializeObject<List<ProjectModel>>(projectList).Select(x => new { x.Id, x.Name }); } else { ViewBag.Projects = ""; } if (!string.IsNullOrEmpty(Id)) { List<CustomerAcknowledgementServicesModel> ackService = new List<CustomerAcknowledgementServicesModel>(); string dataResult = client.GetAcknowledgementServicesbyAcknowledgemetnId(Convert.ToInt64(Id)); if (!string.IsNullOrEmpty(dataResult)) { ackService = JsonConvert.DeserializeObject<List<CustomerAcknowledgementServicesModel>>(dataResult); if (ackService.Count > 0) { avm.Id = ackService[0].AcknowledementId; avm.CustomerId = ackService[0].CustomerId; avm.Status = ackService[0].Status; } } if (ackService.Count > 0) { List<long> Projects = ackService.Select(x => x.ProjectId).Distinct().ToList(); var ServicebyProjects = ackService.ToList(); ViewBag.SelectedProjects = JsonConvert.SerializeObject(Projects); ViewBag.ProjectServices = dataResult; } } return View(avm); }