public List <ReceiptHeader> Search(string t) { try { using BillingContext context = new BillingContext(); return(context.ReceiptHeaders.Where(c => c.Date.Contains(t) || c.Time.Contains(t) || c.Employee.Contains(t) || c.CheckNo.Contains(t) || c.ReceiptNo.ToString() == t || c.TotalDiscount.ToString() == t || c.SubTotal.ToString() == t || c.NetTotal.ToString() == t || c.PaidAmount.ToString() == t || c.DueAmount.ToString() == t || c.Status.ToString() == t || c.IsQuotation.ToString() == t || c.IsPaid.ToString() == t).ToList()); } catch (Exception ex) { Exc.ErMessage(ex); return(null); } }
public int Create(ReceiptBody t) { int result = 0; try { //Initiate the instance of DBContext using BillingContext context = new BillingContext(); //check specific record for same ReceiptNo is exist or not var receipt = context.ReceiptBodies.FirstOrDefault(c => c.ReceiptNo == t.ReceiptNo); if (receipt == null) { //adding receiptbody object to context context.Add(t); //save changes return(result = context.SaveChanges()); } else { context.Update(t); return(result = context.SaveChanges()); } } catch (Exception ex) { Exc.ErMessage(ex); return(result = 0); } }
public int Create(Customer t) { int result = 0; try { //Initiate the instance of DBContext using BillingContext context = new BillingContext(); //check specific record for same Customer id is exist or not var cust = context.Customers.FirstOrDefault(c => c.CustomerId == t.CustomerId); if (cust == null) { //adding Customer object to context context.Add(t); //save changes return(result = context.SaveChanges()); } else { return(Update(t)); } } catch (Exception ex) { Exc.ErMessage(ex); return(result = 0); } }
public List <ReceiptBody> View() { try { using BillingContext context = new BillingContext(); return(context.ReceiptBodies.ToList()); } catch (Exception ex) { Exc.ErMessage(ex); return(null); } }
public List <Customer> View() { try { using BillingContext context = new BillingContext(); return(context.Customers.ToList()); } catch (Exception ex) { Exc.ErMessage(ex); return(null); } }
public List <Employee> View() { try { using BillingContext context = new BillingContext(); return(context.Employees.ToList()); } catch (Exception ex) { Exc.ErMessage(ex); return(null); } }
public int Update(ReceiptBody t) { int result = 0; try { using BillingContext context = new BillingContext(); context.Update(t); return(result = context.SaveChanges()); } catch (Exception ex) { Exc.ErMessage(ex); return(result); } }
public int Delete(ReceiptHeader t) { int result = 0; try { using BillingContext context = new BillingContext(); context.ReceiptHeaders.Remove(t); return(result = context.SaveChanges()); } catch (Exception ex) { Exc.ErMessage(ex); return(result); } }
public List <Customer> Search(string t) { try { using BillingContext context = new BillingContext(); return(context.Customers.Where(c => c.CustomerName.Contains(t) || c.Email.Contains(t) || c.Address.Contains(t) || c.Contact.Contains(t) || c.CustomerId.ToString() == t).ToList()); } catch (Exception ex) { Exc.ErMessage(ex); return(null); } }
public List <ReceiptBody> Search(string t) { try { using BillingContext context = new BillingContext(); return(context.ReceiptBodies.Where(c => c.ProductCode.Contains(t) || c.UnitPrice.Contains(t) || c.Quantity.Contains(t) || c.Discount.Contains(t) || c.SubTotal.Contains(t) || c.NetTotal.Contains(t) || c.ReceiptNo.ToString() == t).ToList()); } catch (Exception ex) { Exc.ErMessage(ex); return(null); } }