public void InsertPriceList(PriceListModel model)
{
try
{
using (VenturadaDataContext vdc = new VenturadaDataContext())
{
PriceList table = new PriceList();
table.ProductCategoryId = model.ProductCategoryId;
table.ProductName = model.ProductName;
table.ProductDescription = model.ProductDescription;
table.Price = model.Price;
vdc.PriceLists.InsertOnSubmit(table);
vdc.SubmitChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdatePriceList(PriceListModel model)
{
try
{
PriceList table = new PriceList();
using (VenturadaDataContext vdc = new VenturadaDataContext())
{
table = vdc.PriceLists.Single(a => a.PriceListId == model.PriceListId);
table.ProductDescription = model.ProductDescription;
table.ProductName = model.ProductName;
table.Price = model.Price;
vdc.SubmitChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public List<PriceListModel> GetPriceListByProductCategoryId(int productCategoryId)
{
List<PriceListModel> modelList = new List<PriceListModel>();
PriceListModel model = new PriceListModel();
try
{
using (VenturadaDataContext vdc = new VenturadaDataContext())
{
var list = from p in vdc.PriceLists.ToList()
where p.ProductCategoryId == productCategoryId
orderby p.PriceListId ascending
select p;
foreach (var item in list)
{
model = new PriceListModel();
model.PriceListId = item.PriceListId;
model.ProductCategoryId = item.ProductCategoryId;
model.ProductName = item.ProductName;
model.ProductDescription = item.ProductDescription;
model.Price = item.Price;
modelList.Add(model);
}
return modelList;
}
}
catch (Exception ex)
{
throw ex;
}
}
public PriceListModel GetPriceListById(int priceListId)
{
PriceListModel model = new PriceListModel();
try
{
using (VenturadaDataContext vdc = new VenturadaDataContext())
{
var list = from p in vdc.PriceLists.ToList()
where p.PriceListId == priceListId
select p;
if (list != null)
{
model.PriceListId = list.FirstOrDefault().PriceListId;
model.ProductCategoryId = list.FirstOrDefault().ProductCategoryId;
model.ProductName = list.FirstOrDefault().ProductName;
model.ProductDescription = list.FirstOrDefault().ProductDescription;
model.Price = list.FirstOrDefault().Price;
}
return model;
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult EditPrice(PriceListModel plm)
{
CommonDataService cds = new CommonDataService();
CommonModel cm = new CommonModel();
cm = cds.GenerateCommonModel();
Session["FaceBook"] = cm.FaceBook;
Session["Twitter"] = cm.Twitter;
Session["Youtube"] = cm.Youtube;
Session["Instagram"] = cm.Instagram;
Session["PhoneNumber"] = cm.PhoneNumber;
Session["Email"] = cm.Email;
Session["ShoppingHours"] = cm.ShoppingHours;
PriceDataService dataService = new PriceDataService();
PriceListModel model = new PriceListModel();
try
{
if (ModelState.IsValid)
{
model.PriceListId = plm.PriceListId;
model.ProductName = plm.ProductName;
model.ProductDescription = plm.ProductDescription;
model.Price = plm.Price;
dataService.UpdatePriceList(model);
return RedirectToAction("Edit", "Price");
}
else
{
return View(plm);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dataService = null;
}
}
public ActionResult EditPrice(int priceListId)
{
CommonDataService cds = new CommonDataService();
CommonModel cm = new CommonModel();
cm = cds.GenerateCommonModel();
Session["FaceBook"] = cm.FaceBook;
Session["Twitter"] = cm.Twitter;
Session["Youtube"] = cm.Youtube;
Session["Instagram"] = cm.Instagram;
Session["PhoneNumber"] = cm.PhoneNumber;
Session["Email"] = cm.Email;
Session["ShoppingHours"] = cm.ShoppingHours;
PriceDataService dataService = new PriceDataService();
PriceListModel model = new PriceListModel();
try
{
model = dataService.GetPriceListById(priceListId);
return View(model);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dataService = null;
}
}
public ActionResult AddPrice(PriceListModel pcm)
{
CommonDataService cds = new CommonDataService();
CommonModel cm = new CommonModel();
cm = cds.GenerateCommonModel();
Session["FaceBook"] = cm.FaceBook;
Session["Twitter"] = cm.Twitter;
Session["Youtube"] = cm.Youtube;
Session["Instagram"] = cm.Instagram;
Session["PhoneNumber"] = cm.PhoneNumber;
Session["Email"] = cm.Email;
Session["ShoppingHours"] = cm.ShoppingHours;
PriceDataService dataService = new PriceDataService();
try
{
dataService.InsertPriceList(pcm);
return RedirectToAction("Edit", "Price");
}
catch (Exception ex)
{
throw ex;
}
finally
{
dataService = null;
}
}
