public static bool UpdateCustomer(AdminRegisterationDTO data)
{
int tempId = Int32.Parse(data.id);
try
{
UjewelriesDBContext db = new UjewelriesDBContext();
if (data.name != null & data.name != "")
{
db.Costumers.Where(a => a.id == tempId).ToList()[0].name = data.name;
}
if (data.password != null & data.password != "")
{
db.Costumers.Where(a => a.id == tempId).ToList()[0].password = data.password;
}
if (data.Admin != null & data.Admin != "")
{
db.Costumers.Where(a => a.id == tempId).ToList()[0].is_manager = bool.Parse(data.Admin);
}
db.SaveChanges();
}
catch
{
Console.WriteLine("ERROR update failed");
return(false);
}
return(true);
}
public static bool CreateProduct(string id, string name, double price, double cost, int inv, int supplier_id, string category, bool is_active)
{
UjewelriesDBContext db = new UjewelriesDBContext();
Product NewProduct = new Product();
NewProduct.name = name;
NewProduct.price = price;
NewProduct.id = id;
NewProduct.cost = cost;
NewProduct.inv = inv;
NewProduct.category = category;
NewProduct.is_active = is_active;
NewProduct.supplier_id = supplier_id;
try
{
db.Products.Add(NewProduct);
db.SaveChanges();
}
catch (System.Exception e)
{
Console.WriteLine(e);
return(false);
}
return(true);
}
public static bool UpdateCustomerToManager(int id)
{
try
{
UjewelriesDBContext db = new UjewelriesDBContext();
db.Costumers.Where(a => a.id == id).ToList()[0].is_manager = true;
db.SaveChanges();
}
catch
{
Console.WriteLine("ERROR update failed");
return(false);
}
return(true);
}
public static bool UCTM(LoginDto data)// set admin account
{
try {
UjewelriesDBContext db = new UjewelriesDBContext();
int id = Int32.Parse(data.id);
db.Costumers.Where(a => a.id == id).ToList()[0].is_manager = true;
db.SaveChanges();
}
catch
{
Console.WriteLine("ERROR update failed");
return(false);
}
return(true);
}
public static bool DeleteCustomer(int id)
{
UjewelriesDBContext db = new UjewelriesDBContext();
Costumer SelectedCustomer = (Costumer)db.Costumers.Where(a => a.id == id).First();
try
{
db.Costumers.Remove(SelectedCustomer);
db.SaveChanges();
}
catch (System.Exception e)
{
Console.WriteLine(e);
return(false);
}
return(true);
}
public static bool DeleteProduct(string id)
{
UjewelriesDBContext db = new UjewelriesDBContext();
Product SelectedProduct = (Product)db.Products.Where(a => a.id == id).First();
try
{
db.Products.Remove(SelectedProduct);
db.SaveChanges();
}
catch (System.Exception e)
{
Console.WriteLine("Deleting false");
Console.WriteLine(e);
return(false);
}
return(true);
}
public static bool UpdateProduct(ProductDTO data)
{
try
{
UjewelriesDBContext db = new UjewelriesDBContext();
if (data.name != "")
{
db.Products.Where(a => a.id == data.id).ToList()[0].name = data.name;
}
if (data.price != "")
{
db.Products.Where(a => a.id == data.id).ToList()[0].price = double.Parse(data.price);
}
if (data.cost != "")
{
db.Products.Where(a => a.id == data.id).ToList()[0].cost = double.Parse(data.cost);
}
if (data.inv != "")
{
db.Products.Where(a => a.id == data.id).ToList()[0].inv = Int32.Parse(data.inv);
}
if (data.supplier_id != "")
{
db.Products.Where(a => a.id == data.id).ToList()[0].supplier_id = Int32.Parse(data.supplier_id);
}
if (data.category != "")
{
db.Products.Where(a => a.id == data.id).ToList()[0].category = data.category;
}
if (data.is_active != "")
{
db.Products.Where(a => a.id == data.id).ToList()[0].is_active = bool.Parse(data.is_active);
}
db.SaveChanges();
}
catch
{
Console.WriteLine("ERROR update failed");
return(false);
}
return(true);
}
public static bool CreateCustomer(int id, string name, string password, bool is_maneger = false)
{
UjewelriesDBContext db = new UjewelriesDBContext();
Costumer NewCustomer = new Costumer();
NewCustomer.name = name;
NewCustomer.password = password;
NewCustomer.id = id;
NewCustomer.is_manager = is_maneger;
try
{
db.Costumers.Add(NewCustomer);
db.SaveChanges();
}
catch (System.Exception e)
{
Console.WriteLine(e);
return(false);
}
return(true);
}