public SupplierPayData PaymentDetails(int month, int year, int vid) { SupplierPayData sinfo = new SupplierPayData(); DatabaseClass ctx = new DatabaseClass(); FeedSupplierPayment f = new FeedSupplierPayment(); f.Year = year; f.Month = month; f.TotalAmount = ctx.FeedTransactions.Where(d => (int?)d.FeedTransDate.Month == month && (int?)d.VendorId == vid).Select(d => d.ItemAmount).Sum(); f.VendorId = vid; ctx.FeedSupplierPayments.Add(f); ctx.SaveChanges(); return(sinfo); }
public AddFeedData FeedDetails(string name, int price, string description, int stock) { AddFeedData finfo = new AddFeedData(); DatabaseClass ctx = new DatabaseClass(); FeedItem f = new FeedItem(); f.ItemName = name; f.ItemPrice = price; f.ItemDescription = description; f.ItemStock = stock; ctx.FeedItems.Add(f); ctx.SaveChanges(); return(finfo); }
public AddVendorData VendorDetails(string username, string password, string address) { AddVendorData vinfo = new AddVendorData(); DatabaseClass ctx = new DatabaseClass(); Login l = new Login(); l.UserName = username; l.Password = password; l.Role = "Vendor"; l.Address = address; ctx.Logins.Add(l); ctx.SaveChanges(); return(vinfo); }
public MilkDailyData MilkData(int userid, int quantity, int fatpercid, string time, DateTime date) { MilkDailyData minfo = new MilkDailyData(); DatabaseClass ctx = new DatabaseClass(); Product p = new Product(); p.VendorUid = userid; p.MilkQuantity = quantity; p.Time = time; p.Date = date; p.FatPercentId = fatpercid; var r = ctx.PriceMaintains.Where(e => e.PriceId == fatpercid).Select(e => e.PriceperLit).FirstOrDefault(); p.Price = r * quantity; ctx.Products.Add(p); ctx.SaveChanges(); return(minfo); }
public AddFeedTransData TransDetails(int itemid, int qty, DateTime date, int vid) { AddFeedTransData tinfo = new AddFeedTransData(); DatabaseClass ctx = new DatabaseClass(); FeedTransaction t = new FeedTransaction(); t.ItemName = ctx.FeedItems.Where(l => l.FeedItemId == itemid).Select(l => l.ItemName).FirstOrDefault(); t.ItemQuantity = qty; t.FeedTransDate = date; t.ItemId = itemid; var r = ctx.FeedItems.Where(e => e.FeedItemId == itemid).Select(e => e.ItemPrice).FirstOrDefault(); t.ItemAmount = r * qty; //t.ItemAmount = amount; t.VendorId = vid; ctx.FeedTransactions.Add(t); ctx.SaveChanges(); return(tinfo); }
public ManagerPaytoVendData VendorPayDetails(int month, int year, int vid) { ManagerPaytoVendData dinfo = new ManagerPaytoVendData(); DatabaseClass ctx = new DatabaseClass(); VendorPayment v = new VendorPayment(); v.Year = year; v.Month = month; double ma = ctx.Products.Where(e => (int?)e.Date.Month == month && (int?)e.VendorUid == vid).Select(e => e.Price).Sum(); v.MilkAmount = ma; double fa = ctx.FeedTransactions.Where(d => (int?)d.FeedTransDate.Month == month && (int?)d.VendorId == vid).Select(d => d.ItemAmount).Sum(); v.FeedAmount = fa; v.GrossAmount = ma - fa; v.VendorId = vid; ctx.VenderPayments.Add(v); ctx.SaveChanges(); return(dinfo); }