public ActionResult AcknowledgementForm(AcknowledgementModel avm, FormCollection fc) { 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 = 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 = client.InsertAcknowledgementServices(ackId, avm.Projects[i].Project.Id, avm.Projects[i].Services[j].Id, avm.Projects[i].Services[j].Total, avm.Projects[i].Services[j].NewVolume, avm.Projects[i].FromDate, avm.Projects[i].EndDate, avm.Projects[i].Services[j].FeesType); } } } 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(); }