public int InsertEmpoyee(Employee employee)
{
// Employee employee = new Employee();
db.Employees.Add(employee);
db.SaveChanges();
return(employee.ID);
}
public void DeleteComment(Comment cm)
{
Comment cmDL = db.Comments.Find(cm.ID);
if (cmDL != null)
{
db.Comments.Remove(cmDL);
db.SaveChanges();
}
}
public int InsertProductImage(int?ProdutsID, string URLImage)
{
ProductImage p = new ProductImage();
p.ProdutsID = ProdutsID;
p.URLImage = URLImage;
db.ProductImages.Add(p);
db.SaveChanges();
return(p.ID);
}
public int InsertCategory(string name, int?position, string description, bool?Active)
{
Category cate = new Category();
cate.Name = name;
cate.Position = position;
cate.Descriptions = description;
cate.Actives = Active;
db.Categories.Add(cate);
db.SaveChanges();
return(cate.ID);
}
public int InsertProduct(string NameProduct, string FullNameProduct, int?Qty, int?Price, bool?News, bool?Sale,
int?PriceSale, string Color, string Size, string Maker, string Description, string Note,
bool?Active, int?CreateByUserID, string[] list_Category, string UrlImage)
{
Product p = new Product();
p.NameProduct = NameProduct;
p.FullNameProduct = FullNameProduct;
p.Qty = Qty;
p.Price = Price;
p.News = News;
p.Sale = Sale;
p.PriceSale = PriceSale;
p.Color = Color;
p.Size = Size;
p.Maker = Maker;
p.Description = Description;
p.NumberView = 0;
p.NumberBuy = 0;
p.Note = Note;
p.Actives = Active;
p.CreateByEmployeeID = CreateByUserID;
p.CreateDate = DateTime.Now;
db.Products.Add(p);
foreach (string category in list_Category)
{
int int_categoryid = Int32.Parse(category);
CF_Products_Categories pc = new CF_Products_Categories();
pc.ProductID = p.ID;
pc.CategoriesID = int_categoryid;
db.CF_Products_Categories.Add(pc);
}
db.SaveChanges();
string[] urlImageDD = UrlImage.Split(',');
foreach (string s in urlImageDD)
{
ProductImage proImage = new ProductImage();
proImage.ProdutsID = p.ID;
proImage.URLImage = s;
db.ProductImages.Add(proImage);
}
db.SaveChanges();
return(p.ID);
}
public int InsertGroupEmployee(GroupEmployee group_employee, bool[] list_access)
{
db.GroupEmployees.Add(group_employee);
db.SaveChanges();
//foreach (bool access in list_access)
//{
//}
for (int i = 0; i < list_access.Length; i++)
{
if (list_access[i] == true)
{
Authorization au = new Authorization();
au.AccessID = i + 1;
au.GroupEmployeeID = group_employee.ID;
db.Authorizations.Add(au);
}
}
db.SaveChanges();
return(group_employee.ID);
}
public void Update(Employee employee_new)
{
Employee employee_old = db.Employees.Find(employee_new.ID);
employee_old.Name = employee_new.Name;
employee_old.Address = employee_new.Address;
employee_old.NumberPhone = employee_new.NumberPhone;
employee_old.Email = employee_new.Email;
employee_old.Login = employee_new.Login;
employee_old.GroupEmployee = employee_new.GroupEmployee;
employee_old.Password = employee_new.Password;
employee_old.PasswordLevel2 = employee_new.PasswordLevel2;
db.SaveChanges();
}
public void DeleteOrder(int ID)
{
var cf = (from table in db.CF_Orders_Products
where table.ProductID == ID
select table);
foreach (var mem in cf)
{
db.CF_Orders_Products.Remove(mem);
}
Order order = db.Orders.Find(ID);
if (order != null)
{
db.Orders.Remove(order);
db.SaveChanges();
}
db.SaveChanges();
}