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