public Response <RfpProduct> Add(RfpProduct item, string user) { try { item.prd_key = Guid.NewGuid(); DynamicParameters _params = new DynamicParameters(); _params.Add("@prd_key", item.prd_key.ToString(), DbType.String); _params.Add("@prd_org_key", item.prd_org_key.ToString(), DbType.String); _params.Add("@prd_name", item.prd_name, DbType.String); _params.Add("@prd_type", item.prd_type, DbType.Int32); _params.Add("@prd_subtype", item.prd_subtype, DbType.Int32); _params.Add("@prd_description", item.prd_description, DbType.String); _params.Add("@prd_benefits", item.prd_benefits, DbType.String); _params.Add("@prd_use_cases", item.prd_use_cases, DbType.String); _params.Add("@prd_pricing", item.prd_pricing, DbType.String); _params.Add("@prd_features", item.prd_features, DbType.String); _params.Add("@prd_website", item.prd_website, DbType.String); _params.Add("@prd_target_users", item.prd_target_users, DbType.String); _params.Add("@prd_add_date", item.prd_add_date, DbType.DateTime); _params.Add("@prd_add_user", item.prd_add_user, DbType.String); _params.Add("@success", DbType.Boolean, direction: ParameterDirection.Output); var result = _dBConnection.Execute("USP_Rfp_Product_Add", _params, null, null, CommandType.StoredProcedure); return(new Response <RfpProduct>(item) { Success = _params.Get <Int32>("success") == 1? true : false }); } catch (Exception ex) { throw ex; } }
// GET: Product/Create public ActionResult Create() { var model = new RfpProduct(); ViewData["Types"] = _productTypeFacade.GetAll(); ViewData["Orgs"] = _organizationFacade.GetAll(); return(View(model)); }
public ActionResult Edit(RfpProduct model) { ViewData["Types"] = _productTypeFacade.GetAll(); //ViewData["Orgs"] = _organizationFacade.GetAll(); if (model.RACIContactList == null) { model.RACIContactList = new List <ContactRACI>(); } List <ContactRACI> existing_raci_contacts = _contactFacade.GetRACIContacts(new RACIFilter { Org_key = CurrentUser.User.org_key, prd_key = model.prd_key.ToString() }); var resp_contact = model.RACIContactList.FirstOrDefault(p => p.lk5_key.ToString() == "5592b25d-d98a-4914-9c8e-ac28d6c11116"); if (resp_contact == null) { ModelState.AddModelError("", "Please add team member with 'Responsible' role."); } try { if (ModelState.IsValid) { model.prd_change_date = DateTime.Now; model.prd_org_key = CurrentUser.User.org_key; var response = _productFacade.Update(model, string.Empty); if (response.Success) { // Delete removed contacts from RACI. if (existing_raci_contacts != null && existing_raci_contacts.Count > 0) { foreach (var item in existing_raci_contacts) { _contactFacade.Delete_RACI_Contact(item.ct_key.ToString(), null, model.prd_key.ToString()); } } // Save added contacts to RACI. foreach (var contact in model.RACIContactList) { _contactFacade.Add_RACI_Contact(contact.lk5_key.ToString(), contact.ct_key.ToString(), null, model.prd_key.ToString(), CurrentUser.User.ct_key.ToString()); } } } else { return(View(model)); } return(RedirectToAction("", "Product")); } catch { return(View(model)); } }
public ActionResult Create(RfpProduct model) { ViewData["Types"] = _productTypeFacade.GetAll(); //ViewData["Orgs"] = _organizationFacade.GetAll(); var resp_contact = model.RACIContactList.FirstOrDefault(p => p.lk5_key.ToString() == "5592b25d-d98a-4914-9c8e-ac28d6c11116"); if (resp_contact == null) { ModelState.AddModelError("", "Please add team member with 'Responsible' role."); } try { if (ModelState.IsValid) { model.prd_add_date = DateTime.Now; model.prd_org_key = CurrentUser.User.org_key; var response = _productFacade.Add(model, CurrentUser.User.ct_key.ToString()); if (response.Success) { // Save added contacts to RACI. foreach (var contact in model.RACIContactList) { _contactFacade.Add_RACI_Contact(contact.lk5_key.ToString(), contact.ct_key.ToString(), null, model.prd_key.ToString(), CurrentUser.User.ct_key.ToString()); } } } else { return(View(model)); } return(RedirectToAction("", "Product")); } catch { return(View(model)); } }
public Response <RfpProduct> Update(RfpProduct item, string user) { return(_productRepositoryDAC.Update(item, user)); }
public Response <RfpProduct> Add(RfpProduct item, string user) { return(_productRepositoryDAC.Add(item, user)); }