internal static void updateFoodOrder(FoodModel mdl)
{
FoodOrderEntity e = mdl.foodOrder;
if (e.Quantity > 0)
{
e.RequiredAt = new DateTime(e.RequiredAt.Year, e.RequiredAt.Month, e.RequiredAt.Day, e.RequiredAtTime.Hour, e.RequiredAtTime.Minute, e.RequiredAtTime.Second);
e.LastUpdatedBY = mdl.profileID;
e.ProfileID = mdl.profileID;
repository.updateFoodOrder(e);
}
}
public void updateFoodOrder(FoodOrderEntity e)
{
try
{
paramList.Clear();
paramList["@OrderID"] = e.OrderID;
paramList["@Quantity"] = e.Quantity;
paramList["@RequiredAt"] = e.RequiredAt;
paramList["@LastUpdatedBY"] = e.LastUpdatedBY;
paramList["@Status"] = e.Status;
spName = "spEM_UpdateFoodOrder";
db.ExecuteNonQuery(spName, true, Common.Enums.SQLConnectionNames.EMDB, paramList);
}
catch
{
throw;
}
}
public FoodOrderEntity getfoodOrderByID(int orderID)
{
DataTable dt = new DataTable();
FoodOrderEntity entity = new FoodOrderEntity();
try
{
paramList.Clear();
paramList["@OrderID"] = orderID;
spName = "spEM_GetFoodOrderByOrderID";
dt.Load(db.ExecuteQuery(spName, true, Common.Enums.SQLConnectionNames.EMDB, paramList));
if (dt.Rows.Count > 0)
{
entity = Utility.ConvertFromDataTable <FoodOrderEntity>(dt).FirstOrDefault();
}
}
catch
{
throw;
}
return(entity);
}
internal static FoodModel addFoodOrder(int locationID, int profileID)
{
FoodModel mdl = new FoodModel();
mdl.foodItemList = repository.getEntireFoodList(locationID);
mdl.foodCategoryList = repository.getfoodCategoryList();
mdl.foodOrderList = new List <FoodOrderEntity>();
mdl.profileID = profileID;
mdl.locationID = locationID;
foreach (FoodEntity e in mdl.foodItemList)
{
if (e.Active == true)
{
FoodOrderEntity order = new FoodOrderEntity();
order.FoodID = e.FoodID;
order.FoodName = e.FoodName;
order.FoodCategoryID = e.FoodCategoryID;
order.Price = e.Price;
mdl.foodOrderList.Add(order);
}
}
return(mdl);
}
public void saveFoodOrder(FoodOrderEntity e)
{
try
{
paramList.Clear();
paramList["@FoodID"] = e.FoodID;
paramList["@BatchID"] = e.BatchID;
paramList["@Quantity"] = e.Quantity;
paramList["@RequiredAt"] = e.RequiredAt;
paramList["@Price"] = e.Price;
paramList["@ProfileID"] = e.ProfileID;
paramList["@LastUpdatedBY"] = e.LastUpdatedBY;
paramList["@TokenID"] = e.BatchID;
paramList["@Status"] = e.Status;
spName = "spEM_insertFoodOrder";
db.ExecuteNonQuery(spName, true, Common.Enums.SQLConnectionNames.EMDB, paramList);
}
catch
{
throw;
}
}
