/// <summary>
/// Write the receipt totals to the appropriate numeric up/down controls and text box controls
/// </summary>
private void WriteTotals()
{
communalTotal.Value = (decimal)CurrentReceipt.returnCommunalTotal();
aTotal.Value = (decimal)CurrentReceipt.returnATotal();
vTotal.Value = (decimal)CurrentReceipt.returnVTotal();
mTotal.Value = (decimal)CurrentReceipt.returnMTotal();
}
public void m_CurrentReceiptIntegration(DateTime vrCurrentReceiptDate, string vrCurrentReceiptType, int vrCurrentCustomerID, int vrDocumentNo, DateTime vrDocumentDate, double vrCurrentTotalAmount, string vrReceiptExchange, double vrCurrentTLAmount, string vrExplanation, int vrAccountingReceipt, string vrApplicationCode, string vrReceivableDebit)
{
//Create a currenct receipt record on selected ınvoice
StockTrackingDataContext = new L_StockTrackingERPDataContext();
CurrentReceipt currentReceipt = new CurrentReceipt();
currentReceipt.ReceiptDate = vrCurrentReceiptDate;
currentReceipt.ReceiptType = vrCurrentReceiptType;
currentReceipt.CustomerNo = vrCurrentCustomerID;
currentReceipt.DocumentNo = vrDocumentNo;
currentReceipt.DocumentDate = vrDocumentDate;
currentReceipt.TotalAmount = decimal.Parse(vrCurrentTotalAmount.ToString());
currentReceipt.ReceiptExchange = vrReceiptExchange;
currentReceipt.TLAmount = decimal.Parse(vrCurrentTLAmount.ToString());
currentReceipt.Explanation = vrExplanation;
currentReceipt.AccountingReceipt = vrAccountingReceipt;
currentReceipt.ApplicationCode = vrApplicationCode;
currentReceipt.ReceivableDebit = vrReceivableDebit;
StockTrackingDataContext.CurrentReceipts.InsertOnSubmit(currentReceipt);
StockTrackingDataContext.SubmitChanges();
//Find the last current receipt with customerId and ApplicationCode
StockTrackingDataContext = new L_StockTrackingERPDataContext();
var LastCurrentReceiptRecord = from vr_CurrentReceipt in StockTrackingDataContext.CurrentReceipts
where vr_CurrentReceipt.CustomerNo == vrCurrentCustomerID && vr_CurrentReceipt.ApplicationCode == "S"
orderby vr_CurrentReceipt.ReceiptNo descending
select vr_CurrentReceipt.ReceiptNo;
foreach (int item_LastCurrentReceipt in LastCurrentReceiptRecord)
{
vrLastCurrentReceiptRecord = item_LastCurrentReceipt;
}
//Update the CurrentReceiptNo for Invoice table
StockTrackingDataContext = new L_StockTrackingERPDataContext();
var UpdateInvoiceCurrentReceiptNo = StockTrackingDataContext.Invoices.Single(d_CurrentReceiptUpdate => d_CurrentReceiptUpdate.InvoiceNo == vrDocumentNo);
UpdateInvoiceCurrentReceiptNo.CurrentReceiptNo = vrLastCurrentReceiptRecord;
StockTrackingDataContext.SubmitChanges();
MessageBox.Show("Cari Entegrasyon İşlemi Gerçekleştirildi.", "Cari Entegrasyon", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public void m_CurrentReceiptAdd(DateTime vrCurrentReceiptDate, string vrCurrentReceiptType, int vrCurrentCustomerID, int vrDocumentNo, DateTime vrDocumentDate, double vrCurrentTotalAmount, string vrReceiptExchange, double vrCurrentTLAmount, string vrExplanation, string vrApplicationCode, string vrReceivableDebit)
{
StockTrackingDataContext = new L_StockTrackingERPDataContext();
CurrentReceipt currentReceipt = new CurrentReceipt();
currentReceipt.ReceiptDate = vrCurrentReceiptDate;
currentReceipt.ReceiptType = vrCurrentReceiptType;
currentReceipt.CustomerNo = vrCurrentCustomerID;
currentReceipt.DocumentNo = vrDocumentNo;
currentReceipt.DocumentDate = vrDocumentDate;
currentReceipt.TotalAmount = decimal.Parse(vrCurrentTotalAmount.ToString());
currentReceipt.ReceiptExchange = vrReceiptExchange;
currentReceipt.TLAmount = decimal.Parse(vrCurrentTLAmount.ToString());
currentReceipt.Explanation = vrExplanation;
currentReceipt.ApplicationCode = vrApplicationCode;
currentReceipt.ReceivableDebit = vrReceivableDebit;
StockTrackingDataContext.CurrentReceipts.InsertOnSubmit(currentReceipt);
StockTrackingDataContext.SubmitChanges();
m_AccountingReceiptAdd(vrCurrentReceiptDate, vrCurrentReceiptType, vrDocumentNo, vrDocumentDate, vrCurrentTotalAmount, vrReceiptExchange, vrCurrentTLAmount, vrExplanation, vrApplicationCode, vrReceivableDebit);
StockTrackingDataContext = new L_StockTrackingERPDataContext();
var LastAccountingReceiptRecord = StockTrackingDataContext.p_CurrentAccountingNo(vrCurrentCustomerID, "M");
vrLastAccountingReceiptRecord = LastAccountingReceiptRecord;
StockTrackingDataContext = new L_StockTrackingERPDataContext();
var LastCurrentReceiptRecord = StockTrackingDataContext.p_CurrentAccountingNo(vrCurrentCustomerID, "C");
vrLastCurrentReceiptRecord = LastCurrentReceiptRecord;
StockTrackingDataContext = new L_StockTrackingERPDataContext();
var UpdateCurrentAccounting = StockTrackingDataContext.CurrentReceipts.Single(d_CurrentReceiptUpdate => d_CurrentReceiptUpdate.ReceiptNo == vrLastCurrentReceiptRecord);
UpdateCurrentAccounting.AccountingReceipt = vrLastAccountingReceiptRecord;
StockTrackingDataContext.SubmitChanges();
MessageBox.Show("Cari Fiş Ekleme İşlemi Gerçekleştirildi.", "Cari Fiş Ekle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public void updateCurrentReceipt_Click(object sender, EventArgs e)
{
// Update the receipt with the values from the total text box fields
CurrentReceipt.changeCommunalTotal((double)communalTotal.Value);
CurrentReceipt.changeATotal((double)aTotal.Value);
CurrentReceipt.changeVTotal((double)vTotal.Value);
CurrentReceipt.changeMTotal((double)mTotal.Value);
if (currentReceiptComboBox.SelectedIndex == NextReceiptNumber - 2)
{
NewReceipt();
}
else
{
WriteTotals();
}
CurrentList.calculateTotals();
// Now to update the labels on the left of the interface that are keeping the running totals for the currently viewed receipt list.
WriteNumberToLabel(aCommunalTotal, CurrentList.returnCommunalTotal());
WriteNumberToLabel(aCommunalTotalPerPerson, CurrentList.returnCommunalTotal() / 3);
if (currentListOwner.SelectedItem.ToString() == "Andy")
{
WriteNumberToLabel(additAmountOwedTotal1, CurrentList.returnVListTotal());
WriteNumberToLabel(additAmountOwedTotal2, CurrentList.returnMListTotal());
}
else if (currentListOwner.SelectedItem.ToString() == "Vince")
{
WriteNumberToLabel(additAmountOwedTotal1, CurrentList.returnAListTotal());
WriteNumberToLabel(additAmountOwedTotal2, CurrentList.returnMListTotal());
}
else if (currentListOwner.SelectedItem.ToString() == "Mike")
{
WriteNumberToLabel(additAmountOwedTotal1, CurrentList.returnAListTotal());
WriteNumberToLabel(additAmountOwedTotal2, CurrentList.returnVListTotal());
}
}