/// <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);
}
}
