private int AddColSale(Cell cell, ref SaleItemWise 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.BrandName = cell.Text;
c++;
break;
case 4:
sr.ProductName = cell.Text;
c++;
break;
case 5:
sr.ItemDesc = cell.Text;
c++;
break;
case 6:
sr.Barcode = cell.Text;
c++;
break;
case 7:
sr.StyleCode = cell.Text;
c++;
break;
case 8:
sr.QTY = (int)cell.Amount;
c++;
break;
case 9:
sr.MRP = cell.Amount;
c++;
break;
case 10:
sr.BasicRate = cell.Amount;
c++;
break;
case 11:
sr.Discount = cell.Amount;
c++;
break;
case 12:
sr.Tax = cell.Amount;
c++;
break;
case 14:
sr.RoundOff = cell.Amount;
c++;
break;
case 13:
sr.LineTotal = cell.Amount;
c++;
break;
case 15:
sr.BillAmnt = cell.Amount;
c++;
break;
case 16:
sr.Saleman = cell.Text;
c++;
break;
case 17:
sr.PaymentType = cell.Text;
c++;
break;
}
return(c);
}
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);
}
