public List <Purchaseinfo> SelectallPurchaseinfo() { try { List <Purchaseinfo> lstpiinfo = new List <Purchaseinfo>(); using (RMSDataContext db = new RMSDataContext()) { Purchaseinfo piinfo; var a = (from o in db.Purchases select o).ToList(); foreach (var obj in a) { piinfo = new Purchaseinfo(); piinfo.PurchaseID = obj.PurchaseID; piinfo.ProductID = obj.ProductID; piinfo.Quantity = obj.Quantity; piinfo.Supplier = obj.Supplier; piinfo.Purchase_Order_Date = obj.Purchase_Order_Date; piinfo.Last_Order_Date = obj.Last_Order_Date; lstpiinfo.Add(piinfo); } return(lstpiinfo); } } catch (Exception ex) { return(new List <Purchaseinfo>()); } }
public void InsertPurchase(Purchaseinfo pinfo) { using (RMSDataContext db = new RMSDataContext()) { Purchase tbl = new Purchase(); tbl.ProductID = pinfo.ProductID; tbl.Last_Order_Date = pinfo.Last_Order_Date; tbl.PurchaseID = pinfo.PurchaseID; tbl.Purchase_Order_Date = pinfo.Purchase_Order_Date; tbl.Quantity = pinfo.Quantity; tbl.Supplier = pinfo.Supplier; db.Purchases.InsertOnSubmit(tbl); db.SubmitChanges(); } }
public void DelectPurchaseByPurchesId(Purchaseinfo puinfo) { try { using (RMSDataContext db = new RMSDataContext()) { var pu = (from p in db.Purchases where p.PurchaseID == puinfo.PurchaseID select p).First(); db.Purchases.DeleteOnSubmit(pu); db.SubmitChanges(); } } catch (Exception ex) { Purchaseinfo p = new Purchaseinfo(); } }
public void UpdatePurchasebyPurchesId(Purchaseinfo puinfo) { try { using (RMSDataContext db = new RMSDataContext()) { var pu = (from p in db.Purchases where p.PurchaseID == puinfo.PurchaseID select p).First(); pu.PurchaseID = puinfo.PurchaseID; pu.Last_Order_Date = puinfo.Last_Order_Date; pu.ProductID = puinfo.ProductID; pu.Purchase_Order_Date = puinfo.Purchase_Order_Date; pu.Quantity = puinfo.Quantity; pu.Supplier = puinfo.Supplier; db.SubmitChanges(); } } catch (Exception ex) { Purchaseinfo p = new Purchaseinfo(); } }
public void DelectPurches(Purchaseinfo puinfo) { puDao.DelectPurchaseByPurchesId(puinfo); }
public void UpdatePurches(Purchaseinfo puinfo) { puDao.UpdatePurchasebyPurchesId(puinfo); }
public void InsertPurches(Purchaseinfo puinfo) { puDao.InsertPurchase(puinfo); }