/// <summary>
/// Method to add drop header
/// </summary>
/// <param name="dropHeader">Drop header</param>
public void AddDropHeader(DropHeader dropHeader)
{
_connection = new SqlConnection(GetConnectionString(DataSource.CSCTills));
if (_connection.State == ConnectionState.Closed)
{
_connection.Open();
}
_dataTable = new DataTable();
_adapter = new SqlDataAdapter("select * from DropHeader", _connection);
_adapter.Fill(_dataTable);
var fields = _dataTable.NewRow();
fields["DropDate"] = dropHeader.DropDate;
fields["User"] = dropHeader.UserCode;
fields["Till_Num"] = dropHeader.TillNumber;
fields["DropCount"] = dropHeader.DropCount;
fields["shiftid"] = dropHeader.ShiftId;
fields["ShiftDate"] = dropHeader.ShiftDate;
if (!string.IsNullOrEmpty(dropHeader.EnvelopeNo))
{
fields["EnvelopeNo"] = dropHeader.EnvelopeNo;
}
fields["ReasonCode"] = dropHeader.ReasonCode;
fields["DropID"] = dropHeader.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 drop header
/// </summary>
/// <param name="tillNumber">Till number</param>
/// <param name="userCode">User code</param>
/// <param name="till">Till</param>
/// <param name="dropDate">Drop date</param>
/// <param name="cntDrop">Drop count</param>
/// <param name="cashDrop">Cash drop</param>
private void AddDropHeader(int tillNumber, string userCode, Till till, DateTime dropDate, short cntDrop,
CashDrop cashDrop)
{
var dateStart = DateTime.Now;
_performancelog.Debug($"Start,CashManager,AddDropHeader,{string.Empty},{dateStart:hh.mm.ss.ffffff}");
var dropHeader = new DropHeader
{
DropDate = dropDate,
UserCode = userCode.ToUpper(),
TillNumber = tillNumber,
DropCount = cntDrop,
ShiftId = till.Shift,
ShiftDate = till.ShiftDate,
EnvelopeNo = cashDrop.Envelope_No,
ReasonCode = string.IsNullOrEmpty(cashDrop.ReasonCode) ? "SAFE" : cashDrop.ReasonCode, //
DropId = cashDrop.DropID
};
_cashService.AddDropHeader(dropHeader);
_performancelog.Debug($"End,CashManager,AddDropHeader,{DateTime.Now.Subtract(dateStart).TotalMilliseconds},{DateTime.Now:hh.mm.ss.ffffff}");
}
