/// <summary>
/// Save Row Data
/// </summary>
/// <param name="sr">SaleRegister Object</param>
/// <returns>Return no of Object</returns>
public int SaveRowData(SaleRegister sr)
{
string query = "INSERT INTO [dbo].[SalesRegister] " +
"( [InvoiceNo], [InvoiceDate], [InvoiceType], " +
"[Qty], [MRP], [Discount], [BasicAmt], [TaxAmount], " +
"[RoundOff], [BillAmount], [PaymentMode]) " +
/*"[Coupon], [CouponAmt], [TalioringFlag], " +
* "[InstOrderCD])" +*/
" VALUES (@Inv,@InvD , @InvT, @QTY, @MRP, @Dis, @BAMT, " +
"@TAMT, @ROFF, @BILL, @PM)"; //, @CO,@CAMT, @TFG, @INST)";
SqlCommand cmd = new SqlCommand(query, vDb.DBCon);
cmd.Parameters.AddWithValue("@Inv", sr.InvoiceNo);
cmd.Parameters.AddWithValue("@InvD", sr.InvDate);
cmd.Parameters.AddWithValue("@InvT", sr.InvType);
cmd.Parameters.AddWithValue("@QTY", sr.QTY);
cmd.Parameters.AddWithValue("@MRP", sr.MRP);
cmd.Parameters.AddWithValue("@Dis", sr.Discount);
cmd.Parameters.AddWithValue("@BAMT", sr.BasicRate);
cmd.Parameters.AddWithValue("@TAMT", sr.Tax);
cmd.Parameters.AddWithValue("@ROFF", sr.RoundOff);
cmd.Parameters.AddWithValue("@BILL", sr.BillAmnt);
cmd.Parameters.AddWithValue("@PM", sr.paymentType);
//cmd.Parameters.AddWithValue("@CO", sr.coupon);
//cmd.Parameters.AddWithValue("@CAMT", sr.couponAmt);
//cmd.Parameters.AddWithValue("@TFG", sr.Tailoring);
//cmd.Parameters.AddWithValue("@INST", sr.instaorder);
return(InsertQuerySql(cmd));
}
// Reader Caller Section Start Here
public int ReadDataSaleRegister(string fname, int start, int end, ProgressBar pBar, string tablename)
{
//GST Features Added
DataTable dt = new DataTable(tablename);
int Row = 0;
int r = 0, c = 0;
SaleRegister sr;
Logs.LogMe("Started reading");
foreach (var worksheet in Workbook.Worksheets(fname))
{
Logs.LogMe(worksheet.ToString());
foreach (var row in worksheet.Rows)
{
//Logs.LogMe ("Row=" + row.ToString () + "RowNo=" + Row);
if (Row <= end)
{
if (Row >= start)
{
Logs.LogMe("iRow=" + r);
sr = new SaleRegister();
c = 0;
foreach (var cell in row.Cells)
{
if (cell != null)
{
c = AddCol(cell, ref sr, c);
}
else
{
Logs.LogMe("C=" + c + "Null");
}
c++;
}
if (Db.SaveRowData(sr) > 0)
{
r++;
pBar.BeginInvoke(new Action(() =>
{
pBar.PerformStep();
}));
Logs.LogMe("Row=" + r + " got saved");
}
}
Row++;
// Logs.LogMe ("Row will be" + Row + "\tr=" + r);
}
else
{
Logs.LogMe("End Target Matched , Breaking out now");
break;
}
}
}
Logs.LogMe("end , record=" + r);
return(r);
}
public Task Handle(CreateNewSaleCommand message, IMessageHandlerContext context)
{
LOG.Info($"Incomimng {message}");
SaleRegister saleRegister = new SaleRegister(saleStorage);
saleRegister.BeginNewSale();
//foreach (var saleItem in message.SaleItems)
//{
// saleRegister.SetItem(saleItem.Key, saleItem.Value.Item1, saleItem.Value.Item2);
//}
//saleRegister.Save();
return(Task.CompletedTask);
}
// Extra Functions start from here
private int AddCol(Cell cell, ref SaleRegister sr, int c)
{
//Logs.LogMe ("cell(" + cell.ColumnIndex + ")=" + cell.Text);
switch (cell.ColumnIndex)
{
case 0:
sr.InvoiceNo = cell.Text;
c++;
break;
case 1:
sr.InvDate = DataConvertor.DateFromExcelFormatString(cell.Text);
c++;
break;
case 2:
sr.InvType = cell.Text;
c++;
break;
case 3:
sr.QTY = (int)cell.Amount;
c++;
break;
case 4:
sr.MRP = cell.Amount;
c++;
break;
case 6:
sr.BasicRate = cell.Amount;
c++;
break;
case 5:
sr.Discount = cell.Amount;
c++;
break;
case 7:
sr.Tax = cell.Amount;
c++;
break;
case 8:
sr.RoundOff = cell.Amount;
c++;
break;
case 9:
sr.BillAmnt = cell.Amount;
c++;
break;
case 10:
sr.paymentType = cell.Text;
c++;
break;
// case 11: sr.coupon = cell.Text; c++; break; case 12: sr.couponAmt = cell.Text;
// c++; break; case 13: sr.LP = cell.Value; c++; break; case 14: sr.instaorder =
// cell.Text; c++; break; case 15: sr.Tailoring = cell.Text; c++; break;
}
return(c);
}