public bool AddFruitsOrder(FruitsOrderModel fom)
{
FruitsDropdownModel oFruitsDropdownModel = new FruitsDropdownModel();
string myConnection = "Data Source = DESKTOP-JVJFROS;Integrated Security=True;Database=FruitsDB";
SqlConnection con = new SqlConnection(myConnection);
SqlCommand cmd = new SqlCommand("SaveFruitsOrderDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FruitsId", fom.FruitsId);
cmd.Parameters.AddWithValue("@OrderBy", fom.OrderBy);
cmd.Parameters.AddWithValue("@Mobile", fom.Mobile);
cmd.Parameters.AddWithValue("@Quantity", fom.Quantity);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}
public List <FruitsDropdownModel> GetAllFruitsName()
{
List <FruitsDropdownModel> fruitList = new List <FruitsDropdownModel>();
FruitsDropdownModel oFruitsDropdownModel = new FruitsDropdownModel();
string myConnection = "Data Source = DESKTOP-JVJFROS;Integrated Security=True;Database=FruitsDB";
SqlConnection con = new SqlConnection(myConnection);
SqlCommand cmd = new SqlCommand("GetAllFruitsName", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
fruitList = (from DataRow dr in dt.Rows
select new FruitsDropdownModel()
{
FruitsId = Convert.ToInt32(dr["FruitsId"]),
FruitsName = Convert.ToString(dr["FruitsName"])
}).ToList();
con.Close();
return(fruitList);
}
