public string InsertOrUpdateLocationPrice(LocationPriceModel LPM)
{
tbl_LocationPrice LocationPrice = new tbl_LocationPrice();
LocationPrice.EAN13 = LPM.EAN13;
LocationPrice.LocationID = LPM.LocationID;
LocationPrice.MaterialID = LPM.MaterialID;
LocationPrice.Price = LPM.Price;
LocationPrice.UOM = LPM.UOM;
return(LocationPriceBL.InsertOrUpdate(LPM));
}
public string Insert(tbl_LocationPrice LocationPrice)
{
try
{
Context.LocationPrice.Insert(LocationPrice);
Context.LocationPrice.Save();
return(LocationPrice.EAN13 + " Inserted Successfully!!");
}
catch (Exception ex)
{
return("Error in saving details, Please try again!!");
}
finally
{
}
}
public string Update(tbl_LocationPrice LocationPrince)
{
try
{
Context.LocationPrice.Update(LocationPrince);
Context.LocationPrice.Save();
return(LocationPrince.EAN13 + " Updated Successfully!!");
}
catch (Exception ex)
{
return("Error in updateing details, Please try again!!");
}
finally
{
}
}
public string InsertOrUpdate(LocationPriceModel LPM)
{
string result = string.Empty;
bool IsExsit = false;
List <tbl_LocationPrice> LocationPrice;
LocationPrice = this.GetById(LPM.EAN13, LPM.LocationID).ToList();
if (LocationPrice != null)
{
IsExsit = true;
}
else
{
LocationPrice = new List <tbl_LocationPrice>();
}
if (!IsExsit)
{
tbl_LocationPrice LocPrice = new tbl_LocationPrice();
LocPrice.EAN13 = LPM.EAN13;
LocPrice.LocationID = LPM.LocationID;
LocPrice.MaterialID = LPM.MaterialID;
LocPrice.Price = LPM.Price;
LocPrice.UOM = LPM.UOM;
LocationPrice.Add(LocPrice);
return(this.Insert(LocPrice));
}
else
{
tbl_LocationPrice LocPrice = new tbl_LocationPrice();
LocPrice.EAN13 = LocationPrice.FirstOrDefault().EAN13;
LocPrice.LocationID = LocationPrice.FirstOrDefault().LocationID;
LocPrice.MaterialID = LocationPrice.FirstOrDefault().MaterialID;
LocPrice.Price = LocationPrice.FirstOrDefault().Price;
LocPrice.UOM = LocationPrice.FirstOrDefault().UOM;
LocationPrice.Add(LocPrice);
return(this.Update(LocPrice));
}
}
