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);
}
}
