/// <summary> /// Add header for date wise report /// </summary> /// <param name="sw"></param> /// <param name="date"></param> public void AddHeaderForDateWise(StreamWriter sw, string date) { sw.WriteLine(" TAMILNADU CIVIL SUPPLIES CORPORATION Report Date : " + ManageReport.GetCurrentDate()); sw.WriteLine(" "); sw.WriteLine(" Stock Issue Register"); sw.WriteLine(" "); sw.WriteLine("Issue Date:" + report.FormatDirectDate(date) + " (Net Wt in kgs\\Klts\\Nos) Godown : " + GName + " Region :" + RName); sw.WriteLine("---------------------------------------------------------------------------------------------------------------------------------------------"); sw.WriteLine("S.No Issue Memo D.No Lorry No To Whom Issued Scheme StackNo No bags Commodity Net wt "); sw.WriteLine("---------------------------------------------------------------------------------------------------------------------------------------------"); sw.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 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> /// /// <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); } }
public List <StackCardRegisterEntity> ManageStackCardRegister(DataSet dataSet, StackEntity stackEntity) { try { ManageReport report = new ManageReport(); List <StackCardRegisterEntity> stackCardEntities = new List <StackCardRegisterEntity>(); DataTable dtIssues = new DataTable(); DataTable dtReceipt = new DataTable(); DataTable dtObStack = new DataTable(); DataTable dtWriteOFF = new DataTable(); //DateTime fDate = default(DateTime); //DateTime SDate = default(DateTime); ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); if (dataSet.Tables.Count > 1) { dtIssues = dataSet.Tables[0]; dtReceipt = dataSet.Tables[1]; dtObStack = dataSet.Tables[2]; dtWriteOFF = dataSet.Tables[3]; string sStackCard = string.Empty; string sCommodity = string.Empty; foreach (DataRow item in dtObStack.Rows) { StackCardRegisterEntity stackCardRegister = new StackCardRegisterEntity(); sStackCard = Convert.ToString(item["StockNo"]); sCommodity = Convert.ToString(item["Commodity"]); //Filter particular stack card only DataRow[] dataRowsIssues = dtIssues.Select("StockNo = '" + sStackCard + "' and Commodity='" + sCommodity + "'"); DataRow[] dataRowsReceipt = dtReceipt.Select("StockNo = '" + sStackCard + "' and Commodity='" + sCommodity + "'"); DataRow[] dataRowsWriteOff = dtWriteOFF.Select("StockNo = '" + sStackCard + "' and Commodity='" + sCommodity + "'"); List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", stackEntity.GCode)); sqlParameters.Add(new KeyValuePair <string, string>("@StacKNo", sStackCard)); sqlParameters.Add(new KeyValuePair <string, string>("@ShortYear", stackEntity.StackDate)); DataSet dsGUGR = manageSQLConnection.GetDataSetValues("GetGUGRbyStackNo", sqlParameters); stackCardRegister.StackCard = sStackCard; stackCardRegister.Commodity = sCommodity; stackCardRegister.OpeningBag = Convert.ToString(item["NoPacking"]); stackCardRegister.OpeningQty = Convert.ToString(item["TOTAL"]); if (dsGUGR.Tables.Count > 1) { if (dsGUGR.Tables[0].Rows.Count > 0) //GU { stackCardRegister.GU = Convert.ToString(dsGUGR.Tables[0].Rows[0]["NoPacking"]); } else { stackCardRegister.GU = "0"; } if (dsGUGR.Tables[1].Rows.Count > 0) //GR { stackCardRegister.GR = Convert.ToString(dsGUGR.Tables[1].Rows[0]["NoPacking"]); } else { stackCardRegister.GR = "0"; } if (dsGUGR.Tables[2].Rows.Count > 0) //StackDate and Status { stackCardRegister.FromDate = report.FormatDirectDate(Convert.ToString(dsGUGR.Tables[2].Rows[0]["ObStackDate"])); stackCardRegister.ToDate = report.FormatDirectDate(Convert.ToString(dsGUGR.Tables[2].Rows[0]["ClsStackDate"])); stackCardRegister.StackStatus = Convert.ToString(dsGUGR.Tables[2].Rows[0]["Status"]); } } if (dataRowsReceipt != null && dataRowsReceipt.Count() > 0) { stackCardRegister.ReceiptBag = Convert.ToString(dataRowsReceipt[0]["NoPacking"]); stackCardRegister.ReceiptQty = Convert.ToString(dataRowsReceipt[0]["TOTAL"]); } else { stackCardRegister.ReceiptBag = "0"; stackCardRegister.ReceiptQty = "0"; } if (dataRowsIssues != null && dataRowsIssues.Count() > 0) { stackCardRegister.IssuesBag = Convert.ToString(dataRowsIssues[0]["NoPacking"]); stackCardRegister.IssuesQty = Convert.ToString(dataRowsIssues[0]["TOTAL"]); } else { stackCardRegister.IssuesBag = "0"; stackCardRegister.IssuesQty = "0"; } if (dataRowsWriteOff != null && dataRowsWriteOff.Count() > 0) { stackCardRegister.WriteOff = Convert.ToString(dataRowsWriteOff[0]["TOTAL"]); } else { stackCardRegister.WriteOff = "0"; } //Balance int totalReceiptBag = Convert.ToInt32(stackCardRegister.OpeningBag) + Convert.ToInt32(stackCardRegister.ReceiptBag) + Convert.ToInt32(stackCardRegister.GU); int totalIssuesBag = Convert.ToInt32(stackCardRegister.IssuesBag) + Convert.ToInt32(stackCardRegister.GR); decimal totalReceiptQty = Convert.ToDecimal(stackCardRegister.OpeningQty) + Convert.ToDecimal(stackCardRegister.ReceiptQty); decimal totalIssuesQty = Convert.ToDecimal(stackCardRegister.IssuesQty); stackCardRegister.BalanceBag = Convert.ToString(totalReceiptBag - totalIssuesBag); stackCardRegister.BalanceQty = Convert.ToString(totalReceiptQty - totalIssuesQty); stackCardEntities.Add(stackCardRegister); } } // AuditLog.WriteError("Print start"); StackCardRegisterPrint stackCardRegisterPrint = new StackCardRegisterPrint(); Task.Run(() => stackCardRegisterPrint.GenerateStackCardRegister(stackCardEntities, stackEntity)); //AuditLog.WriteError("Print End"); return(stackCardEntities); } catch (Exception ex) { AuditLog.WriteError("ManageStackBalance : " + ex.Message + " " + ex.StackTrace); return(null); } }
/// <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 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> /// /// </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> /// 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> /// Add receipt item details /// </summary> /// <param name="streamWriter"></param> /// <param name="stockIssuesEntity"></param> private void AddDetails(StreamWriter streamWriter, List <StackCardEntity> stackCardEntities) { int i = 1; string Fromdate = string.Empty; string Todate = string.Empty; string TotalReceiptBags = string.Empty, TotalIssuesBags = string.Empty; string TotalReceiptQuantity = string.Empty, TotalIssuesQuantity = string.Empty; foreach (var item in stackCardEntities) { if (i == 1) { Fromdate = item.AckDate; } if (item.AckDate == "Total") { streamWriter.WriteLine("----|--------------------------------|-----------------------------------------|"); streamWriter.Write(report.StringFormatWithoutPipe(item.AckDate, 15, 1)); streamWriter.Write(report.StringFormatWithoutPipe(report.StringFormatWithEmpty(item.ReceiptBags).Item1, 5, 1)); streamWriter.Write(report.StringFormat(report.StringFormatWithEmpty(item.ReceiptQuantity).Item1, 15, 1)); streamWriter.Write(report.StringFormatWithoutPipe(report.StringFormatWithEmpty(item.IssuesBags).Item1, 5, 2)); streamWriter.Write(report.StringFormatWithoutPipe(report.StringFormatWithEmpty(item.IssuesQuantity).Item1, 15, 1)); streamWriter.Write(report.StringFormat(report.StringFormatWithEmpty(item.ClosingBalance).Item1, 19, 1)); streamWriter.WriteLine(" "); streamWriter.WriteLine("-------------------------------------------------------------------------------|"); TotalReceiptBags = item.ReceiptBags; TotalIssuesBags = item.IssuesBags; TotalReceiptQuantity = item.ReceiptQuantity; TotalIssuesQuantity = item.IssuesQuantity; break; } Todate = item.AckDate; streamWriter.Write(report.StringFormat(i.ToString(), 4, 1)); streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDirectDate(item.AckDate), 10, 1)); streamWriter.Write(report.StringFormatWithoutPipe(report.StringFormatWithEmpty(item.ReceiptBags).Item1, 5, 1)); streamWriter.Write(report.StringFormat(report.StringFormatWithEmpty(item.ReceiptQuantity).Item1, 15, 1)); streamWriter.Write(report.StringFormatWithoutPipe(report.StringFormatWithEmpty(item.IssuesBags).Item1, 5, 1)); streamWriter.Write(report.StringFormatWithoutPipe(report.StringFormatWithEmpty(item.IssuesQuantity).Item1, 15, 1)); streamWriter.Write(report.StringFormat(report.StringFormatWithEmpty(item.ClosingBalance).Item1, 19, 1)); streamWriter.WriteLine(" "); i = i + 1; } streamWriter.WriteLine(" "); streamWriter.WriteLine(" Bags Quantity"); streamWriter.WriteLine("-------------------------------------------------------------------------------|"); streamWriter.Write(" Total Receipt "); streamWriter.Write(report.StringFormatWithoutPipe(TotalReceiptBags, 8, 2)); streamWriter.Write(report.StringFormatWithoutPipe(TotalReceiptQuantity, 13, 2)); streamWriter.WriteLine(""); streamWriter.Write(" Total Issues "); streamWriter.Write(report.StringFormatWithoutPipe(TotalIssuesBags, 8, 2)); streamWriter.Write(report.StringFormatWithoutPipe(TotalIssuesQuantity, 13, 2)); streamWriter.WriteLine(""); streamWriter.WriteLine("-------------------------------------------------------------------------------|"); streamWriter.Write(" Balance "); streamWriter.Write(report.StringFormatWithoutPipe(GetDifference(TotalReceiptBags, TotalIssuesBags, 1), 8, 2)); streamWriter.Write(report.StringFormatWithoutPipe(GetDifference(TotalReceiptQuantity, TotalIssuesQuantity, 2), 13, 2)); streamWriter.WriteLine(""); streamWriter.WriteLine("-------------------------------------------------------------------------------|"); streamWriter.WriteLine("-------------------------------------------------------------------------------|"); streamWriter.WriteLine(" FROM DATE TODATE TOTAL DAYS"); streamWriter.Write(" Period of Storage "); streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDirectDate(Fromdate), 12, 2)); streamWriter.Write(report.StringFormatWithoutPipe(report.FormatDirectDate(Todate), 12, 2)); streamWriter.Write(report.StringFormatWithoutPipe(report.GetDays(Fromdate, Todate), 12, 2)); streamWriter.WriteLine(""); streamWriter.WriteLine("-------------------------------------------------------------------------------|"); streamWriter.WriteLine((char)12); }