public ActionResult DeliOrder(DeliOrderModel order)
{
OrdersDAL dal = new OrdersDAL();
if (dal.SaveDeliOrder(order))
{
return(RedirectToAction("Orders"));
}
else
{
return(View("DeliOrder", order));
}
}
public IEnumerable <DeliOrderModel> GetDeliOrderModels(int id)
{
var output = new DeliOrderModel();
OrdersDAL dal = new OrdersDAL();
List <DeliOrderModel> orders = dal.GetAllDeliOrders();
for (int i = 0; i < orders.Count; i++)
{
if (orders[i].Id == id)
{
output = orders[i];
}
}
List <DeliOrderModel> outputt = new List <DeliOrderModel>();
outputt.Add(output);
return(outputt);
}
public List <DeliOrderModel> GetAllDeliOrdersForStore(int storeId)
{
List <DeliOrderModel> output = new List <DeliOrderModel>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(getDeliOrdersForStore_SQL, conn);
cmd.Parameters.AddWithValue("@storeId", storeId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DeliOrderModel order = new DeliOrderModel();
order.Id = Convert.ToInt32(reader["id"]);
order.IsActive = Convert.ToBoolean(reader["isActive"]);
order.NumberOfPieces = Convert.ToInt32(reader["numberOfPieces"]);
order.OrderName = Convert.ToString(reader["orderName"]);
order.PhoneNumber = Convert.ToString(reader["phoneNumber"]);
order.OrderTime = Convert.ToDateTime(reader["orderTime"]);
order.PickUpTime = Convert.ToDateTime(reader["pickUpTime"]);
order.StoreId = Convert.ToInt32(reader["storeId"]);
order.UserInfoId = Convert.ToInt32(reader["userInfoId"]);
output.Add(order);
}
}
}
catch (SqlException ex)
{
throw;
}
return(output);
}
public bool SaveDeliOrder(DeliOrderModel order)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(addOrderDeli_SQL, conn);
cmd.Parameters.AddWithValue("@orderName", order.OrderName);
cmd.Parameters.AddWithValue("@phoneNumber", order.PhoneNumber);
cmd.Parameters.AddWithValue("@pickUpTime", order.PickUpTime);
cmd.Parameters.AddWithValue("@userInfoId", order.UserInfoId);
cmd.Parameters.AddWithValue("@numberOfPieces", order.NumberOfPieces);
cmd.Parameters.AddWithValue("@storeId", order.StoreId);
int rowsAffected = cmd.ExecuteNonQuery();
return(rowsAffected > 0);
}
}
catch (SqlException ex)
{
throw;
}
}
public ActionResult DeliOrder()
{
DeliOrderModel model = new DeliOrderModel();
return(View("DeliOrder", model));
}
