public async Task <int> Count(string search)
{
var totSchool = await Task.FromResult(_dapper.Get <int>($"select COUNT(*) from [Schools] WHERE SchoolName like '%{search}%'", null,
commandType: CommandType.Text));
return(totSchool);
}
public IEnumerable <Vendors> GetVendors()
{
//var vendors = dapper.Get<Vendors>(StoredProcedures.GetVendors,null,null,true,null,System.Data.CommandType.StoredProcedure);
try
{
var vendors = dapper.Get <Vendors>("select * from VendorDetails with (nolock)", null, null, true, null, System.Data.CommandType.Text);
return(vendors);
}
catch (Exception ex) {
ex.Data["MethodAndClass"] = "GetVendors() in VendorRepository";
throw ex;
}
}
public IEnumerable <int> GetSunGrowPlants()
{
try
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@FromTable", "SunGrowPlantInformation");
parameters.Add("@ColumnName", "PowerStationId");
var plants = dapper.Get <SunGrowPlantInformation>(StoredProcedures.GetPlants, parameters, null, true, null, System.Data.CommandType.StoredProcedure);
return(plants.Select(x => x.PowerStationId));
}
catch (Exception ex) {
ex.Data["MethodAndClass"] = "GetSunGrowPlants() in SunGrowRepository";
throw ex;
}
}
public IEnumerable <PlantInformation> GetGoodWeePlants()
{
try
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@FromTable", "PlantInformation");
parameters.Add("@ColumnName", "PlantId,CreatedTime");
var plants = dapper.Get <PlantInformation>(StoredProcedures.GetPlants, parameters, null, true, null, System.Data.CommandType.StoredProcedure);
return(plants);
}
catch (Exception ex)
{
ex.Data["MethodAndClass"] = "GetGoodWeePlants() in GoodWeeRepository";
throw ex;
}
}
