/// <summary>
/// Method to add drop line
/// </summary>
/// <param name="dropLine">Drop line</param>
public void AddDropLine(DropLine dropLine)
{
_connection = new SqlConnection(GetConnectionString(DataSource.CSCTills));
if (_connection.State == ConnectionState.Closed)
{
_connection.Open();
}
_dataTable = new DataTable();
_adapter = new SqlDataAdapter("select * from DropLines", _connection);
_adapter.Fill(_dataTable);
var fields = _dataTable.NewRow();
fields["Till_Num"] = dropLine.TillNumber;
fields["DropDate"] = dropLine.DropDate;
fields["Tender_Name"] = dropLine.TenderName;
fields["Exchange_Rate"] = dropLine.ExchangeRate;
fields["Amount"] = dropLine.Amount;
fields["Conv_Amount"] = dropLine.ConvAmount;
fields["DropID"] = dropLine.DropID;
_dataTable.Rows.Add(fields);
SqlCommandBuilder builder = new SqlCommandBuilder(_adapter);
_adapter.InsertCommand = builder.GetInsertCommand();
_adapter.Update(_dataTable);
_connection.Close();
_adapter?.Dispose();
}
/// <summary>
/// Method to add all drop lines
/// </summary>
/// <param name="till">Till</param>
/// <param name="bt">Base currency</param>
/// <param name="dropDate">Drop date</param>
/// <param name="cashDropTenders">Cash drop tenders</param>
/// <param name="cashDrop">Cash drop</param>
private void AddDropLines(Till till, string bt, DateTime dropDate, Tenders cashDropTenders, CashDrop cashDrop)
{
var dateStart = DateTime.Now;
_performancelog.Debug($"Start,CashManager,AddDropLines,{string.Empty},{dateStart:hh.mm.ss.ffffff}");
foreach (Tender tempLoopVarT in cashDropTenders)
{
var T = tempLoopVarT;
if (T.Amount_Entered > 0)
{
var dropLine = new DropLine
{
TillNumber = till.Number,
DropDate = dropDate,
TenderName = T.Tender_Name,
ExchangeRate = T.Exchange_Rate,
Amount = T.Amount_Entered,
ConvAmount = T.Amount_Used,
DropID = cashDrop.DropID
};
_cashService.AddDropLine(dropLine);
if (T.Tender_Name.ToUpper() == bt.ToUpper())
{
till.Cash = till.Cash - T.Amount_Entered;
_tillService.UpdateTill(till);
}
//Cash bonus out of scope
// track the cash bonus
//if (Policy_Renamed.Use_CashBonus)
//{
// if (T.Tender_Name.ToUpper() == modGlobalFunctions.Get_TenderName(System.Convert.ToString(Policy_Renamed.CBonusTend)).ToUpper())
// {
// rs = _dbService.GetRecords("Select * FROM Tills WHERE Tills.Till_Num = " + till.Number + " ", DataSource.CSCMaster, ADODB.CursorTypeEnum.adOpenForwardOnly);
// rs.Fields["CashBonus"].Value = rs.Fields["CashBonus"].Value - T.Amount_Entered;
// rs.Update();
// rs = null;
// }
//}
//Shiny end
}
_performancelog.Debug($"End,CashManager,AddDropLines,{DateTime.Now.Subtract(dateStart).TotalMilliseconds},{DateTime.Now:hh.mm.ss.ffffff}");
}
}
