public static void GetOglasiByDatumIOblast(DSOglasi.PosaoOglasiDataTable dtOglasi, DateTime datumOd, DateTime datumDo, int oblastId)
{
dtOglasi.Clear();
SqlConnection cn = Connection.GetConnection();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
try
{
SqlCommand cmd = new SqlCommand("usp_OglasiSelectByOblastIDatumObjave", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@datumOd", SqlDbType.Date).Value = datumOd;
cmd.Parameters.Add("@datumDo", SqlDbType.Date).Value = datumDo;
if (oblastId != 0)
{
cmd.Parameters.Add("@oblastID", SqlDbType.NVarChar).Value = oblastId;
}
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dtOglasi);
}
finally
{
cn.Close();
}
}
public static void SelectOglasiByKompanijaID(DSOglasi.PosaoOglasiDataTable dtOglasi, int kompanijaID)
{
dtOglasi.Clear();
SqlConnection cn = Connection.GetConnection();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
try
{
SqlCommand cmd = new SqlCommand("usp_Oglasi_SelectByKompanijaID", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@KompanijaID", SqlDbType.Int).Value = kompanijaID;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dtOglasi);
}
finally
{
cn.Close();
}
}
