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