public bool CreateAccount(AddRegisterRequest request) { List <Register> values; values = _db.Registers.Where(a => a.Email == request.email).ToList(); if (values.Count > 0) { return(false); } else { Register register = new Register { FirstName = request.firstname, LastName = request.lastname, Email = request.email, Password = EncodePasswordToBase64(request.password), Created = DateTime.Now, LastModified = DateTime.Now }; _db.Registers.Add(register); _db.SaveChanges(); return(true); } }
public bool AddContact(AddContactRequest request) { if (request != null) { int secretNumber = 5306; request.userId = request.userId - secretNumber; var result = _db.Contacts.Where(a => a.registerId == request.userId).FirstOrDefault(); if (result == null) { Contact contact = new Contact { Email = request.email, Mobile = request.mobile, registerId = request.userId }; _db.Contacts.Add(contact); _db.SaveChanges(); return(true); } } return(false); }
public bool AddTicket(AddTicketRequest request) { int secretKey = 5306; request.UserId = request.UserId - secretKey; if (request != null) { var result = _db.Tickets.Where(a => a.Title == request.title && a.registerId == request.UserId).FirstOrDefault(); if (result != null) { return(false); } else { Ticket ticket = new Ticket { Title = request.title, Description = request.description, Status = "open", Priority = 2, ResponderId = 0, Created = DateTime.Now, LastModified = DateTime.Now, registerId = request.UserId }; _db.Tickets.Add(ticket); _db.SaveChanges(); var result1 = _db.Tickets.Where(a => a.registerId == request.UserId && a.Title == request.title && a.Description == request.description).FirstOrDefault(); //Adding all information to logs table Logs logs = new Logs { Description = request.description, Title = request.title, LastModified = DateTime.Now, ticketId = result1.Id, registerId = request.UserId }; _db.Logs.Add(logs); _db.SaveChanges(); return(true); } } return(false); }