public Response <RfpScoreRule> Add(RfpScoreRule item, string user)
{
try
{
item.eva_key = Guid.NewGuid();
DynamicParameters _params = new DynamicParameters();
_params.Add("@eva_key", item.eva_key, DbType.Guid);
_params.Add("@eva_rfs_key", item.eva_rfs_key, DbType.Guid);
_params.Add("@eva_rfp_key", item.eva_rfp_key, DbType.Guid);
_params.Add("@eva_criteria_name", item.eva_criteria_name, DbType.String);
_params.Add("@eva_criteria_description", item.eva_criteria_description, DbType.String);
_params.Add("@eva_score_method", item.eva_score_method, DbType.String);
_params.Add("@eva_point_max", item.eva_point_max, DbType.Int32);
_params.Add("@eva_weight", item.eva_weight, DbType.Decimal);
_params.Add("@eva_add_user", user, DbType.String);
_params.Add("@success", DbType.Boolean, direction: ParameterDirection.Output);
var result = _dBConnection.Execute("USP_Rfp_ScoreRules_Add", _params, null, null, CommandType.StoredProcedure);
return(new Response <RfpScoreRule>(item)
{
Success = _params.Get <Int32>("success") == 1 ? true : false
});
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult SaveCriteria(RfpScoreRule score_rule)
{
var response = new AppResponseModel <bool>();
try
{
if (score_rule.eva_key == null)
{
score_rule.eva_key = Guid.NewGuid();
var result = _rfpScoreRuleFacade.Add(score_rule, CurrentUser.User.ct_key.ToString());
if (result.Success)
{
response.IsSuccess = true;
response.Data = true;
response.Message = "Score rule saved successfully!";
return(Json(response, JsonRequestBehavior.AllowGet));
}
}
else
{
var score_list = _rfpScoreRuleFacade.GetWhere($"rfp_score_rules.eva_key='{score_rule.eva_key.ToString()}'");
if (score_list != null && score_list.Count > 0 && score_list[0].eva_key == score_rule.eva_key)
{
RfpScoreRule temp_score_rule = score_list[0];
temp_score_rule.eva_change_user = CurrentUser.User.ct_key.ToString();
temp_score_rule.eva_criteria_name = score_rule.eva_criteria_name;
temp_score_rule.eva_criteria_description = score_rule.eva_criteria_description;
temp_score_rule.eva_point_max = score_rule.eva_point_max;
temp_score_rule.eva_weight = score_rule.eva_weight;
var result = _rfpScoreRuleFacade.Update(temp_score_rule, CurrentUser.User.ct_key.ToString());
if (result.Success)
{
response.IsSuccess = true;
response.Data = true;
response.Message = "Score rule saved successfully!";
return(Json(response, JsonRequestBehavior.AllowGet));
}
}
}
response.IsSuccess = false;
response.Message = "Could not saved Score rule!";
return(Json(response, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
response.IsSuccess = false;
response.Message = Messages.ServerError;
return(Json(response, JsonRequestBehavior.AllowGet));
}
}
public Response <RfpScoreRule> Update(RfpScoreRule item, string user)
{
return(_scoreRuleRepositoryDAC.Update(item, user));
}
public Response <RfpScoreRule> Add(RfpScoreRule item, string user)
{
return(_scoreRuleRepositoryDAC.Add(item, user));
}
