public int Remove(int product_id, int Package_Id)
{
try
{
bool check = Data.Package_With_Product.Any(x => x.Package_Id == Package_Id && x.Product_Id == product_id);
if (check)
{
Package_With_Product modify = Data.Package_With_Product.Single(x => x.Package_Id == Package_Id && x.Product_Id == product_id);
if (modify.Unit_Number > 1)
{
modify.Unit_Number--;
Data.Entry(modify).State = EntityState.Modified;
}
else
{
Data.Package_With_Product.Remove(modify);
}
Data.SaveChanges();
return(modify.Package_Id);
}
return(0);
}
catch
{
throw;
}
}
public int Add(int product_id, int Package_Id)
{
try
{
Package_With_Product modify = Data.Package_With_Product.Single(x => x.Package_Id == Package_Id && x.Product_Id == product_id);
modify.Unit_Number = modify.Unit_Number + 1;
Data.Entry(modify).State = EntityState.Modified;
Data.SaveChanges();
return(modify.Package_Id);
}
catch
{
throw;
}
}
public string AddtoPackaget(int id, int package_id)
{
Package_With_Product PP = new Package_With_Product();
bool check = Data.Package_With_Product.Any(x => x.Package_Id == package_id && x.Product_Id == id);
if (check)
{
Package_With_Product modify = Data.Package_With_Product.Single(x => x.Package_Id == package_id && x.Product_Id == id);
modify.Unit_Number = modify.Unit_Number + 1;
Data.Entry(modify).State = EntityState.Modified;
Data.SaveChanges();
return("Product unit is Modified .");
}
else
{
Product_Information PI = Data.Product_Information.Include(Y => Y.Image).Single(x => x.Product_id == id);
Package Package = Data.Package.Single(x => x.Package_Id == package_id);
PP.Package_Id = package_id;
PP.Package_Name = Package.Package_Name;
PP.Product_Id = id;
PP.Unit_Number = 1;
PP.Unit_Name = PI.Unit;
PP.Product_Name = PI.Product_name;
PP.Photo = PI.Image.Image1;
Data.Package_With_Product.Add(PP);
Data.SaveChanges();
return("Product Added Successfully.");
}
}
