public async Task <IHttpActionResult> PuttblMenu(int id, tblMenu tblMenu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblMenu.ID)
{
return(BadRequest());
}
db.Entry(tblMenu).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!tblMenuExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Action(tblMenu objSubmit)
{
if (objSubmit.ID == 0)
{
objSubmit.DateCreated = DateTime.Now;
objSubmit.DateUpdated = DateTime.Now;
objSubmit.CreatedBy = User.Identity.Name;
objSubmit.UpdatedBy = User.Identity.Name;
objSubmit.IsDeleted = false;
objSubmit.IsShow = true;
menuRepository.Add(objSubmit);
}
else
{
var obj = menuRepository.GetById <tblMenu>(objSubmit.ID);
objSubmit.DateUpdated = DateTime.Now;
objSubmit.UpdatedBy = User.Identity.Name;
UpdateModel(obj);
objSubmit.DateUpdated = DateTime.Now;
menuRepository.Update(obj);
}
return(Json(new
{
Error = false
}, JsonRequestBehavior.AllowGet));
}
protected void Page_Load(object sender, EventArgs e)
{
HzLogin login;
login = (HzLogin)Session["Login"];
tblMenu clMenu = new tblMenu();
EditarPagina = clMenu.EditarMenu(Global.GetConnection(), int.Parse(login.cmpCoPerfil), 63);
cmbTipoServico.Enabled = EditarPagina;
cmbObra.Enabled = EditarPagina;
cmbMes.Enabled = EditarPagina;
cmbAno.Enabled = EditarPagina;
chkEmissaoFatura.Enabled = EditarPagina;
chkEntregaFatura.Enabled = EditarPagina;
chkRecebeFatura.Enabled = EditarPagina;
btnPesquisar.Enabled = EditarPagina;
if (!Page.IsPostBack)
{
this.load();
if (Request.QueryString != null && Request.QueryString.Count > 0 & EditarPagina == true)
{
cmbAno.SelectedIndex = Objetos.RetornaIndiceCombo(cmbAno, int.Parse(Request.QueryString["NuAnoFatura"]));
cmbMes.SelectedIndex = Objetos.RetornaIndiceCombo(cmbMes, int.Parse(Request.QueryString["NuMesFatura"]));
cmbTipoServico.SelectedIndex = Objetos.RetornaIndiceCombo(cmbTipoServico, int.Parse(Request.QueryString["IdTipoServico"]));
}
btnPesquisar_Click(sender, e);
}
}
public int UpdateMenu(tblMenu menu)
{
int result = 0;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
var m = db.tblMenus.FirstOrDefault(u => u.Id == menu.Id);
if (m != null)
{
db.Entry(m).CurrentValues.SetValues(menu);
if (db.SaveChanges() > 0)
{
result = m.Id;
}
}
}
}
catch (Exception ex)
{
SELog.WriteLog("MenuService => UpdateMenu", ex);
}
return(result);
}
public GuestViewModel(Guest guestOpen)
{
meal = new tblMenu();
guest = guestOpen;
recordList = new List <tblRecord>();
MealList = service.GetAllMeals();
}
public ActionResult DeleteConfirmed(int id)
{
tblMenu tblMenu = db.tblMenus.Find(id);
db.tblMenus.Remove(tblMenu);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: WebCoin/Delete/5
public ActionResult DeleteCategory(int?id)
{
tblMenu tblMenu = db.tblMenus.Find(id);
db.tblMenus.Remove(tblMenu);
db.SaveChanges();
return(RedirectToAction("IndexCategory"));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
tblMenu tblMenu = await db.tblMenus.FindAsync(id);
db.tblMenus.Remove(tblMenu);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <IHttpActionResult> GettblMenu(int id)
{
tblMenu tblMenu = await db.tblMenus.FindAsync(id);
if (tblMenu == null)
{
return(NotFound());
}
return(Ok(tblMenu));
}
public async Task <IHttpActionResult> PosttblMenu(tblMenu tblMenu)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tblMenus.Add(tblMenu);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = tblMenu.ID }, tblMenu));
}
public async Task <ActionResult> Create([Bind(Include = "ID,DisplayName,icon,type,ordinal,path,ParentID,IsEnable")] tblMenu tblMenu)
{
if (ModelState.IsValid)
{
db.tblMenus.Add(tblMenu);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(tblMenu));
}
// GET: Menus/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblMenu tblMenu = await db.tblMenus.FindAsync(id);
if (tblMenu == null)
{
return(HttpNotFound());
}
return(View(tblMenu));
}
public async Task <IHttpActionResult> DeletetblMenu(int id)
{
tblMenu tblMenu = await db.tblMenus.FindAsync(id);
if (tblMenu == null)
{
return(NotFound());
}
db.tblMenus.Remove(tblMenu);
await db.SaveChangesAsync();
return(Ok(tblMenu));
}
// GET: adminMenu/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblMenu tblMenu = db.tblMenus.Find(id);
if (tblMenu == null)
{
return(HttpNotFound());
}
return(View(tblMenu));
}
public tblMenu GetDetailMenuById(int id)
{
tblMenu result = null;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
result = db.tblMenus.FirstOrDefault(x => x.Id == id);
}
}
catch (Exception)
{
}
return result;
}
public tblMenu GetDetailMenuById(int id)
{
tblMenu result = null;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
result = db.tblMenus.FirstOrDefault(x => x.Id == id);
}
}
catch (Exception ex)
{
SELog.WriteLog("MenuService => GetDetailMenuById", ex);
}
return(result);
}
public int InsertMenu(tblMenu menu)
{
int result = 0;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
db.tblMenus.Add(menu);
db.SaveChanges();
result = menu.Id;
}
}
catch (Exception)
{
}
return result;
}
public void ReadOrder()
{
while (true)
{
bool isIn = false;
//number input
Console.WriteLine("Enter order number for order you want to display? ");
int orderNumber;
bool tryHowMany = Int32.TryParse(Console.ReadLine(), out orderNumber);
while (!tryHowMany || orderNumber < 1)
{
Console.WriteLine("Incorrect input, please try again:");
tryHowMany = Int32.TryParse(Console.ReadLine(), out orderNumber);
}
//from table to list
List <tblOrder> listOfOrders = context.tblOrders.ToList();
tblMenu menu = new tblMenu();
//looking for user
for (int i = 0; i < listOfOrders.Count; i++)
{
if (listOfOrders[i].OrderNumber == orderNumber)
{
tblOrder viaOrder = listOfOrders[i];
menu = context.tblMenus.Where(x => x.MenuID == viaOrder.MenuID).Select(x => x).First();
isIn = true;
//displaiying user
Console.WriteLine("\nOrder date:{0}\nOrder number:{1}\nPizza number:{2}\nChicken number:{3}\nPasta number:{4}\nSoup number:{5}\nSandwich number:{6}\n", listOfOrders[i].OrderTime, listOfOrders[i].OrderNumber, menu.Pizza, menu.Chicken, menu.Pasta, menu.Soup, menu.Sandwich);
break;
}
}
Console.WriteLine("If you want to exit press ~ or any other key to continue");
if (Console.ReadLine() == "~")
{
break;
}
//in case there is no selected user
if (isIn == false)
{
Console.WriteLine("There is no such order with inputed order number.\n");
break;
}
}
}
public async Task <ActionResult> Edit([Bind(Include = "ID,DisplayName,icon,type,ordinal,path,ParentID,IsEnable")] tblMenu tblMenu)
{
if (ModelState.IsValid)
{
db.Entry(tblMenu).State = EntityState.Modified;
await db.SaveChangesAsync();
//var childMenus = db.tblMenus.Where(q => q.ParentID == tblMenu.ID);
//foreach (var childMenu in childMenus)
//{
// childMenu.IsEnable = tblMenu.IsEnable;
// db.Entry(childMenu).State = EntityState.Modified;
// await db.SaveChangesAsync();
//}
return(RedirectToAction("Index"));
}
return(View(tblMenu));
}
public void ReadAllOrders()
{
List <tblOrder> listOrder = context.tblOrders.ToList();
List <tblMenu> listMenu = context.tblMenus.ToList();
if (listOrder.Count < 1)
{
Console.WriteLine("\nThere are no orders.\n");
}
else
{
for (int i = 0; i < listOrder.Count; i++)
{
tblOrder viaOrder = listOrder[i];
tblMenu viaMenu = context.tblMenus.Where(x => x.MenuID == viaOrder.MenuID).Select(x => x).First();
Console.WriteLine("\nOrder date:{0}\nOrder number:{1}\nPizza number:{2}\nChicken number:{3}\nPasta number:{4}\nSoup number:{5}\nSandwich number:{6}\n", viaOrder.OrderTime, viaOrder.OrderNumber, viaMenu.Pizza, viaMenu.Chicken, viaMenu.Pasta, viaMenu.Soup, viaMenu.Sandwich);
}
}
}
public ActionResult CreateCategory(AllModel model)
{
var data = new tblMenu
{
NameMenu = model.TblMenu.NameMenu,
NameMenu_en = model.TblMenu.NameMenu_en,
IdCompany = model.TblMenu.IdCompany,
IsCategoryMenu = model.TblMenu.IsCategoryMenu,
IsParent = model.TblMenu.IsParent,
ShowHomeMenu = model.TblMenu.ShowHomeMenu,
StatusMenu = model.TblMenu.StatusMenu,
LinkMenu = model.TblMenu.LinkMenu,
IdParentMenu = model.TblMenu.IdParentMenu,
};
db.tblMenus.Add(data);
db.SaveChanges();
return(RedirectToAction("IndexCategory"));
}
public int InsertMenu(tblMenu menu)
{
int result = 0;
try
{
using (var db = ContextFactory.UsTransportEntities())
{
db.tblMenus.Add(menu);
db.SaveChanges();
result = menu.Id;
}
}
catch (Exception ex)
{
SELog.WriteLog("MenuService => InsertMenu", ex);
}
return(result);
}
private void CarregarMenu()
{
tblMenu clMenu = new tblMenu();
clMenu.listaTblMenus(Global.GetConnection(), 0);
for (int n1 = 0; n1 < clMenu.lstTblMenu.Count; n1++)
{
TreeNode tn1 = new TreeNode();
tn1.Text = clMenu.lstTblMenu[n1].cmpDcMenu;
tn1.Value = clMenu.lstTblMenu[n1].cmpCoMenu;
for (int n2 = 0; n2 < clMenu.lstTblMenu[n1].lstTblMenu.Count; n2++)
{
TreeNode tn2 = new TreeNode();
tn2.Text = clMenu.lstTblMenu[n1].lstTblMenu[n2].cmpDcMenu;
tn2.Value = clMenu.lstTblMenu[n1].lstTblMenu[n2].cmpCoMenu;
tn1.ChildNodes.Add(tn2);
}
TreeView1.Nodes.Add(tn1);
}
}
public string SaveMenu(HttpPostedFileBase fb, MenuModel model)
{
string Message = "";
NoHungKitchenWebEntities db = new NoHungKitchenWebEntities();
string filePath = "";
string fileName = "";
string sysFileName = "";
if (fb != null && fb.ContentLength > 0)
{
filePath = HttpContext.Current.Server.MapPath("~/Content/Images/MenuPhoto/");
DirectoryInfo di = new DirectoryInfo(filePath);
if (!di.Exists)
{
di.Create();
}
fileName = fb.FileName;
sysFileName = DateTime.Now.ToFileTime().ToString() + Path.GetExtension(fb.FileName);
fb.SaveAs(filePath + "//" + sysFileName);
if (!string.IsNullOrWhiteSpace(fb.FileName))
{
string afileName = HttpContext.Current.Server.MapPath("~/Content/Images/MenuPhoto/") + "/" + sysFileName;
}
}
var savemenu = new tblMenu()
{
KitchenId = model.KitchenId,
MenuTitle = model.MenuTitle,
Category = model.Category,
Qty = model.Qty,
SalePrice = model.SalePrice,
Status = model.Status,
Description = model.Description,
MenuPhoto = sysFileName,
};
db.tblMenus.Add(savemenu);
db.SaveChanges();
return(Message);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
// Operador Obra ou Engenheiro Obra
if (((HzLibGeneral.Util.HzLogin)Session["login"]).cmpNuPerfil.ToString() == "2" || ((HzLibGeneral.Util.HzLogin)Session["login"]).cmpNuPerfil.ToString() == "4")
{
btnGravar.Enabled = false;
}
// Operador Escritório ou Administrador Sistema
else if (((HzLibGeneral.Util.HzLogin)Session["login"]).cmpNuPerfil.ToString() == "1" || ((HzLibGeneral.Util.HzLogin)Session["login"]).cmpNuPerfil.ToString() == "7")
{
btnGravar.Enabled = true;
}
prevPage = Request.UrlReferrer.AbsolutePath;
if (Request.QueryString != null && Request.QueryString.Count > 0)
{
ViewState["idFaturaObra"] = Request.QueryString["idFaturaObra"];
PesquisaNota(0);
loadRecebimento();
}
}
HzLogin login;
login = (HzLogin)Session["Login"];
tblMenu clMenu = new tblMenu();
bool EditarPagina = clMenu.EditarMenu(Global.GetConnection(), int.Parse(login.cmpCoPerfil), 63);
btnGravar.Enabled = EditarPagina;
btnJustificativa.Enabled = EditarPagina;
grdJustifica.Enabled = EditarPagina;
txtVlRecebido.Enabled = EditarPagina;
txtVlGlosado.Enabled = EditarPagina;
txtDtRecebido.Enabled = EditarPagina;
rdbRecebe.Enabled = EditarPagina;
}
public void DeleteOrder()
{
Console.WriteLine("\nPlease enter the number of an order you want to delete");
string d = Console.ReadLine();
int orderNumberToDelete;
try
{
int.TryParse(d, out orderNumberToDelete);
tblOrder orderToDelete = context.tblOrders.Where(x => x.OrderNumber == orderNumberToDelete).Select(x => x).FirstOrDefault();
context.tblOrders.Remove(orderToDelete);
tblMenu menuToDelete = context.tblMenus.Where(x => x.MenuID == orderToDelete.MenuID).Select(x => x).FirstOrDefault();
context.tblMenus.Remove(menuToDelete);
context.SaveChanges();
Console.WriteLine("\nOrder delete succesfull.\n");
}
catch
{
Console.WriteLine("\nOrder delete not succesfull. Order with a number you have just entered does not exist.\n");
}
}
public List <Menu> GetUserMenus()
{
int CurrentUserID = (int)HttpContext.Current.Session["CurrentUserID"];
List <tblUserMenu> dbMenus = db.tblUserMenus.Where(m => m.UserID.Equals(CurrentUserID)).ToList();
List <Menu> menus = new List <Menu>();
if (dbMenus.Count > 0)
{
foreach (var m in dbMenus)
{
tblMenu desc = db.tblMenus.Where(a => a.MenuID.Equals(m.MenuID)).FirstOrDefault();
Menu me = new Menu();
me.MenuID = m.MenuID;
me.MenuName = desc.MenuName;
me.URL = desc.URL;
menus.Add(me);
}
return(menus);
}
else
{
return(null);
}
}
public ActionResult saveMenu([Bind(Include = "idMenu,NameEs,NameEn,Active,Controller")] tblMenu menu)
{
if (ModelState.IsValid)
{
if (menu.idMenu > 0)
{
menu.UpdateUser = Session["UserName"].ToString();
menu.UpdateDate = DateTime.Now;
dbContext.Entry(menu).State = System.Data.Entity.EntityState.Modified;
}
else
{
menu.CreateUser = Session["UserName"].ToString();
menu.CreateDate = DateTime.Now;
dbContext.tblMenu.Add(menu);
}
dbContext.SaveChanges();
}
var result = dbContext.tblMenu.ToList();
ViewData["listMenu"] = result;
return(View("listMenu"));
}
public void UpdateOrder()
{
while (true)
{
bool isIn = false;
Console.WriteLine("Enter order number for order you want to update:");
int orderNumber;
bool tryHowMany = Int32.TryParse(Console.ReadLine(), out orderNumber);
while (!tryHowMany || orderNumber < 1)
{
Console.WriteLine("Incorrect input, please try again:");
tryHowMany = Int32.TryParse(Console.ReadLine(), out orderNumber);
}
//Putting numbers from table to list
List <tblOrder> listOfOrders = context.tblOrders.ToList();
//looking for number in list
for (int i = 0; i < listOfOrders.Count; i++)
{
// in case that number exists
if (listOfOrders[i].OrderNumber == orderNumber)
{
tblOrder viaOrder = listOfOrders[i];
tblMenu viaMenu = context.tblMenus.Where(x => x.MenuID == viaOrder.MenuID).Select(x => x).First();
isIn = true;
Console.WriteLine("\nOrder date:{0}\nOrder number:{1}\nPizza number:{2}\nChicken number:{3}\nPasta number:{4}\nSoup number:{5}\nSandwich number:{6}\n", viaOrder.OrderTime, viaOrder.OrderNumber, viaMenu.Pizza, viaMenu.Chicken, viaMenu.Pasta, viaMenu.Soup, viaMenu.Sandwich);
}
}
//if number does not exists
if (isIn == false)
{
Console.WriteLine("There is no such order with inputed number.\n");
break;
}
else
{
//finding user to update and updating chosen field
tblOrder viaOrder = context.tblOrders.FirstOrDefault(x => x.OrderNumber == orderNumber);
tblMenu viaMenu = context.tblMenus.FirstOrDefault(x => x.MenuID == viaOrder.MenuID);
bool spin = true;
while (spin == true)
{
Console.WriteLine("\nWhat do you want to update?\n");
Console.WriteLine("1: Pizza");
Console.WriteLine("2: Chicken");
Console.WriteLine("3: Sandwich");
Console.WriteLine("4: Pasta");
Console.WriteLine("5: Soup");
Console.WriteLine("6: Exit\n");
string pick = Console.ReadLine();
switch (pick)
{
case "1":
Console.WriteLine("Enter new pizza amount:");
int pizzaNumber;
bool tryPizza = Int32.TryParse(Console.ReadLine(), out pizzaNumber);
while (!tryPizza || pizzaNumber < 0)
{
Console.WriteLine("Incorrect input, please try again:");
tryPizza = Int32.TryParse(Console.ReadLine(), out pizzaNumber);
}
viaMenu.Pizza = pizzaNumber;
viaOrder.OrderTime = DateTime.ParseExact(DateTime.Now.ToString("yyyy-MM-dd"), "yyyy-MM-dd", CultureInfo.InvariantCulture);
context.SaveChanges();
Console.WriteLine("Pizza number is updated.\n");
break;
case "2":
Console.WriteLine("Enter new chicken amount:");
int chickenNumber;
bool tryChicken = Int32.TryParse(Console.ReadLine(), out chickenNumber);
while (!tryChicken || chickenNumber < 0)
{
Console.WriteLine("Incorrect input, please try again:");
tryChicken = Int32.TryParse(Console.ReadLine(), out chickenNumber);
}
viaMenu.Chicken = chickenNumber;
viaOrder.OrderTime = DateTime.ParseExact(DateTime.Now.ToString("yyyy-MM-dd"), "yyyy-MM-dd", CultureInfo.InvariantCulture);
context.SaveChanges();
Console.WriteLine("Chicken number is updated.\n");
break;
case "3":
Console.WriteLine("Enter new sandwich amount:");
int sandwichNumber;
bool trySandwich = Int32.TryParse(Console.ReadLine(), out sandwichNumber);
while (!trySandwich || sandwichNumber < 0)
{
Console.WriteLine("Incorrect input, please try again:");
trySandwich = Int32.TryParse(Console.ReadLine(), out sandwichNumber);
}
viaMenu.Sandwich = sandwichNumber;
viaOrder.OrderTime = DateTime.ParseExact(DateTime.Now.ToString("yyyy-MM-dd"), "yyyy-MM-dd", CultureInfo.InvariantCulture);
context.SaveChanges();
Console.WriteLine("Sandwich number is updated.\n");
break;
case "4":
Console.WriteLine("Enter new pasta amount:");
int pastaNumber;
bool tryPasta = Int32.TryParse(Console.ReadLine(), out pastaNumber);
while (!tryPasta || pastaNumber < 0)
{
Console.WriteLine("Incorrect input, please try again:");
tryPasta = Int32.TryParse(Console.ReadLine(), out pastaNumber);
}
viaMenu.Pasta = pastaNumber;
viaOrder.OrderTime = DateTime.ParseExact(DateTime.Now.ToString("yyyy-MM-dd"), "yyyy-MM-dd", CultureInfo.InvariantCulture);
context.SaveChanges();
Console.WriteLine("Pasta number is updated.\n");
break;
case "5":
Console.WriteLine("Enter new soup amount:");
int soupNumber;
bool trySoup = Int32.TryParse(Console.ReadLine(), out soupNumber);
while (!trySoup || soupNumber < 0)
{
Console.WriteLine("Incorrect input, please try again:");
trySoup = Int32.TryParse(Console.ReadLine(), out soupNumber);
}
viaMenu.Soup = soupNumber;
viaOrder.OrderTime = DateTime.ParseExact(DateTime.Now.ToString("yyyy-MM-dd"), "yyyy-MM-dd", CultureInfo.InvariantCulture);
context.SaveChanges();
Console.WriteLine("Soup number is updated.\n");
break;
case "6":
spin = false;
break;
default:
Console.WriteLine("Wrong input.");
break;
}
}
break;
}
}
}
public static IList <MenuItem> GenerateTree(IEnumerable <tblMenu> collection, tblMenu rootItem)
{
IList <MenuItem> lst = new List <MenuItem>();
foreach (tblMenu c in collection.Where(c => c.ParentID == rootItem.ID))
{
lst.Add(new MenuItem
{
displayName = c.DisplayName,
icon = c.icon,
ordinal = c.ordinal,
path = c.path,
type = c.type,
childItems = GenerateTree(collection.ToList(), c).ToList()
});
}
return(lst);
}
