/// <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}"); }