public static List <Dictionary <string, object> > QueryHospitalsByName(string searchText) { var records = SharedService.ExecuteGetSqlStoredProcedure("[bbu].[Hospital_queryhospitalbyname]", new List <SqlParameter> { new SqlParameter("@searchText", searchText) }); return(records); }
public static List <Dictionary <string, object> > QueryPaymentsByMemberId(Guid memberId) { var records = SharedService.ExecuteGetSqlStoredProcedure("[bbu].[Payment_querypaymentsbymemberid]", new List <SqlParameter> { new SqlParameter("@memberId", memberId), }); return(records); }
public static Dictionary <string, object> QueryDocumentById(Guid documentId) { var record = SharedService.ExecuteGetSqlStoredProcedure("[bbu].[Document_querydocumentbyid]", new List <SqlParameter> { new SqlParameter("@id", documentId), }); return(record[0]); }
public static List <Dictionary <string, object> > QueryActiveDeceaseds(int pageNumber, int listType) { var records = SharedService.ExecuteGetSqlStoredProcedure("[bbu].[Deceased_queryactivedeceaseds]", new List <SqlParameter> { new SqlParameter("@pagenumber", pageNumber), new SqlParameter("@listtype", listType), }); return(records); }
public static List <Dictionary <string, object> > QueryFuneralBoughtItemsByFuneralId(Guid funeralId) { var records = SharedService.ExecuteGetSqlStoredProcedure( "[bbu].[Funeralboughtitem_queryfuneralboughtitembyfuneralid]", new List <SqlParameter> { new SqlParameter("@funeralId", funeralId), }); return(records); }
public static Dictionary <string, object> QueryMemberById(Guid memberId) { var records = SharedService.ExecuteGetSqlStoredProcedure("[bbu].[Member_querymemberbyid]", new List <SqlParameter> { new SqlParameter("@id", memberId) }); if (records != null && records.Count == 1) { return(records[0]); } return(null); }
public static Dictionary <string, object> QueryNextOfKinByFuneralId(Guid funeralId) { var records = SharedService.ExecuteGetSqlStoredProcedure("[bbu].[NextOfKin_querynextofkinbyfuneralid]", new List <SqlParameter> { new SqlParameter("@funeralId", funeralId), }); if (records != null && records.Count == 1) { return(records[0]); } return(null); }
public static Dictionary <string, object> QueryHospitalById(Guid hosptitalId) { var records = SharedService.ExecuteGetSqlStoredProcedure("[bbu].[Hospital_queryhospitalbyid]", new List <SqlParameter> { new SqlParameter("@id", hosptitalId), }); if (records != null && records.Count == 1) { return(records[0]); } return(null); }
public static Dictionary <string, object> QueryInformantById(Guid informantId) { var records = SharedService.ExecuteGetSqlStoredProcedure("[bbu].[Informant_queryinformantbyid]", new List <SqlParameter> { new SqlParameter("@id", informantId), }); if (records != null && records.Count == 1) { return(records[0]); } return(null); }
public static Dictionary <string, object> GetNextNumber(string entityName) { var records = SharedService.ExecuteGetSqlStoredProcedure("[bbu].[Numberconfiguration_querybyentityname]", new List <SqlParameter> { new SqlParameter("@entityName", entityName) }); if (records != null && records.Count == 1) { return(records[0]); } return(null); }
public static Dictionary <string, object> QueryDeceasedById(Guid deceasedId) { var records = SharedService.ExecuteGetSqlStoredProcedure("[bbu].[Deceased_querydeceasedbyid]", new List <SqlParameter> { new SqlParameter("@id", deceasedId), }); if (records != null && records.Count == 1) { return(records[0]); } return(null); }
public static Dictionary <string, object> QueryHomeAffairsOfficerByFuneralId(Guid funeralId) { var records = SharedService.ExecuteGetSqlStoredProcedure( "[bbu].[Homeaffairsofficer_queryhomeaffairsofficerbyfuneralid]", new List <SqlParameter> { new SqlParameter("@funeralId", funeralId), }); if (records != null && records.Count == 1) { return(records[0]); } return(null); }
public static Dictionary <string, object> QueryCredentialByUsernameByPassword(string username, string password) { var records = SharedService.ExecuteGetSqlStoredProcedure( "[bbu].[Credential_querycredentialbyusernamebypassword]", new List <SqlParameter> { new SqlParameter("@username", username), new SqlParameter("@password", Encrypt(password)) }); if (records != null && records.Count == 1) { return(records[0]); } return(null); }
public static int QueryCountOfDoctorsByFuneralId(Guid funeralId) { var records = SharedService.ExecuteGetSqlStoredProcedure("[bbu].[Doctor_querycountofdoctorsbyfuneralid]", new List <SqlParameter> { new SqlParameter("@funeralId", funeralId), }); if (records != null && records.Count == 1) { var count = records[0].FirstOrDefault(x => x.Key == "Count").Value; if (count == null) { return(-1); } else { return((int)count); } } return(-1); }
public static List <Dictionary <string, object> > QueryActiveMonths() { var records = SharedService.ExecuteGetSqlStoredProcedure("[bbu].[Paymentperiod_queryactivepaymentperiods]", null); return(records); }