private void ucPurchaseProduct_Loaded(object sender, RoutedEventArgs e)
{
if (CONTROLLER == null)
{
CONTROLLER = new HCSController();
}
purchaseProduct = new purchaseproduct() { date= DateTime.Now , isenglishvisible=CONTROLLER.ISENGLISHVISIBLE,isurduvisible=CONTROLLER.ISURDUVISIBLE };
this.grdPurchaseProduct.DataContext = purchaseProduct;
this.grdModel.DataContext = purchaseProduct;
bindProducts();
bindSellerType();
bindPurchasers();
bindPurchaserType();
bindBank();
}
public void saveProductPurchased(purchaseproduct purchasedPorduct)
{
db.purchaseproducts.Add(purchasedPorduct);
db.SaveChanges();
}
private void resetAfterSave()
{
purchaseProduct = new purchaseproduct() { date = DateTime.Now, isenglishvisible = CONTROLLER.ISENGLISHVISIBLE, isurduvisible = CONTROLLER.ISURDUVISIBLE };
this.grdPurchaseProduct.DataContext = purchaseProduct;
}
public void saveSellerPayment(purchaseproduct payment)
{
payment.date = DateTime.Now;
SellerTotalPayable sellerPayment = dbContext.SellerTotalPayables.Where(p => p.seller_cde== payment.seller_cde && p.sellerid==payment.sellerid).FirstOrDefault();
sellerPayment.totalpayable = payment.totalpayable;
sellerPayment.totalreceivable += payment.totalreceivable;
payment.totalreceivable = (int) sellerPayment.totalreceivable;
var entry = dbContext.Entry<SellerTotalPayable>(sellerPayment);
if (entry.State.Equals(EntityState.Detached))
{
dbContext.SellerTotalPayables.Attach(sellerPayment);
}
entry.State = EntityState.Modified;
dbContext.purchaseproducts.Add(payment);
dbContext.SaveChanges();
}
public void saveProductPurchased(purchaseproduct purchasedPorduct)
{
#region commented handling sellertotal receivable table
/*
SellerTotalPayable totalPayables = dbContext.SellerTotalPayables.Where(p => p.sellerid == purchasedPorduct.sellerid).FirstOrDefault();
if (totalPayables != null)
{
if(totalPayables.totalreceivable>0)
{
if(totalPayables.totalreceivable>purchasedPorduct.payableprice)
{
totalPayables.totalreceivable -= (int)purchasedPorduct.payableprice;
totalPayables.totalpayable = 0;
purchasedPorduct.totalpayable = 0;
purchasedPorduct.totalreceivable = (int) totalPayables.totalreceivable;
}
else
{
purchasedPorduct.totalpayable =purchasedPorduct.payableprice- totalPayables.totalreceivable;
purchasedPorduct.totalreceivable = 0;
totalPayables.totalreceivable = 0;
totalPayables.totalpayable = purchasedPorduct.totalpayable;
}
}
else
{
purchasedPorduct.totalpayable = totalPayables.totalpayable + purchasedPorduct.payableprice;
totalPayables.totalpayable = purchasedPorduct.totalpayable;
}
var entry = dbContext.Entry<SellerTotalPayable>(totalPayables);
if (entry.State.Equals(EntityState.Detached))
{
dbContext.SellerTotalPayables.Attach(totalPayables);
}
entry.State = EntityState.Modified;
}
else
{
totalPayables = new SellerTotalPayable();
purchasedPorduct.totalpayable = purchasedPorduct.payableprice;
totalPayables.seller_cde = purchasedPorduct.seller_cde;
totalPayables.sellerid = purchasedPorduct.sellerid;
totalPayables.totalpayable = purchasedPorduct.totalpayable;
dbContext.SellerTotalPayables.Add(totalPayables);
}*/
#endregion
//saving in PurchaseProduct table
dbContext.purchaseproducts.Add(purchasedPorduct);
dbContext.SaveChanges();
#region Khata
var result = from n in dbContext.Khatas where n.bpid == purchasedPorduct.purchaserid select n;
//now putting entries in KHATA table for purchaser(e.g ans) khata
Khata kh = new Khata()
{
entrycode = "p",//indicates purchaser record
purchaseproductid = purchasedPorduct.seqid,
saleproductid = 0,
activitycode = ActivityType.Purchase.GetStringValue(),
date = System.DateTime.Now,
productid = purchasedPorduct.productid,
bpid = purchasedPorduct.purchaserid,
sellertypecode = purchasedPorduct.seller_cde,
payable_naam = purchasedPorduct.price,
receivable_jama = 0,
purchasertypecode = purchasedPorduct.purchaser_cde,
totalpayable_naam = (result != null && result.Count() > 0) ? result.Sum(p => p.payable_naam) + purchasedPorduct.price : purchasedPorduct.price,
totalreceivable_jama = (result != null && result.Count() > 0) ? result.Sum(p => p.receivable_jama) : 0
};
dbContext.Khatas.Add(kh);
//now putting entries in KHATA table for seller(e.g Kissaan) khata
result = from n in dbContext.Khatas where n.bpid == purchasedPorduct.sellerid select n;
kh = new Khata()
{
entrycode = "s",//indicates seller record
purchaseproductid = purchasedPorduct.seqid,
saleproductid = 0,
activitycode = ActivityType.Purchase.GetStringValue(),
date = System.DateTime.Now,
productid = purchasedPorduct.productid,
bpid = purchasedPorduct.sellerid,
sellertypecode = purchasedPorduct.seller_cde,
payable_naam = 0,
receivable_jama = purchasedPorduct.payableprice,
purchasertypecode = purchasedPorduct.purchaser_cde,
totalpayable_naam = (result != null && result.Count() > 0) ? result.Sum(p => p.payable_naam) : 0,
totalreceivable_jama = (result != null && result.Count() > 0) ? result.Sum(p => p.receivable_jama) + purchasedPorduct.payableprice : purchasedPorduct.payableprice
};
dbContext.Khatas.Add(kh);
#endregion
#region Other Khata
//Now adding in otherKhata table for labor commission etc.
//here collecting information about labour khata so as to calculate previous values of naam and jama
string khatatypecode = KhataType.Labour.GetStringValue();
var resultOtherKhata = from n in dbContext.OtherKhatas where n.khatatypecde == khatatypecode select n;//activity code indicates it is khata agains purchase
if (purchasedPorduct.selectedProduct.producttype != ProductType.Cash.GetStringValue()&& purchasedPorduct.selectedProduct.producttype != ProductType.cheque.GetStringValue())//there will be no other khata in case of cash.
{
OtherKhata ok = new OtherKhata()
{
purchaseproductid = purchasedPorduct.seqid,
saleproductid = 0,
khatatypecde = KhataType.Labour.GetStringValue(),
date = System.DateTime.Now,
receivable_jama = purchasedPorduct.labour,
payable_naam = 0,
productname = purchasedPorduct.productname,
weight = purchasedPorduct.totalweight,
activitycode = ActivityType.Purchase.GetStringValue(),
purchaserid = purchasedPorduct.purchaserid,
sellerid = purchasedPorduct.sellerid,
sellertypecode = purchasedPorduct.seller_cde,
purchasertypecode = purchasedPorduct.purchaser_cde,
totalpayable_naam = (resultOtherKhata!= null && resultOtherKhata.Count() > 0) ? resultOtherKhata.Sum(p => p.payable_naam) + purchasedPorduct.price : purchasedPorduct.price,
totalreceivable_jama = (resultOtherKhata != null && resultOtherKhata.Count() > 0) ? resultOtherKhata.Sum(p => p.receivable_jama) : 0
};
dbContext.OtherKhatas.Add(ok);
if (purchasedPorduct.seller_cde != "00002")//if purchasing from commission shop then no commission to be entered
{
//here collecting information about commission khata so as to calculate previous values of naam and jama
khatatypecode = KhataType.Commission.GetStringValue();
resultOtherKhata = from n in dbContext.OtherKhatas where n.khatatypecde == khatatypecode select n;//activity code indicates it is khata agains purchase
ok = new OtherKhata()
{
purchaseproductid = purchasedPorduct.seqid,
saleproductid = 0,
khatatypecde = KhataType.Commission.GetStringValue(),
date = System.DateTime.Now,
receivable_jama = purchasedPorduct.commissionamt,
payable_naam = 0,
productname = purchasedPorduct.productname,
weight = purchasedPorduct.totalweight,
activitycode = ActivityType.Purchase.GetStringValue(),
purchaserid = purchasedPorduct.purchaserid,
sellerid = purchasedPorduct.sellerid,
sellertypecode = purchasedPorduct.seller_cde,
purchasertypecode = purchasedPorduct.purchaser_cde,
totalpayable_naam = (resultOtherKhata != null && resultOtherKhata.Count() > 0) ? resultOtherKhata.Sum(p => p.payable_naam) : 0,
totalreceivable_jama = (resultOtherKhata != null && resultOtherKhata.Count() > 0) ? resultOtherKhata.Sum(p => p.receivable_jama) + purchasedPorduct.payableprice : purchasedPorduct.payableprice
};
dbContext.OtherKhatas.Add(ok);
}
}
#endregion
dbContext.SaveChanges();
}
public winPurchaserReportViewer(purchaseproduct product,bool isurduvisible)
{
InitializeComponent();
m_isurduvisible = isurduvisible;
ProductPurchased = product;
}
