public IEnumerable <AfterActionReportView> List() { try { using (AfterActionReportRepository aarRepo = new AfterActionReportRepository()) { return(aarRepo.GetList <AfterActionReportView>()); } } catch (Exception ex) { throw ex; } }
public IEnumerable <AfterActionReportView> GetAllAARsBySubsId(int subsId) { try { using (AfterActionReportRepository aarRepo = new AfterActionReportRepository()) { return(aarRepo.GetList <AfterActionReportView>(new { Subscriber_Id = subsId })); } } catch (Exception ex) { throw ex; } }
public bool Update(int SubscriberId, string UserName, AfterActionReport AARModel) { try { using (AfterActionReportRepository AARRepo = new AfterActionReportRepository()) { AARModel.LastModifiedOn = Common.GetLocalDateTime(MemCache.GetFromCache <string>("Timezone_" + SubscriberId)); AARModel.LastModifiedBy = UserName; AARRepo.Update <AfterActionReport>(AARModel); return(true); } } catch (Exception ex) { throw ex; } }
public AfterActionReportView GetById(int id) { try { using (AfterActionReportRepository AARRepo = new AfterActionReportRepository()) { AfterActionReportView AARViewModel = new AfterActionReportView(); { AARViewModel = AARRepo.Get <AfterActionReportView>(id); return(AARViewModel); } } } catch (Exception ex) { throw ex; } }
public AfterActionReportView Add(Subscriber SubsModel, string UserName, AfterActionReport AARModel) { try { using (AfterActionReportRepository aarRepo = new AfterActionReportRepository()) { AfterActionReportView aarView = new AfterActionReportView(); AARModel.AddressedTo = string.Join(",", AARModel.AddressedToArray); AARModel.ReportingDatetime = Common.GetLocalDateTime(MemCache.GetFromCache <string>("Timezone_" + SubsModel.SubscriberId)); AARModel.SubscriberId = SubsModel.SubscriberId; AARModel.CreatedOn = Common.GetLocalDateTime(MemCache.GetFromCache <string>("Timezone_" + SubsModel.SubscriberId)); AARModel.CreatedBy = UserName; int rowId = aarRepo.Insert(AARModel); return(aarView = GetById(rowId)); } } catch (Exception ex) { throw ex; } }
public bool Delete(int id) { try { using (AfterActionReportRepository AARRepo = new AfterActionReportRepository()) { var AARExisting = AARRepo.Get <AfterActionReport>(id); if (AARExisting == null) { return(false); } else { AARRepo.Delete <AfterActionReport>(id); return(true); } } } catch (Exception ex) { throw ex; } }
public DataTableModel ListPaged(Dictionary <string, string> dic = null) { try { string[] searchColumns = new string[] { "COI_Number", "Subscriber_Code", "PR_Number", "Remarks", "MMSI", "Latitude", "Longitude" }; DataTableModel dtModel = new DataTableModel(); Meta meta = new Meta(); if (dic.TryGetValue("pagination[page]", out string page)) { meta.page = Convert.ToInt64(page); } if (dic.TryGetValue("pagination[pages]", out string pages)) { meta.pages = Convert.ToInt64(pages); } if (dic.TryGetValue("pagination[perpage]", out string perpage)) { meta.perpage = Convert.ToInt64(perpage); } var parameters = this.ParseParameters(dic); using (AfterActionReportRepository aarRepo = new AfterActionReportRepository()) { dtModel.Data = aarRepo.GetListPaged <AfterActionReportView>(Convert.ToInt32(dic["pagination[page]"]), Convert.ToInt32(dic["pagination[perpage]"]), parameters, parameters["orderby"].ToString() + " " + parameters["sortorder"].ToString(), new string[] { "COI_Number", "PR_Number", "COI_Type_Name", "Threat_Name", "Info_Confidence_Level_Name", "Subscriber_Code", "Remarks" }); meta.total = aarRepo.RecordCount <AfterActionReportView>(parameters, searchColumns); } dtModel.Meta = meta; return(dtModel); } catch (Exception ex) { throw ex; } }