/// <summary>
/// Add Commodity wise abstract details
/// </summary>
/// <param name="sw">Streamwriter</param>
/// <param name="stockIssues">Stock issues entity</param>
/// <param name="entity">Common entity</param>
public void StockIssuesCommoditywiseAbstract(StreamWriter sw, List <SchemeIssueList> stockReceipt, CommonEntity entity)
{
int count = 11;
string weighmentType = string.Empty;
var resultSet = from d in stockReceipt
group d by new { d.Commodity } into groupedData
select new
{
NetWt = groupedData.Sum(s => s.Quantity),
GroupByNames = groupedData.Key
};
AddAbstractHeader(sw, entity);
foreach (var item in resultSet)
{
if (count >= 50)
{
count = 11;
sw.WriteLine("--------------------------------------------------------");
sw.WriteLine((char)12);
AddAbstractHeader(sw, entity);
}
sw.Write(" ");
sw.Write(report.StringFormatWithoutPipe(item.GroupByNames.Commodity, 31, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(item.NetWt.ToString()), 18, 2));
sw.WriteLine(" ");
count = count + 2;
}
sw.WriteLine("--------------------------------------------------------");
sw.WriteLine((char)12);
}
/// <summary>
/// Write the Transaction Abstract data
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void WriteTransactionForAbstract(StreamWriter sw, CommonEntity entity)
{
int iCount = 10;
var distinctCommodity = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Commodity");
//Date wise DO report
string sDoNo = string.Empty;
string sCommodity = string.Empty;
decimal dTotal = 0;
AddHeaderForTransactionReceipt(sw, entity);
foreach (DataRow dateValue in distinctCommodity.Rows)
{
iCount = 11;
bool CheckRepeatValue = false;
sCommodity = string.Empty;
sDoNo = string.Empty;
DataRow[] datas = entity.dataSet.Tables[0].Select("Commodity='" + dateValue["Commodity"] + "'");
foreach (var item in datas)
{
if (iCount >= 50)
{
//Add header again
iCount = 11;
sw.WriteLine("------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
AddHeaderForTransactionReceipt(sw, entity);
}
sCommodity = Convert.ToString(item["Commodity"]);
if (sDoNo == sCommodity)
{
CheckRepeatValue = true;
}
else
{
CheckRepeatValue = false;
sDoNo = sCommodity;
}
sw.Write(" ");
sw.Write(report.StringFormatWithoutPipe(CheckRepeatValue == false ? sCommodity : " ", 34, 2));
sw.Write(report.StringFormatWithoutPipe(item["Date"].ToString(), 10, 2));
sw.Write(report.StringFormatWithoutPipe(item["Trans_action"].ToString(), 21, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(item["Quantity"].ToString()), 15, 1));
sw.WriteLine("");
iCount = iCount + 1;
dTotal += Convert.ToDecimal(item["Quantity"].ToString());
}
sw.WriteLine("------------------------------------------------------------------------------------");
sw.Write(" ");
sw.Write(report.StringFormatWithoutPipe(" ", 34, 2));
sw.Write(report.StringFormatWithoutPipe("", 10, 2));
sw.Write(report.StringFormatWithoutPipe("", 21, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(dTotal.ToString()), 15, 1));
sw.WriteLine("");
sw.WriteLine("------------------------------------------------------------------------------------");
}
sw.WriteLine("------------------------------------------------------------------------------------");
sw.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, CommonEntity commonEntity, string reportName)
{
streamWriter.WriteLine(" ");
streamWriter.WriteLine(" TAMILNADU CIVIL SUPPLIES CORPORATION ");
streamWriter.Write(" ");
streamWriter.Write(report.StringFormatWithoutPipe(commonEntity.RName, 30, 1));
streamWriter.Write(report.StringFormatWithoutPipe(reportName, 22, 2));
streamWriter.Write(report.StringFormatWithoutPipe(commonEntity.GName, 30, 2));
streamWriter.WriteLine("");
streamWriter.Write(" Date From.: "); //"R00002 DATE: 03/Jan/2011");
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(commonEntity.FromDate), 13, 2));
streamWriter.Write(" To : ");
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(commonEntity.Todate), 13, 2));
streamWriter.WriteLine(" ");
}
/// <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, QuantityAccountEntity quantityAccount)
{
streamWriter.WriteLine(" ");
streamWriter.WriteLine(" TAMILNADU CIVIL SUPPLIES CORPORATION ");
streamWriter.Write(" ");
streamWriter.Write(report.StringFormatWithoutPipe(quantityAccount.RName, 30, 1));
streamWriter.Write(report.StringFormatWithoutPipe("- Issues Abstract -", 22, 2));
streamWriter.Write(report.StringFormatWithoutPipe(quantityAccount.GName, 30, 2));
streamWriter.WriteLine("");
streamWriter.Write(" Date From.: "); //"R00002 DATE: 03/Jan/2011");
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(quantityAccount.FromDate), 13, 2));
streamWriter.Write(" To : ");
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(quantityAccount.ToDate), 13, 2));
streamWriter.WriteLine(" ");
}
/// <summary>
///
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void DateWiseCommodityIssueMemoReport(StreamWriter sw, CommonEntity entity)
{
try
{
int count = 10;
int i = 1;
AddHeader(sw, entity);
decimal TotalAmount = 0;
foreach (DataRow row in entity.dataSet.Tables[0].Rows)
{
if (count >= 50)
{
//Add header again
count = 11;
sw.WriteLine("-----------------------------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
AddHeader(sw, entity);
}
sw.Write(" ");
sw.Write(report.StringFormatWithoutPipe(i.ToString(), 4, 2));
sw.Write(report.StringFormatWithoutPipe(row["ReceivedFrom"].ToString(), 40, 2));
sw.Write(report.StringFormatWithoutPipe(row["ReceiptNo"].ToString(), 11, 2));
sw.Write(report.StringFormatWithoutPipe(report.FormatDirectDate(row["Date"].ToString()), 10, 2));
sw.Write(report.StringFormatWithoutPipe(row["PaymentType"].ToString(), 3, 2));
sw.Write(report.StringFormatWithoutPipe(row["DDNo"].ToString(), 15, 2));
sw.Write(report.StringFormatWithoutPipe(row["DDDate"].ToString(), 10, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(row["Amount"].ToString()), 15, 1));
sw.Write(report.StringFormatWithoutPipe(row["Bank"].ToString(), 32, 2));
sw.WriteLine("");
TotalAmount += Convert.ToDecimal(report.Decimalformat(row["Amount"].ToString()));
i = i + 1;
count = count + 1;
}
sw.WriteLine("-----------------------------------------------------------------------------------------------------------------------------------------------------");
sw.Write(" TOTAL AMOUNT ");
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(TotalAmount.ToString()), 15, 1));
sw.WriteLine("");
sw.WriteLine("-----------------------------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message);
}
}
/// <summary>
///
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void DateWiseSchemeReceiptReport(StreamWriter sw, CommonEntity entity)
{
int count = 11;
// var dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Date");
int i = 1;
string SINO = string.Empty;
bool isDataAvailable = false;
//foreach (DataRow date in dateList.Rows)
//{
isDataAvailable = true;
AddHeader(sw, entity);
// DataRow[] data = entity.dataSet.Tables[0].Select("Date='" + date["Date"] + "'");
foreach (DataRow row in entity.dataSet.Tables[0].Rows)
{
if (count >= 50)
{
//Add header again
count = 11;
sw.WriteLine("---------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
AddHeader(sw, entity);
}
sw.Write(report.StringFormatWithoutPipe(i.ToString(), 4, 2));
sw.Write(report.StringFormatWithoutPipe(row["Ackno"].ToString(), 14, 2));
sw.Write(report.StringFormatWithoutPipe(row["Date"].ToString(), 10, 2));
sw.Write(report.StringFormatWithoutPipe(row["Commodity"].ToString(), 16, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(row["Quantity"].ToString()), 20, 1));
sw.Write(report.StringFormatWithoutPipe(Convert.ToString(row["RecdFrom"]).Trim(), 23, 2));
sw.Write(report.StringFormatWithoutPipe(row["TruckMemoNo"].ToString(), 11, 2));
sw.Write(report.StringFormatWithoutPipe(row["Lorryno"].ToString(), 10, 2));
sw.WriteLine("");
sw.WriteLine(" ");
i = i + 1;
count++;
}
sw.WriteLine("---------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
//}
if (!isDataAvailable)
{
sw.WriteLine("---------------------------------------------------------------------------------------------------");
sw.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 header for document receipt
/// </summary>
/// <param name="streamWriter">Stream writer to write the text file.</param>
/// <param name="deliveryOrderList"></param>
/// <param name="isDuplicate"></param>
public void AddDocHeaderForDeliveryOrder(StreamWriter streamWriter, DocumentDeliveryOrderEntity deliveryOrderEntity, bool isDuplicate = false)
{
streamWriter.WriteLine("|==========================================================================================================|");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| TAMILNADU CIVIL SUPPLIES CORPORATION |");
streamWriter.Write("| ");
streamWriter.Write(manageReport.StringFormatWithoutPipe("REGION : ", 9, 1));
streamWriter.Write(manageReport.StringFormat(deliveryOrderEntity.RegionName, 50, 2));
streamWriter.WriteLine("");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| DELIVERY ORDER |");
streamWriter.WriteLine("|==========================================================================================================|");
streamWriter.Write("|TRANSACTION:");
streamWriter.Write(manageReport.StringFormatWithoutPipe(deliveryOrderEntity.TransactionName, 21, 2));
streamWriter.Write("GODOWN NAME: ");
streamWriter.Write(manageReport.StringFormat(deliveryOrderEntity.GodownName, 59, 2));
streamWriter.WriteLine(" ");
streamWriter.Write("|DELIVERY ORDER: ");
streamWriter.Write(manageReport.StringFormatWithoutPipe(deliveryOrderEntity.Dono, 16, 2));
streamWriter.Write("DATE: ");
streamWriter.Write(manageReport.StringFormatWithoutPipe(manageReport.FormatIndianDate(deliveryOrderEntity.DoDate.ToString()), 66, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.WriteLine("|==========================================================================================================|");
streamWriter.Write("|ISSUE TO:");
streamWriter.Write(manageReport.StringFormatWithoutPipe(deliveryOrderEntity.ReceivorName, 96, 2) + "|");
streamWriter.WriteLine(" ");
streamWriter.Write("|INDENT NO:");
streamWriter.Write(manageReport.StringFormatWithoutPipe(deliveryOrderEntity.IndentNo, 21, 2));
// streamWriter.Write(manageReport.StringFormatWithoutPipe("DATE: ", 25, 1));
streamWriter.Write("PERMIT DATE:");
streamWriter.Write(manageReport.StringFormatWithoutPipe(manageReport.FormatDate(deliveryOrderEntity.PermitDate.ToString()), 13, 2));
streamWriter.Write("ORDER PERIOD ENDING:");
streamWriter.Write(manageReport.StringFormatWithoutPipe(deliveryOrderEntity.OrderPeriod, 27, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.WriteLine("|==========================================================================================================|");
}
///</summary>
///
/// <param name="sw"></param>
/// <param name="entity"></param>
public void DateWiseHullingDetails(StreamWriter sw, CommonEntity entity)
{
int iCount = 11;
int i = 1;
string SRNO = string.Empty;
bool isDataAvailable = false;
// foreach (DataRow dateValue in distinctDate.Rows)
//{
isDataAvailable = true;
AddHeader(sw, entity);
// DataRow[] datas = entity.dataSet.Tables[0].Select("HullingReportDate='" + dateValue["HullingReportDate"] + "'");
foreach (DataRow dr in entity.dataSet.Tables[0].Rows)
{
if (iCount >= 50)
{
iCount = 11;
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
AddHeader(sw, entity);
}
//sIssuer = Convert.ToString(dr["DepositorName"]).Trim();
sw.Write(report.StringFormatWithoutPipe(i.ToString(), 4, 2));
sw.Write(report.StringFormatWithoutPipe(dr["SRNo"].ToString(), 18, 2));
sw.Write(report.StringFormatWithoutPipe(report.FormatDirectDate(dr["SRDate"].ToString()), 16, 2));
sw.Write(report.StringFormatWithoutPipe(Convert.ToString(dr["DepositorName"]).Trim(), 37, 2));
sw.Write(report.StringFormatWithoutPipe(dr["ITDescription"].ToString(), 26, 2));
sw.Write(report.StringFormatWithoutPipe(dr["NoPacking"].ToString(), 12, 1));
sw.Write(report.StringFormatWithoutPipe(dr["Nkgs"].ToString(), 19, 1));
sw.WriteLine("");
sw.WriteLine(" ");
i = i + 1;
iCount++;
}
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
if (!isDataAvailable)
{
sw.WriteLine("---------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
}
}
/// <summary>
///
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void DateWiseCommodityIssueMemoReport(StreamWriter sw, CommonEntity entity)
{
try
{
int count = 10;
// var dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Issue_Date");
int i = 1;
string issuedTo = string.Empty;
AddHeader(sw, entity);
foreach (DataRow row in entity.dataSet.Tables[0].Rows)
{
if (count >= 50)
{
//Add header again
count = 11;
sw.WriteLine("---------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
AddHeader(sw, entity);
}
issuedTo = Convert.ToString(row["Issuedto"]).Trim();
sw.Write(report.StringFormatWithoutPipe(i.ToString(), 4, 2));
sw.Write(report.StringFormatWithoutPipe(row["Issue_Memono"].ToString(), 16, 1));
sw.Write(report.StringFormatWithoutPipe(row["Issue_Date"].ToString(), 10, 1) + " ");
sw.Write(report.StringFormatWithoutPipe(row["Commodity"].ToString(), 17, 2));
sw.Write(report.StringFormatWithoutPipe(row["Quantity"].ToString(), 18, 1));
sw.Write(report.StringFormatWithoutPipe(issuedTo, 24, 2));
sw.Write(report.StringFormatWithoutPipe(row["Lorryno"].ToString(), 11, 1));
sw.WriteLine("");
sw.WriteLine(" ");
i = i + 1;
count = count + 2;
}
sw.WriteLine("---------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message);
}
}
/// <summary>
///
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void DateWiseCommodityIssueMemoReport(StreamWriter sw, CommonEntity entity, DataTable ndt)
{
try
{
int count = 8;
// var dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Issue_Date");
int pageNo = 1;
decimal Payment = 0;
decimal Ceral = 0;
decimal NonCeral = 0;
AddHeader(sw, entity, pageNo);
foreach (DataRow row in ndt.Rows)
{
if (count >= 50)
{
//Add header again
pageNo++;
count = 8;
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
AddHeader(sw, entity, pageNo);
}
sw.Write(" ");
sw.Write(report.StringFormatWithoutPipe(row["GodownName"].ToString(), 24, 2));
sw.Write(report.StringFormatWithoutPipe(row["Society"].ToString(), 34, 2));
sw.Write(report.StringFormatWithoutPipe(row["Dono"].ToString(), 10, 2));
sw.Write(report.StringFormatWithoutPipe(row["Dodate"].ToString(), 10, 2) + " ");
sw.Write(report.StringFormatWithoutPipe(row["Chequeno"].ToString(), 10, 2));
sw.Write(report.StringFormatWithoutPipe(row["Chequedate"].ToString(), 10, 2));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(row["PaymentAmount"].ToString()), 12, 1) + " ");
sw.Write(report.StringFormatWithoutPipe(row["Bank"].ToString(), 14, 2));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(row["Cereal"].ToString()), 12, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(row["NonCereal"].ToString()), 12, 1));
sw.WriteLine("");
count = count + 1;
Payment += !string.IsNullOrEmpty(row["PaymentAmount"].ToString()) ? Convert.ToDecimal(row["PaymentAmount"]) : 0;
Ceral += !string.IsNullOrEmpty(row["Cereal"].ToString()) ? Convert.ToDecimal(row["Cereal"]) : 0;
NonCeral += !string.IsNullOrEmpty(row["NonCereal"].ToString()) ? Convert.ToDecimal(row["NonCereal"]) : 0;
}
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------------");
sw.Write(report.StringFormatWithoutPipe(" ", 25, 2));
sw.Write(report.StringFormatWithoutPipe(" ", 34, 2));
sw.Write(report.StringFormatWithoutPipe(" ", 10, 2));
sw.Write(report.StringFormatWithoutPipe(" ", 10, 2) + " ");
sw.Write(report.StringFormatWithoutPipe(" ", 10, 2));
sw.Write(report.StringFormatWithoutPipe("Total", 10, 2));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(Convert.ToString(Payment)), 12, 1) + " ");
sw.Write(report.StringFormatWithoutPipe("", 14, 2));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(Convert.ToString(Ceral)), 12, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(Convert.ToString(NonCeral)), 12, 1));
sw.WriteLine("");
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " " + ex.StackTrace);
}
}
/// <summary>
/// Add header for document receipt
/// </summary>
/// <param name="streamWriter">Stream writer to write the text file.</param>
/// <param name="stockIssuesEntity"></param>
/// <param name="isDuplicate"></param>
public void AddDocHeaderForIssues(StreamWriter streamWriter, StackEntity stackEntity)
{
streamWriter.WriteLine(" ");
streamWriter.WriteLine(" TAMILNADU CIVIL SUPPLIES CORPORATION ");
streamWriter.Write(" ");
streamWriter.Write(report.StringFormatWithoutPipe("REGION : ", 9, 1));
streamWriter.Write(report.StringFormatWithoutPipe(stackEntity.RName, 45, 2));
streamWriter.WriteLine("");
streamWriter.Write(" Godown :");
streamWriter.Write(report.StringFormatWithoutPipe(stackEntity.GName, 25, 2));
streamWriter.WriteLine("");
streamWriter.WriteLine(" Formation Year: " + stackEntity.StackDate);
streamWriter.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------");
streamWriter.WriteLine(" OPENING BALANCE RECEIPT RECEIPT ISSUE ISSUE BALANCE BALANCE STACK");
streamWriter.WriteLine(" SNO COMMODITY STACKNO FROM DATE TO DATE BAGS QTY BAGS GU QTY BAGS GR QTY BAGS QTY STATUS W/OFF QTY");
streamWriter.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------");
}
/// <summary>
/// Write the Sales Customer Details
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void WriteHoPurchase(StreamWriter sw, CommonEntity entity)
{
int iCount = 10;
var distinctCoop = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Depositor");
var distinctCommodity = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Commodity");
//var distinctCommodity = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Commodity");
int i = 1;
string sAckno = string.Empty;
string sDepositor = string.Empty;
string sCommodity = string.Empty;
decimal dTotal = 0;
decimal gTotal = 0;
bool dAvailable = false;
AddHeaderForHoPurchase(sw, entity);
foreach (DataRow CommodityValue in distinctCommodity.Rows)
{
gTotal = 0;
foreach (DataRow dateValue in distinctCoop.Rows)
{
dAvailable = false;
iCount = 11;
bool CheckRepeatValue = false;
sAckno = string.Empty;
sDepositor = string.Empty;
DataRow[] datas = entity.dataSet.Tables[0].Select("Depositor='" + dateValue["Depositor"] + "' and Commodity='" + CommodityValue["Commodity"] + "'");
foreach (var item in datas)
{
dAvailable = true;
if (iCount >= 50)
{
//Add header again
iCount = 11;
sw.WriteLine("-------------------------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
AddHeaderForHoPurchase(sw, entity);
}
sDepositor = Convert.ToString(item["Depositor"]);
if (sAckno == sDepositor)
{
CheckRepeatValue = true;
}
else
{
CheckRepeatValue = false;
sAckno = sDepositor;
}
sw.Write(report.StringFormatWithoutPipe(i.ToString(), 4, 2));
sw.Write(report.StringFormatWithoutPipe(item["Ackno"].ToString(), 11, 2));
sw.Write(report.StringFormatWithoutPipe(report.FormatDirectDate(item["Date"].ToString()), 10, 2));
sw.Write(report.StringFormatWithoutPipe(CheckRepeatValue == false ? sDepositor : " ", 35, 2));
sw.Write(report.StringFormatWithoutPipe(item["Commodity"].ToString(), 27, 2));
sw.Write(report.StringFormatWithoutPipe(item["Bags"].ToString(), 6, 1));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(item["Quantity"].ToString()), 14, 1));
sw.Write(report.StringFormatWithoutPipe((item["TruckMen"].ToString()), 16, 2));
sw.Write(report.StringFormatWithoutPipe((item["orderno"].ToString()), 14, 2));
sw.Write(report.StringFormatWithoutPipe((item["Lorryno"].ToString()), 13, 2));
sw.WriteLine("");
iCount = iCount + 1;
dTotal += Convert.ToDecimal(item["Quantity"].ToString());
// gTotal += Convert.ToDecimal(item["Quantity"].ToString());
i = i + 1;
}
if (dAvailable)
{
sw.Write(" ");
sw.Write(report.StringFormatWithoutPipe(" ", 34, 2));
sw.Write(report.StringFormatWithoutPipe("", 27, 2));
sw.Write(report.StringFormatWithoutPipe("Total".ToString(), 11, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(dTotal.ToString()), 37, 1));
gTotal += dTotal;
dTotal = 0;
sw.WriteLine("");
}
}
sw.Write(" ");
sw.Write(report.StringFormatWithoutPipe(" ", 34, 2));
sw.Write(report.StringFormatWithoutPipe("", 27, 2));
sw.Write(report.StringFormatWithoutPipe("Grand Total".ToString(), 11, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(gTotal.ToString()), 37, 1));
dTotal = 0;
sw.WriteLine("");
sw.WriteLine("---------------------------------------------------------------------------------------------------------------------------------------------------------------|");
}
}
/// <summary>
///
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void SocietyWiseDOAllSchemeReport(StreamWriter sw, CommonEntity entity)
{
int count = 10;
int i = 1;
string doNo = string.Empty;
string fromWhomRcd = string.Empty;
bool isDataAvailable = false;
decimal Qty = 0;
decimal Rate = 0;
decimal C_Amount = 0;
decimal NC_Amount = 0;
decimal Toatal_C_Amount = 0;
decimal Total_NC_Amount = 0;
decimal Amount = 0;
decimal GrandTotal_C = 0;
decimal GrandTotal_NC = 0;
decimal GrandTotal = 0;
count = 11;
try
{
// dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, new string[] { "Coop", "Comodity" });
var dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Coop");
foreach (DataRow date in dateList.Rows)
{
Qty = 0;
Rate = 0;
C_Amount = 0;
NC_Amount = 0;
Amount = 0;
Toatal_C_Amount = 0;
Total_NC_Amount = 0;
GrandTotal_C = 0;
GrandTotal_NC = 0;
GrandTotal = 0;
isDataAvailable = true;
string doNoNext = string.Empty;
string coop = string.Empty;
AddHeader(sw, entity);
coop = Convert.ToString(date["Coop"]);
DataRow[] data = entity.dataSet.Tables[0].Select("Coop='" + coop + "'");
var distinctCommodity = report.ConvertDataRowToTable(data, entity.dataSet.Tables[0]).DefaultView.ToTable(true, "Comodity");
sw.WriteLine(report.StringFormatWithoutPipe(coop, 50, 2));
foreach (DataRow item in distinctCommodity.Rows)
{
Qty = 0;
Rate = 0;
C_Amount = 0;
NC_Amount = 0;
Amount = 0;
Toatal_C_Amount = 0;
Total_NC_Amount = 0;
DataRow[] ndata = entity.dataSet.Tables[0].Select("Coop='" + coop + "' and Comodity='" + Convert.ToString(item["Comodity"]) + "'");
foreach (DataRow row in ndata)
{
C_Amount = 0;
NC_Amount = 0;
if (count >= 50)
{
//Add header again
count = 11;
sw.WriteLine("---------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
AddHeader(sw, entity);
}
doNoNext = row["Dono"].ToString();
C_Amount = (row["C_Nc"].ToString() == "C") ? Convert.ToDecimal(row["Amount"]) : 0;
NC_Amount = (row["C_Nc"].ToString() == "NC") ? Convert.ToDecimal(row["Amount"]) : 0;
sw.Write(report.StringFormatWithoutPipe(row["GodownName"].ToString(), 25, 2));
sw.Write(report.StringFormatWithoutPipe(doNoNext, 11, 1));
sw.Write(report.StringFormatWithoutPipe(report.FormatDirectDate(row["Dodate"].ToString()), 10, 2));
sw.Write(report.StringFormatWithoutPipe(row["Comodity"].ToString(), 15, 2));
sw.Write(report.StringFormatWithoutPipe(row["Scheme"].ToString(), 11, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(row["Quantity"].ToString()), 11, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(row["Rate"].ToString()), 10, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(Convert.ToString(C_Amount)), 11, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(Convert.ToString(NC_Amount)), 11, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(row["Amount"].ToString()), 11, 1));
sw.WriteLine("");
Rate += !string.IsNullOrEmpty(Convert.ToString(row["Rate"])) ? Convert.ToDecimal(row["Rate"].ToString()) : 0;
Toatal_C_Amount += !string.IsNullOrEmpty(Convert.ToString(C_Amount)) ? C_Amount : 0;
Total_NC_Amount += !string.IsNullOrEmpty(Convert.ToString(NC_Amount)) ? NC_Amount : 0;
Amount += !string.IsNullOrEmpty(Convert.ToString(row["Amount"])) ? Convert.ToDecimal(row["Amount"].ToString()) : 0;
Qty += !string.IsNullOrEmpty(Convert.ToString(row["Quantity"])) ? Convert.ToDecimal(row["Quantity"].ToString()) : 0;
i = i + 1;
count++;
}
sw.WriteLine("---------------------------------------------------------------------------------------------------------------------------------");
sw.Write(report.StringFormatWithoutPipe("", 36, 2));
sw.Write(report.StringFormatWithoutPipe("", 10, 2));
sw.Write(report.StringFormatWithoutPipe("", 15, 2));
sw.Write(report.StringFormatWithoutPipe(" Total ", 11, 1));
sw.Write(report.StringFormatWithoutPipe(Qty.ToString(), 11, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(Rate.ToString()), 10, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(Toatal_C_Amount.ToString()), 11, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(Total_NC_Amount.ToString()), 11, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(Amount.ToString()), 11, 1));
GrandTotal_C += Toatal_C_Amount;
GrandTotal_NC += Total_NC_Amount;
GrandTotal += Amount;
sw.WriteLine("");
sw.WriteLine("---------------------------------------------------------------------------------------------------------------------------------");
}
sw.WriteLine("---------------------------------------------------------------------------------------------------------------------------------");
sw.Write(report.StringFormatWithoutPipe("", 36, 2));
sw.Write(report.StringFormatWithoutPipe("", 10, 2));
sw.Write(report.StringFormatWithoutPipe("", 15, 2));
sw.Write(report.StringFormatWithoutPipe(" Demand ", 11, 1));
sw.Write(report.StringFormatWithoutPipe(" ", 11, 1));
sw.Write(report.StringFormatWithoutPipe(" ", 10, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(GrandTotal_C.ToString()), 11, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(GrandTotal_NC.ToString()), 11, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(GrandTotal.ToString()), 11, 1));
sw.WriteLine("");
sw.WriteLine("---------------------------------------------------------------------------------------------------------------------------------");
//Check Collections
sw.WriteLine((char)12);
}
if (!isDataAvailable)
{
sw.WriteLine("---------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
}
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message);
}
}
/// <summary>
///
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void CommodityWiseIssueMemoReport(StreamWriter sw, CommonEntity entity)
{
try
{
int count = 8;
var dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Commodity");
int pageNo = 1;
decimal netweight = 0;
AddHeader(sw, entity, pageNo);
int i = 1;
foreach (DataRow nrow in dateList.Rows)
{
netweight = 0;
DataRow[] drdata = entity.dataSet.Tables[0].Select("Commodity='" + Convert.ToString(nrow["Commodity"]) + "'");
foreach (DataRow row in drdata)
{
if (count >= 50)
{
//Add header again
pageNo++;
count = 8;
sw.WriteLine("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
AddHeader(sw, entity, pageNo);
}
sw.Write("");
sw.Write(report.StringFormatWithoutPipe(i.ToString(), 4, 2));
sw.Write(report.StringFormatWithoutPipe(row["Issue_Date"].ToString(), 10, 2));
sw.Write(report.StringFormatWithoutPipe(row["Issueno"].ToString(), 11, 1) + " ");
sw.Write(report.StringFormatWithoutPipe(row["Commodity"].ToString(), 16, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(row["NetWt"].ToString()), 11, 1) + " ");
sw.Write(report.StringFormatWithoutPipe(row["Stackno"].ToString(), 14, 2));
sw.Write(report.StringFormatWithoutPipe(row["remarks"].ToString(), 101, 2));
sw.WriteLine("");
count = count + 1;
netweight += !string.IsNullOrEmpty(row["NetWt"].ToString()) ? Convert.ToDecimal(row["NetWt"]) : 0;
i++;
}
sw.WriteLine("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------");
sw.Write("");
sw.Write(report.StringFormatWithoutPipe("", 4, 2));
sw.Write(report.StringFormatWithoutPipe("Total", 10, 2));
sw.Write(report.StringFormatWithoutPipe("-", 11, 1) + " ");
sw.Write(report.StringFormatWithoutPipe("-", 16, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(Convert.ToString(netweight)), 11, 1) + " ");
sw.Write(report.StringFormatWithoutPipe("-", 14, 2));
sw.Write(report.StringFormatWithoutPipe("-", 101, 2));
sw.WriteLine("");
sw.WriteLine("-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------");
count = count + 1;
}
sw.WriteLine((char)12);
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " " + ex.StackTrace);
}
}
/// <summary>
/// Add date wise stock issues
/// </summary>
/// <param name="sw">Stream writer</param>
/// <param name="entity">Common eitity</param>
public void DateWiseStockIssuesRegister(StreamWriter sw, CommonEntity entity)
{
int count = 10;
var dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Issue_Date");
int i = 1;
string issueMemo = string.Empty;
string fromWhomRcd = string.Empty;
bool CheckRepeatValue = false;
string weighmentType = string.Empty;
foreach (DataRow date in dateList.Rows)
{
count = 11;
string issueMemoNext = string.Empty;
DataRow[] data = entity.dataSet.Tables[0].Select("Issue_Date='" + date["Issue_Date"] + "'");
AddHeaderForDateWise(sw, Convert.ToString(date["Issue_Date"]));
foreach (DataRow row in data)
{
if (count >= 50)
{
//Add header again
count = 11;
sw.WriteLine("---------------------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
AddHeaderForDateWise(sw, Convert.ToString(date["Issue_Date"]));
}
weighmentType = row["ITBweighment"].ToString().ToUpper();
issueMemoNext = row["Issue_Memono"].ToString();
fromWhomRcd = Convert.ToString(row["To_Whom_Issued"]).Trim();
if (issueMemo == issueMemoNext)
{
CheckRepeatValue = true;
}
else
{
CheckRepeatValue = false;
issueMemo = issueMemoNext;
}
sw.Write(report.StringFormatWithoutPipe(CheckRepeatValue == false ? i.ToString() : " ", 4, 2));
sw.Write(report.StringFormatWithoutPipe(CheckRepeatValue == false ? issueMemoNext : " ", 11, 1));
sw.Write(report.StringFormatWithoutPipe(CheckRepeatValue == false ? row["DNo"].ToString() : " ", 11, 2));
sw.Write(report.StringFormatWithoutPipe(CheckRepeatValue == false ? row["Lorryno"].ToString() : " ", 11, 1));
sw.Write(report.StringFormatWithoutPipe(CheckRepeatValue == false ? fromWhomRcd : " ", 33, 2));
sw.Write(report.StringFormatWithoutPipe(row["Scheme"].ToString(), 12, 2));
sw.Write(report.StringFormatWithoutPipe(row["Stackno"].ToString(), 12, 1));
sw.Write(report.StringFormatWithoutPipe(row["NoPacking"].ToString(), 8, 1));
sw.Write(report.StringFormatWithoutPipe(row["Commodity"].ToString(), 17, 2));
sw.Write(report.StringFormatWithoutPipe(weighmentType == "NOS" ? row["NetWt"].ToString() : report.DecimalformatForWeight(row["NetWt"].ToString()), 14, 1));
sw.WriteLine("");
i = CheckRepeatValue == false ? i + 1 : i;
count++;
}
sw.WriteLine((char)12);
}
sw.WriteLine("---------------------------------------------------------------------------------------------------------------------------------------------");
if (count == 11)
{
sw.WriteLine((char)12);
}
}
/// <summary>
/// Write the Sales Customer Details
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void WriteSalesIssueMemo(StreamWriter sw, CommonEntity entity)
{
int iCount = 11;
int i = 1;
var distinctCoop = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Coop");
//var distinctCommodity = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Commodity");
string sAckno = string.Empty;
string sCoop = string.Empty;
string sCommodity = string.Empty;
decimal dTotal = 0;
decimal gTotal = 0;
AddHeaderForCustomerDetail(sw, entity);
foreach (DataRow dateValue in distinctCoop.Rows)
{
bool CheckRepeatValue = false;
sCoop = string.Empty;
sAckno = string.Empty;
sCommodity = string.Empty;
DataRow[] datas = entity.dataSet.Tables[0].Select("Coop='" + dateValue["Coop"] + "'");
//DataRow[] datac = entity.dataSet.Tables[0].Select("Commodity='" + dateValue["Commodity"] + "'");
foreach (var item in datas)
{
if (iCount >= 50)
{
//Add header again
iCount = 11;
sw.WriteLine("----------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
AddHeaderForCustomerDetail(sw, entity);
}
sCoop = Convert.ToString(item["Coop"]);
if (sAckno == sCoop)
{
CheckRepeatValue = true;
}
else
{
CheckRepeatValue = false;
sAckno = sCoop;
}
sw.Write(report.StringFormatWithoutPipe(i.ToString(), 4, 2));
sw.Write(report.StringFormatWithoutPipe(item["Ackno"].ToString(), 12, 2));
//sw.Write(report.StringFormatWithoutPipe(report.FormatDirectDate(dateValue["Date"].ToString()), 16, 2));
sw.Write(report.StringFormatWithoutPipe(report.FormatDirectDate(item["Date"].ToString()), 10, 2));
sw.Write(report.StringFormatWithoutPipe(CheckRepeatValue == false ? sCoop : " ", 35, 2));
sw.Write(report.StringFormatWithoutPipe(item["Scheme"].ToString(), 13, 2));
sw.Write(report.StringFormatWithoutPipe(item["Commodity"].ToString(), 27, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(item["Quantity"].ToString()), 11, 1));
sw.Write(report.StringFormatWithoutPipe((item["Rate"].ToString()), 10, 1));
sw.Write(report.StringFormatWithoutPipe((item["Value"].ToString()), 11, 1));
sw.WriteLine("");
iCount = iCount + 1;
dTotal += Convert.ToDecimal(item["Quantity"].ToString());
gTotal += Convert.ToDecimal(item["Quantity"].ToString());
i = i + 1;
iCount++;
}
//sw.WriteLine("-------------------------------------------------------------------------------------------------------------------------------------|");
sw.Write(" ");
sw.Write(report.StringFormatWithoutPipe(" ", 34, 2));
sw.Write(report.StringFormatWithoutPipe("", 28, 2));
sw.Write(report.StringFormatWithoutPipe("Total".ToString(), 11, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(dTotal.ToString()), 41, 1));
dTotal = 0;
sw.WriteLine("");
//sw.WriteLine("-------------------------------------------------------------------------------------------------------------------------------------|");
}
sw.WriteLine("----------------------------------------------------------------------------------------------------------------------------------------------|");
sw.Write(" ");
sw.Write(report.StringFormatWithoutPipe(" ", 34, 2));
sw.Write(report.StringFormatWithoutPipe("", 28, 2));
sw.Write(report.StringFormatWithoutPipe("Grand Total".ToString(), 12, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(gTotal.ToString()), 40, 1));
sw.WriteLine("");
sw.WriteLine("----------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
}
/// <summary>
///
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void SocietyWiseDOAllSchemeReport(StreamWriter sw, CommonEntity entity)
{
int count = 8;
int i = 1;
string doNo = string.Empty;
string fromWhomRcd = string.Empty;
bool isDataAvailable = false;
decimal Due = 0;
decimal Paid = 0;
decimal AdvanceCollection = 0;
decimal Debit = 0;
decimal GrandTotal_Due = 0;
decimal GrandTotal_Paid = 0;
decimal GrandTotal_ADV = 0;
decimal GrandTotal_Debit = 0;
try
{
// dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, new string[] { "Coop", "Comodity" });
var dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, "issuername");
AddHeader(sw, entity);
foreach (DataRow date in dateList.Rows)
{
Due = 0;
Paid = 0;
AdvanceCollection = 0;
Debit = 0;
isDataAvailable = true;
string doNoNext = string.Empty;
string coop = string.Empty;
coop = Convert.ToString(date["issuername"]);
DataRow[] data = entity.dataSet.Tables[0].Select("issuername='" + coop + "'");
i = 1;
foreach (DataRow row in data)
{
if (count >= 50)
{
//Add header again
count = 8;
sw.WriteLine("----------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
AddHeader(sw, entity);
}
sw.Write(report.StringFormatWithoutPipe(row["GodownName"].ToString(), 25, 2));
sw.Write(report.StringFormatWithoutPipe(row["Dono"].ToString(), 10, 2));
sw.Write(report.StringFormatWithoutPipe(i == 1 ? row["issuername"].ToString() : " ", 30, 2));
sw.Write(report.StringFormatWithoutPipe(report.FormatDirectDate(row["DoDate"].ToString()), 10, 2));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(row["Due"].ToString()), 13, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(row["Paid"].ToString()), 12, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(row["AdvanceCollection"].ToString()), 13, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(row["Debit"].ToString()), 12, 1));
sw.WriteLine("");
Due += !string.IsNullOrEmpty(Convert.ToString(row["Due"])) ? Convert.ToDecimal(row["Due"].ToString()) : 0;
Paid += !string.IsNullOrEmpty(Convert.ToString(row["Paid"])) ? Convert.ToDecimal(row["Paid"].ToString()) : 0;
AdvanceCollection += !string.IsNullOrEmpty(Convert.ToString(row["AdvanceCollection"])) ? Convert.ToDecimal(row["AdvanceCollection"].ToString()) : 0;
Debit += !string.IsNullOrEmpty(Convert.ToString(row["Debit"])) ? Convert.ToDecimal(row["Debit"].ToString()) : 0;
i = 2;
count++;
}
sw.WriteLine("----------------------------------------------------------------------------------------------------------------------------------");
sw.Write(report.StringFormatWithoutPipe(" ", 35, 2));
sw.Write(report.StringFormatWithoutPipe(" ", 30, 2));
sw.Write(report.StringFormatWithoutPipe("Total", 10, 2));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(Due.ToString()), 13, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(Paid.ToString()), 12, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(AdvanceCollection.ToString()), 13, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(Debit.ToString()), 12, 1));
sw.WriteLine("");
GrandTotal_Due += Due;
GrandTotal_Paid += Paid;
GrandTotal_ADV += AdvanceCollection;
GrandTotal_Debit += Debit;
sw.WriteLine("----------------------------------------------------------------------------------------------------------------------------------");
}
sw.WriteLine("----------------------------------------------------------------------------------------------------------------------------------");
sw.Write(report.StringFormatWithoutPipe(" ", 35, 2));
sw.Write(report.StringFormatWithoutPipe(" ", 20, 2));
sw.Write(report.StringFormatWithoutPipe("Grand Total", 20, 2));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(GrandTotal_Due.ToString()), 13, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(GrandTotal_Paid.ToString()), 12, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(GrandTotal_ADV.ToString()), 13, 1));
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(GrandTotal_Debit.ToString()), 12, 1));
sw.WriteLine("");
sw.WriteLine("----------------------------------------------------------------------------------------------------------------------------------");
//Check Collections
sw.WriteLine((char)12);
if (!isDataAvailable)
{
sw.WriteLine("----------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
}
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message);
}
}
/// <summary>
/// Add header for document receipt
/// </summary>
/// <param name="streamWriter">Stream writer to write the text file.</param>
/// <param name="stockIssuesEntity"></param>
/// <param name="isDuplicate"></param>
public void AddDocHeaderForIssues(StreamWriter streamWriter, List <StackCardEntity> stackCardEntities, StackEntity stackEntity)
{
streamWriter.WriteLine(" ");
streamWriter.WriteLine(" TAMILNADU CIVIL SUPPLIES CORPORATION ");
streamWriter.Write(" ");
streamWriter.Write(report.StringFormatWithoutPipe("REGION : ", 9, 1));
streamWriter.Write(report.StringFormatWithoutPipe(stackEntity.RName, 45, 2));
streamWriter.WriteLine("");
streamWriter.Write(" Commodity: ");
streamWriter.Write(report.StringFormatWithoutPipe(stackEntity.ITName, 25, 2));
streamWriter.Write(" Godown :");
streamWriter.Write(report.StringFormatWithoutPipe(stackEntity.GName, 25, 2));
streamWriter.WriteLine("");
streamWriter.WriteLine(" Stack.No: " + stackEntity.TStockNo);
streamWriter.WriteLine("----|--------------------------------|-----------------------------------------|");
streamWriter.WriteLine(" | RECEIPT | ISSUES |");
streamWriter.WriteLine("----|--------------------------------|-----------------------------------------|");
streamWriter.WriteLine("Slno| DATE Bags. Quantity | Bags. Quantity Clo.Bal. |");
streamWriter.WriteLine("----|--------------------------------|-----------------------------------------|");
}
/// <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, DocumentStockReceiptList stockReceipt, bool isDuplicate = false)
{
streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| TAMILNADU CIVIL SUPPLIES CORPORATION |");
streamWriter.Write("| ");
streamWriter.Write(report.StringFormatWithoutPipe("REGION : ", 9, 1));
streamWriter.Write(report.StringFormat(stockReceipt.RegionName, 53, 2));
streamWriter.WriteLine("");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| |");
if (isDuplicate)
{
streamWriter.WriteLine("| STOCK RECEIPT ACKNOWLEDGMENT DUPLICATE COPY |");
}
else
{
streamWriter.WriteLine("| STOCK RECEIPT ACKNOWLEDGMENT |");
}
streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|");
streamWriter.Write("|ACKNOWLEDGEMENT NO:");
streamWriter.Write(report.StringFormatWithoutPipe(stockReceipt.SRNo, 21, 2));
streamWriter.Write("ALLOTMENT/RELEASE ORDER: ");
streamWriter.Write(report.StringFormatWithoutPipe(stockReceipt.OrderNo + " " + stockReceipt.PAllotment, 16, 2));
streamWriter.Write("GATE PASS : "******"", 10, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.Write("| DATE:");
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(stockReceipt.SRDate.ToString()), 21, 2));
streamWriter.Write(report.StringFormatWithoutPipe("DATE: ", 25, 1));
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(stockReceipt.OrderDate.ToString()), 38, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.Write("|PERIOD OF ALLOTMENT:");
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(stockReceipt.SRDate.ToString()), 30, 2));
streamWriter.Write("Transaction Type: ");
streamWriter.Write(report.StringFormatWithoutPipe(stockReceipt.TransactionName, 36, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.Write("|RECEIVING GODOWN:");
streamWriter.Write(report.StringFormatWithoutPipe(stockReceipt.GodownName, 30, 2));
streamWriter.Write("DEPOSITOR'S NAME:");
streamWriter.Write(report.StringFormatWithoutPipe(stockReceipt.DepositorName, 40, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|");
streamWriter.WriteLine("||--------------------------------------------------------------------------------------------------------||");
streamWriter.WriteLine("||SNo |STACK NO |COMMODITY | SCHEME |UNIT WEIGHT |NO.OF | Gross NET |% OF ||");
streamWriter.WriteLine("|| | | | | | UNIT| WEIGHT in Kgs/NOs |MOISTURE||");
streamWriter.WriteLine("||--------------------------------------------------------------------------------------------------------||");
}
/// <summary>
/// Add header for document receipt
/// </summary>
/// <param name="streamWriter">Stream writer to write the text file.</param>
/// <param name="stockIssuesEntity"></param>
/// <param name="isDuplicate"></param>
public void AddDocHeaderForIssues(StreamWriter streamWriter, DocumentStockIssuesEntity stockIssuesEntity, bool isDuplicate = false)
{
streamWriter.WriteLine("---------------------------------------------------------------------------------------------------------------");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| TAMILNADU CIVIL SUPPLIES CORPORATION |");
streamWriter.Write("| ");
streamWriter.Write(report.StringFormatWithoutPipe("REGION : ", 9, 1));
streamWriter.Write(report.StringFormat(stockIssuesEntity.RegionName, 53, 2));
streamWriter.WriteLine("");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| |");
if (isDuplicate)
{
streamWriter.WriteLine("| STOCK ISSUE - ISSUE MEMO DUPLICATE COPY |");
}
else
{
streamWriter.WriteLine("| STOCK ISSUE - ISSUE MEMO |");
}
streamWriter.WriteLine("|-------------------------------------------------------------------------------------------------------------|");
streamWriter.Write("|ISSUE MEMO NO : ");
streamWriter.Write(report.StringFormatWithoutPipe(stockIssuesEntity.SINo, 21, 2));
streamWriter.Write("DATE: ");
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(stockIssuesEntity.SIDate.ToString()), 12, 2));
streamWriter.Write("TIME:");
streamWriter.Write(report.StringFormatWithoutPipe(report.GetCurrentTime(DateTime.Now), 14, 2));
streamWriter.Write(report.StringFormatWithoutPipe((stockIssuesEntity.IssueRegularAdvance.ToUpper() == "R" ? "REGULAR" : "ADVANCE"), 8, 2));
streamWriter.Write(report.StringFormat(stockIssuesEntity.IRelates, 20, 2));
streamWriter.WriteLine(" ");
streamWriter.Write("|ISSUING GODOWN : ");
streamWriter.Write(report.StringFormatWithoutPipe(stockIssuesEntity.GodownName, 21, 2));
streamWriter.Write(report.StringFormatWithoutPipe("TO WHOM ISSUED:", 15, 1));
streamWriter.Write(report.StringFormatWithoutPipe(stockIssuesEntity.ReceiverName, 51, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
try
{
streamWriter.Write("| ");
streamWriter.Write(report.StringFormatWithoutPipe("ISSUER CODE :", 15, 1));
streamWriter.Write(report.StringFormatWithoutPipe(stockIssuesEntity.IssuerCode, 51, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message);
}
streamWriter.WriteLine("||------------------------------------------------------------------------------------------------------|-----|");
streamWriter.WriteLine("||SNo| STACK NO | COMMODITY | SCHEME |UNIT WEIGHT |NO.OFUNITS| NET Wt/Nos|MOI% |");
streamWriter.WriteLine("||------------------------------------------------------------------------------------------------------|-----|");
}
/// <summary>
///
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void DateWiseCommodityIssueMemoReport(StreamWriter sw, CommonEntity entity)
{
try
{
int count = 8;
int i = 1;
AddHeader(sw, entity);
decimal TotalAmount = 0;
foreach (DataRow row in entity.dataSet.Tables[0].Rows)
{
if (count >= 50)
{
//Add header again
count = 8;
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
AddHeader(sw, entity);
}
sw.Write(report.StringFormatWithoutPipe(row["GodownName"].ToString(), 25, 2));
sw.Write(report.StringFormatWithoutPipe(row["Coop"].ToString(), 33, 2));
sw.Write(report.StringFormatWithoutPipe(row["Dono"].ToString(), 10, 2));
sw.Write(report.StringFormatWithoutPipe(report.FormatDirectDate(row["Dodate"].ToString()), 10, 2));
sw.Write(report.StringFormatWithoutPipe(row["Comodity"].ToString(), 26, 2));
sw.Write(report.StringFormatWithoutPipe(row["Scheme"].ToString(), 12, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(row["Quantity"].ToString()), 12, 1) + " ");
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(row["Rate"].ToString()), 6, 1) + " ");
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(row["Amount"].ToString()), 10, 1));
sw.WriteLine("");
TotalAmount += Convert.ToDecimal(report.Decimalformat(row["Amount"].ToString()));
i = i + 1;
count = count + 1;
}
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------");
sw.Write(report.StringFormatWithoutPipe(" ", 33, 2));
sw.Write(report.StringFormatWithoutPipe(" ", 35, 2));
sw.Write(report.StringFormatWithoutPipe(" ", 10, 2));
sw.Write(report.StringFormatWithoutPipe(" ", 26, 2));
sw.Write(report.StringFormatWithoutPipe(" ", 12, 2));
sw.Write(report.StringFormatWithoutPipe(" ", 12, 1) + " ");
sw.Write(report.StringFormatWithoutPipe(report.Decimalformat(TotalAmount.ToString()), 18, 1));
sw.WriteLine("");
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message);
}
}
/// <summary>
///
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void WriteSalesIssueMemoAbstract(StreamWriter sw, CommonEntity entity)
{
try
{
int count = 10;
var distinctCommodity = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Commodity");
// var dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Issue_Date");
int i = 1;
string society = string.Empty;
string sCommodity = string.Empty;
decimal dTotal = 0;
decimal gTotal = 0;
AddHeader(sw, entity);
foreach (DataRow dateValue in distinctCommodity.Rows)
{
sCommodity = string.Empty;
DataRow[] datas = entity.dataSet.Tables[0].Select("Commodity='" + dateValue["Commodity"] + "'");
//DataRow[] datac = entity.dataSet.Tables[0].Select("Commodity='" + dateValue["Commodity"] + "'");
foreach (var row in datas)
{
if (count >= 50)
{
//Add header again
count = 11;
sw.WriteLine("---------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
AddHeader(sw, entity);
}
society = Convert.ToString(row["Society"]).Trim();
sw.Write(report.StringFormatWithoutPipe(i.ToString(), 4, 2));
sw.Write(report.StringFormatWithoutPipe(society, 30, 2));
sw.Write(report.StringFormatWithoutPipe(row["Scheme"].ToString(), 16, 2));
sw.Write(report.StringFormatWithoutPipe(row["Commodity"].ToString(), 27, 2) + " ");
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(row["Quantity"].ToString()), 10, 1));
sw.Write(report.StringFormatWithoutPipe(row["Rate"].ToString(), 10, 1));
sw.Write(report.StringFormatWithoutPipe(row["Value"].ToString(), 10, 1));
//sw.WriteLine("");
sw.WriteLine(" ");
dTotal += Convert.ToDecimal(row["Quantity"].ToString());
gTotal += Convert.ToDecimal(row["Quantity"].ToString());
i = i + 1;
count = count + 2;
}
//sw.WriteLine("--------------------------------------------------------------------------------------------------------------------------------|");
sw.Write(" ");
sw.Write(report.StringFormatWithoutPipe(" ", 34, 2));
sw.Write(report.StringFormatWithoutPipe("Total".ToString(), 11, 2));
sw.Write(report.StringFormatWithoutPipe("", 16, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(dTotal.ToString()), 28, 1));
sw.WriteLine(" ");
//sw.WriteLine("");
dTotal = 0;
//sw.WriteLine("--------------------------------------------------------------------------------------------------------------------------------|");
}
sw.WriteLine("---------------------------------------------------------------------------------------------------------------------|");
sw.Write(" ");
sw.Write(report.StringFormatWithoutPipe(" ", 34, 2));
sw.Write(report.StringFormatWithoutPipe("Grand Total".ToString(), 11, 2));
sw.Write(report.StringFormatWithoutPipe("", 16, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(gTotal.ToString()), 28, 1));
sw.WriteLine("");
sw.WriteLine("---------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message);
}
}
/// <summary>
///
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void DateWiseCommodityReceiptReport(StreamWriter sw, CommonEntity entity)
{
int count = 10;
var dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Commodity");
int i = 1;
string ackNo = string.Empty;
string fromWhomRcd = string.Empty;
bool isDataAvailable = false;
decimal Qty = 0;
int Bags = 0;
count = 11;
foreach (DataRow date in dateList.Rows)
{
isDataAvailable = true;
Bags = 0;
Qty = 0;
string ackNoNext = string.Empty;
AddHeader(sw, entity);
DataRow[] data = entity.dataSet.Tables[0].Select("Commodity='" + date["Commodity"] + "'");
foreach (DataRow row in data)
{
if (count >= 50)
{
//Add header again
count = 11;
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
AddHeader(sw, entity);
}
ackNoNext = row["Ackno"].ToString();
fromWhomRcd = Convert.ToString(row["RecdFrom"]).Trim();
sw.Write(report.StringFormat(i.ToString(), 4, 2));
sw.Write(report.StringFormat(ackNoNext, 11, 1));
sw.Write(report.StringFormat(row["Date"].ToString(), 10, 1));
sw.Write(report.StringFormat(row["Commodity"].ToString(), 16, 2));
sw.Write(report.StringFormat(row["Bags_No"].ToString(), 8, 1));
sw.Write(report.StringFormat(row["Quantity"].ToString(), 17, 1));
sw.Write(report.StringFormat(fromWhomRcd, 21, 2));
sw.Write(report.StringFormat(row["Lorryno"].ToString(), 11, 1));
sw.Write(report.StringFormat(row["TruckMemoNo"].ToString(), 15, 1));
sw.Write(report.StringFormat(row["Truckmemodate"].ToString(), 11, 1));
sw.Write(report.StringFormat(row["Orderno"].ToString(), 11, 2));
sw.Write(report.StringFormat("", 8, 1));
sw.Write(report.StringFormat("", 7, 1));
sw.WriteLine("");
Bags += !string.IsNullOrEmpty(Convert.ToString(row["Bags_No"])) ? Convert.ToInt32(row["Bags_No"].ToString()) : 0;
Qty += !string.IsNullOrEmpty(Convert.ToString(row["Quantity"])) ? Convert.ToDecimal(row["Quantity"].ToString()) : 0;
i = i + 1;
count++;
}
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------------|");
sw.Write(report.StringFormat("", 4, 2));
sw.Write(report.StringFormat(" Total ", 11, 1));
sw.Write(report.StringFormatWithoutPipe(" ", 10, 1));
sw.Write(report.StringFormatWithoutPipe(" ", 16, 2));
sw.Write(report.StringFormatWithoutPipe(Bags.ToString(), 8, 1));
sw.Write(report.StringFormatWithoutPipe(Qty.ToString(), 17, 1));
sw.WriteLine(" ");
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------------|");
//Total
sw.WriteLine((char)12);
}
if (!isDataAvailable)
{
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
}
}
/// <summary>
///
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void TruckToRegionWiseReport(StreamWriter sw, CommonEntity entity)
{
int count = 10;
int i = 1;
string doNo = string.Empty;
string fromWhomRcd = string.Empty;
bool isDataAvailable = false;
decimal Total = 0;
decimal GrandTotal = 0;
int pageno = 1;
count = 8;
bool isfirst = true;
try
{
// dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, new string[] { "Coop", "Comodity" });
var dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, "DepositorName");
AddHeader(sw, entity, pageno);
foreach (DataRow depdata in dateList.Rows)
{
Total = 0;
GrandTotal = 0;
isDataAvailable = true;
isfirst = true;
string PackingType = string.Empty;
string depositor = string.Empty;
depositor = Convert.ToString(depdata["DepositorName"]);
DataRow[] data = entity.dataSet.Tables[0].Select("DepositorName='" + depositor + "'");
var distinctCommodity = report.ConvertDataRowToTable(data, entity.dataSet.Tables[0]).DefaultView.ToTable(true, "ITDescription");
foreach (DataRow item in distinctCommodity.Rows)
{
Total = 0;
DataRow[] ndata = entity.dataSet.Tables[0].Select("DepositorName='" + depositor + "' and ITDescription='" + Convert.ToString(item["ITDescription"]) + "'");
foreach (DataRow row in ndata)
{
if (count >= 50)
{
//Add header again
pageno++;
count = 8;
sw.WriteLine("-------------------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
AddHeader(sw, entity, pageno);
}
PackingType = row["PBWeight"].ToString(); //PBWeight
sw.Write(report.StringFormatWithoutPipe(i.ToString(), 4, 2));
sw.Write(report.StringFormatWithoutPipe(row["STNo"].ToString(), 11, 2));
sw.Write(report.StringFormatWithoutPipe(report.FormatDirectDate(row["STDate"].ToString()), 10, 2) + " ");
sw.Write(report.StringFormatWithoutPipe(isfirst == true ? row["DepositorName"].ToString() : " ", 20, 2));
sw.Write(report.StringFormatWithoutPipe(isfirst == true ? row["RGNAME"].ToString() : " ", 15, 2));
sw.Write(report.StringFormatWithoutPipe(row["ITDescription"].ToString(), 15, 1));
sw.Write(report.StringFormatWithoutPipe(row["SCName"].ToString(), 11, 2));
sw.Write(report.StringFormatWithoutPipe(row["NoPacking"].ToString(), 6, 1));
sw.Write(report.StringFormatWithoutPipe(PackingType.ToUpper() == "NOS" ? row["Nkgs"].ToString() : report.DecimalformatForWeight(row["Nkgs"].ToString()), 15, 1));
sw.Write(report.StringFormatWithoutPipe(row["LNo"].ToString(), 21, 2));
sw.WriteLine("");
Total += !string.IsNullOrEmpty(Convert.ToString(row["Nkgs"])) ? Convert.ToDecimal(row["Nkgs"].ToString()) : 0;
i = i + 1;
count++;
isfirst = false;
}
sw.Write(report.StringFormatWithoutPipe("", 4, 1));
sw.Write(report.StringFormatWithoutPipe("", 11, 2));
sw.Write(report.StringFormatWithoutPipe("", 10, 2) + " ");
sw.Write(report.StringFormatWithoutPipe(" ", 20, 2));
sw.Write(report.StringFormatWithoutPipe(" ", 15, 2));
sw.Write(report.StringFormatWithoutPipe("", 10, 1));
sw.Write(report.StringFormatWithoutPipe("Total", 16, 1));
sw.Write(report.StringFormatWithoutPipe("", 6, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(Total.ToString()), 15, 1));
sw.WriteLine("");
count++;
GrandTotal += Total;
}
sw.Write(report.StringFormatWithoutPipe("", 4, 1));
sw.Write(report.StringFormatWithoutPipe("", 11, 2));
sw.Write(report.StringFormatWithoutPipe("", 10, 2) + " ");
sw.Write(report.StringFormatWithoutPipe(" ", 20, 2));
sw.Write(report.StringFormatWithoutPipe(" ", 15, 2));
sw.Write(report.StringFormatWithoutPipe("", 10, 1));
sw.Write(report.StringFormatWithoutPipe("Grand Total", 16, 1));
sw.Write(report.StringFormatWithoutPipe("", 6, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(GrandTotal.ToString()), 15, 1));
sw.WriteLine("");
count++;
}
if (!isDataAvailable)
{
sw.WriteLine("-------------------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
}
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message);
}
}
/// <summary>
/// Add header for document receipt
/// </summary>
/// <param name="streamWriter">Stream writer to write the text file.</param>
/// <param name="truckMemoList"></param>
/// <param name="isDuplicate"></param>
public void AddDocHeaderForTruckMemo(StreamWriter streamWriter, DocumentStockTransferDetails truckMemoList, bool isDuplicate = false)
{
streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| TAMILNADU CIVIL SUPPLIES CORPORATION |");
streamWriter.Write("| ");
streamWriter.Write(report.StringFormatWithoutPipe("REGION : ", 9, 1));
streamWriter.Write(report.StringFormat(truckMemoList.RegionName, 53, 2));
streamWriter.WriteLine("");
streamWriter.WriteLine("| |");
streamWriter.WriteLine("| |");
if (isDuplicate)
{
streamWriter.WriteLine("| STOCK ISSUE TRUCK MEMO DUPLICATE COPY |");
}
else
{
streamWriter.WriteLine("| STOCK ISSUE TRUCK MEMO |");
}
streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|");
streamWriter.Write("|TRUCK MEMO NO:");
streamWriter.Write(report.StringFormatWithoutPipe(truckMemoList.STNo, 21, 2));
streamWriter.Write("ALLOTMENT/RELEASE ORDER: ");
streamWriter.Write(report.StringFormatWithoutPipe(truckMemoList.RNo, 12, 2));
streamWriter.Write("MOVE. ORDER NO: ");
streamWriter.Write(report.StringFormatWithoutPipe(truckMemoList.MNo, 15, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.Write("| DATE:");
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(truckMemoList.STDate.ToString()), 21, 2));
streamWriter.Write(report.StringFormatWithoutPipe("TIME: ", 25, 1));
streamWriter.Write(report.StringFormatWithoutPipe(report.GetCurrentTime(DateTime.Now), 16, 2));
streamWriter.Write("DATE:");
streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDate(truckMemoList.RDate.ToString()), 16, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.Write("|ISSUING GODOWN :");
streamWriter.Write(report.StringFormatWithoutPipe(truckMemoList.GodownName, 30, 2));
streamWriter.Write("RECEIVER NAME: ");
streamWriter.Write(report.StringFormatWithoutPipe(truckMemoList.ReceivingName, 41, 2));
streamWriter.Write("|");
streamWriter.WriteLine(" ");
streamWriter.WriteLine("|----------------------------------------------------------------------------------------------------------|");
streamWriter.WriteLine("||--------------------------------------------------------------------------------------------------------||");
streamWriter.WriteLine("||SNo |STACK NO |COMMODITY | SCHEME |UNIT WEIGHT |NO.OF | Gross NET |% OF ||");
streamWriter.WriteLine("|| | | | | | UNIT| WEIGHT in Kgs/NOs |MOISTURE||");
streamWriter.WriteLine("||--------------------------------------------------------------------------------------------------------||");
}
public void WriteTruckMemoForDateWise(StreamWriter sw, CommonEntity entity)
{
int iCount = 10;
var distinctDate = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Issue_Date");
//Date wise DO report
int i = 1;
string sIssuer = string.Empty;
string sDoNo = string.Empty;
foreach (DataRow dateValue in distinctDate.Rows)
{
iCount = 11;
bool CheckRepeatValue = false;
string sDoNo1 = string.Empty;
DataRow[] datas = entity.dataSet.Tables[0].Select("Issue_Date='" + dateValue["Issue_Date"] + "'");
AddHeader(sw, Convert.ToString(dateValue["Issue_Date"]));
foreach (DataRow dr in datas)
{
if (iCount >= 50)
{
//Add header again
iCount = 11;
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
AddHeader(sw, Convert.ToString(dateValue["Issue_Date"]));
}
sDoNo1 = dr["Truck_Memono"].ToString();
if (sDoNo == sDoNo1)
{
CheckRepeatValue = true;
}
else
{
CheckRepeatValue = false;
sDoNo = sDoNo1;
}
sIssuer = Convert.ToString(dr["To_Whom_Issued"]).Trim();
sw.Write(report.StringFormatWithoutPipe(CheckRepeatValue == false ? i.ToString() : " ", 4, 2));
sw.Write(report.StringFormatWithoutPipe(CheckRepeatValue == false ? dr["Truck_Memono"].ToString() : " ", 12, 2));
sw.Write(report.StringFormatWithoutPipe(CheckRepeatValue == false ? dr["Mono"].ToString() : " ", 15, 2));
sw.Write(report.StringFormatWithoutPipe(CheckRepeatValue == false ? dr["RoNo"].ToString() : " ", 11, 2));
sw.Write(report.StringFormatWithoutPipe(CheckRepeatValue == false ? sIssuer : " ", 31, 2));
sw.Write(report.StringFormatWithoutPipe(dr["Scheme"].ToString(), 10, 2));
sw.Write(report.StringFormatWithoutPipe(dr["Stackno"].ToString(), 10, 2));
sw.Write(report.StringFormatWithoutPipe(dr["NoBags"].ToString(), 7, 1));
sw.Write(report.StringFormatWithoutPipe(dr["Commodity"].ToString(), 25, 2));
sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(dr["NetWt"].ToString()), 9, 1));
sw.WriteLine("");
iCount = iCount + 1;
i = CheckRepeatValue == false ? i + 1 : i;
}
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
}
}
/// <summary>
///
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void DateWiseCommodityWiseGUGRReport(StreamWriter sw, CommonEntity entity)
{
try
{
int count = 8;
var dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Date");
int pageNo = 1;
decimal qty = 0;
int Bags = 0;
AddHeader(sw, entity, pageNo);
int i = 1;
foreach (DataRow nrow in dateList.Rows)
{
DataRow[] drdata = entity.dataSet.Tables[0].Select("Date='" + Convert.ToString(nrow["Date"]) + "'");
foreach (DataRow row in drdata)
{
if (count >= 50)
{
//Add header again
pageNo++;
count = 8;
sw.WriteLine("--------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
AddHeader(sw, entity, pageNo);
}
sw.Write("");
sw.Write(report.StringFormatWithoutPipe(row["Ackno"].ToString(), 10, 2));
sw.Write(report.StringFormatWithoutPipe(row["Date"].ToString(), 10, 2));
sw.Write(report.StringFormatWithoutPipe(row["Commodity"].ToString(), 16, 2));
sw.Write(report.StringFormatWithoutPipe("0", 8, 2));
sw.Write(report.StringFormatWithoutPipe(row["Quantity"].ToString(), 9, 2));
sw.Write(report.StringFormatWithoutPipe(row["stackno"].ToString(), 10, 2));
// sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(row["Quantity"].ToString()), 11, 1) + " ");
sw.Write(report.StringFormatWithoutPipe(row["Year"].ToString(), 5, 1));
sw.Write(report.StringFormatWithoutPipe(row["Commodity"].ToString(), 16, 2));
sw.WriteLine("");
count = count + 1;
// qty += !string.IsNullOrEmpty(row["Quantity"].ToString()) ? Convert.ToDecimal(row["Quantity"]) : 0;
Bags += !string.IsNullOrEmpty(Convert.ToString(row["Quantity"])) ? Convert.ToInt32(row["Quantity"].ToString()) : 0;
i++;
}
// count = count + 1;
}
sw.WriteLine("--------------------------------------------------------------------------------------------------------");
sw.Write("");
sw.Write(report.StringFormatWithoutPipe("", 10, 2));
sw.Write(report.StringFormatWithoutPipe("Total", 10, 2));
sw.Write(report.StringFormatWithoutPipe("-", 16, 2));
sw.Write(report.StringFormatWithoutPipe("-", 8, 2));
sw.Write(report.StringFormatWithoutPipe((Convert.ToString(Bags)), 9, 2));
// sw.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(Convert.ToString(qty)), 11, 1) + " ");
sw.Write(report.StringFormatWithoutPipe("-", 14, 2));
sw.Write(report.StringFormatWithoutPipe("-", 101, 2));
sw.WriteLine("");
sw.WriteLine("--------------------------------------------------------------------------------------------------------");
sw.WriteLine((char)12);
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " " + ex.StackTrace);
}
}
