public JsonResult SaveAccountParameters(AccountParameterJson data)
{
List <AccountParametersModel> Jsonlist = new List <AccountParametersModel>();
string errormessage = "Error Occured";
try
{
int NoOfParameters = data.Paramters.Length;
for (int i = 0; i < NoOfParameters; i++)
{
AccountParametersModel Parameter = new AccountParametersModel();
Parameter.ParamID = data.Paramters[i];
Parameter.Quarter = data.Quarter;
Parameter.AccountID = data.ProjectId;
Parameter.Year = data.Year;
AccountParams.AddAccountParam(Parameter);
Jsonlist.Add(Parameter);
}
}
catch (Exception ex)
{
logger.Error(ex.InnerException);
logger.Error(ex.Message);
logger.Error(ex.Source);
return(Json(errormessage, JsonRequestBehavior.AllowGet));
}
return(Json(Jsonlist, JsonRequestBehavior.AllowGet));
}
public List <ParamaterBoundsModel> CopyPreviousParameterBounds(AccountParametersModel parameter)
{
List <AccountParametersModel> parameters = Parmservice.GetAccountParameters(parameter.AccountID, parameter.Quarter, parameter.Year);
int paramid = Parmservice.GetParameter(parameter.AccountParamID).ParamID;
AccountParametersModel AccountParamId = (from id in parameters where id.ParamID == paramid select id).SingleOrDefault();
List <ParamaterBoundsModel> bounds = GetBounds(AccountParamId.AccountParamID);
return(bounds);
}
public bool AddAccountParam(AccountParametersModel AccountParameter)
{
if (AccountParameterDal.AddAccountParameter(AccountParametersModelToEntityMapper(AccountParameter)))
{
logger.Info("AccountParam Added" + AccountParameter.ToString());
return(true);
}
else
{
logger.Info("Exception Thrown" + AccountParameter.ToString());
}
return(false);
}
public void SaveWeightage(AccountParametersModel data)
{
try
{
AccountParams.UpdateParameterWeightage(data.AccountParamID, Convert.ToInt32(data.Weightage));
}
catch (Exception ex)
{
logger.Error(ex.InnerException);
logger.Error(ex.Message);
logger.Error(ex.Source);
}
}
public JsonResult GetWeightage(AccountParametersModel parameter)
{
string weightage = null;
try
{
weightage = AccountParams.GetParameter(parameter.AccountParamID).Weightage;
}
catch (Exception ex) {
logger.Error(ex.InnerException);
logger.Error(ex.Message);
logger.Error(ex.Source);
}
return(Json(weightage, JsonRequestBehavior.AllowGet));
}
public JsonResult GetQuarters(AccountParametersModel Account)
{
string response;
string[] Quarters = AccountParams.GetQuarters(Account.AccountID, Account.Year);
if (Quarters != null)
{
return(Json(Quarters, JsonRequestBehavior.AllowGet));
}
else
{
response = "Please Select the parameters";
}
return(Json(response, JsonRequestBehavior.AllowGet));
}
public JsonResult CopyPreviousParameterBounds(AccountParametersModel parameter)
{
List <ParamaterBoundsModel> bounds = null;
try
{
bounds = ParameterBounds.CopyPreviousParameterBounds(parameter);
}
catch (Exception ex) {
logger.Error(ex.InnerException);
logger.Error(ex.Message);
logger.Error(ex.Source);
}
return(Json(bounds, JsonRequestBehavior.AllowGet));
}
public JsonResult GetAccountParameters(AccountParametersModel Param)
{
List <AccountParametersModel> Parameters = null;
try
{
Parameters = AccountParams.GetAccountParameters(Param.AccountID, Param.Quarter, Param.Year);
}
catch (Exception ex)
{
logger.Error(ex.InnerException);
logger.Error(ex.Message);
logger.Error(ex.Source);
return(Json("Error Occured", JsonRequestBehavior.AllowGet));
}
return(Json(Parameters, JsonRequestBehavior.AllowGet));
}
public JsonResult GetQuarterJson(AccountParametersModel Account)
{
List <Object> list = new List <Object>();
try
{
string[] arr = AccountParams.GetQuarters(Account.AccountID, Account.Year);
for (int i = 0; i < arr.Length; i++)
{
var obj = new { Quarter = arr[i] };
list.Add(obj);
}
}
catch (Exception ex) {
logger.Error(ex.InnerException);
logger.Error(ex.Message);
logger.Error(ex.Source);
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
public JsonResult GetFinalScore(AccountParametersModel Param)
{
return(Json(ScoreCalculator.AccountKraScoreYearly(Param.AccountID, Param.Year), JsonRequestBehavior.AllowGet));
}
public DataTable GetScoresDataTable(int AccountId, int Year)
{
DataTable scorestable = new DataTable();
scorestable.Columns.Add("Parameter Name");
scorestable.Columns.Add("Weightage");
scorestable.Columns.Add("Q1");
scorestable.Columns.Add("Q2");
scorestable.Columns.Add("Q3");
scorestable.Columns.Add("Q4");
try
{
string[] Quarters = AccountParams.GetQuarters(AccountId, Year);
List <AccountParametersModel> Parameters = AccountParams.GetParameters(AccountId, Year);
List <CalculatedScoreYear> list = new List <CalculatedScoreYear>();
foreach (var items in Parameters)
{
CalculatedScoreYear ob = new CalculatedScoreYear();
ob.ParameterName = items.ParameterName;
ob.Weightage = Convert.ToInt32(items.Weightage);
ob.Score = new float[Quarters.Length];
for (int i = 0; i < Quarters.Length; i++)
{
AccountParametersModel parameter =
AccountParams.GetParameter(AccountId, items.ParamID, Quarters[i], Year);
if (parameter != null)
{
KraInputScores score = InputScores.GetScores(parameter.AccountParamID);
if (score != null)
{
ob.Score[i] = score.Score;
}
else
{
ob.Score[i] = 0;
}
}
else
{
ob.Score[i] = 0;
}
}
list.Add(ob);
}
foreach (var items in list)
{
int size = items.Score.Length;
if (size == 1)
{
scorestable.Rows.Add(items.ParameterName, items.Weightage, items.Score[0]);
}
else if (size == 2)
{
scorestable.Rows.Add(items.ParameterName, items.Weightage, items.Score[0], items.Score[1]);
}
else if (size == 3)
{
scorestable.Rows.Add(items.ParameterName, items.Weightage, items.Score[0], items.Score[1], items.Score[2]);
}
else if (size == 4)
{
scorestable.Rows.Add(items.ParameterName, items.Weightage, items.Score[0], items.Score[1], items.Score[2], items.Score[3]);
}
}
}
catch (Exception ex)
{
logger.Error(ex.ToString());
logger.Error(ex.Message);
logger.Error(ex.Source);
scorestable = null;
}
return(scorestable);
}
public JsonResult GetParameterBounds(AccountParametersModel Parameter)
{
List <ParamaterBoundsModel> bounds = ParameterBounds.GetBounds(Parameter.AccountParamID);
return(Json(bounds, JsonRequestBehavior.AllowGet));
}
public AccountParametersModel GetParameter(int AccountId, int ParamId, string Quarter, int Year)
{
AccountParametersModel parameter = AccountParametersEntityModelMapper(AccountParameterDal.GetParameter(AccountId, ParamId, Quarter, Year));
return(parameter);
}
public AccountParametersModel GetParameter(int AccountParameterId)
{
AccountParametersModel parameter = AccountParametersEntityModelMapper(AccountParameterDal.GetParameter(AccountParameterId));
return(parameter);
}
