public List <Polazak> RedVoznje(string linija, string smer, string dan, int vremeOd, int vremeDo)
{
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["GSPConnection"].ConnectionString);
if (vremeOd == -1 && vremeDo == -1)
{
SqlDataAdapter adapter = new SqlDataAdapter("listRedVoznjeByLinijaAndSmerAndDan", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.Parameters.Add(new SqlParameter("@Linija", SqlDbType.VarChar, 5));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@Smer", SqlDbType.Char, 1));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@Dan", SqlDbType.VarChar, 8));
adapter.SelectCommand.Parameters["@Linija"].Value = linija;
adapter.SelectCommand.Parameters["@Smer"].Value = smer;
adapter.SelectCommand.Parameters["@Dan"].Value = dan;
DataSet ds = new DataSet();
adapter.Fill(ds, "listRedVoznjeByLinijaAndSmerAndDan");
List <Polazak> lista = new List <Polazak>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Polazak p = new Polazak();
p.Vreme = ds.Tables[0].Rows[i]["Vreme"].ToString();
p.ID = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"].ToString());
p.LinijaStajalisteID = Convert.ToInt32(ds.Tables[0].Rows[i]["LinijaStajalisteID"].ToString());
lista.Add(p);
}
return(lista);
}
else
{
if (vremeDo == -1)
{
vremeDo = 24;
}
SqlDataAdapter adapter = new SqlDataAdapter("listRedVoznjeByVreme", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.Parameters.Add(new SqlParameter("@Linija", SqlDbType.VarChar, 5));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@Smer", SqlDbType.Char, 1));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@Dan", SqlDbType.VarChar, 8));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@VremeOd", SqlDbType.Int));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@VremeDo", SqlDbType.Int));
adapter.SelectCommand.Parameters["@Linija"].Value = linija;
adapter.SelectCommand.Parameters["@Smer"].Value = smer;
adapter.SelectCommand.Parameters["@Dan"].Value = dan;
adapter.SelectCommand.Parameters["@VremeOd"].Value = vremeOd;
adapter.SelectCommand.Parameters["@VremeDo"].Value = vremeDo;
DataSet ds = new DataSet();
adapter.Fill(ds, "listRedVoznjeByVreme");
List <Polazak> lista = new List <Polazak>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Polazak p = new Polazak();
p.Vreme = ds.Tables[0].Rows[i]["Vreme"].ToString();
lista.Add(p);
}
return(lista);
}
}
public void GetRedVoznje(string smer, string dan)
{
Polazak polazak = new Polazak();
RedVoznje = polazak.RedVoznje(Naziv, smer, dan, -1, -1);
}
