public static void setCSale(int sale_no, int product_no,
DateTime sale_date, string payment_method,
string empusname, int barcode)
{
Employee e = Employee.getEmployeebyUsName(empusname);
Product p = Product.getProductbyBarcode(barcode);
using (MngContext context = new MngContext())
{
CashSale m = new CashSale
{
sale_no = sale_no,
product_no = product_no,
barcode = barcode,
sale_date = sale_date,
payment_method = payment_method,
price = p.price,
unit_input_price = p.unit_input_price,
Employee = e,
};
context.CashSales.Add(m);
context.SaveChanges();
}
}
public static CashSale getCSalebydate(DateTime sale_date)
{
CashSale cSaleInfo;
using (var context = new MngContext())
{
cSaleInfo = context.CashSales.SqlQuery("Select * from CashSales where sale_date=@sldt", new SqlParameter("@sldt", sale_date)).FirstOrDefault <CashSale>();
}
return(cSaleInfo);
}
public static List <CashSale> getallCSale()
{
List <CashSale> cSaleInfo;
using (var context = new MngContext())
{
cSaleInfo = context.CashSales.SqlQuery("Select * from CashSales").ToList();
}
return(cSaleInfo);
}
public static CashSale getCSalebyNo(string sale_no)
{
CashSale cSaleInfo;
using (var context = new MngContext())
{
cSaleInfo = context.CashSales.SqlQuery("Select * from CashSales where sale_no=@sale", new SqlParameter("@sale", sale_no)).FirstOrDefault <CashSale>();
}
return(cSaleInfo);
}
