public ActionResult SaveFruitsOrder(FruitsOrderModel oFruitsOrderModel)
{
try
{
if (ModelState.IsValid)
{
FruitsOrderRepository oFruitsOrderRepository = new FruitsOrderRepository();
if (oFruitsOrderModel.Id == 0)
{
if (oFruitsOrderRepository.AddFruitsOrder(oFruitsOrderModel))
{
ViewBag.Message = "Fruits Order details added successfully";
}
}
else
{
}
}
return(RedirectToAction("Success"));
}
catch (Exception ex)
{
return(RedirectToAction("Index"));
}
}
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);
}
}
// GET: FruitsOrder
public ActionResult Index()
{
FruitsOrderRepository oFruitsOrderRepository = new FruitsOrderRepository();
FruitsOrderModel oFruitsOrderModel = new FruitsOrderModel();
//FruitsDropdownModel oFruitsModel = new FruitsDropdownModel();
List <FruitsDropdownModel> listOrder = oFruitsOrderRepository.GetAllFruitsName();
List <SelectListItem> list = new List <SelectListItem>();
foreach (var v in listOrder)
{
list.Add(new SelectListItem {
Text = v.FruitsName, Value = v.FruitsId.ToString()
});
}
ViewBag.Fruits = list;
return(View());
}
