private async void SubmitButton_Click(object sender, RoutedEventArgs e) { var ticket = new Ticket(); var customer = new Customer(); using (var Db = new HelpDeskDataContext()) { try { customer.Name = CustomerList.Text; ticket.DeviceType = DeviceType.Text; ticket.Customer = customer; ticket.SerialNumber = SerialNumberField.Text; ticket.PartNumber = PartNumberField.Text; Db.Add(ticket); Db.SaveChanges(); OutputTextBlock.Text = ticket.Id + " " + "Created."; } catch (Exception) { var message = new MessageDialog("Error Ticket Not Created"); await message.ShowAsync(); } } SubmitButton.IsEnabled = false; var send = new Send(); await send.Send_Email(ticket); SubmitButton.IsEnabled = true; ClearField(); }
public RegisteredEvent CreateReview(CreateEvent newRegistry) { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { using (var transaction = helpDeskDataContext.Database.BeginTransaction()) { try { var eEvent = newRegistry.ToEntityReview(); helpDeskDataContext.Events.Add(eEvent); helpDeskDataContext.SaveChanges(); var eRequest = helpDeskDataContext.Requests.Where(x => x.Id == eEvent.RequestId).First(); eRequest.State = 3; helpDeskDataContext.Requests.Attach(eRequest); helpDeskDataContext.Entry(eRequest).Property(x => x.State).IsModified = true; helpDeskDataContext.SaveChanges(); transaction.Commit(); return(eEvent.ToDTO()); } catch (Exception) { transaction.Rollback(); return(new RegisteredEvent()); } } } }
public List <RegisteredEventType> List() { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { return(helpDeskDataContext.EventTypes.ToList().Select(x => x.ToDTO()).ToList()); } }
public RegisteredUser ListUsersById(int userId) { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { return(helpDeskDataContext.Users.Where(x => x.Id == userId).ToList().Select(x => x.ToDTO()).ToList().First()); } }
public List <RegisteredRequestState> List() { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { return(helpDeskDataContext.RequestStates.ToList().Select(x => x.ToDTO()).ToList()); } }
public List <RegisteredUser> List() { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { return(helpDeskDataContext.Users.ToList().Select(x => x.ToDTO()).ToList()); } }
public List <RegisteredUser> Login(LoginRequest loginRequest) { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { var list = helpDeskDataContext.Users.Where(x => x.UserName.Equals(loginRequest.User) && x.UserPassword.Equals(loginRequest.Pass)).ToList(); return(list.Select(x => x.ToDTO()).ToList()); } }
/// <summary> /// Initializes the singleton application object. This is the first line of authored code /// executed, and as such is the logical equivalent of main() or WinMain(). /// </summary> public App() { this.InitializeComponent(); this.Suspending += OnSuspending; using (var Db = new HelpDeskDataContext()) { Db.Database.Migrate(); } }
public List <RegisteredEvent> ListEventsByRequest(int RequestId) { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { return(helpDeskDataContext.Events .Include("User") .Include("EventType") .Where(x => x.RequestId == RequestId).ToList().Select(x => x.ToDTO()).ToList()); } }
public RegisteredRequestFile CreateFile(CreateRequestFile createRequestFile) { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { var newRequestFile = createRequestFile.ToEntity(); helpDeskDataContext.Files.Add(newRequestFile); helpDeskDataContext.SaveChanges(); return(newRequestFile.ToDTO()); } }
public RegisteredRequest Create(CreateRequest newRegistry) { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { var newRequest = newRegistry.ToEntity(); helpDeskDataContext.Requests.Add(newRequest); helpDeskDataContext.SaveChanges(); return(newRequest.ToDTO()); } }
public RegisteredUser Create(CreateUser newRegistry) { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { var eUser = newRegistry.ToEntity(); helpDeskDataContext.Users.Add(eUser); helpDeskDataContext.SaveChanges(); return(eUser.ToDTO()); } }
public RegisteredEvent Create(CreateEvent newRegistry) { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { var eEvent = newRegistry.ToEntity(); helpDeskDataContext.Events.Add(eEvent); helpDeskDataContext.SaveChanges(); return(eEvent.ToDTO()); } }
public RegisteredModule Create(CreateModule newRegistry) { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { var eModule = newRegistry.ToEntity(); helpDeskDataContext.Modules.Add(eModule); helpDeskDataContext.SaveChanges(); return(eModule.ToDTO()); } }
public List <RegisteredRequest> List() { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { return(helpDeskDataContext.Requests .Include(x => x.User) .Include(x => x.Module) .Include(x => x.RequestState) .Include(x => x.AttentionUser).ToList().Select(x => x.ToDTO()).ToList()); } }
public RegisteredModule Update(UpdateModule updateRegistry) { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { var module = updateRegistry.ToEntity(); helpDeskDataContext.Modules.Attach(module); helpDeskDataContext.Entry(module).Property(x => x.Name).IsModified = true; helpDeskDataContext.SaveChanges(); return(module.ToDTO()); } }
public CustomerViewModel() { using (var Db = new HelpDeskDataContext()) { var query = from c in Db.Customers select c; foreach (var c in query) { CustList.Add(c); list = CustList; } } }
public List <RegisteredRequest> ListRequestsByStateAndUser(int UserId, int State) { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { return(helpDeskDataContext.Requests .Include(x => x.User) .Include(x => x.Module) .Include(x => x.RequestState) .Include(x => x.AttentionUser).ToList() .Where(x => x.State == (State == 0 ? x.State : State) && x.UserId == UserId) .Select(x => x.ToDTO()).ToList()); } }
public RegisteredRequest CloseRequest(UpdateRequest updateRequest) { using (HelpDeskDataContext helpDeskDataContext = new HelpDeskDataContext()) { using (var transaction = helpDeskDataContext.Database.BeginTransaction()) { var request = updateRequest.ToEntityClose(); helpDeskDataContext.Requests.Attach(request); helpDeskDataContext.Entry(request).Property(x => x.State).IsModified = true; helpDeskDataContext.Entry(request).Property(x => x.LastUpdateUserId).IsModified = true; helpDeskDataContext.SaveChanges(); transaction.Commit(); return(request.ToDTO()); } } }
private async void SaveButton_Click(object sender, RoutedEventArgs e) { try { using (var Db = new HelpDeskDataContext()) { var customer = new Customer(); customer.Name = NameField.Text; customer.EmailAddress = EmailField.Text; Db.Add(customer); Db.SaveChanges(); OutputTextBlock.Text = customer.Name + " " + "Created."; ClearField(); } } catch (Exception) { var message = new MessageDialog("Unable to Create Ticket"); await message.ShowAsync(); } }