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