public List <MessageDto> GetUnreadedMessageList(dugunEntities _context) { var currentUser = SessionControl.UserStatus; List <MessageDto> messages = new List <MessageDto>(); if (currentUser != null) { messages.AddRange(_context.Message.Where(x => x.UserIDReceiver == currentUser.UserID && x.IsRead == false).OrderByDescending(x => x.DtInsert). Select(x => new MessageDto() { UserIDReceiver = x.UserIDReceiver, DtInsert = x.DtInsert, RowStatus = x.RowStatus, MessageText = x.MessageText, UserIDSender = x.UserIDSender, User = x.UserIDSender != null ? new UserDto() { UserID = (int)x.UserIDSender, Name = x.User.Name, } : null, }).ToList()); } return(messages); }
public List <MessageDto> GetReceivedMessages(int page, int size, dugunEntities _context) { var currentUser = SessionControl.UserStatus; List <MessageDto> messages = null; messages = _context.Message .Where(x => x.UserIDReceiver == currentUser.UserID) .OrderByDescending(x => x.DtInsert) .Skip(page * size).Take(size) .Select(x => new MessageDto() { UserIDSender = x.UserIDSender, UserIDReceiver = x.UserIDReceiver, DtInsert = x.DtInsert, RowStatus = x.RowStatus, MessageID = x.MessageID, MessageText = x.MessageText, User1 = new UserDto() { UserID = (int)x.UserIDReceiver, Name = x.User1.Name, } }).ToList(); return(messages); }
public GuestDto DeleteGuest(int GuestID, dugunEntities _context) { Guest guest = _context.Guest.Where(x => x.GuestID == GuestID).FirstOrDefault(); if (guest == null) { return(new GuestDto() { ErrorObject = new ErrorDto() { IsError = true, ErrorMessage = "Misafir bulunamadı." } }); } if (guest.RowStatus == (int)Enums.RowStatus.PASSIVE) { return(new GuestDto() { ErrorObject = new ErrorDto() { IsError = true, ErrorMessage = "Misafir zaten daha önce silinmiş." } }); } guest.DtUpdate = DateTime.Now; guest.RowStatus = (int)Enums.RowStatus.PASSIVE; _context.SaveChanges(); return(new GuestDto(guest)); }
public int GetCurrentCountTable(int TableID, dugunEntities _context) { List <GuestDto> guestList = _context.Guest.Where(x => x.TableID == TableID && x.RowStatus == (int)Enums.RowStatus.ACTIVE) .Select(x => new GuestDto { GuestID = x.GuestID, }).ToList(); return(guestList.Count()); }
public UserDto SetUser(UserDto dto, dugunEntities _context) { #region Server Validation if (!Utils.ValidEmail(dto.EMail)) { return new UserDto() { ErrorObject = new ErrorDto() { IsError = true, ErrorMessage = "Email adresi geçersizdir." } } } ; #endregion #region Email'e göre sorgulama User entity = _context.User.Where(x => x.EMail == dto.EMail).FirstOrDefault(); if (entity != null) { return new UserDto() { ErrorObject = new ErrorDto() { IsError = true, ErrorMessage = "Bu Email adresi zaten kayıtlıdır." } } } ; #endregion entity = new User(); entity.Name = dto.Name; entity.Surname = dto.Surname; entity.EMail = dto.EMail; entity.UserTypeID = dto.UserTypeID; entity.DtInsert = DateTime.Now; entity.RowStatus = (int)Enums.RowStatus.PASSIVE; entity.Password = StringCipher.Encrypt(dto.Password, "password"); entity.DtInsert = DateTime.Now; entity.TelNo = dto.TelNo; entity.DugunID = dto.DugunID; entity.DugunSalonuID = dto.DugunSalonuID; _context.User.Add(entity); _context.SaveChanges(); return(new UserDto(entity)); } } }
public GuestDto ChangeGuestTable(int GuestID, int newTableID, dugunEntities _context) { Guest guest = _context.Guest.Where(x => x.GuestID == GuestID).FirstOrDefault(); Table table = _context.Table.Where(x => x.TableID == newTableID).FirstOrDefault(); if (guest == null) { return(new GuestDto() { ErrorObject = new ErrorDto() { IsError = true, ErrorMessage = "Misafir bulunamadı." } }); } if (table == null) { return(new GuestDto() { ErrorObject = new ErrorDto() { IsError = true, ErrorMessage = "Masa bulunamadı." } }); } if (guest.RowStatus == (int)Enums.RowStatus.PASSIVE) { return(new GuestDto() { ErrorObject = new ErrorDto() { IsError = true, ErrorMessage = "Misafir silinmiş." } }); } if (GetCurrentCountTable(newTableID, _context) >= table.Count) { return(new GuestDto() { ErrorObject = new ErrorDto() { IsError = true, ErrorMessage = "Ekleyeceğiniz masada yeterli yer bulunmamaktadır." } }); } guest.DtUpdate = DateTime.Now; guest.TableID = newTableID; _context.SaveChanges(); return(new GuestDto(guest)); }
public CategoryDto SetCategory(CategoryDto dto, dugunEntities _context) { Category entity = new Category(); entity.CategoryName = dto.CategoryName; entity.DtInsert = DateTime.Now; entity.RowStatus = (int)Enums.RowStatus.ACTIVE; _context.Category.Add(entity); _context.SaveChanges(); return(new CategoryDto(entity)); }
public MessageDto SetMessage(MessageDto dto, dugunEntities _context) { Message entity = new Message(); if (dto.UserIDSender != 0) { entity.UserIDSender = (int)SessionControl.UserStatus.UserID; } entity.MessageText = dto.MessageText; entity.UserIDReceiver = dto.UserIDReceiver; entity.RowStatus = (int)Enums.RowStatus.ACTIVE; entity.DtInsert = DateTime.Now; entity.IsRead = false; _context.Message.Add(entity); _context.SaveChanges(); return(new MessageDto(entity)); }
public UserDto GetUser(int userID, dugunEntities _context) { var entity = _context.User.FirstOrDefault(x => x.UserID == userID && x.RowStatus == (int)Enums.RowStatus.ACTIVE); UserDto user = new UserDto(); user = _context.User.Where(x => x.UserID == userID).Select(x => new UserDto() { UserID = x.UserID, Name = x.Name, Surname = x.Surname, DugunSalonuID = x.DugunSalonuID, DugunID = x.DugunID, EMail = x.EMail, TelNo = x.TelNo, UserName = x.UserName, DtInsert = x.DtInsert, DtUpdate = x.DtUpdate, }).FirstOrDefault(); return(user); }
public GuestDto SetGuest(GuestDto dto, dugunEntities _context) { Guest entity = new Guest(); entity = new Guest(); entity.Name = dto.Name; entity.Surname = dto.Surname; entity.TelNo = dto.TelNo; entity.State = dto.State; entity.Count = dto.Count; entity.Alcoholic = dto.Alcoholic; entity.TableID = dto.TableID; entity.DugunID = dto.DugunID; entity.CategoryID = dto.CategoryID; entity.ServiceID = dto.ServiceID; entity.DtInsert = DateTime.Now; entity.RowStatus = (int)Enums.RowStatus.ACTIVE; _context.Guest.Add(entity); _context.SaveChanges(); return(new GuestDto(entity)); }
public List <GuestDto> GetGuestsByTable(int TableID, dugunEntities _context) { List <GuestDto> guestList = _context.Guest.Where(x => x.TableID == TableID && x.RowStatus == (int)Enums.RowStatus.ACTIVE) .Select(x => new GuestDto { GuestID = x.GuestID, Name = x.Name, Surname = x.Surname, TelNo = x.TelNo, State = x.State, Count = x.Count, Alcoholic = x.Alcoholic, TableID = x.TableID, DugunID = x.DugunID, CategoryID = x.CategoryID, ServiceID = x.ServiceID, DtInsert = x.DtInsert, DtUpdate = x.DtUpdate, }).ToList(); return(guestList); }
public GuestDto GetGuest(int GuestID, dugunEntities _context) { var entity = _context.Guest.FirstOrDefault(x => x.GuestID == GuestID && x.RowStatus == (int)Enums.RowStatus.ACTIVE); GuestDto Guest = new GuestDto(); Guest = _context.Guest.Where(x => x.GuestID == GuestID).Select(x => new GuestDto() { GuestID = x.GuestID, Name = x.Name, Surname = x.Surname, TelNo = x.TelNo, State = x.State, Count = x.Count, Alcoholic = x.Alcoholic, TableID = x.TableID, DugunID = x.DugunID, CategoryID = x.CategoryID, ServiceID = x.ServiceID, DtInsert = x.DtInsert, DtUpdate = x.DtUpdate, }).FirstOrDefault(); return(Guest); }
public List <GuestDto> GetGuestsByWedding(int DugunID, int page, int size, dugunEntities _context) { List <GuestDto> discountList = _context.Guest.Where(x => x.DugunID == DugunID && x.RowStatus == (int)Enums.RowStatus.ACTIVE) .Skip(page * size) .Take(size) .Select(x => new GuestDto { GuestID = x.GuestID, Name = x.Name, Surname = x.Surname, TelNo = x.TelNo, State = x.State, Count = x.Count, Alcoholic = x.Alcoholic, TableID = x.TableID, DugunID = x.DugunID, CategoryID = x.CategoryID, ServiceID = x.ServiceID, DtInsert = x.DtInsert, DtUpdate = x.DtUpdate, }).ToList(); return(discountList); }
public Nullable <int> GetNewMessageCount(dugunEntities _context) { return(_context.Message.Count(x => x.UserIDReceiver == SessionControl.UserStatus.UserID && x.RowStatus == (int)Enums.RowStatus.ACTIVE && x.IsRead == false)); }
public static object Invoke <TResponse>(Expression <Func <TResponse> > function, object manager) { var fbody = function.Body as MethodCallExpression; if (fbody == null || fbody.Method == null) { throw new InvalidOperationException("Expression must be a method call."); } var method = (typeof(IWinService).GetMethod(fbody.Method.Name)); if (method != null) { var attributes = method.GetCustomAttributes(true); if (attributes != null) { List <AuthenticationAttribute> attr = attributes.Where(t => t.GetType() == typeof(AuthenticationAttribute)).Select(x => x as AuthenticationAttribute).ToList(); for (int i = 0; i < attr.Count; i++) { if (attr[i].Auth == AuthenticationType.Admin) { return(null); } } } } try { IList <object> managerInputs = new List <object>(); IList <MemberExpression> arguments = fbody.Arguments.OfType <MemberExpression>().ToList(); for (int argIndex = 0; argIndex < arguments.Count; argIndex++) { managerInputs.Add(ExpressionExtension.ExtractConstants(arguments[argIndex]).ToList()); } using (var context = new dugunEntities()) { context.Configuration.ProxyCreationEnabled = false; object[] dynamicArgs = null; if (managerInputs.Count > 0) { dynamicArgs = new object[managerInputs.Count + 1]; dynamicArgs[dynamicArgs.Length - 1] = context; for (int index = 0; index < dynamicArgs.Length - 1; index++) { dynamicArgs[index] = ((List <object>)managerInputs[index])[0]; } } return(managerInputs.Count > 0 ? fbody.Method.Invoke(manager, dynamicArgs) : fbody.Method.Invoke(manager, new object[] { context })); } } catch (TargetInvocationException tiex) { Exception dex = tiex.InnerException; throw dex; } catch (Exception ex) { throw ex; } finally { } }