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();
}
