public ResponseOut UpdatePlanByPlanIDByAdmin(int planId) { ResponseOut responseOut = new ResponseOut(); using (PortalEntities _context = new PortalEntities()) { try { portal_userplan_mapping portal_Userplan = null; portal_Userplan = _context.portal_userplan_mapping.Where(x => x.userplan_id == planId).FirstOrDefault(); if (portal_Userplan != null) { portal_Userplan.is_active = true; } int result = _context.SaveChanges(); if (result > 0) { responseOut.status = ActionStatus.Success; responseOut.message = ActionMessage.PlansSelectedSuccess; } } catch (EntityException ex) { responseOut.status = ActionStatus.Fail; responseOut.message = ActionMessage.ApplicationException; } catch (Exception ex) { responseOut.status = ActionStatus.Fail; responseOut.message = ActionMessage.ApplicationException; } } return(responseOut); }
public ResponseOut AddUpdateSelectPlanByVendor(int plan_id, int vendor_id) { ResponseOut responseOut = new ResponseOut(); try { using (PortalEntities _context = new PortalEntities()) { portal_userplan_mapping vendor_plan_mapping = null; vendor_plan_mapping = _context.portal_userplan_mapping.Where(x => x.user_id == vendor_id).FirstOrDefault(); if (vendor_plan_mapping != null) { vendor_plan_mapping.plan_id = plan_id; vendor_plan_mapping.is_active = false; } else { vendor_plan_mapping = new portal_userplan_mapping(); vendor_plan_mapping.user_id = vendor_id; vendor_plan_mapping.plan_id = plan_id; vendor_plan_mapping.plan_time = DateTime.Now; vendor_plan_mapping.is_active = false; _context.portal_userplan_mapping.Add(vendor_plan_mapping); } int result = _context.SaveChanges(); if (result > 0) { responseOut.status = ActionStatus.Success; responseOut.message = ActionMessage.PlansSelectedSuccess; } } } catch (Exception ex) { responseOut.status = ActionStatus.Fail; responseOut.message = ActionMessage.ApplicationException; } return(responseOut); }
public ResponseOut AddUpdateSelectPlanByCandidate(PlansViewModel model) { ResponseOut responseOut = new ResponseOut(); using (PortalEntities _context = new PortalEntities()) { try { portal_userplan_mapping portal_Userplan = null; portal_plan_duration_left portal_Plan_Duration_Left = _context.portal_plan_duration_left.Where(x => x.fk_user_id == model.pk_user_id).FirstOrDefault(); portal_vendor_plan portal_Vendor_Plan; portal_Vendor_Plan = _context.portal_vendor_plan.Where(x => x.pk_vendor_plan_id == model.pk_plan_id).FirstOrDefault(); if (portal_Plan_Duration_Left != null) { portal_Plan_Duration_Left.fk_plan_id = portal_Vendor_Plan.pk_vendor_plan_id; portal_Plan_Duration_Left.candidate_listing_limit = portal_Vendor_Plan.candidate_listing_limit; portal_Plan_Duration_Left.interest_recived_limit = portal_Vendor_Plan.interest_recived_limit; portal_Plan_Duration_Left.lead_access_limit = portal_Vendor_Plan.lead_access_limit; portal_Plan_Duration_Left.technology_limit = portal_Vendor_Plan.technology_limit; portal_Plan_Duration_Left.technology_count = portal_Vendor_Plan.technology_count; portal_Plan_Duration_Left.added_date = DateTime.Now; portal_Plan_Duration_Left.bold_listing = portal_Vendor_Plan.bold_listing; portal_Plan_Duration_Left.top_ranking = portal_Vendor_Plan.top_ranking; portal_Plan_Duration_Left.fk_user_id = model.pk_user_id; } else { portal_Plan_Duration_Left = new portal_plan_duration_left(); portal_Plan_Duration_Left.fk_plan_id = portal_Vendor_Plan.pk_vendor_plan_id; portal_Plan_Duration_Left.candidate_listing_limit = portal_Vendor_Plan.candidate_listing_limit; portal_Plan_Duration_Left.interest_recived_limit = portal_Vendor_Plan.interest_recived_limit; portal_Plan_Duration_Left.lead_access_limit = portal_Vendor_Plan.lead_access_limit; portal_Plan_Duration_Left.technology_limit = portal_Vendor_Plan.technology_limit; portal_Plan_Duration_Left.technology_count = portal_Vendor_Plan.technology_count; portal_Plan_Duration_Left.added_date = DateTime.Now; portal_Plan_Duration_Left.bold_listing = portal_Vendor_Plan.bold_listing; portal_Plan_Duration_Left.top_ranking = portal_Vendor_Plan.top_ranking; portal_Plan_Duration_Left.fk_user_id = model.pk_user_id; _context.portal_plan_duration_left.Add(portal_Plan_Duration_Left); } portal_Userplan = _context.portal_userplan_mapping.Where(x => x.user_id == model.pk_user_id).FirstOrDefault(); if (portal_Userplan != null) { portal_Userplan.plan_id = model.pk_plan_id; portal_Userplan.is_active = false; } else { portal_Userplan = new portal_userplan_mapping(); portal_Userplan.user_id = model.pk_user_id; portal_Userplan.plan_id = model.pk_plan_id; portal_Userplan.plan_time = DateTime.Now; portal_Userplan.is_active = false; _context.portal_userplan_mapping.Add(portal_Userplan); } int result = _context.SaveChanges(); if (result > 0) { responseOut.status = ActionStatus.Success; responseOut.message = ActionMessage.PlansSelectedSuccess; } } catch (EntityException ex) { responseOut.status = ActionStatus.Fail; responseOut.message = ActionMessage.ApplicationException; } catch (Exception ex) { responseOut.status = ActionStatus.Fail; responseOut.message = ActionMessage.ApplicationException; } } return(responseOut); }