public bool AddColorMapping(product_color_mapping productColor, long create_by)
{
try
{
var product = new product_color_mapping();
product.color_id = productColor.color_id;
product.created_by = create_by;
product.is_active = productColor.is_active;
product.product_id = productColor.product_id;
product.created_date = DateTime.Now;
_entities.product_color_mapping.Add(product);
int save = _entities.SaveChanges();
if (save > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool EditColorMapping(product_color_mapping productColor, long update_by)
{
try
{
var product1 = _entities.product_color_mapping.Find(productColor.product_color_mapping_id);
product1.color_id = productColor.color_id;
product1.is_active = productColor.is_active;
product1.updated_by = update_by;
product1.updated_date = DateTime.Now;
product1.product_id = productColor.product_id;
int save = _entities.SaveChanges();
if (save > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool CheckDuplicateMappingForUpdate(product_color_mapping productColor)
{
try
{
var check =
_entities.product_color_mapping.SingleOrDefault(a => a.product_id == productColor.product_id && a.color_id == productColor.color_id);
if (check == null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
