public FoodTimeFrame GetFoodTimeFrameById(int?id)
{
try
{
Query = "SELECT*FROM CafeTimeSchedule Where Id = " + id + "";
Command.CommandText = Query;
Command.Connection = Connection;
Connection.Open();
Reader = Command.ExecuteReader();
FoodTimeFrame foodTime = new FoodTimeFrame();
if (Reader.HasRows)
{
while (Reader.Read())
{
FoodTimeFrame food = new FoodTimeFrame();
food.Id = Convert.ToInt32(Reader["Id"]);
food.FoodItemCostId = (int)Reader["ItemId"];
food.StartTime = Reader["StartTime"].ToString();
food.EndTime = Reader["EndTime"].ToString();
foodTime = food;
}
Reader.Close();
}
return(foodTime);
}
catch (Exception exception)
{
return(null);
}
finally
{
Connection.Close();
}
}
public bool IsNameExists(FoodTimeFrame foodTimeFrame)
{
try
{
bool isNameExists = false;
Query = @"SELECT ItemId FROM CafeTimeSchedule
Where StartTime <= '" + foodTimeFrame.StartTime + "' and EndTime >= '" + foodTimeFrame.EndTime + "' and ItemId='" +
foodTimeFrame.FoodItemCostId + "' and Id != '" + foodTimeFrame.Id + "'";
Command.CommandText = Query;
Command.Connection = Connection;
Connection.Open();
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
isNameExists = true;
}
return(isNameExists);
}
catch (Exception exception)
{
return(false);
}
finally
{
Connection.Close();
}
}
public int UpdatefoodTimeFrame(FoodTimeFrame foodTimeFrame)
{
try
{
Query = @"UPDATE CafeTimeSchedule
SET [ItemId] = @FoodItemCostId
,[StartTime] = @StartTime
,[EndTime] = @EndTime
WHERE Id = '" + foodTimeFrame.Id + "'";
Command.CommandText = Query;
Command.Connection = Connection;
Command.Parameters.Clear();
Command.Parameters.Add("FoodItemCostId", SqlDbType.Int);
Command.Parameters["FoodItemCostId"].Value = foodTimeFrame.FoodItemCostId;
Command.Parameters.Add("StartTime", SqlDbType.Time);
Command.Parameters["StartTime"].Value = foodTimeFrame.StartTime;
Command.Parameters.Add("EndTime", SqlDbType.VarChar);
Command.Parameters["EndTime"].Value = foodTimeFrame.EndTime;
Connection.Open();
int rowsAffected = Command.ExecuteNonQuery();
return(rowsAffected);
}
catch (Exception exception)
{
return(0);
}
finally
{
Connection.Close();
}
}
public int Save(FoodTimeFrame foodTimeFrame)
{
try
{
Query = "INSERT INTO CafeTimeSchedule(ItemId,StartTime,EndTime) VALUES(@ItemId,@StartTime,@EndTime)";
Command.CommandText = Query;
Command.Connection = Connection;
Command.Parameters.Clear();
Command.Parameters.Add("ItemId", SqlDbType.Int);
Command.Parameters["ItemId"].Value = foodTimeFrame.FoodItemCostId;
Command.Parameters.Add("StartTime", SqlDbType.Time);
Command.Parameters["StartTime"].Value = foodTimeFrame.StartTime;
Command.Parameters.Add("EndTime", SqlDbType.Time);
Command.Parameters["EndTime"].Value = foodTimeFrame.EndTime;
Connection.Open();
int rowsAffected = Command.ExecuteNonQuery();
return(rowsAffected);
}
catch (Exception exception)
{
return(0);
}
finally
{
Connection.Close();
}
}
public int UpdatefoodTimeFrame(FoodTimeFrame foodTimeFrame)
{
int message = 0;
if (IsNameExists(foodTimeFrame))
{
message = 0;
}
else
{
message = foodTimeFrameGateway.UpdatefoodTimeFrame(foodTimeFrame);
}
return(message);
}
public bool Save(FoodTimeFrame foodTimeFrame)
{
bool message = false;
if (IsTimeExists(foodTimeFrame))
{
message = false;
}
else
{
message = foodTimeFrameGateway.Save(foodTimeFrame) > 0;
}
return(message);
}
public ActionResult Save(FoodTimeFrame foodTimeFrame)
{
string status = null;
try
{
status = foodTimeFrameManager.Save(foodTimeFrame) ? "Time Frame Assigned Successfully" : "Time Frame Assigned Faild";
}
catch (Exception exception)
{
status = exception.Message;
}
return(Json(status, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(FoodTimeFrame foodTimeFrame)
{
if (ModelState.IsValid)
{
int result = foodTimeFrameManager.UpdatefoodTimeFrame(foodTimeFrame);
if (result == 0)
{
ViewBag.Massage = "Item Name is Alrady Exist! Please Try a different Name.";
}
else
{
return(RedirectToAction("Save"));
}
}
return(View());
}
public ActionResult Edit(int?id)
{
if (Session["UserRoleId"] == null)
{
return(RedirectToAction("Login", "Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FoodTimeFrame timeFrame = foodTimeFrameManager.GetFoodTimeFrameById(id);
if (timeFrame == null)
{
return(HttpNotFound());
}
return(View(timeFrame));
}
public bool IsTimeExists(FoodTimeFrame foodTimeFrame)
{
return(foodTimeFrameGateway.IsTimeExists(foodTimeFrame));
}
