private void btnFilters_Click(object sender, EventArgs e)
{
Reports.Accountbooks.PurchaseRegister frmpurchaseregister = new PurchaseRegister();
frmpurchaseregister.StartPosition = FormStartPosition.CenterScreen;
frmpurchaseregister.ShowDialog(this);
//Reports.Accountbooks.Daybook frmdayBook = new Daybook();
//frmdayBook.ShowDialog();
//frmdayBook(this);
}
private void tlistAccountbook_MouseDown(object sender, MouseEventArgs e)
{
DevExpress.XtraTreeList.TreeListHitInfo hi = tlistAccountbook.CalcHitInfo(e.Location);
if (hi.HitInfoType == DevExpress.XtraTreeList.HitInfoType.Cell)
{
string selectedNode = hi.Node[Accountbooks].ToString();
switch (selectedNode)
{
case "Account Group Ledger":
Reports.Accountbooks.AccountGroupLedger frmAccGrp = new Reports.Accountbooks.AccountGroupLedger();
frmAccGrp.StartPosition = FormStartPosition.CenterParent;
frmAccGrp.ShowDialog();
break;
case "Account Ledger":
Reports.Accountbooks.AccountLedger frmAccLed = new Reports.Accountbooks.AccountLedger();
frmAccLed.ShowDialog();
break;
case "Bank Book":
Bankbook frmBook = new Bankbook();
frmBook.ShowDialog();
break;
case "Cash Book Single":
CashbookSingle frmCashbook = new CashbookSingle();
frmCashbook.ShowDialog();
break;
case "Day Book":
Daybook frmday = new Daybook();
frmday.ShowDialog();
break;
case "Payment Register":
PaymentRegister frmpay = new PaymentRegister();
frmpay.ShowDialog();
break;
case "Purchase Register":
PurchaseRegister frmpurc = new PurchaseRegister();
frmpurc.ShowDialog();
break;
case "Purchase Return Register":
PurchaseReturnRegister frmPurcre = new PurchaseReturnRegister();
frmPurcre.ShowDialog();
break;
case "Receipt Register":
RecepitRegister frmRece = new RecepitRegister();
frmRece.ShowDialog();
break;
case "Sales Register":
Saleregister frmsale = new Saleregister();
frmsale.ShowDialog();
break;
case "Sales Return Register":
SalesReturnRegister frmsaleret = new SalesReturnRegister();
frmsaleret.ShowDialog();
break;
case "Sub Ledger":
SubLedger frmsub = new SubLedger();
frmsub.ShowDialog();
break;
default:
break;
}
}
//string selectedNode = (sender as TreeList).FocusedNode.GetValue(0).ToString();
}
private void UpdatePurchaseRegister(Invoice invoice, string company, string dbShip,
DateTime fromDate, DateTime toDate)
{
try
{
using (var db = new eXmlContext())
{
foreach (var invItem in invoice.Items)
{
var purRecExists = db.Set <PurchaseRegister>()
.Where(x => x.Company == company && x.DbShip == dbShip)
.Where(x => x.InvoiceNo == invoice.InvoiceNo)
.Where(x => x.InvoiceType == invoice.InvoiceType)
.Where(x => x.ItemCode == invItem.ItemCode)
.Where(x => x.PaymentInstrument == invItem.PaymentInstrument)
.Where(x => x.OrdYearWk == invoice.OrdYearWk && x.InvYearWk == invoice.InvYearWk)
.FirstOrDefault();
if (purRecExists == null)
{
PurchaseRegister reg = new PurchaseRegister
{
Company = company,
DbShip = dbShip,
FromDate = fromDate,
ToDate = toDate,
ItemCode = invItem.ItemCode,
PaymentInstrument = invItem.PaymentInstrument,
ItemName = invItem.ItemName,
OrdYearWk = invoice.OrdYearWk,
InvoiceNo = invoice.InvoiceNo,
InvoiceType = invoice.InvoiceType,
InvoiceDate = invoice.InvoiceDate,
InvYearWk = invoice.InvYearWk,
Quantity = invItem.Quantity,
PriceWOTax = invItem.PriceWOTax,
VAT = invItem.VAT,
PriceInclVAT = invItem.PriceInclVAT
};
db.PurchaseRegister.Add(reg);
}
else
{
purRecExists.Company = company;
purRecExists.DbShip = dbShip;
purRecExists.FromDate = fromDate;
purRecExists.ToDate = toDate;
purRecExists.ItemCode = invItem.ItemCode;
purRecExists.PaymentInstrument = invItem.PaymentInstrument;
purRecExists.ItemName = invItem.ItemName;
purRecExists.OrdYearWk = invoice.OrdYearWk;
purRecExists.InvoiceNo = invoice.InvoiceNo;
purRecExists.InvoiceType = invoice.InvoiceType;
purRecExists.InvoiceDate = invoice.InvoiceDate;
purRecExists.InvYearWk = invoice.InvYearWk;
purRecExists.Quantity = invItem.Quantity;
purRecExists.PriceWOTax = invItem.PriceWOTax;
purRecExists.VAT = invItem.VAT;
purRecExists.PriceInclVAT = invItem.PriceInclVAT;
db.Entry(purRecExists).State = EntityState.Modified;
}
}
db.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
