public static void Updatebrands(List <brand> brands)
{
using (var context = new WebsiteTTKEntities())
{
foreach (brand item in brands)
{
var result = context.brands.SingleOrDefault(b => b.brand_id == item.brand_id);
if (result != null)
{
result.brand_name = item.brand_name;
result.brand_description = item.brand_description;
result.images = item.images;
result.create_date = item.create_date;
context.SaveChanges();
}
else
{
context.brands.Add(new brand
{
brand_name = item.brand_name,
brand_description = item.brand_description,
images = item.images,
create_date = item.create_date,
});
context.SaveChanges();
}
}
}
}
public static void Updatecolours(List <colour> colours, bool isUpdateProductImages = false)
{
using (var context = new WebsiteTTKEntities())
{
foreach (colour item in colours)
{
var result = context.colours.SingleOrDefault(b => b.colour_id == item.colour_id);
if (result != null)
{
result.colour_name = item.colour_name;
result.colour_description = item.colour_description;
result.create_date = item.create_date;
context.SaveChanges();
}
else
{
context.colours.Add(new colour
{
colour_name = item.colour_name,
colour_description = item.colour_description,
create_date = item.create_date,
});
context.SaveChanges();
}
}
}
}
/// <summary>
/// Update or add a new address
/// </summary>
/// <param name="addresses">List of address to be updated or added</param>
public static void UpdateUserAddresses(List <AspNetUserAddress> addresses)
{
using (var context = new WebsiteTTKEntities())
{
foreach (AspNetUserAddress item in addresses)
{
var result = context.AspNetUserAddresses.SingleOrDefault(b => b.Id == item.Id);
if (result != null)
{
result.Firstname = item.Firstname;
result.Lastname = item.Lastname;
result.Company = item.Company;
result.Street = item.Street;
result.City = item.City;
result.Zip = item.Zip;
result.State = item.State;
result.Country = item.Country;
result.Birthday = item.Birthday;
result.Gender = item.Gender;
result.PhoneNumber = item.PhoneNumber;
result.Email = item.Email;
result.AddressType = item.AddressType;
context.SaveChanges();
}
else
{
context.AspNetUserAddresses.Add(new AspNetUserAddress
{
UserId = item.UserId,
Firstname = item.Firstname,
Lastname = item.Lastname,
Company = item.Company,
Street = item.Street,
City = item.City,
Zip = item.Zip,
State = item.State,
Country = item.Country,
Birthday = item.Birthday,
Gender = item.Gender,
PhoneNumber = item.PhoneNumber,
Email = item.Email,
AddressType = item.AddressType
});
context.SaveChanges();
}
}
}
}
public static string UpdateNewOrderShippingCost(string userId, int delivery_id)
{
try
{
using (var context = new WebsiteTTKEntities())
{
order order = context.orders.FirstOrDefault(x => x.customer_id == userId && x.order_status == (int)OrderStatus.Status.New);
List <order_items> orderItems = context.order_items.Where(x => x.order_id == order.order_id).ToList();
if (order != null)
{
order.delivery_id = delivery_id;
context.SaveChanges();
return(null);
}
else
{
return("Order doesn't exist!");
}
}
} catch (Exception ex)
{
LogHelper.Log("App_Code\\Helper\\OrderHelper.cs", LogHelper.ErrorType.Error, ex);
return("Cannot update order's shipping cost!");
}
}
/// <summary>
/// Update customer address
/// </summary>
/// <param name="customer">Customer entity</param>
/// <returns></returns>
public static string UpdateCustomerAddress(Customer customer)
{
try
{
AspNetUser user = customer.AspNetUser;
AspNetUserAddress address = customer.AspNetUserAddress;
using (var context = new WebsiteTTKEntities())
{
var existAddress = context.AspNetUserAddresses.FirstOrDefault(x => x.UserId == user.Id);
existAddress.Firstname = address.Firstname;
existAddress.Lastname = address.Lastname;
existAddress.Company = address.Company;
existAddress.Street = address.Street;
existAddress.City = address.City;
existAddress.Zip = address.Zip;
existAddress.State = address.State;
existAddress.PhoneNumber = address.PhoneNumber;
existAddress.Email = address.Email;
existAddress.Country = address.Country;
context.SaveChanges();
return(null);
}
} catch (Exception ex)
{
return(ex.Message);
}
}
public static void AddCurrencyData()
{
List <string> list = new List <string>();
foreach (System.Globalization.CultureInfo ci in System.Globalization.CultureInfo.GetCultures(System.Globalization.CultureTypes.AllCultures))
{
string specName = "(none)";
try { specName = System.Globalization.CultureInfo.CreateSpecificCulture(ci.Name).Name; }
catch { }
list.Add(ci.Name);
}
for (int i = 0; i < list.Count; i++)
{
if (list[i] != "" && list[i].Contains('-'))
{
try
{
var cl = new System.Globalization.CultureInfo(list[i]);
using (var context = new WebsiteTTKEntities())
{
context.currencies.Add(new currency
{
currency_name = cl.EnglishName,
currency_code = cl.Name,
currency_symbol = cl.NumberFormat.CurrencySymbol
});
context.SaveChanges();
}
}
catch { }
}
}
}
public static void Updateorders(List <order> orders)
{
using (var context = new WebsiteTTKEntities())
{
foreach (order item in orders)
{
var result = context.orders.SingleOrDefault(b => b.order_id == item.order_id);
if (result != null)
{
result.customer_id = item.customer_id;
result.order_status = item.order_status;
result.order_date = item.order_date;
result.required_date = item.required_date;
result.shipped_date = item.shipped_date;
result.store_id = item.store_id;
result.staff_id = item.staff_id;
result.order_discount = item.order_discount;
result.order_discount_is_fixed = item.order_discount_is_fixed;
result.delivery_id = item.delivery_id;
result.currency_id = item.currency_id;
context.SaveChanges();
}
else
{
context.orders.Add(new order
{
order_id = item.order_id,
order_status = item.order_status,
order_date = item.order_date,
required_date = item.required_date,
shipped_date = item.shipped_date,
store_id = item.store_id,
staff_id = item.staff_id,
order_discount = item.order_discount,
order_discount_is_fixed = item.order_discount_is_fixed,
delivery_id = item.delivery_id,
currency_id = item.currency_id,
});
context.SaveChanges();
}
}
}
}
public static void Updatestaffs(List <staff> staffs)
{
using (var context = new WebsiteTTKEntities())
{
foreach (staff item in staffs)
{
var result = context.staffs.SingleOrDefault(b => b.staff_id == item.staff_id);
if (result != null)
{
result.first_name = item.first_name;
result.last_name = item.last_name;
result.phone = item.phone;
result.email = item.email;
result.phone = item.phone;
result.active = item.active;
result.store_id = item.store_id;
result.manager_id = item.manager_id;
result.address = item.address;
context.SaveChanges();
}
else
{
context.staffs.Add(new staff
{
staff_id = item.staff_id,
first_name = item.first_name,
last_name = item.last_name,
phone = item.phone,
email = item.email,
active = item.active,
store_id = item.store_id,
manager_id = item.manager_id,
address = item.address,
});
context.SaveChanges();
}
}
}
}
public static void Updatestores(List <store> stores)
{
using (var context = new WebsiteTTKEntities())
{
foreach (store item in stores)
{
var result = context.stores.SingleOrDefault(b => b.store_id == item.store_id);
if (result != null)
{
result.store_name = item.store_name;
result.store_description = item.store_description;
result.store_images = item.store_images;
result.phone = item.phone;
result.email = item.email;
result.street = item.street;
result.city = item.city;
result.zip_code = item.zip_code;
context.SaveChanges();
}
else
{
context.stores.Add(new store
{
store_id = item.store_id,
store_name = item.store_name,
store_description = item.store_description,
store_images = item.store_images,
phone = item.phone,
email = item.email,
street = item.street,
city = item.city,
zip_code = item.zip_code,
});
context.SaveChanges();
}
}
}
}
public static void DeleteStoreByIds(List <int> deletedIds)
{
using (var context = new WebsiteTTKEntities())
{
foreach (var id in deletedIds)
{
var result = context.stores.SingleOrDefault(b => b.store_id == id);
if (result != null)
{
context.stores.Attach(result);
context.stores.Remove(result);
context.SaveChanges();
}
}
}
}
public static void DeleteCustomerByIds(List <string> deletedIds)
{
using (var context = new WebsiteTTKEntities())
{
foreach (var id in deletedIds)
{
var result = context.AspNetUsers.SingleOrDefault(b => b.Id == id);
if (result != null)
{
context.AspNetUsers.Attach(result);
context.AspNetUsers.Remove(result);
context.SaveChanges();
}
}
}
}
public static void UpdateCategories(List <procategory> categories, bool isUpdateCategoryImages = false)
{
using (var context = new WebsiteTTKEntities())
{
foreach (procategory item in categories)
{
var result = context.procategories.SingleOrDefault(b => b.category_id == item.category_id);
if (result != null)
{
result.category_name = item.category_name;
result.category_description = item.category_description;
if (isUpdateCategoryImages)
{
result.category_images = item.category_images;
}
result.category_url = item.category_url;
result.create_date = item.create_date;
result.parent_id = item.parent_id;
result.is_publish = item.is_publish;
result.is_menu = item.is_menu;
result.is_label = item.is_label;
result.is_collection = item.is_collection;
result.store_id = item.store_id;
try
{
context.SaveChanges();
} catch (Exception ex)
{
LogHelper.Log("App_Code\\CategoryHelper.cs", LogHelper.ErrorType.Error, ex);
}
}
else
{
context.procategories.Add(new procategory
{
category_name = item.category_name,
category_description = item.category_description,
category_images = item.category_images,
category_url = item.category_url,
create_date = item.create_date,
parent_id = item.parent_id,
is_publish = item.is_publish,
is_menu = item.is_menu,
is_label = item.is_label,
is_collection = item.is_collection,
store_id = item.store_id
});
try
{
context.SaveChanges();
}
catch (Exception ex)
{
LogHelper.Log("App_Code\\CategoryHelper.cs", LogHelper.ErrorType.Error, ex);
}
}
}
}
}
public static void UpdateProducts(List <product> products, bool isUpdateProductImages = false)
{
using (var context = new WebsiteTTKEntities())
{
foreach (product item in products)
{
var result = context.products.SingleOrDefault(b => b.product_id == item.product_id);
if (result != null)
{
result.product_name = item.product_name;
result.product_description = item.product_description;
if (isUpdateProductImages)
{
result.product_images = item.product_images;
}
result.brand_id = item.brand_id;
result.category_id = item.category_id;
result.colour_id = item.colour_id;
result.model_year = item.model_year;
result.list_price = item.list_price;
result.shipping_fee = item.shipping_fee;
result.free_shipping_amount = item.free_shipping_amount;
result.tax = item.tax;
result.taxed_countries = item.taxed_countries;
result.create_date = item.create_date;
result.create_by = item.create_by;
result.is_publish = item.is_publish;
result.is_featured = item.is_featured;
result.is_sale = item.is_sale;
result.is_new = item.is_new;
result.is_gift = item.is_gift;
result.currency_id = item.currency_id;
context.SaveChanges();
}
else
{
context.products.Add(new product {
product_name = item.product_name,
product_description = item.product_description,
product_images = item.product_images,
brand_id = item.brand_id,
category_id = item.category_id,
colour_id = item.colour_id,
model_year = item.model_year,
list_price = item.list_price,
shipping_fee = item.shipping_fee,
free_shipping_amount = item.free_shipping_amount,
tax = item.tax,
taxed_countries = item.taxed_countries,
create_date = item.create_date,
create_by = item.create_by,
is_publish = item.is_publish,
is_featured = item.is_featured,
is_sale = item.is_sale,
is_new = item.is_new,
is_gift = item.is_gift,
currency_id = item.currency_id
});
context.SaveChanges();
}
}
}
}
