/// <summary> /// Add footer for document receipt /// </summary> /// <param name="streamWriter"></param> /// <param name="truckMemoList"></param> public void AddFooter(StreamWriter streamWriter, DocumentStockTransferDetails transferDetails) { streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|"); streamWriter.Write("|LORRY NO: "); streamWriter.Write(report.StringFormatWithoutPipe(transferDetails.LorryNo, 23, 2)); streamWriter.Write("TC NAME : "); streamWriter.Write(report.StringFormatWithoutPipe(transferDetails.documentSTTDetails[0].TransporterName, 59, 2) + "|"); streamWriter.WriteLine(" "); streamWriter.Write("|MODE OF WEIGHMENT : "); streamWriter.Write(report.StringFormatWithoutPipe(GetWTCode(transferDetails), 85, 2)); streamWriter.Write("|"); streamWriter.WriteLine(" "); streamWriter.Write("|FROM RAIL HEAD: "); streamWriter.Write(report.StringFormatWithoutPipe(transferDetails.RailHeadName, 17, 2)); streamWriter.Write("WAGON NO : "); streamWriter.Write(report.StringFormatWithoutPipe(GetWNo(transferDetails), 21, 2)); streamWriter.Write("RR NO:"); streamWriter.Write(report.StringFormatWithoutPipe(GetRRNo(transferDetails), 31, 2)); streamWriter.Write("|"); streamWriter.WriteLine(" "); streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI1, 105, 2) + "|"); streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI2, 105, 2) + "|"); streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI3, 105, 2) + "|"); streamWriter.WriteLine("| NAME OF TC |"); streamWriter.WriteLine("| |"); streamWriter.WriteLine("|GODOWN INCHARGE Sign. of the Authorised Person. |"); streamWriter.WriteLine("|REMARKS |"); streamWriter.WriteLine("| " + report.StringFormatWithoutPipe(GetRemarks(transferDetails), 102, 2) + "|"); report.AddMoreContent(streamWriter, GetRemarks(transferDetails), 102, 3);//Add content next line. streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|"); streamWriter.WriteLine((char)12); }
/// <summary> /// Add header for document receipt /// </summary> /// <param name="streamWriter">Stream writer to write the text file.</param> /// <param name="stockReceipt"></param> /// <param name="isDuplicate"></param> public void AddDocHeaderForReceipt(StreamWriter streamWriter, DDChequeEntity chequeEntity) { streamWriter.WriteLine(" "); streamWriter.WriteLine(" TAMILNADU CIVIL SUPPLIES CORPORATION "); streamWriter.Write(" "); streamWriter.Write(report.StringFormatWithoutPipe(chequeEntity.RegionName, 30, 1)); streamWriter.Write(report.StringFormatWithoutPipe("- RECEIPT -", 11, 2)); streamWriter.Write(report.StringFormatWithoutPipe(chequeEntity.GodownName, 30, 2)); streamWriter.WriteLine(""); streamWriter.Write(" RECP.NO.: "); //"R00002 DATE: 03/Jan/2011"); streamWriter.Write(report.StringFormatWithoutPipe(chequeEntity.ReceiptNo, 25, 2)); streamWriter.Write(" "); streamWriter.Write("DATE : "); streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(chequeEntity.ReceiptDate), 13, 2)); streamWriter.WriteLine(""); streamWriter.WriteLine("------------------------------------------------------------------------------"); streamWriter.Write(" Received with Thanks from Thiru / M/s."); streamWriter.Write(report.StringFormatWithoutPipe(chequeEntity.DDChequeItems[0].ReceivedFrom, 35, 2)); streamWriter.WriteLine(""); streamWriter.WriteLine(""); streamWriter.Write(" Rupees "); string Rupees = string.Empty; try { NumberToWordConvertion numberToWord = new NumberToWordConvertion(); //string[] split = chequeEntity.Total.Split('.'); Rupees = numberToWord.GetNumberToWord(chequeEntity.Total); // ConvertNumbertoWords(Convert.ToInt64(split[0].ToString())); } catch (Exception ex) { AuditLog.WriteError(ex.Message + " " + ex.StackTrace); } streamWriter.Write(report.StringFormatWithoutPipe(Rupees, 68, 2)); streamWriter.WriteLine(""); report.AddMoreContent(streamWriter, Rupees, 68, 1);//Add content next line. streamWriter.WriteLine(""); streamWriter.WriteLine(" by Cash/DD/Cheque "); streamWriter.WriteLine("------------------------------------------------------------------------------"); streamWriter.WriteLine(" DD/Cheque No. Date Bank Amount"); streamWriter.WriteLine("------------------------------------------------------------------------------"); }
/// <summary> /// Add footer for document receipt /// </summary> /// <param name="streamWriter"></param> /// <param name="stockReceipt"></param> public void AddFooter(StreamWriter streamWriter, DocumentDeliveryOrderEntity deliveryOrderList) { ManageReport report = new ManageReport(); streamWriter.WriteLine("|**(Pre.AmtBal+AmtPay)-(TotalValue+Others) = Balance >>> For Credit |"); streamWriter.WriteLine("|**(Pre.AmtBal+TotalValue+others)-(Amtpaid) = Balance >>> For Debit |"); streamWriter.WriteLine("| |"); streamWriter.WriteLine("| SIGNATURE OF GODOWN INCHARGE |"); streamWriter.WriteLine("| |"); streamWriter.WriteLine("|REMARKS |"); streamWriter.WriteLine("| " + manageReport.StringFormatWithoutPipe(deliveryOrderList.Remarks, 102, 2) + "|"); report.AddMoreContent(streamWriter, deliveryOrderList.Remarks, 102, 3);//Add content next line. streamWriter.WriteLine("|==========================================================================================================|"); streamWriter.WriteLine((char)12); }
/// <summary> /// Add footer for document receipt /// </summary> /// <param name="streamWriter"></param> /// <param name="stockReceipt"></param> public void AddFooter(StreamWriter streamWriter, DocumentStockReceiptList stockReceipt) { //GetDate() ManageSQLConnection manageSQL = new ManageSQLConnection(); DateTime dateTime = manageSQL.GetSRTime(stockReceipt.SRNo); streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|"); streamWriter.Write("|T.MEMO/IN.NO:"); streamWriter.Write(report.StringFormatWithoutPipe(stockReceipt.TruckMemoNo, 19, 2)); streamWriter.Write("LORRY NO : "); streamWriter.Write(report.StringFormatWithoutPipe(stockReceipt.LNo, 14, 2)); streamWriter.Write("TC NAME : "); streamWriter.Write(report.StringFormatWithoutPipe(stockReceipt.TransporterName, 25, 2)); streamWriter.Write("|"); streamWriter.WriteLine(" "); streamWriter.Write("|T.MEMO/IN.DT:"); streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(stockReceipt.TruckMemoDate.ToString()), 19, 2)); streamWriter.Write("LORRY FROM : "); streamWriter.Write(report.StringFormatWithoutPipe(stockReceipt.LFrom, 56, 2)); streamWriter.Write("|"); streamWriter.WriteLine(" "); streamWriter.WriteLine("| |"); streamWriter.Write("|MODE OF WEIGHMENT: "); streamWriter.Write(report.StringFormatWithoutPipe(GetWTCode(stockReceipt), 13, 2)); streamWriter.Write("WAGON NO : "); streamWriter.Write(report.StringFormatWithoutPipe("-", 14, 2)); streamWriter.Write("RR NO : "); streamWriter.Write(report.StringFormatWithoutPipe(stockReceipt.MTransport, 25, 2)); streamWriter.Write("|"); streamWriter.WriteLine(" "); streamWriter.WriteLine("| |"); streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI1, 105, 2) + "|"); streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI2, 105, 2) + "|"); streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI3, 105, 2) + "|"); streamWriter.WriteLine("| |"); streamWriter.WriteLine("| Sign. of the Authorised Person. GODOWN INCHARGE |"); streamWriter.WriteLine("| |"); streamWriter.WriteLine("|REMARKS |"); streamWriter.WriteLine("| " + report.StringFormatWithoutPipe(stockReceipt.Remarks, 102, 2) + "|"); report.AddMoreContent(streamWriter, stockReceipt.Remarks, 102, 3); streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|"); string receiptDateTime = report.FormatDate(stockReceipt.SRDate.ToString()) + " " + report.GetCurrentTime(dateTime); streamWriter.WriteLine(" Prepared DateTime:" + receiptDateTime + " Printing DateTime:" + DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss")); streamWriter.WriteLine((char)12); }
/// <summary> /// Add footer for document receipt /// </summary> /// <param name="streamWriter"></param> /// <param name="stockIssuesEntity"></param> private void AddFooter(StreamWriter streamWriter, DocumentStockIssuesEntity stockIssuesEntity) { streamWriter.WriteLine("| LORRY NO :" + report.StringFormatWithoutPipe(report.ConvertToUpper(stockIssuesEntity.LorryNo), 17, 2) + "TC NAME : " + report.StringFormatWithoutPipe(report.ConvertToUpper(stockIssuesEntity.TransporterName), 60, 2) + "|"); // streamWriter.WriteLine("| |"); streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI1, 108, 2) + "|"); streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI2, 108, 2) + "|"); streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI3, 108, 2) + "|"); streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI4, 108, 2) + "|"); streamWriter.WriteLine("|" + report.StringFormatWithoutPipe(GlobalVariable.FSSAI5, 108, 2) + "|"); streamWriter.WriteLine("| |"); streamWriter.WriteLine("| Signature of the representative. GODOWN INCHARGE |"); // streamWriter.WriteLine("| Sign. of the Authorised Person. GODOWN INCHARGE |"); streamWriter.WriteLine("| |"); streamWriter.WriteLine("|REMARKS |"); streamWriter.WriteLine("| " + report.StringFormatWithoutPipe(stockIssuesEntity.Remarks, 105, 2) + "|"); report.AddMoreContent(streamWriter, stockIssuesEntity.Remarks, 105, 3); streamWriter.WriteLine("|-------------------------------------------------------------------------------------------------------------|"); streamWriter.WriteLine((char)12); }
/// <summary> /// Write text file for Date wise record. /// </summary> /// <param name="sw">Text Streamwriter</param> /// <param name="entity">Common Entity</param> public void WriteDORegForDateWise(StreamWriter sw, CommonEntity entity) { int iCount = 10; var distinctDate = entity.dataTable.DefaultView.ToTable(true, "DeliveryOrderDate"); //Date wise DO report int i = 1; string sIssuer = string.Empty; bool CheckRepeatValue = false; string sDoNo = string.Empty; foreach (DataRow dateValue in distinctDate.Rows) { iCount = 11; string sDoNo1 = string.Empty; DataRow[] datas = entity.dataTable.Select("DeliveryOrderDate='" + dateValue["DeliveryOrderDate"] + "'"); AddHeader(sw, Convert.ToString(dateValue["DeliveryOrderDate"])); foreach (DataRow dr in datas) { if (iCount >= 50) { //Add header again iCount = 11; sw.WriteLine("----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|"); sw.WriteLine((char)12); AddHeader(sw, Convert.ToString(dateValue["DeliveryOrderDate"])); } sDoNo1 = dr["Dono"].ToString(); if (sDoNo == sDoNo1) { CheckRepeatValue = true; } else { CheckRepeatValue = false; sDoNo = sDoNo1; } sIssuer = Convert.ToString(dr["To_Whom_Issued"]).Trim(); sw.Write(report.StringFormat(CheckRepeatValue == false ? i.ToString() : " ", 4, 2)); sw.Write(report.StringFormat(CheckRepeatValue == false ? sDoNo1 : " ", 11, 1)); sw.Write(report.StringFormat(CheckRepeatValue == false ? report.Decimalformat(Convert.ToString(dr["Totals"])) : "-", 17, 1)); sw.Write(report.StringFormat(CheckRepeatValue == false ? sIssuer : " ", 15, 2)); sw.Write(report.StringFormat(dr["Cheque_DD"].ToString(), 11, 2)); sw.Write(report.StringFormat(report.Decimalformat(dr["PaymentAmount"].ToString()), 15, 1)); sw.Write(report.StringFormat(dr["Scheme"].ToString(), 13, 2)); sw.Write(report.StringFormat(dr["Commodity"].ToString(), 14, 2)); sw.Write(report.StringFormat(report.DecimalformatForWeight(dr["Netwt_Kgs"].ToString()), 11, 1)); sw.Write(report.StringFormat(report.Decimalformat(dr["Rate_Rs"].ToString()), 14, 1)); sw.Write(report.StringFormat(report.Decimalformat(dr["Itemamount"].ToString()), 15, 1)); sw.Write(report.StringFormat(report.Decimalformat(dr["PreviousAmount"].ToString()), 15, 1)); sw.Write(report.StringFormat(report.Decimalformat(dr["Adjusted"].ToString()), 13, 1)); sw.Write(report.StringFormat(report.Decimalformat(dr["Balance"].ToString()), 14, 1)); sw.Write(report.StringFormat(report.Decimalformat(dr["MarginAmount"].ToString()), 12, 1)); sw.WriteLine(""); int addedLines = 0; if (!CheckRepeatValue) { addedLines = report.AddMoreContent(sw, sIssuer, 15, 35); } sw.WriteLine(" | | | | | | | | | | | | | | |"); iCount = iCount + 2 + addedLines; i = CheckRepeatValue == false ? i + 1 : i; } sw.WriteLine("----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|"); sw.WriteLine((char)12); } }