public void RegisterPendingOrdr(Busy_tables _Tables, List <Pending_Orders> _Orders)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
using (DbContextTransaction transaction = en.Database.BeginTransaction())
{
try
{
en.Busy_tables.Add(_Tables);
en.SaveChanges();
foreach (Pending_Orders itemOrder in _Orders)
{
en.Pending_Orders.Add(itemOrder);
}
en.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
}
}
}
public void RegisterPofMerch(purchase_of_merchandise purchase, Merchandise merchandise)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
using (DbContextTransaction transaction = en.Database.BeginTransaction())
{
try
{
var merch_bd = en.Merchandise.First(x => x.Id == merchandise.Id);
merch_bd.Stock = merchandise.Stock;
en.SaveChanges();
en.purchase_of_merchandise.Add(purchase);
en.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
}
//en.SP_PurchaseMerchandise(detail, amount, datePurchase, qty, idMerch, idSuppl,idUser);
}
}
public void RegisterSupplier(String nameSuppl, String addrs, String city, String phone)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
en.SP_AddSupplier(nameSuppl, addrs, city, phone);
}
}
public void RegisterProduct(String nameProduct, int price, int idCategory)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
en.SP_AddProduct(nameProduct, price, idCategory);
}
}
public void PaymentPayroll(Paysheet paysheet)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
en.Paysheet.Add(paysheet);
en.SaveChanges();
}
}
public void RegisterLoan(Mov_CxC_Employees mov_CxC)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
en.Mov_CxC_Employees.Add(mov_CxC);
en.SaveChanges();
}
}
public void RegisterEmployee(Employees employees)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
en.Employees.Add(employees);
en.SaveChanges();
}
}
public void RegisterUserLogin(Login_FT objuser)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
en.Login_FT.Add(objuser);
en.SaveChanges();
}
}
public List <Employees> GetEmployeeList()
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = from p in en.Employees
select p;
return(query.ToList());
}
}
public Product GetProductDetail(Product product)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = en.Product.FirstOrDefault(p => p.Id == product.Id);
return(query);
}
}
public Mov_CxC_Employees GetMov(int idEmployee)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = en.Mov_CxC_Employees.FirstOrDefault(m => m.Id_employee == idEmployee && m.Transaction_type == 1);
return(query);
}
}
public List <Expiry_of_mode> GetTypeCredit()
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = from t in en.Expiry_of_mode
select t;
return(query.ToList());
}
}
public void RegisterMerch(Merchandise merchandise)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
//en.SP_AddMerchandise(nameMerch, stock);
en.Merchandise.Add(merchandise);
en.SaveChanges();
}
}
public Login_FT GetLoginsDetail(Login_FT login_FT)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = en.Login_FT.FirstOrDefault(x => x.Id == login_FT.Id);
return(query);
}
}
public int NofPOrder()
{
int cantOrder = 0;
using (var en = new DB_SystemFoodTrucksEntities())
{
cantOrder = en.Busy_tables.Count();
}
return(cantOrder);
}
public void UpdateEmployee(Employees employees_)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var employee_bd = en.Employees.FirstOrDefault(x => x.Id == employees_.Id);
en.Entry(employee_bd).State = EntityState.Modified;
en.Entry(employee_bd).CurrentValues.SetValues(employees_);
en.SaveChanges();
}
}
public void UpdateUser(Login_FT login_)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var userLogin_bd = en.Login_FT.FirstOrDefault(x => x.Id == login_.Id);
en.Entry(userLogin_bd).State = EntityState.Modified;
en.Entry(userLogin_bd).CurrentValues.SetValues(login_);
en.SaveChanges();
}
}
public void UpdateMerch(Merchandise merchandise_)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var merch_bd = en.Merchandise.FirstOrDefault(x => x.Id == merchandise_.Id);
en.Entry(merch_bd).State = EntityState.Modified;
en.Entry(merch_bd).CurrentValues.SetValues(merchandise_);
en.SaveChanges();
}
}
public void UpdateProduct(Product product)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var product_bd = en.Product.FirstOrDefault(p => p.Id == product.Id);
en.Entry(product_bd).State = EntityState.Modified;
en.Entry(product_bd).CurrentValues.SetValues(product);
en.SaveChanges();
}
}
public void RegisterPendingOrdr2(List <Pending_Orders> _Orders)
{
using (var en = new DB_SystemFoodTrucksEntities())
{
foreach (Pending_Orders itemOrder in _Orders)
{
en.Pending_Orders.Add(itemOrder);
}
en.SaveChanges();
}
}
public List <Categorias> GetCategorias()
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = from p in en.Category
select new Categorias()
{
Nombre = p.Name
};
return(query.ToList());
}
}
public List <GetDepartments> GetDepartmentsList()
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = from p in en.Departments
select new GetDepartments()
{
DepartName = p.Depart_name
};
return(query.ToList());
}
}
public List <GetProduct> GetProductList()
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = from p in en.Product
select new GetProduct()
{
Name = p.Name_product
};
return(query.ToList());
}
}
public List <GetMerch> GerMerchList()
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = from p in en.Merchandise
select new GetMerch()
{
Id = p.Id, Name = p.Name, Stock = p.Stock
};
return(query.ToList());
}
}
public List <GetLocation> GetLocationsList()
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = from p in en.Location
select new GetLocation()
{
Name = p.nameLocation
};
return(query.ToList());
}
}
public List <GetSupplier> GetSupplierList()
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = from p in en.Supplier
select new GetSupplier()
{
Name = p.Supplier1
};
return(query.ToList());
}
}
public List <GetRoles> GetRoleList()
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = from p in en.Roles_Account
select new GetRoles()
{
Roles = p.Role_name
};
return(query.ToList());
}
}
public List <GetStatusAcc> GetStatusAccList()
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = from p in en.Status_Account
select new GetStatusAcc()
{
StatusName = p.Status
};
return(query.ToList());
}
}
public List <GetMerchandise> GetMerchandiseList()
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = from p in en.Merchandise
select new GetMerchandise()
{
Name = p.Name
};
return(query.ToList());
}
}
public List <GetPaysheetMode> GetPaysheetModeList()
{
using (var en = new DB_SystemFoodTrucksEntities())
{
var query = from p in en.PaysheetModePay
select new GetPaysheetMode()
{
PaysheetModeName = p.PayMode
};
return(query.ToList());
}
}
