public JsonResult AddFoodOrder(string[] ids, string[] leftValue, string[] overValue) { UserContext cont = (UserContext)Session["UserContext"]; FoodOrderModel fom = new FoodOrderModel(); string error = ""; string msg = ""; try { if (!ValidationUtility.IsNull(ids) && ids.Length > 0 && !ValidationUtility.IsNull(cont)) { FoodOrderDTO foodOrderDTO = new FoodOrderDTO(); foodOrderDTO.StoreId = fom.GetStoredId(cont.Id); foodOrderDTO.FoodOrderDate = DateTime.Now; foodOrderDTO.CreatedDateTime = DateTime.Now; foodOrderDTO.LastUpdateDateTime = DateTime.Now; fom.AddFoodOrder(foodOrderDTO); int foodId = fom.GetFoodOrderId(foodOrderDTO); for (int i = 0; i < ids.Length; i++) { int itemId = ValidationUtility.ToInteger(ids[i]); int left = ValidationUtility.ToInteger(leftValue[i]); int over = ValidationUtility.ToInteger(overValue[i]); OrderDTO dto = new OrderDTO(); dto.ItemId = itemId; dto.NumberRemaining = left; dto.NumberOver = over; dto.FoodOrderId = foodId; dto.CreatedDateTime = DateTime.Now; dto.LastUpdateDateTime = DateTime.Now; fom.AddOrder(dto); } error = "Success"; msg = "Food Order Added Successfully"; } } catch (Exception ex) { error = "Error"; msg = "Food Order is not Added Please Try Again"; log.Error(" Exception in AddFoodItem Method ", ex); } ResponseDTO resDTO = new ResponseDTO { Error = error, Message = msg }; return Json(resDTO, JsonRequestBehavior.AllowGet); }
// Add Order by manager // one food order have multiple order public void AddOrder(OrderDTO dto) { DataBaseUtility db = new DataBaseUtility(); string query = " INSERT INTO [dbo].[Orders]([FoodOrderId],[ItemId],[NumberRemaining],[NumberOver],[CreatedDateTime],[LastUpdateDateTime])VALUES ( " + " " + SQLUtility.getInteger(dto.FoodOrderId) + " , " + SQLUtility.getInteger(dto.ItemId) + " , " + SQLUtility.getInteger(dto.NumberRemaining) + " , " + SQLUtility.getInteger(dto.NumberOver) + " , " + " '" + SQLUtility.FormateDateYYYYMMDDWtithTime(dto.CreatedDateTime) + "' , '" + SQLUtility.FormateDateYYYYMMDDWtithTime(dto.LastUpdateDateTime) + "' ) "; db.ExecuteUpdate(query); }
// Get order list agains Food Order Id public ArrayList GetFoodOrderInfo(int foodOrderId) { ArrayList list = new ArrayList(); DataBaseUtility db = new DataBaseUtility(); SqlConnection conn = null; try { string query = "select fi.FoodName,o.NumberRemaining,o.NumberOver from dbo.FoodItem fi , dbo.Orders o where " + " o.FoodOrderId = " + SQLUtility.getInteger(foodOrderId) + " and fi.Id = o.ItemId "; conn = db.OpenConnection(); SqlCommand comm = db.getSQLCommand(query, conn); SqlDataReader reader = comm.ExecuteReader(); while (reader.Read()) { string foodName = reader["FoodName"].ToString(); int numberRemaining = ValidationUtility.ToInteger(reader["NumberRemaining"].ToString()); int numberOver = ValidationUtility.ToInteger(reader["NumberOver"].ToString()); OrderDTO dto = new OrderDTO { ItemName = foodName, NumberRemaining = numberRemaining, NumberOver = numberOver }; list.Add(dto); } reader.Close(); comm.Dispose(); } catch (Exception ex) { log.Error(" Exception in GetFoodOrderInfo Method ", ex); } finally { db.CloseConnection(conn); } return list; }