public ActionResult AddOrDeleteCafe(CafeUpdateModel cafeupdateModel)
{
var jsonResult = new JsonResult();
var loginSuccessful = false;
if (Session["loggedIn"] != null || m_helper.Login(cafeupdateModel.LoginDetails, Constants.ODBCString))
{
loginSuccessful = true;
var connectionString = Constants.ODBCString;
using (var dbConnection = new ODBConnection(connectionString))
using (var persister = new ODBCPersister(dbConnection))
{
var count = int.Parse(persister.ExecuteScalar(string.Format(m_helper.GetQueryValue("checkCafeteriaManager"), cafeupdateModel.CafeteriaManagerID)).ToString());
if (count > 0)
{
// if it exists
var itemExists = int.Parse(persister.ExecuteScalar(string.Format(m_helper.GetQueryValue("checkCafe"), cafeupdateModel.Cafe.CafeName)).ToString()) > 0;
if (itemExists)
{
//update updateStoreHouseInventory
persister.ExecuteNonQueryCmd("Cafe", string.Format(m_helper.GetQueryValue("updateCafe"),
cafeupdateModel.Cafe.CafeName,
cafeupdateModel.Cafe.CafeName,
cafeupdateModel.Delete ? "inactive" : "active",
cafeupdateModel.Cafe.CafeteriaVendorID,
cafeupdateModel.Delete ? cafeupdateModel.Cafe.CafeName : cafeupdateModel.NewName));
}
else
{
persister.ExecuteNonQueryCmd("Cafe", string.Format(m_helper.GetQueryValue("insertCafe"),
cafeupdateModel.Cafe.CafeName,
cafeupdateModel.Cafe.CafeName,
"active",
cafeupdateModel.Cafe.CafeteriaVendorID));
}
}
else
{
var msg = "You are not previliged to complete this action";
jsonResult.Data = new { msg };
}
}
}
else
{
jsonResult.Data = new { loginSuccessful };
}
return(jsonResult);
}
public ActionResult GetCafeByStatus(CafeUpdateModel cafeupdateModel)
{
var jsonResult = new JsonResult();
var loginSuccessful = false;
var queryString = string.Format(m_helper.GetQueryValue("allcafes"), cafeupdateModel.Cafe.Status);
if (Session["loggedIn"] != null || m_helper.Login(cafeupdateModel.LoginDetails, Constants.ODBCString))
{
loginSuccessful = true;
var Data = m_helper.GetODBCData(Constants.ODBCString, queryString).GroupBy(x => x["CAFEID"]).ToDictionary(x => x.Key, x => x.ToList().Count);
jsonResult.Data = Data;
}
else
{
jsonResult.Data = new { loginSuccessful };
}
return(jsonResult);
}
public ActionResult GetOrderDetailsFromCafe(CafeUpdateModel cafeupdateModel)
{
var jsonResult = new JsonResult();
var loginSuccessful = false;
var queryString = string.Format(m_helper.GetQueryValue(cafeupdateModel.Cafe.CafeID == null ? "cafeAllCustomerOrdersFromCafe" :"cafeAllCustomerOrders"), cafeupdateModel.Cafe.CafeID);
if (Session["loggedIn"] != null || m_helper.Login(cafeupdateModel.LoginDetails, Constants.ODBCString))
{
loginSuccessful = true;
var Data = m_helper.GetODBCData(Constants.ODBCString, queryString);
jsonResult.Data = Data;
}
else
{
jsonResult.Data = new { loginSuccessful };
}
return(jsonResult);
}
