private void Fill()
{
DocumentPaymentsLogic payments = new DocumentPaymentsLogic(manager);
DataGV.AutoGenerateColumns = false;
ListToDataTable listToDataTable = new ListToDataTable();
List <ViewPayment> paymentsList = new List <ViewPayment>();
if (documentId == null)
{
paymentsList = payments.GetAllViewByPeriod(StartDateDTP.Value, EndDateDTP.Value);
}
else
{
paymentsList = payments.GetAllViewByDocumentID(Convert.ToInt32(documentId));
StartDateDTP.Enabled = false;
EndDateDTP.Enabled = false;
}
DataGV.DataSource = listToDataTable.ToDataTable <ViewPayment>(paymentsList);
DgvFilterManager filterManager = new DgvFilterManager(DataGV);
DataGV.Update();
SummaryDataGV.AutoGenerateColumns = true;
var groupResult = from p in paymentsList
group p by new { p.FullEmployeeName, p.PaymentTypeName }
into myGroup
where myGroup.Count() > 0
select new { myGroup.Key.FullEmployeeName, myGroup.Key.PaymentTypeName, Count = myGroup.Count(), Suma = myGroup.Sum(a => a.Suma) };
SummaryDataGV.DataSource = groupResult.ToList();
SummaryDataGV.Update();
}
private void Fill()
{
DocumentPaymentsLogic payments = new DocumentPaymentsLogic(manager);
DataGV.AutoGenerateColumns = false;
ListToDataTable listToDataTable = new ListToDataTable();
List<ViewPayment> paymentsList = new List<ViewPayment>();
if (documentId == null)
paymentsList = payments.GetAllViewByPeriod(StartDateDTP.Value, EndDateDTP.Value);
else
{
paymentsList = payments.GetAllViewByDocumentID(Convert.ToInt32(documentId));
StartDateDTP.Enabled = false;
EndDateDTP.Enabled = false;
}
DataGV.DataSource = listToDataTable.ToDataTable<ViewPayment>(paymentsList);
DgvFilterManager filterManager = new DgvFilterManager(DataGV);
DataGV.Update();
SummaryDataGV.AutoGenerateColumns = true;
var groupResult = from p in paymentsList
group p by new { p.FullEmployeeName, p.PaymentTypeName }
into myGroup
where myGroup.Count() > 0
select new { myGroup.Key.FullEmployeeName, myGroup.Key.PaymentTypeName, Count = myGroup.Count(), Suma = myGroup.Sum(a => a.Suma) };
SummaryDataGV.DataSource = groupResult.ToList();
SummaryDataGV.Update();
}
private void DeleteSB_Click(object sender, EventArgs e)
{
DocumentPaymentsLogic brands = new DocumentPaymentsLogic(manager);
brands.CancelPayment(Convert.ToInt32(DataGV.SelectedRows[0].Cells["ID"].Value));
manager.Save();
Fill();
}
private void DeleteSB_Click(object sender, EventArgs e)
{
DocumentPaymentsLogic brands = new DocumentPaymentsLogic(manager);
brands.CancelPayment(Convert.ToInt32(DataGV.SelectedRows[0].Cells["ID"].Value));
manager.Save();
Fill();
}
/// <summary>
/// Оплати по документу
/// </summary>
private void FillPayments()
{
DocumentPaymentsLogic paymentsLogic = new DocumentPaymentsLogic(manager);
if (id != null)
{
PaymentSumaL.Text = paymentsLogic.GetSumByDocumentID(Convert.ToInt32(id)).ToString("n2");
}
}
private void SaveBt_Click(object sender, EventArgs e)
{
//виводимо квитанцію на фіскальний принтер
List <WareDocumentDetail> details = (from a in document.WareDocumentDetails
select a).ToList();
if (cashRegister != null)
{
cashRegister.StartCheck();
foreach (var detail in details)
{
cashRegister.AddCheckPosition(detail.WareID, Convert.ToDecimal(detail.PriceForUnit), detail.UnitQuantity, detail.Ware.Name);
}
cashRegister.AddPayment(Convert.ToDecimal(PaySumaL.Text));
cashRegister.EndCheck();
}
else
{
MessageBox.Show("Фіскальний принтер не підключено");
}
//зберігаємо дані про оплату в БД
int?cardId = null;
if (CardTB.Text.Length > 0)
{
CardsLogic cardsLogic = new CardsLogic(manager);
WareCard card = cardsLogic.GetByCode(CardTB.Text);
if (card != null)
{
cardId = card.ID;
}
}
DocumentPaymentsLogic paymentsLogic = new DocumentPaymentsLogic(manager);
paymentsLogic.Create(DateTime.Now,
Convert.ToDecimal(PaySumaL.Text),
true, documentId,
Convert.ToInt32(document.CurrencyID),
Convert.ToInt32(StructureObjectsLUE.EditValue),
Convert.ToInt32(PaymentTypesLUE.EditValue),
cardId,
CheckNumberTB.Text);
manager.Save();
this.Close();
}
/// <summary>
/// Оплати по документу
/// </summary>
private void FillPayments()
{
DocumentPaymentsLogic paymentsLogic = new DocumentPaymentsLogic(manager);
if (id != null)
{
PaymentSumaL.Text = paymentsLogic.GetSumByDocumentID(Convert.ToInt32(id)).ToString("n2");
}
}
private void SaveBt_Click(object sender, EventArgs e)
{
//виводимо квитанцію на фіскальний принтер
List<WareDocumentDetail> details = (from a in document.WareDocumentDetails
select a).ToList();
if (cashRegister != null)
{
cashRegister.StartCheck();
foreach (var detail in details)
{
cashRegister.AddCheckPosition(detail.WareID, Convert.ToDecimal(detail.PriceForUnit), detail.UnitQuantity, detail.Ware.Name);
}
cashRegister.AddPayment(Convert.ToDecimal(PaySumaL.Text));
cashRegister.EndCheck();
}
else
MessageBox.Show("Фіскальний принтер не підключено");
//зберігаємо дані про оплату в БД
int? cardId = null;
if (CardTB.Text.Length > 0)
{
CardsLogic cardsLogic = new CardsLogic(manager);
WareCard card = cardsLogic.GetByCode(CardTB.Text);
if (card != null)
cardId = card.ID;
}
DocumentPaymentsLogic paymentsLogic = new DocumentPaymentsLogic(manager);
paymentsLogic.Create(DateTime.Now,
Convert.ToDecimal(PaySumaL.Text),
true, documentId,
Convert.ToInt32(document.CurrencyID),
Convert.ToInt32(StructureObjectsLUE.EditValue),
Convert.ToInt32(PaymentTypesLUE.EditValue),
cardId,
CheckNumberTB.Text);
manager.Save();
this.Close();
}