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);
}
