public bool addItem(String name, String description, int typeId, decimal price, String image_path) { using (restaurantEntities context = new restaurantEntities()) { try { item newItem = new item { name = name, description = description, ItemType_id = typeId, image_path = image_path, active = 1, price = price }; context.item.Add(newItem); context.SaveChanges(); return(true); } catch { return(false); } } }
// שמירת המשמרות של עובד לתאריך מסוים public static string AddShifttoNextWeekEmployee(List <calandar> calandarList, int userID) { using (restaurantEntities db = new restaurantEntities()) { foreach (var item in calandarList) { UserCalander userCalandar = db.UserCalander.FirstOrDefault(u => u.IdUser == userID && u.Date.Value.Year == item.date.Year && u.Date.Value.Month == item.date.Month && u.Date.Value.Day == item.date.Day); if (userCalandar != null) { userCalandar.Shift = item.shift; db.Entry(userCalandar).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else { UserCalander userC = new UserCalander(); userC.IdUser = userID; userC.Date = item.date; userC.Shift = item.shift; db.UserCalander.Add(userC); db.SaveChanges(); } } return("השינויים נשמרו"); } }
// יציאה של עובד שומר במסד נתונים ת שעת היציאה של העובד public static UserCalandarDTO SingOut(int id, DateTime date) { using (restaurantEntities db = new restaurantEntities()) { Employees emm = db.Employees.FirstOrDefault(e => e.Id == id); if (emm != null) { UserCalander userCalandar = db.UserCalander.FirstOrDefault(u => u.IdUser == id && u.Date.Value.Year == date.Year && u.Date.Value.Month == date.Month && u.Date.Value.Day == date.Day); if (userCalandar != null) { userCalandar.LeavingTime = date; db.Entry(userCalandar).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(UserCalandarC.ToDTO(userCalandar)); } else { return(null); } } Visiters visiter = db.Visiters.FirstOrDefault(e => e.ld == id); if (visiter != null) { visiter.lastDateEnter = date; db.Entry(visiter).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(null); } }
public bool addAccountAndTable(String username, String password, int accTypeId, int tableNumber) { using (restaurantEntities context = new restaurantEntities()) { try { account newAcc = new account { username = username, password = password, AccountType_id = accTypeId, active = 1 }; context.account.Add(newAcc); context.SaveChanges(); table newTable = new table { number = tableNumber, Account_id = newAcc.id }; context.table.Add(newTable); context.SaveChanges(); return(true); } catch { return(false); } } }
public static int GetNumberMessege(int IdUser) { using (restaurantEntities db = new restaurantEntities()) { List <managerMessage> L = db.managerMessage.Where(m => m.AlreadyRead == false && m.IdEmployee == IdUser).ToList(); return(L.Count()); } }
public static List <managerMessageDTO> GetAllMessege(int IdUser) { using (restaurantEntities db = new restaurantEntities()) { List <managerMessage> L = db.managerMessage.Where(m => m.IdEmployee == IdUser).ToList(); return(managerMessageDTO.ListToDTO(L)); } }
public static List <MenuDTO> GetANewMenu() { using (restaurantEntities db = new restaurantEntities()) { //Where(u => u.DateAdded < DateTime.Today.AddDays(-8)). List <Menu> newM = db.Menu.Where(u => DateTime.Compare(u.DateAdded.Value, DateTime.Now) > 1).ToList(); return(MenuCast.ListToDTO(newM)); } }
// קבלת דוח עובד public static List <CalandarToManager> GetEmloyeesCalandarByManaer(DateTime startOfWeek, int idE) { using (restaurantEntities db = new restaurantEntities()) { DateTime endOfWeek = startOfWeek.AddDays(6); List <UserCalander> lc = db.UserCalander.Where(c => c.Date >= startOfWeek && c.Date <= endOfWeek && c.IdUser == idE).ToList(); List <CalandarToManager> LCTM = new List <CalandarToManager>(); foreach (var item in lc) { Employees em = db.Employees.FirstOrDefault(c => c.Id == item.IdUser); CalandarToManager calandarToManager = new CalandarToManager(); if (em.IdEmployeeType != 1) { if (LCTM.Find(t => t.date == item.Date && t.shift == item.Shift) != null) { int i = LCTM.FindIndex(t => t.date == item.Date); LCTM[i].employeeName.Add(em.FirstName); LCTM[i].employeeID.Add(em.Id); } else { calandarToManager.date = item.Date.Value; calandarToManager.employeeID.Add(em.Id); calandarToManager.employeeName.Add(em.FirstName); calandarToManager.shift = item.Shift; LCTM.Add(calandarToManager); } } } IEnumerable <DateTime> lD = DateRange(startOfWeek.AddDays(1), endOfWeek); foreach (var date in lD) { CalandarToManager calandarToManager = new CalandarToManager(); if (LCTM.Find(t => t.date.Year == date.Year && t.date.Month == date.Month && t.date.Day == date.Day && t.shift == "evening") == null) { calandarToManager.date = date; calandarToManager.employeeID.Add(0); calandarToManager.employeeName.Add(""); calandarToManager.shift = "evening"; LCTM.Add(calandarToManager); } if (LCTM.Find(t => t.date.Year == date.Year && t.date.Month == date.Month && t.date.Day == date.Day && t.shift == "morning") == null) { calandarToManager.date = date; calandarToManager.employeeID.Add(0); calandarToManager.employeeName.Add(""); calandarToManager.shift = "morning"; LCTM.Add(calandarToManager); } } // כאן אני יעבור ל המעך של ימי השבוע ויבדוק אם אין ערך רעק ליום מסוים אם שי ערך ריק להוסים לי אוביקט ללא שם return(LCTM.OrderBy(r => r.date).ToList()); } }
public bool Pagar(string id) { using (restaurantEntities bdd = new restaurantEntities()) { int cod = int.Parse(id); bdd.P_ACTUALIZAR_ORDEN_PAGADA(cod); return(true); } }
// הוספת הודעה public static managerMessageDTO SendManagerMassegeToEmloyee(managerMessageDTO messege) { using (restaurantEntities db = new restaurantEntities()) { managerMessage m = managerMessageDTO.ConvertDonationToTabel(messege); db.managerMessage.Add(m); db.SaveChanges(); return(messege); } }
public static List <UserCalandarDTO> getDailyWorker() { using (restaurantEntities db = new restaurantEntities()) { List <UserCalander> userCalandar = db.UserCalander.Where(u => u.Date.Value.Year == DateTime.Today.Year && u.Date.Value.Month == DateTime.Today.Month && u.Date.Value.Day == DateTime.Today.Day).ToList(); return(UserCalandarC.ListToDTO(userCalandar)); } }
public ActionResult Login(int User, string Pass) { try { using (restaurantEntities db = new restaurantEntities()) { empleado emple; int id = 0; int idUsuario = 0; var userInterno = (from dd in db.cliente where dd.telefono.Value == User && dd.contraseña == Pass.Trim() select dd).FirstOrDefault(); if (userInterno == null) { emple = (from d2 in db.empleado where d2.telefooo == User && d2.contrasenia == Pass.Trim() select d2).FirstOrDefault(); if (emple == null) { ViewBag.Error = "Usuario o contraseña invalida"; return(View()); } id = (int)emple.rolEmp; idUsuario = (int)emple.id; } else { idUsuario = (int)userInterno.id; id = (int)userInterno.rolCli; } /*var oUser = (from d in db.usuario * where d.email == User.Trim() && d.password == Pass.Trim() * select d).FirstOrDefault();*/ var oUser = (from d in db.usuario where d.id == id select d).FirstOrDefault(); userr.id = oUser.id; userr.email = oUser.email; userr.idRol = (int)oUser.idRol; userr.nombre = oUser.nombre; userr.password = oUser.password; userr.IdUser = idUsuario; Session["User"] = userr; } return(RedirectToAction("Catalogo", "Productos")); } catch (Exception ex) { ViewBag.Error = ex.Message; return(View()); } }
public List <DetalleRecetaClase> ListarPlatosResumen() { using (restaurantEntities bdd = new restaurantEntities()) { return(bdd.F_LISTA_DE_PLATOS_RESUMEN().Select(l => new DetalleRecetaClase { Receta = l.Receta, Cantidad = l.Cantidad }).ToList()); } }
public List <DetalleOrdenClase> ListarOrdenesSinPagar() { using (restaurantEntities bdd = new restaurantEntities()) { return(bdd.F_LISTA_DE_ORDENES_SIN_PAGAR().Select(l => new DetalleOrdenClase { fecha_orden = l.Fecha, mesa = l.Mesa }).ToList()); } }
public List <t> ListarOrdenesSinPagarPorMesa(string mesa) { using (restaurantEntities bdd = new restaurantEntities()) { int m = int.Parse(mesa); return(bdd.F_LISTA_DE_ORDENES_SIN_PAGAR_POR_MESA(m).Select(l => new t { Id = l.Orden }).ToList()); } }
public string ActualizarEstadoMesa(string id, string capacidad) { using (restaurantEntities bdd = new restaurantEntities()) { short cod = short.Parse(id); byte cap = byte.Parse(capacidad); bdd.P_OCUPAR_MESA_SIN_RESERVA(cod, cap); return("Actualizado Correctamente"); } }
public string ActualizarEstadoOrden(string id, string estado) { using (restaurantEntities bdd = new restaurantEntities()) { int cod = int.Parse(id); byte est = byte.Parse(estado); bdd.P_ACTUALIZAR_ESTADO_ORDEN(cod, est); return("Actualizado Correctamente"); } }
public static managerMessageDTO EditReadMessege(managerMessageDTO messege) { using (restaurantEntities db = new restaurantEntities()) { messege.AlreadyRead = true; managerMessage m = managerMessageDTO.ConvertDonationToTabel(messege); db.Entry(m).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(messege); } }
public List <OrdenClase> ListarOrdenes() { using (restaurantEntities bdd = new restaurantEntities()) { return(bdd.F_LISTA_DE_ORDENES().Select(l => new OrdenClase { fecha = l.Fecha, Receta = l.Recetas, Total = l.Total }).ToList()); } }
public List <MesaClase> ListarMesas() { using (restaurantEntities bdd = new restaurantEntities()) { return(bdd.F_LISTA_DE_MESAS().Select(l => new MesaClase { Id = l.Id, Estado = l.Estado, Capacidad = l.Capacidad, Numero = l.Numero }).ToList()); } }
public List <RecetaClase> ListarRecetasMenu() { using (restaurantEntities bdd = new restaurantEntities()) { return(bdd.F_LISTA_DE_RECETAS_MENU().Select(l => new RecetaClase { Id = l.Id, Precio = l.Precio, Tipo = l.Tipo, Estado = true, Nombre = l.Nombre }).ToList()); } }
public List <item> getAllActiveItems() { using (restaurantEntities context = new restaurantEntities()) { try { return(context.item.Where(i => i.active == 1).ToList()); }catch (Exception ex) { Console.WriteLine(ex); return(null); } } }
public List <orderitem> getOrderItemsForOrderId(int orderId) { using (restaurantEntities context = new restaurantEntities()) { try { return(context.orderitem.Where(o => o.Order_id == orderId).ToList()); } catch { return(null); } } }
public List <order> getAllOrders() { using (restaurantEntities context = new restaurantEntities()) { try { return(context.order.ToList()); } catch { return(null); } } }
public List <order> getNotAcceptedOrders() { using (restaurantEntities context = new restaurantEntities()) { try { return(context.order.Where(o => o.accepted == 0).ToList()); } catch { return(null); } } }
public List <MesaClase> ListarMesasLibresC(string capacidad) { using (restaurantEntities bdd = new restaurantEntities()) { byte cap = byte.Parse(capacidad); return(bdd.F_LISTA_DE_MESAS_LIBRES().Where(c => c.Capacidad >= cap).Select(l => new MesaClase { Id = l.Id, Estado = l.Estado, Capacidad = l.Capacidad, Numero = l.Numero }).ToList()); } }
public List <DetalleOrdenClase> ListarOrdenesEnCocina() { using (restaurantEntities bdd = new restaurantEntities()) { return(bdd.F_LISTA_DE_ORDENES_EN_COCINA().Select(l => new DetalleOrdenClase { Orden = l.Orden, hora = l.Hora_Encargo, mesa = l.Numero_Mesa, nombre_receta = l.Receta, descripcion_dificultad = l.Dificultad }).ToList()); } }
public account getAccountForUsernameAndPassword(String username, String password) { using (restaurantEntities context = new restaurantEntities()) { try { return(context.account.Where(a => a.username.Equals(username) && a.password.Equals(password)).First()); } catch { return(null); } } }
public String getItemNameForId(int itemId) { using (restaurantEntities context = new restaurantEntities()) { try { return(context.item.Where(i => i.id == itemId).First().name); } catch { return(null); } } }
public List <accounttype> getAllAccountTypes() { using (restaurantEntities context = new restaurantEntities()) { try { return(context.accounttype.ToList()); } catch { return(null); } } }
public UserModel GetUser(int id) { var context = new restaurantEntities(); var entity = context.USERs.First(x => x.User_Id == id); return entity.ToUserModel(); }