public ActionResult AddVendorPlan(VendorPlansViewModel data) { IPlansBL planBL = new PlansEngine(); ResponseOut responseOut = new ResponseOut(); try { if (data.pk_vendor_plan_id == 0) { responseOut = planBL.AddVendorPlans(data); } else { responseOut = planBL.UpdateVendorPlans(data); } } catch (Exception ex) { Log.Error("Error in PlansController/AddVendorPlan", ex); responseOut.message = ActionMessage.ApplicationException; responseOut.status = ActionStatus.Fail; } return(Json(responseOut, JsonRequestBehavior.AllowGet)); }
public ResponseOut AddVendorPlans(VendorPlansViewModel model) { string temp_country_name = ""; string temp_state_name = ""; string temp_city_name = ""; ResponseOut responseOut = new ResponseOut(); try { using (PortalEntities _context = new PortalEntities()) { if (!string.IsNullOrEmpty(model.country_listing)) { var country_names = model.country_listing.Split(','); foreach (var c_id in country_names) { temp_country_name += _context.portal_country.AsEnumerable().Where(x => x.pk_country_id == Convert.ToInt32(c_id)).Select(x => x.country_name).FirstOrDefault() + ","; } if (!string.IsNullOrEmpty(temp_country_name)) { temp_country_name = temp_country_name.Remove(temp_country_name.Length - 1, 1); } } if (!string.IsNullOrEmpty(model.state_listing)) { var country_names = model.state_listing.Split(','); foreach (var s_id in country_names) { temp_state_name += _context.portal_state.AsEnumerable().Where(x => x.pk_state_id == Convert.ToInt32(s_id)).Select(x => x.state_name).FirstOrDefault() + ","; } if (!string.IsNullOrEmpty(temp_state_name)) { temp_state_name = temp_state_name.Remove(temp_state_name.Length - 1, 1); } } if (!string.IsNullOrEmpty(model.city_listing)) { var country_names = model.city_listing.Split(','); foreach (var c_id in country_names) { temp_city_name += _context.portal_city.AsEnumerable().Where(x => x.pk_city_id == Convert.ToInt32(c_id)).Select(x => x.city_name).FirstOrDefault() + ","; } if (!string.IsNullOrEmpty(temp_city_name)) { temp_city_name = temp_city_name.Remove(temp_city_name.Length - 1, 1); } } model.country_listing_names = temp_country_name; model.state_listing_names = temp_state_name; model.city_listing_names = temp_city_name; portal_vendor_plan plan = new portal_vendor_plan(); plan.is_active = model.is_active; plan.is_deleted = false; plan.lead_access_limit = model.lead_access_limit; plan.candidate_listing_limit = model.candidate_listing_limit; plan.technology_count = model.technology_limit; plan.interest_recived_limit = model.interest_received_limit; plan.fk_plan_id = model.fk_plan_id; plan.added_date = DateTime.Now; plan.per_technology_count = model.per_technology_limit; plan.country_listing = model.country_listing; plan.state_listing = model.state_listing; plan.city_listing = model.city_listing; plan.country_listing_names = model.country_listing_names; plan.state_listing_names = model.state_listing_names; plan.city_listing_names = model.city_listing_names; plan.custom_plan_price = model.plan_price; plan.plan_duration_type = model.plan_duration_type; plan.fk_role_id = model.user_role_id; plan.bold_listing = model.bold_listing; plan.top_ranking = model.top_ranking; _context.portal_vendor_plan.Add(plan); int result = _context.SaveChanges(); if (result > 0) { responseOut.status = ActionStatus.Success; responseOut.message = ActionMessage.PlansCreatedSuccess; } } } catch (Exception ex) { responseOut.status = ActionStatus.Fail; responseOut.message = ActionMessage.ApplicationException; } return(responseOut); }