public List <DistrictData> GetLQASData()
{
List <DistrictData> list = new List <DistrictData>();
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["DTA"].ConnectionString);//connectionString
con.Open();
using (con)
{
using (var command = con.CreateCommand())
{
command.CommandText = "SELECT * FROM Coverage_district";
using (var reader = command.ExecuteReader())
{
var indexOfCol1 = reader.GetOrdinal("Id");
var indexOfCol2 = reader.GetOrdinal("Region");
var indexOfCol3 = reader.GetOrdinal("Year");
var indexOfCol4 = reader.GetOrdinal("Round");
var indexOfCol5 = reader.GetOrdinal("TypeOfCampaign");
var indexOfCol6 = reader.GetOrdinal("TargetPop");
var indexOfCol7 = reader.GetOrdinal("PercVacCoverage");
var indexOfCol8 = reader.GetOrdinal("MissedChildren");
var indexOfCol9 = reader.GetOrdinal("PercRecovDay1");
var indexOfCol10 = reader.GetOrdinal("PercRecovDay2");
var indexOfCol11 = reader.GetOrdinal("PercRecovDay3");
var indexOfCol13 = reader.GetOrdinal("PercRecovDay5");
var indexOfCol14 = reader.GetOrdinal("PercNSSRecovered");
var indexOfCol15 = reader.GetOrdinal("Location");
var indexOfCol16 = reader.GetOrdinal("ParentId");
var indexOfCol17 = reader.GetOrdinal("Province");
while (reader.Read())
{
DistrictData obj = new DistrictData();
obj.Id = Convert.ToInt32(reader.GetValue(indexOfCol1));
obj.Region = reader.GetValue(indexOfCol2).ToString();
obj.Year = Convert.ToInt32(reader.GetValue(indexOfCol3));
obj.Round = reader.GetValue(indexOfCol4).ToString();
obj.TypeOfCampaign = reader.GetValue(indexOfCol5).ToString();
obj.TargetPop = Convert.ToInt64(reader.GetValue(indexOfCol6));
obj.PercVacCoverage = Convert.ToDouble(reader.GetValue(indexOfCol7));
obj.MissedChildren = Convert.ToInt64(reader.GetValue(indexOfCol8));
obj.PercRecovDay1 = Convert.ToDouble(reader.GetValue(indexOfCol9));
obj.PercRecovDay2 = Convert.ToDouble(reader.GetValue(indexOfCol10));
obj.PercRecovDay3 = Convert.ToDouble(reader.GetValue(indexOfCol11));
obj.PercRecovDay5 = Convert.ToDouble(reader.GetValue(indexOfCol13));
obj.PercNSSRecovered = Convert.ToDouble(reader.GetValue(indexOfCol14));
obj.Location = reader.GetValue(indexOfCol15).ToString();
obj.ParentId = reader.GetValue(indexOfCol16).ToString();
obj.Province = reader.GetValue(indexOfCol17).ToString();
//Need to read value from correct column index
obj.ParentId = (reader.GetValue(indexOfCol16).ToString() == "") ? null : reader.GetValue(indexOfCol16).ToString();
list.Add(obj);
}
reader.Close();
}
}
con.Close();
}
return(list);
}