// GET api/DashboardAdvertise public ArrayList Get() { ArrayList al = new ArrayList(); using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("SELECT TOP 10 a.Photo_URL AS img, a.Price_PKG AS price, a.Amount_Kg AS amount, t.FirstName AS farmer, v.Vegitable_Name AS veg, r.Mark / r.Count AS farmerRating from[dbo].[Advertisement_List] a JOIN[dbo].[Table] t ON a.Owner_Id = t.Id JOIN[dbo].[Vegitable_List] v ON a.Vegitable_Id = v.Vegitable_Id JOIN[dbo].[Rating] r ON a.Owner_Id = r.Id ORDER BY a.Post_Date DESC; ", con); con.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { DashbordObjects = new DashboardAdvertise(); DashbordObjects.img = reader.GetString(reader.GetOrdinal("img")); DashbordObjects.price = reader.GetInt32(reader.GetOrdinal("price")); DashbordObjects.amount = reader.GetInt32(reader.GetOrdinal("amount")); DashbordObjects.farmer = reader.GetString(reader.GetOrdinal("farmer")); DashbordObjects.veg = reader.GetString(reader.GetOrdinal("veg")); DashbordObjects.farmerRating = reader.GetInt32(reader.GetOrdinal("farmerRating")); al.Add(DashbordObjects); } con.Close(); } return(al); }
// GET api/values public ArrayList Get() { ArrayList al = new ArrayList(); using (SqlConnection con = new SqlConnection(CS)) { using (SqlCommand cmd = new SqlCommand("checkPro", con)) { cmd.CommandType = CommandType.StoredProcedure; SqlParameter parm = new SqlParameter("@img", SqlDbType.VarChar, 500); parm.Direction = ParameterDirection.Output; // This is important! cmd.Parameters.Add(parm); parm = new SqlParameter("@price", SqlDbType.Int); parm.Direction = ParameterDirection.Output; cmd.Parameters.Add(parm); parm = new SqlParameter("@Amount_Kg", SqlDbType.Int); parm.Direction = ParameterDirection.Output; cmd.Parameters.Add(parm); parm = new SqlParameter("@FirstName", SqlDbType.VarChar, 50); parm.Direction = ParameterDirection.Output; cmd.Parameters.Add(parm); parm = new SqlParameter("@Vegitable_Name", SqlDbType.VarChar, 50); parm.Direction = ParameterDirection.Output; cmd.Parameters.Add(parm); parm = new SqlParameter("@farmerRating", SqlDbType.Int); parm.Direction = ParameterDirection.Output; cmd.Parameters.Add(parm); con.Open(); int k = cmd.ExecuteNonQuery(); //SqlDataReader reader = cmd.ExecuteReader(); //con.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { DashboardAdvertise DashbordObjects = new DashboardAdvertise(); DashbordObjects.img = reader.GetString(reader.GetOrdinal("img")); DashbordObjects.price = reader.GetInt32(reader.GetOrdinal("price")); DashbordObjects.amount = reader.GetInt32(reader.GetOrdinal("amount")); DashbordObjects.farmer = reader.GetString(reader.GetOrdinal("farmer")); DashbordObjects.veg = reader.GetString(reader.GetOrdinal("veg")); DashbordObjects.farmerRating = reader.GetInt32(reader.GetOrdinal("farmerRating")); //DashbordObjects.img = cmd.Parameters["@img"].ToString(); //DashbordObjects.price = Convert.ToInt32( cmd.Parameters["@price"].Value.ToString()); //DashbordObjects.amount = Convert.ToInt32(cmd.Parameters["@Amount_Kg"].Value.ToString()); //DashbordObjects.farmer = cmd.Parameters["@FirstName"].ToString(); //DashbordObjects.veg = cmd.Parameters["@Vegitable_Name"].ToString(); //DashbordObjects.farmerRating = Convert.ToInt32(cmd.Parameters["@farmerRating"].Value.ToString()); al.Add(DashbordObjects); } } con.Close(); } return(al);; }