//public List<PLPCompanyModel> GetPLPCompanyData(List<Company> companies) //{ // List<PLPCompanyModel> lstPLPCompanies = new List<PLPCompanyModel>(); // if (null != companies && companies.Count() > 0) // { // foreach (var item in companies) // { // PLPCompanyModel model = new PLPCompanyModel(); // //if (item.CategoryId1 > 0) // //{ // // var category = _db.Categories.FirstOrDefault(a => a.CategoryId == item.CategoryId); // // model.CategoryName = category.Category1; // //} // model.CompanyStatus = item.Status; // model.CompanyName = item.CompanyName; // model.Description = ""; // model.CompanyId = item.CompanyId; // lstPLPCompanies.Add(model); // } // } // return lstPLPCompanies; //} public JsonResult GetPLPCompanyInfo(int id) { PLPCompanyInfoModel model = new PLPCompanyInfoModel(); if (id > 0) { var _company = _db.Companies.FirstOrDefault(a => a.CompanyId == id); if (null != _company) { model.ASI = _company.ASI; // model.CategoryId = _company.CategoryId; model.City = _company.City; model.CompanyId = _company.CompanyId; model.CompanyLogo = _company.Company_Logo; model.CompanyName = _company.CompanyName; model.PartnerType = _company.PartnerType; model.FOBPointInCanada = _company.FOBPointInCanada; model.PPAI = _company.PPAI; model.PrimaryContactAffilations = _company.PrimaryContactAffiliations; model.PrimaryContactDirectLine = _company.PrimaryContactDirectLine; model.PrimaryContactEmail = _company.PrimaryContactEmail; model.PrimaryContactFax = _company.PrimaryContactFax; model.PrimaryContactFirstName = _company.PrimaryContactFirstName; model.PrimaryContactLastName = _company.PrimaryContactLastName; model.PrimaryContactTradeOnly = _company.PrimaryContactTradeOnly; model.SAGE = _company.SAGE; model.SecondaryContactAffilations = _company.SecondaryContactAffiliations; model.SecondaryContactDirectLine = _company.SecondaryContactDirectLine; model.SecondaryContactEmail = _company.SecondaryContactEmail; model.SecondaryContactFax = _company.SecondaryContactFax; model.SecondaryContactFirstName = _company.SecondaryContactFirstName; model.SecondaryContactLastName = _company.SecondaryContactLastName; model.SecondaryContactTradeOnly = _company.SecondaryContactTradeOnly; model.State = _company.State; model.StreetAddress = _company.StreetAddress; model.TertiaryContactAffilations = _company.TertiaryContactAffiliations; model.TertiaryContactDirectLine = _company.TertiaryContactDirectLine; model.TertiaryContactEmail = _company.TertiaryContactEmail; model.TertiaryContactFax = _company.TertiaryContactFax; model.TertiaryContactFirstName = _company.TertiaryContactFirstName; model.TertiaryContactLastName = _company.TertiaryContactLastName; model.TertiaryContactTradeOnly = _company.TertiaryContactTradeOnly; model.Website = _company.Website; model.ZipCode = _company.ZipCode; model.Description = _company.Description; model.lstAllCategories = new List <int>(); var categories = _db.CompanyCategories.Where(a => a.CompanyId == _company.CompanyId); if (null != categories && categories.Count() > 0) { foreach (var cat in categories) { model.lstAllCategories.Add(cat.CategoryId); } } } } return(Json(model, JsonRequestBehavior.AllowGet)); }
public JsonResult SavePLPCompanyInfo(string PLPCompanyInfoData) { string finalString = string.Empty; string original = PLPCompanyInfoData; if (!string.IsNullOrEmpty(PLPCompanyInfoData)) { PLPCompanyInfoData = PLPCompanyInfoData.Replace('"', '\''); var arr11 = PLPCompanyInfoData.Split(new string[] { "'lstAllCategories':" }, StringSplitOptions.None); var arr12 = arr11[1].Split(new string[] { ",'PrimaryContactFirstName'" }, StringSplitOptions.None); var cat1 = arr12[0]; if (!cat1.Contains("[")) { var arrNumberOnly = cat1.Split(new string[] { "'" }, StringSplitOptions.RemoveEmptyEntries); finalString = arr11[0] + "'lstAllCategories':" + "[" + arrNumberOnly[0] + "]" + ",'PrimaryContactFirstName'" + arr12[1]; } else { finalString = original; } } var serializer = new JavaScriptSerializer(); var companyInfo = serializer.Deserialize(finalString, typeof(PLPCompanyInfoModel)); PLPCompanyInfoModel model = (dynamic)(companyInfo); if (model.CompanyId > 0) { var company = _db.Companies.FirstOrDefault(a => a.CompanyId == model.CompanyId); company.CompanyName = model.CompanyName; company.ASI = "" + model.ASI; company.PPAI = "" + model.PPAI; company.SAGE = "" + model.SAGE; company.StreetAddress = "" + model.StreetAddress; company.City = "" + model.City; company.State = "" + model.State; company.ZipCode = "" + model.ZipCode; company.Website = "" + model.Website; company.FOBPointInCanada = "" + model.FOBPointInCanada; company.PrimaryContactFirstName = "" + model.PrimaryContactFirstName; company.PrimaryContactLastName = "" + model.PrimaryContactLastName; company.PrimaryContactEmail = "" + model.PrimaryContactEmail; company.PrimaryContactDirectLine = "" + model.PrimaryContactDirectLine; company.PrimaryContactFax = "" + model.PrimaryContactFax; company.PrimaryContactTradeOnly = "" + model.PrimaryContactTradeOnly; company.PrimaryContactAffiliations = "" + model.PrimaryContactAffilations; company.SecondaryContactFirstName = "" + model.SecondaryContactFirstName; company.SecondaryContactLastName = "" + model.SecondaryContactLastName; company.SecondaryContactEmail = "" + model.SecondaryContactEmail; company.SecondaryContactDirectLine = "" + model.SecondaryContactDirectLine; company.SecondaryContactFax = "" + model.SecondaryContactFax; company.SecondaryContactTradeOnly = "" + model.SecondaryContactTradeOnly; company.SecondaryContactAffiliations = "" + model.SecondaryContactAffilations; company.TertiaryContactFirstName = "" + model.TertiaryContactFirstName; company.TertiaryContactLastName = "" + model.TertiaryContactLastName; company.TertiaryContactEmail = "" + model.TertiaryContactEmail; company.TertiaryContactDirectLine = "" + model.TertiaryContactDirectLine; company.TertiaryContactFax = "" + model.TertiaryContactFax; company.TertiaryContactTradeOnly = "" + model.TertiaryContactTradeOnly; company.TertiaryContactAffiliations = "" + model.TertiaryContactAffilations; company.Description = "" + model.Description; if (null != model.lstAllCategories && model.lstAllCategories.Count() > 0) { var companyCategories = _db.CompanyCategories.Where(cc => cc.CompanyId == company.CompanyId).ToList(); foreach (var comp in companyCategories) { _db.CompanyCategories.Remove(comp); } _db.SaveChanges(); foreach (var id in model.lstAllCategories) { CompanyCategory _CompanyCategory = new CompanyCategory(); _CompanyCategory.CompanyId = company.CompanyId; _CompanyCategory.CategoryId = Convert.ToInt32(id); _db.CompanyCategories.Add(_CompanyCategory); _db.SaveChanges(); } } if (null == model.PartnerType) { company.PartnerType = "PLP"; } else { company.PartnerType = "MVPLP"; } if (!string.IsNullOrEmpty(model.CompanyLogo)) { company.Company_Logo = Path.Combine(Server.MapPath("~/Uploads/"), model.CompanyLogo); } else { company.Company_Logo = ""; } //_db.Entry(company).State = EntityState.Modified; //_db.SaveChanges(); } return(Json("Success", JsonRequestBehavior.AllowGet)); }