public List <ProductCategoryModel> GenerateProductCategoryModel() { List <ProductCategoryModel> modelList = new List <ProductCategoryModel>(); ProductCategoryModel model = new ProductCategoryModel(); ProductHeaderModel model2 = new ProductHeaderModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var list = from p in vdc.ProductCategories.ToList() orderby p.ProductCategoryId ascending select p; foreach (var item in list) { model = new ProductCategoryModel(); model.ProductCategoryId = item.ProductCategoryId; model.ProductCategory = item.ProductCategory1; //model.ProductHeaderModel = GetProductHeaderByProductCategoryId(item.ProductCategoryId); model.PriceListModel = GetPriceListByProductCategoryId(item.ProductCategoryId); modelList.Add(model); } return(modelList); } } catch (Exception ex) { throw ex; } }
public ProductHeaderModel GetProductHeaderByHeaderId(int productLabelId) { ProductHeaderModel model = new ProductHeaderModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var list = from p in vdc.ProductHeaders.ToList() where p.ProductLabelId == productLabelId select p; if (list != null) { model.ProductCategoryId = list.FirstOrDefault().ProductCategoryId; model.ProductLabelId = list.FirstOrDefault().ProductLabelId; model.ProductTableTitleDescription = list.FirstOrDefault().ProductTableTitleDescription; } return(model); } } catch (Exception ex) { throw ex; } }
public List <ProductHeaderModel> GetProductHeaderByProductCategoryId(int productCategoryId) { List <ProductHeaderModel> modelList = new List <ProductHeaderModel>(); ProductHeaderModel model = new ProductHeaderModel(); try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { var list = from p in vdc.ProductHeaders.ToList() where p.ProductCategoryId == productCategoryId orderby p.ProductLabelId ascending select p; foreach (var item in list) { model = new ProductHeaderModel(); model.ProductLabelId = item.ProductLabelId; model.ProductCategoryId = item.ProductCategoryId; model.ProductTableTitleDescription = item.ProductTableTitleDescription; modelList.Add(model); } return(modelList); } } catch (Exception ex) { throw ex; } }
public ActionResult EditHeader(int productLabelId, string productTableTitleDescription) { 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(); ProductHeaderModel model = new ProductHeaderModel(); try { model.ProductLabelId = productLabelId; model.ProductTableTitleDescription = productTableTitleDescription; dataService.UpdateHeader(model); return(RedirectToAction("Edit", "Price")); } catch (Exception ex) { throw ex; } finally { dataService = null; } }
public ActionResult EditHeader(int headerId) { 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(); ProductHeaderModel model = new ProductHeaderModel(); try { model = dataService.GetProductHeaderByHeaderId(headerId); return(View(model)); } catch (Exception ex) { throw ex; } finally { dataService = null; } }
public void UpdateHeader(ProductHeaderModel model) { try { ProductHeader table = new ProductHeader(); using (VenturadaDataContext vdc = new VenturadaDataContext()) { table = vdc.ProductHeaders.Single(a => a.ProductLabelId == model.ProductLabelId); table.ProductTableTitleDescription = model.ProductTableTitleDescription; vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
public void InsertProductHeader(ProductHeaderModel model) { try { using (VenturadaDataContext vdc = new VenturadaDataContext()) { ProductHeader table = new ProductHeader(); table.ProductTableTitleDescription = model.ProductTableTitleDescription; table.ProductCategoryId = model.ProductCategoryId; vdc.ProductHeaders.InsertOnSubmit(table); vdc.SubmitChanges(); } } catch (Exception ex) { throw ex; } }
private static AssetWarrantyResponseModel ConvertJsonToAssetWarrantyResponse(string Json) { AssetWarrantyResponseModel ResultModel = new AssetWarrantyResponseModel(); AssetHeaderModel assetHeader = new AssetHeaderModel(); ProductHeaderModel productHeader = new ProductHeaderModel(); AssetEntitlementModel assetEntitlement = new AssetEntitlementModel(); List <AssetEntitlementModel> AssetEntitlementModelList = new List <AssetEntitlementModel>(); JObject jObject = JObject.Parse(Json); JToken jAssetEntitlement = jObject.SelectToken("AssetWarrantyResponse[0].AssetEntitlementData"); JToken jAssetHeader = jObject.SelectToken("AssetWarrantyResponse[0].AssetHeaderData"); JToken jProductHeader = jObject.SelectToken("AssetWarrantyResponse[0].ProductHeaderData"); if (jAssetHeader != null && jAssetHeader.HasValues) { assetHeader.BUILD = (string)jAssetHeader["BUID"]; assetHeader.ServiceTag = (string)jAssetHeader["ServiceTag"]; assetHeader.ShipDate = (DateTime)jAssetHeader["ShipDate"]; assetHeader.CountryLookupCode = (string)jAssetHeader["CountryLookupCode"]; assetHeader.LocalChannel = (string)jAssetHeader["LocalChannel"]; assetHeader.CustomerNumber = (string)jAssetHeader["CustomerNumber"]; assetHeader.ItemClassCode = (string)jAssetHeader["ItemClassCode"]; assetHeader.IsDuplicate = (bool)jAssetHeader["IsDuplicate"]; assetHeader.MachineDescription = (string)jAssetHeader["MachineDescription"]; assetHeader.OrderNumber = (string)jAssetHeader["OrderNumber"]; assetHeader.ParentServiceTag = (string)jAssetHeader["ParentServiceTag"]; assetHeader.CompanyNumber = (string)jAssetHeader["CompanyNumber"]; ResultModel.AssetHeader = assetHeader; } if (jAssetHeader != null && jProductHeader.HasValues) { productHeader.SystemDescription = (string)jProductHeader["SystemDescription"]; productHeader.ProductId = (string)jProductHeader["ProductId"]; productHeader.ProductFamily = (string)jProductHeader["ProductFamily"]; productHeader.LOB = (string)jProductHeader["LOB"]; productHeader.LOBFriendlyName = (string)jProductHeader["LOBFriendlyName"]; ResultModel.ProductHeader = productHeader; } if (jAssetHeader != null && jAssetEntitlement.HasValues) { for (int i = 0; i < jAssetEntitlement.Count(); i++) { string _quantityJtoken = "AssetWarrantyResponse[0].AssetEntitlementData[" + i + "]"; JToken jAssetEntitlementChild = jObject.SelectToken(_quantityJtoken); assetEntitlement = new AssetEntitlementModel(); assetEntitlement.StartDate = (DateTime)jAssetEntitlementChild["StartDate"]; assetEntitlement.EndDate = (DateTime)jAssetEntitlementChild["EndDate"]; assetEntitlement.ServiceLevelDescription = (string)jAssetEntitlementChild["ServiceLevelDescription"]; assetEntitlement.ServiceLevelCode = (string)jAssetEntitlementChild["ServiceLevelCode"]; assetEntitlement.ServiceLevelGroup = (string)jAssetEntitlementChild["ServiceLevelGroup"]; assetEntitlement.EntitlementType = (string)jAssetEntitlementChild["EntitlementType"]; assetEntitlement.ServiceProvider = (string)jAssetEntitlementChild["ServiceProvider"]; assetEntitlement.ItemNumber = (string)jAssetEntitlementChild["ItemNumber"]; AssetEntitlementModelList.Add(assetEntitlement); } ResultModel.AssetEntitlement = AssetEntitlementModelList; } return(ResultModel); }