public void InsertRecord(SaleReceipt sale)
{
using (var db = new MotorcycleShopsEntities())
{
db.SaleReceipts.Add(sale);
db.SaveChanges();
}
}
public List <Employee> GetAllItems()
{
List <Employee> result = null;
using (var db = new MotorcycleShopsEntities())
{
result = db.Employees.ToList();
}
return(result);
}
public Employee GetEmployeeByID(long ID)
{
Employee employee = null;
using (var db = new MotorcycleShopsEntities())
{
employee = db.Employees.FirstOrDefault(e => e.ID == ID);
}
return(employee);
}
public long Insert(BillEmployee billEmp)
{
long id = 1;
using (var db = new MotorcycleShopsEntities())
{
db.BillEmployees.Add(billEmp);
db.SaveChanges();
}
return(id);
}
public long Insert(BillDetail bd)
{
long id = 1;
using (var db = new MotorcycleShopsEntities())
{
db.BillDetails.Add(bd);
db.SaveChanges();
id = bd.ID;
}
return(id);
}
public long Insert(MaintenanceBill bill)
{
long id = 1;
using (var db = new MotorcycleShopsEntities())
{
db.MaintenanceBills.Add(bill);
db.SaveChanges();
id = bill.ID;
}
return(id);
}
public List <QuotationTable> GetAllItems()
{
List <QuotationTable> result = null;
using (var db = new MotorcycleShopsEntities())
{
var list = db.QuotationTables.ToList();
result = new List <QuotationTable>(list);
}
return(result);
}
public TransactionResult CreateNewSaleReceipt(string phone, Bike bike)
{
var cashier = AccountInformation.GetInstance().CurrentAccount.Employee;
var result = new TransactionResult();
using (var db = new MotorcycleShopsEntities())
{
var success = new ObjectParameter("Success", typeof(bool));
var error = new ObjectParameter("Error", typeof(string));
db.NEW_SALE_TRANSACTION(phone, bike.EngineNumber, bike.ChassisNumber, cashier.ID, DateTime.Now, cashier.StoreID, success, error);
result.Success = success.Value != DBNull.Value ? (bool)success.Value : true;
result.Error = error.Value != DBNull.Value ? (string)error.Value : "";
}
return(result);
}
public TransactionResult InsertCustomer(Customer cus)
{
var result = new TransactionResult(true, "");
using (var db = new MotorcycleShopsEntities())
{
var success = new ObjectParameter("Success", typeof(bool));
var error = new ObjectParameter("Error", typeof(string));
var id = new ObjectParameter("CurrentIdentity", typeof(long));
db.INSERT_CUSTOMER(cus.Name, cus.DOB, cus.Address, cus.PhoneNumber, cus.Email, id, success, error);
result.Success = success.Value != DBNull.Value ? (bool)success.Value : true;
//if (!result.Success)
//{
result.Error = error.Value != DBNull.Value ? (string)error.Value : "";
result.CurrentIdentity = error.Value != DBNull.Value ? (long)id.Value : 1;
//}
}
return(result);
}
