/// <summary>
/// Method to add sale vendor coupon line
/// </summary>
/// <param name="oLine">Sale vendor coupon line</param>
/// <param name="saleNumber">Sale number</param>
/// <param name="tillNumber">Till number</param>
public void AddSaleVendorCouponLine(SaleVendorCouponLine oLine, int saleNumber, int tillNumber)
{
_connection = new SqlConnection(GetConnectionString(DataSource.CSCCurSale));
if (_connection.State == ConnectionState.Closed)
{
_connection.Open();
}
_dataTable = new DataTable();
_adapter = new SqlDataAdapter("select * from SaleVendorCoupon where TILL_NUM=" + tillNumber
+ " AND SALE_NO=" + Convert.ToString(saleNumber) + " AND LINE_NUM="
+ Convert.ToString(oLine.Line_Num) + "AND SeqNumber=" + Convert.ToString(oLine.SeqNum)
, _connection);
_adapter.Fill(_dataTable);
if (_dataTable.Rows.Count == 0)
{
var fields = _dataTable.NewRow();
fields["Till_Num"] = tillNumber;
fields["Sale_No"] = saleNumber;
fields["Line_Num"] = oLine.Line_Num;
fields["CouponCode"] = oLine.CouponCode;
fields["CouponName"] = oLine.CouponName;
fields["UnitValue"] = oLine.UnitValue;
fields["Quantity"] = oLine.Quantity;
fields["TotalValue"] = oLine.TotalValue;
fields["SerialNumber"] = oLine.SerialNumber;
fields["SeqNumber"] = oLine.SeqNum;
fields["TendDesc"] = oLine.TendDesc;
_dataTable.Rows.Add(fields);
SqlCommandBuilder builder = new SqlCommandBuilder(_adapter);
_adapter.InsertCommand = builder.GetInsertCommand();
_adapter.Update(_dataTable);
_connection.Close();
_adapter?.Dispose();
}
}
/// <summary>
/// Method to add a line to sale vendor coupon
/// </summary>
/// <param name="svc">Sale vendor coupon</param>
/// <param name="tillNumber">Till number</param>
/// <param name="oLine">Sale line</param>
/// <param name="saveToTmp">Save to Db</param>
public void Add_a_Line(ref SaleVendorCoupon svc, int tillNumber, SaleVendorCouponLine oLine,
bool saveToTmp)
{
svc.SVC_Lines.AddLine((short)(svc.SVC_Lines.Count + 1), oLine, "");
svc.Amount = svc.Amount + oLine.TotalValue;
if (saveToTmp)
{
_svcService.AddSaleVendorCouponLine(oLine, svc.Sale_Num, tillNumber);
}
}