Ejemplo n.º 1
0
        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();
        }