// // GET: /ChequeBooks/Create public ActionResult CollectionForm(int id) { // ChkBook_collectorDetail List<ChkBook_collectorDetail> cc = new List<ChkBook_collectorDetail>(); ChkBook_collectorDetail collector = new ChkBook_collectorDetail(); collector.checkbookId = id; cc.Add(collector); // return View(); return View(collector);//(cc); }
public ActionResult CollectionForm(ChkBook_collectorDetail collectionForm) { if (ModelState.IsValid) { collectionForm.DateCollected = DateTime.Now; db.collectorDetails.Add(collectionForm); db.SaveChanges(); //Update collection Status chqbook_processedstatus chqbook = db.chkbookprocessStatus.Single(p => p.checkbookId == collectionForm.checkbookId); chqbook.collectionStatus = 1; db.Entry(chqbook).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("CollectionLetter", collectionForm); } return View(collectionForm); }
public ActionResult printLetter(ChkBook_collectorDetail collectionForm) { if (ModelState.IsValid) { } // return RedirectToAction("showLetter.pdf", collectionForm); return RedirectToAction("showLetter", collectionForm); }
// public ReportResult showLetter(int idx=11) public ActionResult showLetter(ChkBook_collectorDetail collectionForm) { int idx = collectionForm.checkbookId; ReportGenerator reportGen = new ReportGenerator(); string rname = "";//userManager.getReportbyName(pgId); ViewBag.msgTitle = rname; ViewBag.Title = rname; // Customize the Text Fields ReportsMap rep = new ReportsMap(); rep.fieldId = 1; rep.field1 = ""; rep.field2 = ""; rep.field3 = ""; rep.field4 = ""; rep.field5 = ""; var reportList = new List<ReportsMap>(); reportList.Add(rep); var report = new Report(reportList.ToReportSource()); string data1 = "---", data2 = "", data3 = "", data4 = ""; //Read File string fileName = fngetSystemParamter("COLLECTION LETTER TEMPLATE"); string agent = collectionForm.FullNames; Document myDocument = new Document(PageSize.A4.Rotate()); try { string fileLocation = HttpContext.Server.MapPath(".") + @"\Letter\" + "collection.pdf"; if (!Directory.Exists(HttpContext.Server.MapPath(".") + @"\Letter\")) { Directory.CreateDirectory(HttpContext.Server.MapPath(".") + @"\Letter\"); } if (System.IO.File.Exists(fileLocation)) { System.IO.File.Delete(fileLocation); } PdfWriter.GetInstance(myDocument, new FileStream(fileLocation, FileMode.OpenOrCreate)); myDocument.Open(); Contacts contactObj = new Contacts();//"0100047012" chqBook_CheckBookFieldDec chkBkFields = db.chqBook_CheckBookFieldDecs.Single(p => p.checkbookId == idx); List<Contacts> contactsList = db.ContactsList.Where(p => p.Customer_No == chkBkFields.acc_no).ToList<Contacts>(); int i = 0; foreach (Contacts contactmodel in contactsList) { if (i == 0) { contactObj = contactmodel; } i++; } string[] lines = System.IO.File.ReadAllLines(fileName); string[] data; string printData = ""; string footerText = ""; int footerCount = 0; foreach (string lin in lines) { string tempData = lin; if (lin.Contains("<<date>>")) { tempData = DateTime.Now.ToString("MMMM") + " " + DateTime.Today.Day.ToString() + " , " + DateTime.Today.Year.ToString(); ; //lin.Replace("<<Flex_Name>>", contactObj.Customer_Name); } if (lin.Contains("<<Flex_Name>>")) { tempData = lin.Replace("<<Flex_Name>>", contactObj.Customer_Name); } if (lin.Contains("<<Address_Line_1>>")) { tempData = lin.Replace("<<Address_Line_1>>", contactObj.Address_Line1); } if (lin.Contains("<<Address_Line_2>>")) { tempData = lin.Replace("<<Address_Line_2>>", contactObj.Address_Line2); } if (lin.Contains("<<SERIES>>")) { tempData = lin.Replace("<<SERIES>>", collectionForm.Series); } if (tempData.Contains("<<NO_OF_BOOKS>>")) { tempData = tempData.Replace("<<NO_OF_BOOKS>>", collectionForm.no_of_books); } if (lin.Contains("<<Account_No>>")) { tempData = lin.Replace("<<Account_No>>", chkBkFields.acc_no); } if (lin.Contains("<<AGENT>>")) { tempData = lin.Replace("<<AGENT>>", agent); } if (tempData.Contains("<<ISSUED>>")) { tempData = tempData.Replace("<<ISSUED>>", System.DateTime.Now.ToString("dd-MMM-yyyy")); } if (tempData.Contains("Citibank, N.A.")) { footerCount = 1; } if (footerCount == 0) { printData = printData + tempData + "\n"; } else { footerText = footerText + tempData + "\n"; } } // } report.TextFields.Header = printData; report.TextFields.Footer = footerText; myDocument.Add(new Paragraph(printData)); myDocument.Add(new Paragraph(footerText)); //myDocument.Close(); report.RenderHints.BooleanCheckboxes = true; report.RenderHints.BooleansAsYesNo = true; report.RenderHints.FreezeRows = 9; report.RenderHints.FreezeColumns = 2; // Customize the data fields report.DataFields["fieldId"].Hidden = true; // report.DataFields["field1"].Hidden = true; report.DataFields["field1"].HeaderText = " ";// .DataFormatString="{0:c}"; report.DataFields["field2"].Hidden = true; report.DataFields["field3"].Hidden = true; report.DataFields["field4"].Hidden = true; report.DataFields["field5"].Hidden = true; report.DataFields["field6"].Hidden = true; } catch (DocumentException de) { Console.Error.WriteLine(de.Message); } finally { myDocument.Close(); } // // Return the ReportResult // // the type of report that is rendered will be determined by the extension in the URL (.pdf, .xls, .html, etc) //return new ReportResult(); return RedirectToAction("CollectionLetterpdf"); }
public ActionResult CollectionLetter(ChkBook_collectorDetail collectionForm) { if (ModelState.IsValid) { if (collectionForm.CellNo != null) { return RedirectToAction("printLetter", collectionForm); } } collectionForm.CellNo = "1"; return View(collectionForm); }