public Fly_Videos getItem(int id)
{
Fly_Videos obj = null;
try
{
using (var context = new flycameraEntities())
{
obj = context.Fly_Videos
.Include("Fly_Picture")
.Include("Fly_Customer")
.Include("Fly_Product")
.Include("Fly_PositionGallery")
.Include("Fly_SectionContent").FirstOrDefault(x => x.VideosID == id);
}
}
catch (Exception ex)
{
throw ex;
}
return(obj);
}
public Fly_Customer SignIn(string usname, string pword)
{
Fly_Customer obj = null;
try
{
using (var context = new flycameraEntities())
{
pword = Encryption.Encrypt(pword);
var user = context.Fly_Customer.SingleOrDefault(x => x.Username.Equals(usname) && x.PasswordHash.Equals(pword));
if (user != null)
{
obj = user;
}
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
return(obj);
}
public string SignIn(string usname, string pword)
{
string obj = null;
try
{
using (var context = new flycameraEntities())
{
pword = Encryption.Encrypt(pword);
var user = context.Fly_Customer.Where(x => x.Username.Equals(usname) && x.PasswordHash.Equals(pword)).SingleOrDefault();
if (user != null)
{
obj = (user.IsAdmin.GetValueOrDefault(false)) ? RoleUser.ADMIN : RoleUser.CUSTOMER;
}
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
return(obj);
}
public bool RemoveItemById(int mappingRoleId, int customerId)
{
bool isSuccess = false;
try
{
using (var context = new flycameraEntities())
{
var item = context.Fly_Customer_CustomerRole_Mapping.FirstOrDefault(x => x.CustomerRoleID == mappingRoleId && x.CustomerID.Equals(customerId));
if (item != null)
{
context.Fly_Customer_CustomerRole_Mapping.Remove(item);
context.SaveChanges();
isSuccess = true;
}
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
return(isSuccess);
}
public void Edit(Fly_RelatedProduct obj)
{
try
{
using (var context = new flycameraEntities())
{
var item = context.Fly_RelatedProduct.Find(obj.RelatedProductID);
if (item != null)
{
context.Entry(item).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj, item));
context.SaveChanges();
}
else
{
this.Add(obj);
}
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
}
public void Edit(Fly_Category obj)
{
try
{
using (var context = new flycameraEntities())
{
var item = context.Fly_Category.Include("Fly_Category_Discount_Mapping").Include("Fly_CategoryLocalized").Where(x => x.CategoryID == obj.CategoryID).FirstOrDefault();
var mappingDiscount = item.Fly_Category_Discount_Mapping.FirstOrDefault();
var mappingLocalized = item.Fly_CategoryLocalized.FirstOrDefault();
if (item != null)
{
if (mappingDiscount != null)
{
var NewValue = obj.Fly_Category_Discount_Mapping.FirstOrDefault();
NewValue.CategoryID = (NewValue.CategoryID > 0 || NewValue.CategoryID.Equals(mappingDiscount.CategoryID)) ? mappingDiscount.CategoryID : NewValue.CategoryID;
NewValue.DiscountID = (NewValue.DiscountID > 0 || NewValue.DiscountID.Equals(mappingDiscount.DiscountID)) ? mappingDiscount.DiscountID : NewValue.DiscountID;
context.Entry(mappingDiscount).CurrentValues.SetValues(NewValue);
}
if (mappingLocalized != null)
{
var NewValue = obj.Fly_CategoryLocalized.FirstOrDefault();
NewValue.CategoryID = (NewValue.CategoryID == null || NewValue.CategoryID.Equals(mappingLocalized.CategoryID)) ? mappingLocalized.CategoryID : NewValue.CategoryID;
NewValue.Name = (NewValue.Name == null || NewValue.Name.Equals(mappingLocalized.Name)) ? mappingLocalized.Name : NewValue.Name;
context.Entry(mappingLocalized).CurrentValues.SetValues(NewValue);
}
context.Entry(item).CurrentValues.SetValues(obj);
context.SaveChanges();
}
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
}
public Fly_Customer getItem(int id)
{
Fly_Customer obj = null;
try
{
using (var context = new flycameraEntities())
{
obj = context.Fly_Customer
.Include("Fly_Picture")
.Include("Fly_Customer_CustomerRole_Mapping")
.Include("Fly_CustomerAttribute")
.Include("Fly_Customer_CustomerRole_Mapping.Fly_CustomerRole")
.Include("Fly_Customer_CustomerRole_Mapping.Fly_CustomerRole.Fly_CustomerRole_Discount_Mapping")
.Include("Fly_Customer_CustomerRole_Mapping.Fly_CustomerRole.Fly_CustomerRole_ProductPrice")
.Include("Fly_CustomerSession").FirstOrDefault(x => x.CustomerID == id);
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
return(obj);
}
public void Edit(Fly_Manufacturer obj)
{
try
{
using (var context = new flycameraEntities())
{
var item = context.Fly_Manufacturer.Include("Fly_ManufacturerLocalized").Where(x => x.ManufacturerID == obj.ManufacturerID).FirstOrDefault();
var localized = item.Fly_ManufacturerLocalized.FirstOrDefault();
if (item != null)
{
if (localized != null)
{
context.Entry(localized).CurrentValues.SetValues(obj.Fly_ManufacturerLocalized.FirstOrDefault());
}
context.Entry(item).CurrentValues.SetValues(obj);
context.SaveChanges();
}
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
}
public void Edit(Fly_Videos obj)
{
try
{
using (var context = new flycameraEntities())
{
var item = context.Fly_Videos.FirstOrDefault(x => x.VideosID == obj.VideosID);
var sectionContent = context.Fly_SectionContent.FirstOrDefault(x => x.SectionContentID == obj.Fly_SectionContent.SectionContentID);
if (item != null)
{
if (sectionContent != null)
{
context.Entry(sectionContent).CurrentValues.SetValues(obj.Fly_SectionContent);
}
context.Entry(item).CurrentValues.SetValues(obj);
context.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public IList <Fly_Videos> getAllItems()
{
IList <Fly_Videos> item = null;
try
{
using (var context = new flycameraEntities())
{
item = new List <Fly_Videos>();
item = context.Fly_Videos
.Include("Fly_Picture")
.Include("Fly_Customer")
.Include("Fly_Product")
.Include("Fly_PositionGallery")
.Include("Fly_SectionContent")
.ToList <Fly_Videos>();
}
}
catch (Exception ex)
{
throw ex;
}
return(item);
}
public void Edit(Fly_Product obj)
{
try
{
using (var context = new flycameraEntities())
{
var product = context.Fly_Product.Include("Fly_ProductVariant.Fly_ProductVariantLocalized")
.Include("Fly_ProductVariant.Fly_ProductVariant_Discount_Mapping")
.Include("Fly_ProductLocalized")
.Include("Fly_Product_Category_Mapping")
.Include("Fly_Product_Manufacturer_Mapping")
.Include("Fly_ProductPicture.Fly_Picture")
.Where(x => x.ProductId == obj.ProductId).FirstOrDefault();
// old Entity Data
var mappingCate = product.Fly_Product_Category_Mapping.FirstOrDefault();
var mappingManufacturer = product.Fly_Product_Manufacturer_Mapping.FirstOrDefault();
var productLocalized = product.Fly_ProductLocalized.FirstOrDefault();
var productPicture = product.Fly_ProductPicture.FirstOrDefault();
var productVariant = product.Fly_ProductVariant.FirstOrDefault();
var mappingVariantDiscount = productVariant.Fly_ProductVariant_Discount_Mapping.FirstOrDefault();
var mappingVariantLocalized = productVariant.Fly_ProductVariantLocalized.FirstOrDefault();
// new Entity Data
var productVariantNew = obj.Fly_ProductVariant.FirstOrDefault();
if (product != null)
{
if (mappingCate != null)
{
context.Entry(mappingCate).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj.Fly_Product_Category_Mapping.FirstOrDefault(), mappingCate));
}
if (mappingManufacturer != null)
{
context.Entry(mappingManufacturer).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj.Fly_Product_Manufacturer_Mapping.FirstOrDefault(), mappingManufacturer));
}
if (productLocalized != null)
{
context.Entry(productLocalized).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj.Fly_ProductLocalized.FirstOrDefault(), productLocalized));
}
if (productPicture != null)
{
context.Entry(productPicture).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj.Fly_ProductPicture.FirstOrDefault(), productPicture));
}
if (productVariant != null)
{
context.Entry(productVariant).CurrentValues.SetValues(UpdateEntities.UpdateEntity(productVariantNew, productVariant));
}
if (mappingVariantLocalized != null)
{
context.Entry(mappingVariantLocalized).CurrentValues.SetValues(UpdateEntities.UpdateEntity(productVariantNew.Fly_ProductVariantLocalized.FirstOrDefault(), mappingVariantLocalized));
}
if (mappingVariantDiscount != null)
{
context.Entry(mappingVariantDiscount).CurrentValues.SetValues(UpdateEntities.UpdateEntity(productVariantNew.Fly_ProductVariant_Discount_Mapping.FirstOrDefault(), mappingVariantDiscount));
}
if (mappingVariantDiscount != null)
{
context.Entry(mappingVariantDiscount).CurrentValues.SetValues(UpdateEntities.UpdateEntity(productVariantNew.Fly_ProductVariant_Discount_Mapping.FirstOrDefault(), mappingVariantDiscount));
}
context.Entry(product).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj, product));
context.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
