// GET: LocationPrice
public ActionResult Index()
{
LocationPriceModel LPM = new LocationPriceModel();
LPM = LocationPriceBL.MLocationPrice();
return(View(LPM));
}
public string LocationPriceGetByID(LocationPriceModel LPM)
{
List <tbl_LocationPrice> LP = new List <tbl_LocationPrice>();
// LP.FirstOrDefault().EAN13 = LPM.EAN13;
// LP.FirstOrDefault().LocationID = LPM.LocationID;
string LocID = string.Join(",", LPM.LocationID);
string EAN13 = string.Join(",", LPM.EAN13);
return(null);// LocationPriceBL.GetById(EAN13, LocID);
}
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 LocationPriceModel MLocationPrice()
{
LocationPriceModel ModelLocationPrice;
List <tbl_Material> MMaterial;
List <tbl_LocationPrice> MLocationPrice;
List <tbl_MaterialEAN> MMaterialEAN;
List <tbl_Location> MLocation;
List <tbl_UOM> MUOM;
try
{
ModelLocationPrice = new LocationPriceModel();
MMaterial = this.GetMaterial();
MLocationPrice = this.GetAll();
MMaterialEAN = this.MaterialEAN();
MLocation = this.Location();
MUOM = this.UOM();
ModelLocationPrice.MLocation = MLocation;
ModelLocationPrice.MLocationPrice = MLocationPrice;
ModelLocationPrice.MMaterialEAN = MMaterialEAN;
ModelLocationPrice.MMaterial = MMaterial;
ModelLocationPrice.MUOM = MUOM;
return(ModelLocationPrice);
}
catch (Exception ex)
{
return(null);
}
finally
{
MMaterial = null;
MLocationPrice = null;
MMaterialEAN = null;
MLocation = null;
MUOM = null;
}
}
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));
}
}
