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