public ActionResult SearchModel()
{
try
{
var orgId = LookUps.GetOrgId(User.Identity.Name);
if (orgId == 0)
{
orgId = Settings.Default.DefaultOrgId;
}
var model = new SearchModel()
{
OrgId = orgId,
// ModelData = _unitOfWork.PaidDataRepository.GetResultReport(orgId)
OrgLookUp = LookUps.OrganisationById(orgId),
CobLookUp = LookUps.ClassOfBusiness(),
TypeOfLossLookUp = LookUps.TypeOfLoss(),
};
// ModelData = _unitOfWork.PaidDataRepository.ExecWithStoreProcedure(
// "rModelViewByOrg @orgId",
//new SqlParameter("orgId", SqlDbType.Int) { Value = orgId })
return(View(model));
}
catch (Exception ex)
{
// Log with Elmah
ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
}
public ActionResult Create(InflationRateModel model)
{
try
{
if (TypeNameExist(model.Entity.OrgID ?? 0, model.Entity.InflationYear ?? 0, model.Entity.ID))
{
ModelState.AddModelError("", "Inflation Rate Already Exist");
}
if (ModelState.IsValid)
{
var certGrade = model.Entity;
certGrade.ModifiedBy = User.Identity.Name;
certGrade.ModifiedDate = DateTime.Now;
certGrade.CreatedBy = User.Identity.Name;
certGrade.CreatedDate = DateTime.Now;
_unitOfWork.InflationRateRepository.Insert(certGrade);
_unitOfWork.Save();
TempData["message"] = "<b>" + certGrade.InflationYear + "</b> was successfully created";
return(RedirectToAction("Index", new { orgId = model.Entity.OrgID }));
}
model.OrgLookUp = LookUps.OrganisationById(model.Entity.OrgID ?? 0);
return(View(model));
}
catch (Exception ex)
{
// Log with Elmah
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
}
public void LookUpsTest()
{
LookUps lookUps = new LookUps();
lookUps.SetupTest();
lookUps.TheLookUpsTest();
lookUps.TeardownTest();
}
public ActionResult Edit(OutstandingDataModel model)
{
try
{
if (ModelState.IsValid)
{
var certGrade = model.Entity;
certGrade.ModifiedBy = User.Identity.Name;
certGrade.ModifiedDate = DateTime.Now;
certGrade.LossYear = certGrade.DateOfLoss.GetValueOrDefault().Year;
_unitOfWork.OutstandingDataRepository.Update(certGrade);
_unitOfWork.Save();
TempData["message"] = "<b>" + certGrade.ClaimNo + "</b> was successfully updated";
return(RedirectToAction("Index", new { orgId = model.Entity.ID }));
}
model.OrgLookUp = LookUps.OrganisationById(model.Entity.OrgID ?? 0);
model.CobLookUp = LookUps.ClassOfBusiness();
model.TypeOfLossLookUp = LookUps.TypeOfLoss();
return(View(model));
}
catch (Exception ex)
{
// Log with Elmah
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
}
public ActionResult Edit(int id = 0)
{
try
{
var certGrade = _unitOfWork.InflationRateRepository.GetByID(id);
if (certGrade == null)
{
return(HttpNotFound());
}
var model = new InflationRateModel
{
Entity = certGrade,
OrgLookUp = LookUps.OrganisationById(certGrade.OrgID ?? 0),
OrgId = certGrade.OrgID ?? 0
};
return(View(model));
}
catch (Exception ex)
{
// Log with Elmah
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
}
public ActionResult Create(int orgId)
{
var model = new OrgClassOfBusinessModel();
model.OrgId = orgId;
model.CobLookUp = LookUps.ClassOfBusiness();
model.SelectedCob = unitOfWork.OrgClassOfBusinessRepository.Get(filter: x => x.OrgID == orgId).Select(x => x.BusinessClass).ToArray();
return(View(model));
}
public ActionResult Create(int orgId)
{
var model = new InflationRateModel
{
Entity = new InflationRate(),
OrgLookUp = LookUps.OrganisationById(orgId),
OrgId = orgId
};
return(View(model));
}
public ActionResult Create(int orgId)
{
var model = new EarnedPremiumModel
{
Entity = new EarnedPremium(),
OrgLookUp = LookUps.OrganisationById(orgId),
CobLookUp = LookUps.ClassOfBusiness(),
OrgId = orgId
};
return(View(model));
}
public ActionResult Create(int orgId)
{
var model = new PaidDataModel
{
Entity = new PaidData(),
OrgLookUp = LookUps.OrganisationById(orgId),
CobLookUp = LookUps.ClassOfBusiness(),
TypeOfLossLookUp = LookUps.TypeOfLoss(),
OrgId = orgId
};
return(View(model));
}
public ActionResult Index([DefaultValue(1)] int page, string keywords, [DefaultValue(10)] int pgsize)
{
try
{
var orgId = LookUps.GetOrgId(User.Identity.Name);
if (orgId == 0)
{
orgId = Settings.Default.DefaultOrgId;
}
List <InflationRate> rowsToShow;
int totalRecords;
if (!string.IsNullOrEmpty(keywords))
{
rowsToShow = _unitOfWork.InflationRateRepository.Get(filter: x => x.OrgID == orgId && x.Organisation.Name.ToUpper().Contains(keywords.Trim().ToUpper()), orderBy: q => q.OrderBy(x => x.ID)).Skip((page - 1) * pgsize).Take(pgsize).ToList();
totalRecords = _unitOfWork.InflationRateRepository.Get(filter: x => x.OrgID == orgId && x.Organisation.Name.ToUpper().Contains(keywords.Trim().ToUpper())).Count();
}
else
{
rowsToShow = _unitOfWork.InflationRateRepository.Get(filter: x => x.OrgID == orgId, orderBy: q => q.OrderBy(x => x.ID)).Skip((page - 1) * pgsize).Take(pgsize).ToList();
totalRecords = _unitOfWork.InflationRateRepository.Get(filter: x => x.OrgID == orgId, orderBy: q => q.OrderBy(x => x.ID)).Count();
}
var model = new InflationRateModel()
{
Rows = rowsToShow,
OrgId = orgId,
PagingInfo = new PagingInfo
{
FirstItem = ((page - 1) * pgsize) + 1,
LastItem = page * pgsize,
CurrentPage = page,
ItemsPerPage = pgsize,
TotalItems = totalRecords
},
CurrentKeywords = keywords,
PageSize = pgsize
};
return(View(model));
}
catch (Exception ex)
{
// Log with Elmah
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
}
public ActionResult Create(TypeOfLossThresholdModel model)
{
try
{
if (model.Entity.MaxValue <= model.Entity.MinValue)
{
ModelState.AddModelError("", "Please Make Sure Maximum Value is Higher than the Minimum Value");
}
if (ThresholdExist(model.Entity.OrgID ?? 0, model.Entity.ClassOfBusiness ?? 0, model.Entity.TypeOfLoss ?? 0, model.Entity.ID))
{
ModelState.AddModelError("", "Threshold Already Exist");
}
if (ValuesConflict(model.Entity.OrgID ?? 0, model.Entity.ClassOfBusiness ?? 0, model.Entity.MinValue ?? 0, model.Entity.MaxValue ?? 0, model.Entity.ID))
{
ModelState.AddModelError("", "Minimum and Maximum Values Conflict with existing setup for the selected Class of Business");
}
if (ModelState.IsValid)
{
var certGrade = model.Entity;
certGrade.ModifiedBy = User.Identity.Name;
certGrade.ModifiedDate = DateTime.Now;
certGrade.CreatedBy = User.Identity.Name;
certGrade.CreatedDate = DateTime.Now;
_unitOfWork.TypeOfLossThresholdRepository.Insert(certGrade);
_unitOfWork.Save();
TempData["message"] = "Type of Loss Threshold was successfully created";
return(RedirectToAction("Index", new { orgid = model.Entity.OrgID }));
}
model.OrgId = model.Entity.OrgID ?? 0;
model.OrgLookUp = LookUps.OrganisationById(model.Entity.OrgID ?? 0);
model.CobLookUp = LookUps.ClassOfBusiness();
model.TypeOfLossLookUp = LookUps.TypeOfLoss();
return(View(model));
}
catch (Exception ex)
{
// Log with Elmah
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
}
public ActionResult CreateExcel(ExcelUploadModel model)
{
try
{
if (ModelState.IsValid)
{
var excelReader = new PaidDataExcelReader();
//upload excel file
var result = excelReader.UploadCpExcelFile(model.ExcelFile);
if (result.Key)
{
//if upload is successfull insert the record into the the cpuploads
//if insert in ok process the excel file details
var processResult = excelReader.ProcessExcel(result.Value, model.OrgId, User.Identity.Name);
var sucessResult = "";
if (processResult.Key)
{
sucessResult = processResult.Value;
}
else
{
TempData["ExcelSummary"] = processResult.Value;
return(RedirectToAction("Index", new { orgid = model.OrgId }));
}
TempData["ExcelSummary"] = sucessResult;
return(RedirectToAction("Index", new { orgid = model.OrgId }));
}
else
{
TempData["ExcelSummary"] = result.Value;
return(RedirectToAction("Index", new { orgid = model.OrgId }));
}
}
model.OrgLookUp = LookUps.OrganisationById(model.OrgId);
return(View(model));
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index"));
}
}
public ActionResult CreateExcel(int orgId)
{
try
{
var model = new ExcelUploadModel {
OrgId = orgId, OrgLookUp = LookUps.OrganisationById(orgId)
};
return(View(model));
}
catch (Exception ex)
{
// Log with Elmah
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index"));
}
}
public ActionResult Create(PaidDataModel model)
{
try
{
if (ClaimExist(model.Entity.OrgID ?? 0, model.Entity.ClaimNo, model.Entity.ID))
{
ModelState.AddModelError("", "Claim Number Already Exist");
}
if (ModelState.IsValid)
{
var certGrade = model.Entity;
certGrade.ModifiedBy = User.Identity.Name;
certGrade.ModifiedDate = DateTime.Now;
certGrade.CreatedBy = User.Identity.Name;
certGrade.CreatedDate = DateTime.Now;
//calcualte dev period
certGrade.LossYear = certGrade.DateOfLoss.GetValueOrDefault().Year;
certGrade.PaidYear = certGrade.DateOfPayment.GetValueOrDefault().Year;
certGrade.DevPeriod = certGrade.PaidYear - certGrade.LossYear;
_unitOfWork.PaidDataRepository.Insert(certGrade);
_unitOfWork.Save();
TempData["message"] = "<b>" + certGrade.ClaimNo + "</b> was successfully created";
return(RedirectToAction("Index", new { orgid = model.Entity.OrgID }));
}
model.OrgLookUp = LookUps.OrganisationById(model.Entity.OrgID ?? 0);
model.CobLookUp = LookUps.ClassOfBusiness();
model.TypeOfLossLookUp = LookUps.TypeOfLoss();
return(View(model));
}
catch (Exception ex)
{
// Log with Elmah
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
}
//Task<TEntity> GetByIdAsync(string id );
public Task <int> AddAsync(LookUps entity)
{
throw new NotImplementedException();
}
public ActionResult SearchModel(SearchModel model)
{
try
{
if (model.EndYear <= model.StartYear)
{
ModelState.AddModelError("", "Please Make End Date is Higher than Start Date");
}
if (ModelState.IsValid)
{
// _unitOfWork.PaidDataRepository.UpdateHierarchy("rModelCummulativeSetUp @orgId, @startYear, @endYear,@cob,@losstype",
// new SqlParameter("orgId", SqlDbType.Int) { Value = model.OrgId },
// new SqlParameter("startYear", SqlDbType.Int) { Value = model.StartYear },
// new SqlParameter("endYear", SqlDbType.Int) { Value = model.EndYear },
// new SqlParameter("cob", SqlDbType.Int) { Value = model.ClassOfBusiness },
// new SqlParameter("losstype", SqlDbType.Int) { Value = model.LossType });
_unitOfWork.PaidDataRepository.UpdateHierarchy("GeneralSetUp @orgId, @startYear, @endYear,@cob,@losstype",
new SqlParameter("orgId", SqlDbType.Int)
{
Value = model.OrgId
},
new SqlParameter("startYear", SqlDbType.Int)
{
Value = model.StartYear
},
new SqlParameter("endYear", SqlDbType.Int)
{
Value = model.EndYear
},
new SqlParameter("cob", SqlDbType.Int)
{
Value = model.ClassOfBusiness
},
new SqlParameter("losstype", SqlDbType.Int)
{
Value = model.LossType
});
return(RedirectToAction("Index", new { orgid = model.OrgId, startYear = model.StartYear, endYear = model.EndYear, cob = model.ClassOfBusiness, losstype = model.LossType }));
}
// ModelData = _unitOfWork.PaidDataRepository.ExecWithStoreProcedure(
// "rModelViewByOrg @orgId",
//new SqlParameter("orgId", SqlDbType.Int) { Value = orgId })
model.OrgLookUp = LookUps.OrganisationById(model.OrgId);
model.CobLookUp = LookUps.ClassOfBusiness();
model.TypeOfLossLookUp = LookUps.TypeOfLoss();
return(View(model));
}
catch (Exception ex)
{
// Log with Elmah
ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
}
public ActionResult Index(int startYear, int endYear, int cob, int losstype)
{
try
{
//List<TypeOfLoss> rowsToShow;
var orgId = LookUps.GetOrgId(User.Identity.Name);
if (orgId == 0)
{
orgId = Settings.Default.DefaultOrgId;
}
var growthCurveData =
_unitOfWork.DevFactorRepository.Get(
filter:
x => x.OrgID == orgId && x.FactorName.Equals("Growth Curve", StringComparison.CurrentCultureIgnoreCase))
.ToList();
var chartCategory = growthCurveData.Select(a => a.DevPeriod.ToString()).ToList();
var chartData = growthCurveData.Select(x => x.FactorValue).Cast <object>().ToList();
var chart = new DotNet.Highcharts.Highcharts("chart")
.InitChart(new Chart {
Type = ChartTypes.Areaspline
})
.SetTitle(new Title {
Text = "Growth Curve"
})
.SetXAxis(new XAxis
{
Categories = chartCategory.ToArray(),
})
.SetYAxis(new YAxis {
Title = new YAxisTitle {
Text = "Growth Curve Value"
}
})
.SetTooltip(new Tooltip {
Formatter = "function() { return ''+ this.x +': '+ this.y +' units'; }"
})
.SetCredits(new Credits {
Enabled = false
})
.SetPlotOptions(new PlotOptions {
Areaspline = new PlotOptionsAreaspline {
FillOpacity = 0.5
}
})
.SetSeries(new Series
{
Name = "Dev Period",
Data = new Data(chartData.ToArray()),
// Color = ColorTranslator.FromHtml("#89A54E"),
});
var model = new InsuranceModel()
{
OrgId = orgId,
Cob = cob,
LossType = losstype,
//LinkRatioData = _unitOfWork.PaidDataRepository.GetResultReport("LinkRatioView",
// new SqlParameter("@orgId", SqlDbType.Int) { Value = orgId },
// new SqlParameter("@cob", SqlDbType.Int) { Value = cob },
// new SqlParameter("@losstype", SqlDbType.Int) { Value = losstype }),
ModelData = _unitOfWork.PaidDataRepository.GetResultReport("rModelView",
orgId, cob, losstype),
ModelCummulativeData = _unitOfWork.PaidDataRepository.GetResultReport("rModelCummulativeView",
orgId, cob, losstype),
LinkRatioData = _unitOfWork.PaidDataRepository.GetResultReport("LinkRatioView",
orgId, cob, losstype),
DevFactor = _unitOfWork.PaidDataRepository.GetResultReport("DevFactView",
orgId, cob, losstype),
CurrentRatio = _unitOfWork.PaidDataRepository.GetResultReport("CurrentRatioView",
orgId, cob, losstype),
ProjectedData = _unitOfWork.PaidDataRepository.GetResultReport("rModelProjectedView",
orgId, cob, losstype),
UnwiddingData = _unitOfWork.PaidDataRepository.GetResultReport("rModelUnwiddingView",
orgId, cob, losstype),
ProjectedAmount = _unitOfWork.PaidDataRepository.GetResultReport("ProjectedAmountView",
orgId, cob, losstype),
TypeOfLoss = _unitOfWork.TypeOfLossRepository.GetByID(losstype),
ClassOfBusiness = _unitOfWork.ClassOfBusinessRepository.GetByID(cob),
Organisation = _unitOfWork.OrganisationRepository.GetByID(orgId),
StartYear = startYear,
EndYear = endYear,
GrowthCurveChart = chart
};
return(View(model));
}
catch (Exception ex)
{
// Log with Elmah
ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
}
public Task <bool> UpdateAsync(LookUps entity)
{
throw new NotImplementedException();
}
