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