public IEnumerable <AmplifyingReportView> List()
{
try
{
using (AmplifyingReportRepository ARRepo = new AmplifyingReportRepository())
{
return(ARRepo.GetList <AmplifyingReportView>());
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <AmplifyingReportView> GetByCOIId(int COIId)
{
try
{
using (AmplifyingReportRepository ARRepo = new AmplifyingReportRepository())
{
return(ARRepo.GetList <AmplifyingReportView>(new { COI_Id = COIId }).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <AmplifyingReportView> GetSubsARs(Subscriber subsModel)
{
try
{
using (AmplifyingReportRepository ARRepo = new AmplifyingReportRepository())
{
return(ARRepo.GetList <AmplifyingReportView>("WHERE Information_Addressee_Codes LIKE '%" + subsModel.SubscriberCode + "%'"));
}
}
catch (Exception ex)
{
throw ex;
}
}
public AmplifyingReportView Add(Subscriber SubsModel, string UserName, AmplifyingReport ARModel)
{
try
{
if (SubsModel == null)
{
throw new Exception("Subscriber model is null");
}
else if (ARModel == null)
{
throw new Exception("Preliminary report model is null");
}
using (AmplifyingReportRepository ARRepo = new AmplifyingReportRepository())
{
AmplifyingReportView ARView = new AmplifyingReportView();
string coiNumber = "";
List <AmplifyingReportView> lstARs = ARRepo.GetList <AmplifyingReportView>(new { COI_ID = ARModel.COIId }).ToList();
using (COIRepository coiRepo = new COIRepository())
{
coiNumber = coiRepo.Get <COI>(ARModel.COIId).COINumber;
}
string generatedARNo = coiNumber + "-AR-" + 1;
ARView = lstARs.OrderByDescending(x => x.ARId).FirstOrDefault();
if (ARView != null)
{
generatedARNo = Common.GetNextSubReportNumber(ARView.ARNumber);
}
ARModel.ARNumber = generatedARNo;
ARModel.ActionAddressee = string.Join(",", ARModel.ActionAddresseeArray);
ARModel.InformationAddressee = string.Join(",", ARModel.InformationAddresseeArray);
ARModel.ReportingDatetime = Common.GetLocalDateTime(MemCache.GetFromCache <string>("Timezone_" + SubsModel.SubscriberId));
ARModel.SubscriberId = SubsModel.SubscriberId;
ARModel.CreatedOn = Common.GetLocalDateTime(MemCache.GetFromCache <string>("Timezone_" + SubsModel.SubscriberId));
ARModel.CreatedBy = UserName;
int rowId = ARRepo.Insert(ARModel);
return(ARView = GetById(rowId));
}
}
catch (Exception ex)
{
throw ex;
}
}