/// <summary>
///
/// </summary>
/// <param name="sw"></param>
/// <param name="entity"></param>
public void DateWiseStockReceiptRegister(StreamWriter sw, CommonEntity entity)
{
int count = 10;
var dateList = entity.dataSet.Tables[0].DefaultView.ToTable(true, "Date");
int i = 1;
string ackNo = string.Empty;
string fromWhomRcd = string.Empty;
bool CheckRepeatValue = false;
bool isDataAvailable = false;
foreach (DataRow date in dateList.Rows)
{
isDataAvailable = true;
count = 11;
string ackNoNext = string.Empty;
DataRow[] data = entity.dataSet.Tables[0].Select("Date='" + date["Date"] + "'");
AddHeader(sw, Convert.ToString(date["Date"]));
foreach (DataRow row in data)
{
if (count >= 50)
{
//Add header again
count = 11;
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
AddHeader(sw, Convert.ToString(date["Date"]));
}
ackNoNext = row["Ackno"].ToString();
fromWhomRcd = Convert.ToString(row["From_Whom_Received"]).Trim();
if (ackNo == ackNoNext)
{
CheckRepeatValue = true;
}
else
{
CheckRepeatValue = false;
ackNo = ackNoNext;
}
sw.Write(report.StringFormat(CheckRepeatValue == false ? i.ToString() : " ", 4, 2));
sw.Write(report.StringFormat(CheckRepeatValue == false ? ackNoNext : " ", 11, 2));
sw.Write(report.StringFormat(CheckRepeatValue == false ? row["TruckMemoNo"].ToString() : " ", 19, 2));
sw.Write(report.StringFormat(CheckRepeatValue == false ? row["Lorryno"].ToString() : " ", 11, 2));
sw.Write(report.StringFormat(CheckRepeatValue == false ? fromWhomRcd : " ", 33, 2));
sw.Write(report.StringFormat(row["Scheme"].ToString(), 12, 2));
sw.Write(report.StringFormat(row["Stackno"].ToString(), 12, 2));
sw.Write(report.StringFormat(row["NoPacking"].ToString(), 8, 1));
sw.Write(report.StringFormat(row["Commodity"].ToString(), 15, 2));
sw.Write(report.StringFormat(report.DecimalformatForWeight(row["NetWt"].ToString()), 10, 1));
sw.WriteLine("");
i = CheckRepeatValue == false ? i + 1 : i;
}
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
}
if (!isDataAvailable)
{
sw.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
}
}
/// <summary>
/// Add receipt item details
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="stockReceipt"></param>
public void AddItemsDetails(StreamWriter streamWriter, DocumentDeliveryOrderEntity deliveryOrderList)
{
int i = 0;
double dTotal = 0;
streamWriter.WriteLine("| Commodity Details |");
streamWriter.WriteLine("||------|-------------------------|-------------------|---------------------|-----------|-------------| |");
streamWriter.WriteLine("||S.NO. | ITEM DESCRIPTION |SCHEME |QUANTITY TO BE ISSUED|RATE/UNIT | TOTAL VALUE | |");
streamWriter.WriteLine("|| | | | KGS.(Nett) GMS. | RS. P. | RS. P. | |");
streamWriter.WriteLine("||------|-------------------------|-------------------|---------------------|-----------|-------------| |");
foreach (var item in deliveryOrderList.documentDeliveryItems)
{
i = i + 1;
streamWriter.Write("||");
streamWriter.Write(manageReport.StringFormat(i.ToString(), 6, 2));
streamWriter.Write(manageReport.StringFormat(item.ITDescription, 25, 2));
streamWriter.Write(manageReport.StringFormat(item.SchemeName, 19, 2));
streamWriter.Write(manageReport.StringFormat(manageReport.DecimalformatForWeight(item.NetWeight.ToString()), 21, 2));
streamWriter.Write(manageReport.StringFormat(item.Rate.ToString(), 11, 1));
streamWriter.Write(manageReport.StringFormat(item.Total.ToString(), 13, 1));
streamWriter.Write(" |");
streamWriter.WriteLine(" ");
dTotal = dTotal + Convert.ToDouble(item.Total);
}
streamWriter.WriteLine("||------|-------------------------|-------------------|---------------------|-----------|-------------| |");
streamWriter.Write("| TOTAL |");
streamWriter.Write(manageReport.StringFormat(dTotal.ToString(), 13, 1));
streamWriter.Write(" |");
streamWriter.WriteLine(" ");
streamWriter.WriteLine("|==========================================================================================================|");
}
/// <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>
///
/// </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);
}
}
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>
/// 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>
/// Add receipt item details
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="stockIssuesEntity"></param>
private void AddDetails(StreamWriter streamWriter, DocumentStockIssuesEntity stockIssuesEntity)
{
int i = 0;
int units = 0;
double netKgs = 0;
foreach (var item in stockIssuesEntity.IssueItemList)
{
i = i + 1;
if (item.TStockNo.ToUpper() != "TOTAL")
{
streamWriter.Write("||");
streamWriter.Write(report.StringFormat(i.ToString(), 3, 2));
streamWriter.Write(report.StringFormat(item.TStockNo, 12, 2));
streamWriter.Write(report.StringFormat(item.CommodityName, 31, 2));
streamWriter.Write(report.StringFormat(item.SchemeName, 14, 2));
streamWriter.Write(report.StringFormat(item.PackingName, 13, 2));
streamWriter.Write(report.StringFormat(item.NoPacking.ToString(), 10, 1));
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(item.Nkgs.ToString()), 13, 1));
streamWriter.Write(report.StringFormat(item.Moisture.ToString(), 5, 1));
streamWriter.WriteLine(" ");
units = units + item.NoPacking;
netKgs = netKgs + Convert.ToDouble(item.Nkgs);
}
}
streamWriter.WriteLine("||------------------------------------------------------------------------------------------------------|-----|");
streamWriter.WriteLine("|| |Total |" + report.StringFormatWithoutPipe(units.ToString(), 9, 1) + "|" + report.StringFormatWithoutPipe(report.DecimalformatForWeight(netKgs.ToString()), 12, 1) + "| |");
streamWriter.WriteLine("||------------------------------------------------------------------------------------------------------|-----|");
}
/// <summary>
/// Add receipt item details
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="stockReceipt"></param>
public void AddDetails(StreamWriter streamWriter, DataSet dataSet)
{
int i = 0;
//Add header values
int count = dataSet.Tables[0].Columns.Count;
int length = (count * 20) + count + 18;
streamWriter.WriteLine("-" + report.AddLine(length));
streamWriter.Write(" ");
foreach (DataColumn dataColumn in dataSet.Tables[0].Columns)
{
streamWriter.Write(report.StringFormat(dataColumn.ColumnName, i == 0 ? 20 : 20, i <= 1 ? 2 : 1));
i++;
}
streamWriter.Write(" Total |");
streamWriter.WriteLine(" ");
streamWriter.WriteLine("-" + report.AddLine(length));
foreach (DataRow item in dataSet.Tables[0].Rows)
{
i = 0;
decimal Total = 0;
decimal dTotal = 0;
streamWriter.Write(" ");
for (int k = 0; k < count; k++)
{
var result = report.StringFormatWithEmpty(Convert.ToString(item[k]));
if (i <= 1)
{
streamWriter.Write(report.StringFormat(result.Item1, i == 0 ? 20 : 20, i <= 1 ? 2 : 1));
}
else
{
dTotal = result.Item2 == true?Convert.ToDecimal(result.Item1) : 0;
Total = Total + dTotal;
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(Convert.ToString(dTotal)), i == 0 ? 20 : 20, i <= 1 ? 2 : 1));
}
i++;
}
//Total
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(Convert.ToString(Total)), 18, 1));
streamWriter.WriteLine(" ");
}
streamWriter.WriteLine("-" + report.AddLine(length));
streamWriter.WriteLine((char)12);
}
/// <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 receipt item details
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="truckMemoList"></param>
public void AddDetails(StreamWriter streamWriter, DocumentStockTransferDetails transferDetails)
{
int i = 0;
foreach (var item in transferDetails.documentSTItemDetails)
{
i = i + 1;
streamWriter.Write("||");
streamWriter.Write(report.StringFormat(i.ToString(), 4, 2));
streamWriter.Write(report.StringFormat(item.TStockNo, 11, 2));
streamWriter.Write(report.StringFormat(item.ITDescription, 20, 2));
streamWriter.Write(report.StringFormat(item.SchemeName, 14, 2));
streamWriter.Write(report.StringFormat(item.PackingType, 13, 2));
streamWriter.Write(report.StringFormat(item.NoPacking.ToString(), 6, 1));
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(item.GKgs.ToString()), 10, 1));
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(item.Nkgs.ToString()), 10, 1));
streamWriter.Write(report.StringFormat(item.Moisture.ToString(), 8, 1) + "|");
streamWriter.WriteLine(" ");
}
}
/// <summary>
/// Add receipt item details
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="stockReceipt"></param>
public void AddDetails(StreamWriter streamWriter, DocumentStockReceiptList stockReceipt)
{
int i = 0;
foreach (var item in stockReceipt.ItemList)
{
i = i + 1;
streamWriter.Write("||");
streamWriter.Write(report.StringFormat(i.ToString(), 4, 2));
streamWriter.Write(report.StringFormat(item.TStockNo, 11, 2));
streamWriter.Write(report.StringFormat(item.CommodityName, 20, 2));
streamWriter.Write(report.StringFormat(item.SchemeName, 14, 2));
streamWriter.Write(report.StringFormat(item.PackingName, 13, 2));
streamWriter.Write(report.StringFormat(item.NoPacking.ToString(), 6, 1));
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(item.GKgs.ToString()), 10, 1));
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(item.Nkgs.ToString()), 10, 1));
streamWriter.Write(report.StringFormat(item.Moisture.ToString(), 8, 1) + "|");
streamWriter.WriteLine(" ");
}
}
public decimal GetCBQty(decimal qty, int type)
{
try
{
ManageReport report = new ManageReport();
decimal svalue = Math.Round((type == 1 ? qty / 1000 : qty), 3);
return(Convert.ToDecimal(report.DecimalformatForWeight(Convert.ToString(svalue))));
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message);
return(0);
}
}
/// <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 StockStatementReport(StreamWriter sw, List <DailyStockDetailsEntity> stockDetailsEntity, StockParameter entity)
{
try
{
int count = 8;
int pageNo = 1;
AddHeader(sw, entity, pageNo);
int i = 1;
foreach (var data in stockDetailsEntity)
{
if (count >= 50)
{
//Add header again
pageNo++;
count = 8;
sw.WriteLine("|------------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
AddHeader(sw, entity, pageNo);
}
sw.Write("|");
sw.Write(report.StringFormat(i.ToString(), 4, 2));
sw.Write(report.StringFormat(data.ITDescription.ToString(), 16, 2));
sw.Write(report.StringFormat(report.DecimalformatForWeight(data.OpeningBalance.ToString()), 13, 1));
sw.Write(report.StringFormat(report.DecimalformatForWeight(data.TotalReceipt.ToString()), 13, 1));
sw.Write(report.StringFormat((report.DecimalformatForWeight((data.TotalReceipt + data.OpeningBalance).ToString())), 17, 1));
sw.Write(report.StringFormat((report.DecimalformatForWeight((data.IssueSales + data.IssueOthers).ToString())), 13, 1));
sw.Write(report.StringFormat(report.DecimalformatForWeight(data.ClosingBalance.ToString()), 13, 1));
sw.Write(report.StringFormat(report.DecimalformatForWeight(data.CSBalance.ToString()), 20, 1));
sw.Write(report.StringFormat(report.DecimalformatForWeight(data.Shortage.ToString()), 13, 1));
sw.Write(report.StringFormat(report.DecimalformatForWeight(data.PhycialBalance.ToString()), 13, 1));
sw.WriteLine("");
count = count + 1;
i++;
}
sw.WriteLine("|------------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " " + ex.StackTrace);
}
}
/// <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);
}
}
public List <DailyStockDetailsEntity> ProcessStockStatement(StockParameter stockParameter)
{
decimal _BookBalanceWeight = 0, _PhysicalBalanceWeight = 0, _CumulitiveShortage = 0, _Shortage = 0;
decimal _receiptuptoYesterday = 0, _receipttotay = 0, _issuesuptoYesterday = 0,
_issuestoday = 0, _otherIssuesuptoYesterday = 0, _otherIssuestoday = 0, _writeOFFAll = 0,
_openingBookBalance = 0, _closingBookBalance = 0, _phycialbalance = 0;
string _itemCode = string.Empty;
string _ITDescription = string.Empty;
List <DailyStockDetailsEntity> dailyStockDetailsEntities = new List <DailyStockDetailsEntity>();
try
{
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
DataSet dataSetMaster = new DataSet();
List <KeyValuePair <string, string> > _mastersqlParameters = new List <KeyValuePair <string, string> >();
_mastersqlParameters.Add(new KeyValuePair <string, string>("@GCode", stockParameter.GCode));
_mastersqlParameters.Add(new KeyValuePair <string, string>("@RCode", stockParameter.RCode));
_mastersqlParameters.Add(new KeyValuePair <string, string>("@Date", stockParameter.FDate));
dataSetMaster = manageSQLConnection.GetDataSetValues("GetMasterDataToProcessCB", _mastersqlParameters);
DataSet todayIssues = new DataSet();
DataSet todayReceipt = new DataSet();
DataSet issuesUptoYesterday = new DataSet();
DataSet receiptUptoYesterday = new DataSet();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", stockParameter.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", stockParameter.FDate));
sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", stockParameter.ToDate));
sqlParameters.Add(new KeyValuePair <string, string>("@RCode", stockParameter.RCode));
todayIssues = manageSQLConnection.GetDataSetValues("GetTodayIssuesByDate", sqlParameters);
todayReceipt = manageSQLConnection.GetDataSetValues("GetTodayReceiptByDate", sqlParameters);
issuesUptoYesterday = manageSQLConnection.GetDataSetValues("GetIssuesUptoYesterdayByDate", sqlParameters);
receiptUptoYesterday = manageSQLConnection.GetDataSetValues("GetReceiptUptoYesterdayByDate", sqlParameters);
if (dataSetMaster.Tables.Count > 0)
{
foreach (DataRow godown in dataSetMaster.Tables[2].Rows) // godown details.
{
foreach (DataRow item in dataSetMaster.Tables[1].Rows) // item master details.
{
DailyStockDetailsEntity stockDetailsEntity = new DailyStockDetailsEntity();
_itemCode = Convert.ToString(item["ITCode"]);
_ITDescription = Convert.ToString(item["ITDescription"]);
stockDetailsEntity.ItemCode = _itemCode;
stockDetailsEntity.ITDescription = _ITDescription;
stockDetailsEntity.GodownCode = Convert.ToString(godown["TNCSCode"]);
stockDetailsEntity.RegionCode = Convert.ToString(godown["TNCSRegn"]);
stockDetailsEntity.RName = Convert.ToString(godown["RGNAME"]);
stockDetailsEntity.GName = Convert.ToString(godown["TNCSName"]);
stockDetailsEntity.TNCSCapacity = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(godown["TNCSCapacity"])));
// sqlParameters.Add(new KeyValuePair<string, string>("@ItemCode", _itemCode));
//get opening balance for particualr item.
DataRow[] openingBalance = dataSetMaster.Tables[0].Select("GodownCode='" + stockDetailsEntity.GodownCode + "' and CommodityCode='" + stockDetailsEntity.ItemCode + "'");
DataRow[] receiptuptoYesterday = receiptUptoYesterday.Tables[0].Select("GCode='" + stockDetailsEntity.GodownCode + "' and ITCode='" + _itemCode + "'");
DataRow[] receipttotay = todayReceipt.Tables[0].Select("GCode='" + stockDetailsEntity.GodownCode + "' and ITCode='" + _itemCode + "'");
DataRow[] issuesuptoYesterday = issuesUptoYesterday.Tables[1].Select("GCode='" + stockDetailsEntity.GodownCode + "' and ITCode='" + _itemCode + "'");
DataRow[] issuestoday = todayIssues.Tables[0].Select("GCode='" + stockDetailsEntity.GodownCode + "' and ITCode='" + _itemCode + "'");
DataRow[] otherIssuesuptoYesterday = issuesUptoYesterday.Tables[0].Select("GCode='" + stockDetailsEntity.GodownCode + "' and ITCode='" + _itemCode + "'");
DataRow[] otherIssuestoday = todayIssues.Tables[1].Select("GCode='" + stockDetailsEntity.GodownCode + "' and ITCode='" + _itemCode + "'");
DataRow[] writeOFFuptoYesterday = issuesUptoYesterday.Tables[2].Select("GCode='" + stockDetailsEntity.GodownCode + "' and ITCode='" + _itemCode + "'");
_BookBalanceWeight = 0;
_PhysicalBalanceWeight = 0;
_CumulitiveShortage = 0;
_Shortage = 0;
_receiptuptoYesterday = 0;
_receipttotay = 0;
_issuesuptoYesterday = 0;
_issuestoday = 0;
_otherIssuesuptoYesterday = 0;
_otherIssuestoday = 0;
_openingBookBalance = 0;
_closingBookBalance = 0;
_phycialbalance = 0;
_writeOFFAll = 0;
if (openingBalance != null && openingBalance.Count() > 0)
{
_BookBalanceWeight = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["BookBalanceWeight"])));
_PhysicalBalanceWeight = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["PhysicalBalanceWeight"])));
_CumulitiveShortage = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["CumulitiveShortage"])));
_Shortage = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["WriteOff"])));
}
if (receiptuptoYesterday != null && receiptuptoYesterday.Count() > 0)
{
_receiptuptoYesterday = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(receiptuptoYesterday[0]["TOTAL"])));
}
if (receipttotay != null && receipttotay.Count() > 0)
{
_receipttotay = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(receipttotay[0]["TOTAL"])));
}
if (issuesuptoYesterday != null && issuesuptoYesterday.Count() > 0)
{
_issuesuptoYesterday = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(issuesuptoYesterday[0]["TOTAL"])));
}
if (issuestoday != null && issuestoday.Count() > 0)
{
_issuestoday = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(issuestoday[0]["TOTAL"])));
}
if (otherIssuesuptoYesterday != null && otherIssuesuptoYesterday.Count() > 0)
{
_otherIssuesuptoYesterday = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(otherIssuesuptoYesterday[0]["TOTAL"])));
}
if (otherIssuestoday != null && otherIssuestoday.Count() > 0)
{
_otherIssuestoday = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(otherIssuestoday[0]["TOTAL"])));
}
if (writeOFFuptoYesterday.Count() > 0)
{
_writeOFFAll = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(writeOFFuptoYesterday[0]["TOTAL"])));
}
_openingBookBalance = (_BookBalanceWeight + _receiptuptoYesterday) - (_issuesuptoYesterday + _otherIssuesuptoYesterday);
_closingBookBalance = (_openingBookBalance + _receipttotay) - (_issuestoday + _otherIssuestoday);
_CumulitiveShortage = _CumulitiveShortage - _writeOFFAll;
_phycialbalance = _closingBookBalance - (_CumulitiveShortage + _Shortage);
_Shortage = _CumulitiveShortage > 0 ? _Shortage : (_CumulitiveShortage + _Shortage);
_CumulitiveShortage = _CumulitiveShortage > 0 ? _CumulitiveShortage : 0;
stockDetailsEntity.OpeningBalance = _openingBookBalance;
stockDetailsEntity.ClosingBalance = _closingBookBalance;
stockDetailsEntity.PhycialBalance = _phycialbalance;
stockDetailsEntity.CSBalance = _CumulitiveShortage;
stockDetailsEntity.Shortage = _Shortage;
stockDetailsEntity.TotalReceipt = _receipttotay;
stockDetailsEntity.IssueSales = _issuestoday;
stockDetailsEntity.IssueOthers = _otherIssuestoday;
stockDetailsEntity.LastUpdated = DateTime.Now;
stockDetailsEntity.Remarks = string.Empty;
stockDetailsEntity.Flag = true;
// InsertData(stockDetailsEntity);
//}
// Data checking
decimal CheckData = stockDetailsEntity.OpeningBalance + stockDetailsEntity.ClosingBalance +
stockDetailsEntity.TotalReceipt + stockDetailsEntity.IssueSales
+ stockDetailsEntity.IssueOthers;
if (CheckData > 0)
{
dailyStockDetailsEntities.Add(stockDetailsEntity);
}
}
}
}
}
catch (Exception ex)
{
AuditLog.WriteError(" Process Daily Stock " + ex.Message);
}
ManageStockStatement manageStockStatement = new ManageStockStatement();
Task.Run(() => manageStockStatement.GenerateStockStatementReport(dailyStockDetailsEntities, stockParameter)); //Generate the Report
return(dailyStockDetailsEntities);
}
/// <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>
/// Add receipt item details
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="stockReceipt"></param>
public void AddDetails(StreamWriter streamWriter, DataSet dataSet, int type)
{
int i = 0;
//Add header values
int count = dataSet.Tables[0].Columns.Count;
int length = (count * 12) + count + 20 + 6;
streamWriter.WriteLine("-" + report.AddLine(length));
streamWriter.Write(" ");
foreach (DataColumn dataColumn in dataSet.Tables[0].Columns)
{
streamWriter.Write(report.StringFormat(dataColumn.ColumnName, i == 0 ? 20 : i > 0 && i <= 2 ? 15 : 12, i <= 2 ? 2 : 1));
i++;
}
streamWriter.Write(" Total |");
streamWriter.WriteLine(" ");
streamWriter.WriteLine("-" + report.AddLine(length));
foreach (DataRow item in dataSet.Tables[0].Rows)
{
i = 0;
decimal Total = 0;
decimal dTotal = 0;
streamWriter.Write(" ");
for (int k = 0; k < count; k++)
{
var result = report.StringFormatWithEmpty(Convert.ToString(item[k]));
if (i <= 2 && type == 0)
{
streamWriter.Write(report.StringFormat(result.Item1, i == 0 ? 20 : i > 0 && i <= 2 ? 15 : 12, i <= 2 ? 2 : 1));
}
else if (i <= 3 && type == 1)
{
streamWriter.Write(report.StringFormat(result.Item1, i == 0 ? 20 : i > 0 && i <= 2 ? 15 : 12, i <= 3 ? 2 : 1));
}
else if (i <= 1 && type == 2)
{
streamWriter.Write(report.StringFormat(result.Item1, i == 0 ? 20 : i > 0 && i <= 1 ? 15 : 12, i <= 1 ? 2 : 1));
}
if (i > 2 && type == 0)
{
dTotal = (result.Item2 == true ? Convert.ToDecimal(result.Item1) : 0);
Total = Total + dTotal;
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(Convert.ToString(dTotal)), i == 0 ? 20 : i > 0 && i <= 2 ? 15 : 12, i <= 2 ? 2 : 1));
}
else if (i > 3 && type == 1)
{
dTotal = (result.Item2 == true ? Convert.ToDecimal(result.Item1) : 0);
Total = Total + dTotal;
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(Convert.ToString(dTotal)), i == 0 ? 20 : i > 0 && i <= 2 ? 15 : 12, i <= 3 ? 2 : 1));
}
else if (i > 1 && type == 2)
{
dTotal = (result.Item2 == true ? Convert.ToDecimal(result.Item1) : 0);
Total = Total + dTotal;
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(Convert.ToString(dTotal)), i == 0 ? 20 : i > 0 && i <= 2 ? 15 : 12, i <= 1 ? 2 : 1));
}
i++;
}
//Total
streamWriter.Write(report.StringFormat(report.DecimalformatForWeight(Convert.ToString(Total)), 12, 1));
streamWriter.WriteLine(" ");
}
streamWriter.WriteLine("-" + report.AddLine(length));
}
/// <summary>
/// Write text file for Date wise record.
/// </summary>
/// <param name="sw">Text Streamwriter</param>
/// <param name="entity">Common Entity</param>
public void WriteDORegForDateWise(StreamWriter sw, CommonEntity entity)
{
int iCount = 10;
var distinctDate = entity.dataTable.DefaultView.ToTable(true, "DeliveryOrderDate");
//Date wise DO report
int i = 1;
string sIssuer = string.Empty;
bool CheckRepeatValue = false;
string sDoNo = string.Empty;
foreach (DataRow dateValue in distinctDate.Rows)
{
iCount = 11;
string sDoNo1 = string.Empty;
DataRow[] datas = entity.dataTable.Select("DeliveryOrderDate='" + dateValue["DeliveryOrderDate"] + "'");
AddHeader(sw, Convert.ToString(dateValue["DeliveryOrderDate"]));
foreach (DataRow dr in datas)
{
if (iCount >= 50)
{
//Add header again
iCount = 11;
sw.WriteLine("----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
AddHeader(sw, Convert.ToString(dateValue["DeliveryOrderDate"]));
}
sDoNo1 = dr["Dono"].ToString();
if (sDoNo == sDoNo1)
{
CheckRepeatValue = true;
}
else
{
CheckRepeatValue = false;
sDoNo = sDoNo1;
}
sIssuer = Convert.ToString(dr["To_Whom_Issued"]).Trim();
sw.Write(report.StringFormat(CheckRepeatValue == false ? i.ToString() : " ", 4, 2));
sw.Write(report.StringFormat(CheckRepeatValue == false ? sDoNo1 : " ", 11, 1));
sw.Write(report.StringFormat(CheckRepeatValue == false ? report.Decimalformat(Convert.ToString(dr["Totals"])) : "-", 17, 1));
sw.Write(report.StringFormat(CheckRepeatValue == false ? sIssuer : " ", 15, 2));
sw.Write(report.StringFormat(dr["Cheque_DD"].ToString(), 11, 2));
sw.Write(report.StringFormat(report.Decimalformat(dr["PaymentAmount"].ToString()), 15, 1));
sw.Write(report.StringFormat(dr["Scheme"].ToString(), 13, 2));
sw.Write(report.StringFormat(dr["Commodity"].ToString(), 14, 2));
sw.Write(report.StringFormat(report.DecimalformatForWeight(dr["Netwt_Kgs"].ToString()), 11, 1));
sw.Write(report.StringFormat(report.Decimalformat(dr["Rate_Rs"].ToString()), 14, 1));
sw.Write(report.StringFormat(report.Decimalformat(dr["Itemamount"].ToString()), 15, 1));
sw.Write(report.StringFormat(report.Decimalformat(dr["PreviousAmount"].ToString()), 15, 1));
sw.Write(report.StringFormat(report.Decimalformat(dr["Adjusted"].ToString()), 13, 1));
sw.Write(report.StringFormat(report.Decimalformat(dr["Balance"].ToString()), 14, 1));
sw.Write(report.StringFormat(report.Decimalformat(dr["MarginAmount"].ToString()), 12, 1));
sw.WriteLine("");
int addedLines = 0;
if (!CheckRepeatValue)
{
addedLines = report.AddMoreContent(sw, sIssuer, 15, 35);
}
sw.WriteLine(" | | | | | | | | | | | | | | |");
iCount = iCount + 2 + addedLines;
i = CheckRepeatValue == false ? i + 1 : i;
}
sw.WriteLine("----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|");
sw.WriteLine((char)12);
}
}
/// <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 = 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);
}
}
public List <QAObjectEntity> ProcessQAStatement(QuantityAccountEntity quantityAccountEntity)
{
string _itemCode = string.Empty;
string _ITDescription = string.Empty;
List <QAObjectEntity> _qaObjectEntity = new List <QAObjectEntity>();
try
{
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
DataSet dataSetMaster = new DataSet();
List <KeyValuePair <string, string> > sqlMasterParameters = new List <KeyValuePair <string, string> >();
sqlMasterParameters.Add(new KeyValuePair <string, string>("@GCode", quantityAccountEntity.GCode));
sqlMasterParameters.Add(new KeyValuePair <string, string>("@RCode", quantityAccountEntity.RCode));
sqlMasterParameters.Add(new KeyValuePair <string, string>("@FromDate", quantityAccountEntity.FromDate));
dataSetMaster = manageSQLConnection.GetDataSetValues("GetMasterDataForQuantityAccountCB", sqlMasterParameters);
DataSet todayIssues = new DataSet();
DataSet todayReceipt = new DataSet();
DataSet issuesUptoYesterday = new DataSet();
DataSet receiptUptoYesterday = new DataSet();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@GCode", quantityAccountEntity.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@RCode", quantityAccountEntity.RCode));
sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", quantityAccountEntity.FromDate));
sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", quantityAccountEntity.ToDate));
todayIssues = manageSQLConnection.GetDataSetValues("GetTodayIssuesForQuantityAccount", sqlParameters);
todayReceipt = manageSQLConnection.GetDataSetValues("GetTodayReceiptForQuantityAccount", sqlParameters);
issuesUptoYesterday = manageSQLConnection.GetDataSetValues("GetIssuesUptoYesterForQuantityAccount", sqlParameters);
receiptUptoYesterday = manageSQLConnection.GetDataSetValues("GetReceiptUptoYesterForQuantityAccount", sqlParameters);
if (dataSetMaster.Tables.Count > 0)
{
foreach (DataRow item in dataSetMaster.Tables[1].Rows) // item master details.
{
_itemCode = Convert.ToString(item["ITCode"]);
_ITDescription = Convert.ToString(item["ITDescription"]);
foreach (DataRow godown in dataSetMaster.Tables[2].Rows) // godown details.
{
QAObjectEntity objectEntity = new QAObjectEntity();
objectEntity.ItemCode = _itemCode;
objectEntity.Commodity = _ITDescription;
objectEntity.GCode = godown["TNCSCode"].ToString();
objectEntity.RCode = godown["RGCODE"].ToString();
objectEntity.GName = godown["TNCSName"].ToString();
objectEntity.RName = godown["RGNAME"].ToString();
//get opening balance for particualr item.
DataRow[] openingBalance = dataSetMaster.Tables[0].Select("CommodityCode='" + _itemCode + "'");
DataRow[] receiptuptoYesterday = receiptUptoYesterday.Tables[0].Select("ITCode='" + _itemCode + "'");
// DataRow[] receipttotay = todayReceipt.Tables[0].Select("GCode='" + objectEntity.GCode + "' and ITCode='" + _itemCode + "'");
DataRow[] issuesuptoYesterday = issuesUptoYesterday.Tables[0].Select("ITCode='" + _itemCode + "'");
// DataRow[] issuestoday = todayIssues.Tables[0].Select("GCode='" + objectEntity.GCode + "' and ITCode='" + _itemCode + "'");
ClearVariable();
if (openingBalance != null && openingBalance.Count() > 0)
{
_BookBalanceWeight = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["BookBalanceWeight"])));
//_PhysicalBalanceWeight = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["PhysicalBalanceWeight"])));
//_CumulitiveShortage = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["CumulitiveShortage"])));
//_Shortage = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["WriteOff"])));
}
if (receiptuptoYesterday != null && receiptuptoYesterday.Count() > 0)
{
_receiptuptoYesterday = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(receiptuptoYesterday[0]["TOTAL"])));
}
if (issuesuptoYesterday != null && issuesuptoYesterday.Count() > 0)
{
_issuesuptoYesterday = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(issuesuptoYesterday[0]["TOTAL"])));
}
_OpeningBalance = (_BookBalanceWeight + _receiptuptoYesterday) - (_issuesuptoYesterday);
_RecPDS = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.PDS.ToString());
_RecPRIORITY = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.PRIORITY.ToString());
_RecTIDEOVER = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.TIDEOVER.ToString());
_RecAAY = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.AAY.ToString());
_RecSPLPDS = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.SPLPDS.ToString());
_RecCEMENT = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.CEMENT.ToString());
_RecHOPURCHASE = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.HOPURCHASE.ToString());
_RecSEIZUR = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.SEIZUR.ToString());
_RecPTMGRNMP = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.PTMGRNMP.ToString());
_RecSGRY = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.SGRY.ToString());
_RecANNAPURNA = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.ANNAPURNA.ToString());
_RecRECEIVEDFROM = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.RECEIVEDFROM.ToString());
_RecTRANSFERWITHINREGION = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.TRANSFERWITHINREGION.ToString());
_RecTRANSFEROTHERREGION = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.TRANSFEROTHERREGION.ToString());
_RecEXCESS = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.EXCESS.ToString());
_RecCLEANINGANDPACKING = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.CLEANINGANDPACKING.ToString());
_RecVCFLOOD = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.VCFLOOD.ToString());
_RecSALESRETURN = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.SALESRETURN.ToString());
//issues details
_IsPDS = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.PDS.ToString());
_IsCOOP = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.COOP.ToString());
_IsPOLICE = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.POLICE.ToString());
_IsNMP = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.NMP.ToString());
_IsBULK = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.BULK.ToString());
_IsCREDIT = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.CREDIT.ToString());
_IsOAP = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.OAP.ToString());
_IsSRILANKA = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.SRILANKA.ToString());
_IsAAY = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.AAY.ToString());
_IsSPLPDS = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.SPLPDS.ToString());
_IsPDSCOOP = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.PDSCOOP.ToString());
_IsCEMENTFLOOD = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.CEMENTFLOOD.ToString());
_IsPTMGR = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.PTMGR.ToString());
_IsSGRY = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.SGRY.ToString());
_IsANNAPOORNA = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.ANNAPOORNA.ToString());
_IsISSUESTOPROCESSING = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.ISSUESTOPROCESSING.ToString());
_IsTRANSFERWITHINREGION = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.TRANSFERWITHINREGION.ToString());
_IsTRANSFEROTHERREGION = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.TRANSFEROTHERREGION.ToString());
_IsWRITEOFF = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.WRITEOFF.ToString());
_IsCLEANING = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.CLEANING.ToString());
_IsVCBLG = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.VCBLG.ToString());
_IsPURCHASERETURN = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.PURCHASERETURN.ToString());
_Total = _RecPDS + _RecPRIORITY + _RecTIDEOVER + _RecAAY + _RecSPLPDS
+ _RecCEMENT + _RecHOPURCHASE + _RecSEIZUR;
objectEntity.OpeningBalance = _OpeningBalance;
objectEntity.RecPDS = _RecPDS;
objectEntity.RecPRIORITY = _RecPRIORITY;
objectEntity.RecTIDEOVER = _RecTIDEOVER;
objectEntity.RecAAY = _RecAAY;
objectEntity.RecSPLPDS = _RecSPLPDS;
objectEntity.RecCEMENT = _RecCEMENT;
objectEntity.RecHOPURCHASE = _RecHOPURCHASE;
objectEntity.RecSEIZUR = _RecSEIZUR;
objectEntity.Total = _Total;
_TotalFreeRice = _RecPTMGRNMP + _RecSGRY + _RecANNAPURNA;
objectEntity.RecPTMGRNMP = _RecPTMGRNMP;
objectEntity.RecSGRY = _RecSGRY;
objectEntity.RecANNAPURNA = _RecANNAPURNA;
objectEntity.TotalFreeRice = _TotalFreeRice;
objectEntity.RecRECEIVEDFROM = _RecRECEIVEDFROM;
objectEntity.RecTRANSFERWITHINREGION = _RecTRANSFERWITHINREGION;
objectEntity.RecTRANSFEROTHERREGION = _RecTRANSFEROTHERREGION;
objectEntity.RecEXCESS = _RecEXCESS;
objectEntity.RecCLEANINGANDPACKING = _RecCLEANINGANDPACKING;
objectEntity.RecVCFLOOD = _RecVCFLOOD;
objectEntity.RecSALESRETURN = _RecSALESRETURN;
_TotalOtherReceipt = _RecRECEIVEDFROM + _RecTRANSFERWITHINREGION + _RecTRANSFEROTHERREGION
+ _RecEXCESS + _RecCLEANINGANDPACKING + _RecSALESRETURN;
objectEntity.TotalOtherReceipt = _TotalOtherReceipt;
_TotalReceipt = _Total + _TotalFreeRice + _TotalOtherReceipt;
objectEntity.TotalReceipt = _TotalReceipt;
_GrandTotalReceipt = _TotalReceipt + _OpeningBalance;
objectEntity.GrandTotalReceipt = _GrandTotalReceipt;
//Issues Details.
objectEntity.IsPDS = _IsPDS;
objectEntity.IsCOOP = _IsCOOP;
objectEntity.IsPOLICE = _IsPOLICE;
objectEntity.IsNMP = _IsNMP;
objectEntity.IsBULK = _IsBULK;
objectEntity.IsCREDIT = _IsCREDIT;
objectEntity.IsOAP = _IsOAP;
objectEntity.IsSRILANKA = _IsSRILANKA;
objectEntity.IsAAY = _IsAAY;
objectEntity.IsSPLPDS = _IsSPLPDS;
objectEntity.IsPDSCOOP = _IsPDSCOOP;
objectEntity.IsCEMENTFLOOD = _IsCEMENTFLOOD;
_IsTotalSales = _IsPDS + _IsCOOP + _IsPOLICE + _IsNMP + _IsBULK + _IsCREDIT
+ _IsOAP + _IsSRILANKA + _IsAAY + _IsSPLPDS + _IsPDSCOOP + _IsCEMENTFLOOD;
objectEntity.IsTotalSales = _IsTotalSales;
objectEntity.IsPTMGR = _IsPTMGR;
objectEntity.IsSGRY = _IsSGRY;
objectEntity.IsANNAPOORNA = _IsANNAPOORNA;
_IsTotalFreeRiceIssues = _IsPTMGR + _IsSGRY + _IsANNAPOORNA;
objectEntity.IsTotalFreeRiceIssues = _IsTotalFreeRiceIssues;
objectEntity.IsISSUESTOPROCESSING = _IsISSUESTOPROCESSING;
objectEntity.IsTRANSFERWITHINREGION = _IsTRANSFERWITHINREGION;
objectEntity.IsTRANSFEROTHERREGION = _IsTRANSFEROTHERREGION;
objectEntity.IsWRITEOFF = _IsWRITEOFF;
objectEntity.IsCLEANING = _IsCLEANING;
objectEntity.IsVCBLG = _IsVCBLG;
objectEntity.IsPURCHASERETURN = _IsPURCHASERETURN;
_IsTotalOtherIssues = _IsISSUESTOPROCESSING + _IsTRANSFERWITHINREGION + _IsTRANSFEROTHERREGION
+ _IsWRITEOFF + _IsCLEANING + _IsVCBLG + _IsPURCHASERETURN;
objectEntity.IsTotalOtherIssues = _IsTotalOtherIssues;
_IsTotalIssues = _IsTotalSales + _IsTotalFreeRiceIssues + _IsTotalOtherIssues;
objectEntity.IsTotalIssues = _IsTotalIssues;
_IsBalanceQty = _GrandTotalReceipt - _IsTotalIssues;
objectEntity.IsBalanceQty = _IsBalanceQty;
if (_IsBalanceQty > 0 || _IsTotalOtherIssues > 0 || _IsTotalFreeRiceIssues > 0 || _IsTotalSales > 0 ||
_GrandTotalReceipt > 0 || _TotalReceipt > 0 || _TotalOtherReceipt > 0 || _Total > 0 || _TotalFreeRice > 0)
{
_qaObjectEntity.Add(objectEntity);
}
//decimal CheckData = stockDetailsEntity.OpeningBalance + stockDetailsEntity.ClosingBalance +
// stockDetailsEntity.TotalReceipt + stockDetailsEntity.IssueSales
// + stockDetailsEntity.IssueOthers;
//if (CheckData > 0)
//{
// dailyStockDetailsEntities.Add(stockDetailsEntity);
//}
}
}
}
}
catch (Exception ex)
{
AuditLog.WriteError(" Process Daily Stock " + ex.Message);
}
//ManageStockStatement manageStockStatement = new ManageStockStatement();
//Task.Run(() => manageStockStatement.GenerateStockStatementReport(dailyStockDetailsEntities, stockParameter)); //Generate the Report
return(_qaObjectEntity);
}
/// <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>
/// Add receipt item details
/// </summary>
/// <param name="streamWriter"></param>
/// <param name="stockIssuesEntity"></param>
private void AddDetails(StreamWriter streamWriter, List <StackCardRegisterEntity> stackCardRegisters, StackEntity stackEntity)
{
try
{
int count = 13;
int i = 1;
string Fromdate = string.Empty;
string Todate = string.Empty;
int OpeningBag = 0;
int ReceiptBag = 0;
int IssuesBag = 0;
int BalanceBag = 0;
int GU = 0;
int GR = 0;
decimal OpeningQty = 0;
decimal ReceiptQty = 0;
decimal IssuesQty = 0;
decimal BalanceQty = 0;
decimal WriteOffQty = 0;
foreach (var item in stackCardRegisters)
{
if (count > 50)
{
streamWriter.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------");
count = 13;
streamWriter.WriteLine((char)12);
AddDocHeaderForIssues(streamWriter, stackEntity);
}
count++;
streamWriter.Write(report.StringFormatWithoutPipe(i.ToString(), 4, 1));
streamWriter.Write(report.StringFormatWithoutPipe(item.Commodity, 25, 2));
streamWriter.Write(report.StringFormatWithoutPipe(item.StackCard, 13, 2));
streamWriter.Write(report.StringFormatWithoutPipe(item.FromDate, 10, 2));
streamWriter.Write(report.StringFormatWithoutPipe(item.ToDate, 10, 2));
streamWriter.Write(report.StringFormatWithoutPipe(item.OpeningBag, 9, 1));
streamWriter.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(item.OpeningQty), 11, 1));
streamWriter.Write(report.StringFormatWithoutPipe(item.ReceiptBag, 9, 1));
streamWriter.Write(report.StringFormatWithoutPipe(item.GU, 8, 1));
streamWriter.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(item.ReceiptQty), 11, 1));
streamWriter.Write(report.StringFormatWithoutPipe(item.IssuesBag, 9, 1));
streamWriter.Write(report.StringFormatWithoutPipe(item.GR, 8, 1));
streamWriter.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(item.IssuesQty), 11, 1));
streamWriter.Write(report.StringFormatWithoutPipe(item.BalanceBag, 9, 1));
streamWriter.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(item.BalanceQty), 15, 1));
streamWriter.Write(report.StringFormatWithoutPipe(item.StackStatus, 5, 1));
streamWriter.Write(report.StringFormatWithoutPipe(report.DecimalformatForWeight(item.WriteOff), 9, 1));
streamWriter.WriteLine(" ");
streamWriter.WriteLine(" ");
OpeningBag += Convert.ToInt32(item.OpeningBag);
ReceiptBag += Convert.ToInt32(item.ReceiptBag);
IssuesBag += Convert.ToInt32(item.IssuesBag);
BalanceBag += Convert.ToInt32(item.BalanceBag);
GU += Convert.ToInt32(item.GU);
GR += Convert.ToInt32(item.GR);
OpeningQty += Convert.ToDecimal(item.OpeningQty);
ReceiptQty += Convert.ToDecimal(item.ReceiptQty);
IssuesQty += Convert.ToDecimal(item.IssuesQty);
BalanceQty += Convert.ToDecimal(item.BalanceQty);
WriteOffQty += Convert.ToDecimal(item.WriteOff);
i = i + 1;
}
streamWriter.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------");
streamWriter.Write(report.StringFormatWithoutPipe(" ", 4, 1));
streamWriter.Write(report.StringFormatWithoutPipe("-", 13, 1));
streamWriter.Write(report.StringFormatWithoutPipe("-", 10, 1));
streamWriter.Write(report.StringFormatWithoutPipe("-", 10, 1));
streamWriter.Write(report.StringFormatWithoutPipe(OpeningBag.ToString(), 9, 1));
streamWriter.Write(report.StringFormatWithoutPipe(OpeningQty.ToString(), 11, 1));
streamWriter.Write(report.StringFormatWithoutPipe(ReceiptBag.ToString(), 9, 1));
streamWriter.Write(report.StringFormatWithoutPipe(GU.ToString(), 8, 1));
streamWriter.Write(report.StringFormatWithoutPipe(ReceiptQty.ToString(), 11, 1));
streamWriter.Write(report.StringFormatWithoutPipe(IssuesBag.ToString(), 9, 1));
streamWriter.Write(report.StringFormatWithoutPipe(GR.ToString(), 8, 1));
streamWriter.Write(report.StringFormatWithoutPipe(IssuesQty.ToString(), 11, 1));
streamWriter.Write(report.StringFormatWithoutPipe(BalanceBag.ToString(), 9, 1));
streamWriter.Write(report.StringFormatWithoutPipe(BalanceQty.ToString(), 15, 1));
streamWriter.Write(report.StringFormatWithoutPipe("-", 5, 1));
streamWriter.Write(report.StringFormatWithoutPipe(WriteOffQty.ToString(), 9, 1));
streamWriter.WriteLine(" ");
streamWriter.WriteLine("------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------");
streamWriter.WriteLine((char)12);
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " " + ex.StackTrace);
}
}
public void AddDetails(iTextSharp.text.Document doc, DocumentStockReceiptList stockReceipt)
{
//streamWriter.WriteLine("||SNo |STACK NO |COMMODITY | SCHEME |UNIT WEIGHT |NO.OF UNIT | Gross WEIGHT NET |% OF MOISTURE ||");
//streamWriter.WriteLine("|| | | | | | UNIT| WEIGHT in Kgs/NOs |MOISTURE||");
PdfPTable table = new PdfPTable(9);
table.DefaultCell.Border = iTextSharp.text.Rectangle.NO_BORDER;
//set overall width
table.WidthPercentage = 100f;
//set column widths
int[] firstTablecellwidth = { 5, 8, 20, 12, 18, 7, 10, 10, 10 };
table.SetWidths(firstTablecellwidth);
PdfPCell cell = new PdfPCell(new Phrase("SNo", NormalFont));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("STACK NO", NormalFont));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("COMMODITY", NormalFont));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("SCHEME", NormalFont));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("UNIT WEIGHT", NormalFont));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("NO.OF UNIT", NormalFont));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Gross WEIGHT", NormalFont));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("NET WEIGHT", NormalFont));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("% OF MOISTURE", NormalFont));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(cell);
int i = 0;
foreach (var item in stockReceipt.ItemList)
{
i++;
cell = new PdfPCell(new Phrase(i.ToString(), NormalFont));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(item.TStockNo, NormalFont));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(item.CommodityName, NormalFont));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(item.SchemeName, NormalFont));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(item.PackingName, NormalFont));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(item.NoPacking.ToString(), NormalFont));
cell.HorizontalAlignment = Element.ALIGN_RIGHT;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(report.DecimalformatForWeight(item.GKgs.ToString()), NormalFont));
cell.HorizontalAlignment = Element.ALIGN_RIGHT;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(report.DecimalformatForWeight(item.Nkgs.ToString()), NormalFont));
cell.HorizontalAlignment = Element.ALIGN_RIGHT;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(item.Moisture.ToString(), NormalFont));
cell.HorizontalAlignment = Element.ALIGN_RIGHT;
table.AddCell(cell);
}
doc.Add(table);
}
public List <QAGunnyEntity> ProcessQAStatement(QuantityAccountEntity quantityAccountEntity)
{
string _itemCode = string.Empty;
string _ITDescription = string.Empty;
List <QAGunnyEntity> _qaObjectEntity = new List <QAGunnyEntity>();
try
{
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
DataSet dataSetMaster = new DataSet();
List <KeyValuePair <string, string> > sqlMasterParameters = new List <KeyValuePair <string, string> >();
sqlMasterParameters.Add(new KeyValuePair <string, string>("@GCode", quantityAccountEntity.GCode));
sqlMasterParameters.Add(new KeyValuePair <string, string>("@RCode", quantityAccountEntity.RCode));
sqlMasterParameters.Add(new KeyValuePair <string, string>("@FromDate", quantityAccountEntity.FromDate));
dataSetMaster = manageSQLConnection.GetDataSetValues("GetMasterDataForGunnyReceiptIssue", sqlMasterParameters);
DataSet todayIssues = new DataSet();
DataSet todayReceipt = new DataSet();
DataSet issuesUptoYesterday = new DataSet();
DataSet receiptUptoYesterday = new DataSet();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@GCode", quantityAccountEntity.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@RCode", quantityAccountEntity.RCode));
sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", quantityAccountEntity.FromDate));
sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", quantityAccountEntity.ToDate));
todayIssues = manageSQLConnection.GetDataSetValues("GetTodayIssuesForGunnyQuantityAccount", sqlParameters);
todayReceipt = manageSQLConnection.GetDataSetValues("GetTodayReceiptForGunnyQuantityAccount", sqlParameters);
issuesUptoYesterday = manageSQLConnection.GetDataSetValues("GetIssuesUptoYesterForGunnyQuantityAccount", sqlParameters);
receiptUptoYesterday = manageSQLConnection.GetDataSetValues("GetReceiptUptoYesterForGunnyQuantityAccount", sqlParameters);
if (dataSetMaster.Tables.Count > 0)
{
foreach (DataRow item in dataSetMaster.Tables[1].Rows) // item master details.
{
_itemCode = Convert.ToString(item["ITCode"]);
_ITDescription = Convert.ToString(item["ITDescription"]);
foreach (DataRow godown in dataSetMaster.Tables[2].Rows) // godown details.
{
QAGunnyEntity objectEntity = new QAGunnyEntity();
objectEntity.ItemCode = _itemCode;
objectEntity.Commodity = _ITDescription;
objectEntity.GCode = godown["TNCSCode"].ToString();
objectEntity.RCode = godown["RGCODE"].ToString();
objectEntity.GName = godown["TNCSName"].ToString();
objectEntity.RName = godown["RGNAME"].ToString();
//get opening balance for particualr item.
DataRow[] openingBalance = dataSetMaster.Tables[0].Select("CommodityCode='" + _itemCode + "'");
DataRow[] receiptuptoYesterday = receiptUptoYesterday.Tables[0].Select("ITCode='" + _itemCode + "'");
DataRow[] issuesuptoYesterday = issuesUptoYesterday.Tables[0].Select("ITCode='" + _itemCode + "'");
ClearVariable();
if (openingBalance != null && openingBalance.Count() > 0)
{
_BookBalanceWeight = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(openingBalance[0]["BookBalanceWeight"])));
}
if (receiptuptoYesterday != null && receiptuptoYesterday.Count() > 0)
{
_receiptuptoYesterday = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(receiptuptoYesterday[0]["TOTAL"])));
}
if (issuesuptoYesterday != null && issuesuptoYesterday.Count() > 0)
{
_issuesuptoYesterday = Convert.ToDecimal(manageReport.DecimalformatForWeight(Convert.ToString(issuesuptoYesterday[0]["TOTAL"])));
}
_OpeningBalance = (_BookBalanceWeight + _receiptuptoYesterday) - (_issuesuptoYesterday);
_RecPURCHASE = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.PURCHASE.ToString());
_RecHULLING = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.HULLING.ToString());
_RecGUNNYRELEASE = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.GUNNYRELEASE.ToString());
_RecHOPURCHASE = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.HOPURCHASE.ToString());
_RecTRANSFERWITHINREGION = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.TRANSFERWITHINREGION.ToString());
_RecTRANSFEROTHERREGION = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.TRANSFEROTHERREGION.ToString());
_RecEXCESS = GetValue(todayReceipt.Tables[0], dataSetMaster.Tables[3], objectEntity,
EnumQAReceiptParameter.EXCESS.ToString());
//issues details
_IsSALES = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.SALES.ToString());
_IsGUNNYRELEASE = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.GU.ToString());
_IsMENDING = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.MENDING.ToString());
_IsTRANSFERWITHINREGION = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.TRANSFERWITHINREGION.ToString());
_IsTRANSFEROTHERREGION = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.TRANSFEROTHERREGION.ToString());
_IsWRITEOFF = GetValue(todayIssues.Tables[0], dataSetMaster.Tables[4], objectEntity,
EnumQAIssuesHeaderParameter.WRITEOFF.ToString());
_Total = _RecPURCHASE + _RecHOPURCHASE + _RecHULLING + _RecGUNNYRELEASE + _RecEXCESS + _RecTRANSFERWITHINREGION + _RecTRANSFEROTHERREGION;
objectEntity.OpeningBalance = _OpeningBalance;
objectEntity.RecPURCHASE = _RecPURCHASE;
objectEntity.RecHULLING = _RecHULLING;
objectEntity.RecGUNNYRELEASE = _RecGUNNYRELEASE;
objectEntity.RecHOPURCHASE = _RecHOPURCHASE;
objectEntity.Total = _Total;
objectEntity.RecTRANSFERWITHINREGION = _RecTRANSFERWITHINREGION;
objectEntity.RecTRANSFEROTHERREGION = _RecTRANSFEROTHERREGION;
objectEntity.RecEXCESS = _RecEXCESS;
_TotalReceipt = _Total;
objectEntity.TotalReceipt = _TotalReceipt;
_GrandTotalReceipt = _TotalReceipt + _OpeningBalance;
objectEntity.GrandTotalReceipt = _GrandTotalReceipt;
//Issues Details.
objectEntity.IsSALES = _IsSALES;
objectEntity.IsGUNNYRELEASE = _IsGUNNYRELEASE;
objectEntity.IsMENDING = _IsMENDING;
_IsTotalSales = _IsSALES + _IsGUNNYRELEASE + _IsMENDING + _IsWRITEOFF + _IsTRANSFERWITHINREGION + _IsTRANSFEROTHERREGION;
objectEntity.IsTotalSales = _IsTotalSales;
objectEntity.IsTRANSFERWITHINREGION = _IsTRANSFERWITHINREGION;
objectEntity.IsTRANSFEROTHERREGION = _IsTRANSFEROTHERREGION;
objectEntity.IsWRITEOFF = _IsWRITEOFF;
_IsTotalIssues = _IsTotalSales;
objectEntity.IsTotalIssues = _IsTotalIssues;
_IsBalanceQty = _GrandTotalReceipt - _IsTotalIssues;
objectEntity.IsBalanceQty = _IsBalanceQty;
if (_IsBalanceQty > 0 || _IsTotalSales > 0 ||
_GrandTotalReceipt > 0 || _TotalReceipt > 0 || _Total > 0)
{
_qaObjectEntity.Add(objectEntity);
}
//decimal CheckData = stockDetailsEntity.OpeningBalance + stockDetailsEntity.ClosingBalance +
// stockDetailsEntity.TotalReceipt + stockDetailsEntity.IssueSales
// + stockDetailsEntity.IssueOthers;
//if (CheckData > 0)
//{
// dailyStockDetailsEntities.Add(stockDetailsEntity);
//}
}
}
}
}
catch (Exception ex)
{
AuditLog.WriteError(" Process Daily Stock " + ex.Message);
}
//ManageStockStatement manageStockStatement = new ManageStockStatement();
//Task.Run(() => manageStockStatement.GenerateStockStatementReport(dailyStockDetailsEntities, stockParameter)); //Generate the Report
return(_qaObjectEntity);
}
/// <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);
}
}