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);
}
