private void LoginButton_Click(object sender, EventArgs e)
{
CodeHogEntities hogEntities = new CodeHogEntities();
string email = emailTextBox.Text;
string pass = passwordTextBox.Text;
var query = hogEntities.Users.Where(s => s.Email == email);
if (query.FirstOrDefault() != null)
{
User temp = query.FirstOrDefault();
if (temp.Password == pass)
{
MainMenu menu = new MainMenu();
menu.SetUser(temp.UserID, temp.Username, temp.RoleID);
menu.Show();
this.Hide();
}
else
{
MessageBox.Show("Failed login.");
}
}
else
{
MessageBox.Show("Login Failed: Please Check Email and Password");
}
}
//------------------------------ Constructor ------------------------------//
public MainMenu()
{
InitializeComponent();
codeHogEntities = new CodeHogEntities();
ApplyFilterToDataGrid();
}
public DependenciesMenu(string ticketID, CodeHogEntities currentCodeHogEntities)
{
InitializeComponent();
codeHogEntities = currentCodeHogEntities;
ticketIDLabel.Text = ticketID;
tempID = Convert.ToInt32(ticketIDLabel.Text); //this is only used to compare. See line below(if there is a better way please change it)
dependencyDataGridView.DataSource = codeHogEntities.Dependencies.Where(x => (x.TicketID == tempID)).ToList(); //display related ticketID
}
public Menus()
{
InitializeComponent();
codeHogEntities = new CodeHogEntities();
CurrentSort = Convert.ToBoolean(ChosenSort.TicketSort);
ApplyFilterToDataGrid();
}
public UserManagementMenu(UserLogin currentUser)
{
InitializeComponent();
codeHogEntities = new CodeHogEntities();
user = currentUser;
BindUserList();
roleComboBox.SelectedIndex = 0;
}
private int userIDNum; //the ID number of the current user
public AddNote(int tickNum, string userName, CodeHogEntities currentCodeHogEntities)
{
//setup
InitializeComponent();
codeHogEntities = currentCodeHogEntities;
ticketNumber = tickNum;
userN = userName;
//set the title component labels to the correct text
//set menu components
ticketNumPrintLabel.Text = ticketNumber.ToString(); //ticket Number label
usernamePrintLabel.Text = userN; //username label
}
private int chosenPriority; //New priority for ticket, as chosen by user
public ChangePriority(int ticketNum, CodeHogEntities currentCodeHogEntities, UserLogin currentUser)
{
//setup
InitializeComponent();
codeHogEntities = currentCodeHogEntities;
ticketNumber = ticketNum;
//set menu components
ticketNumPrintLabel.Text = ticketNum.ToString(); //ticket Number label
usernamePrintLabel.Text = currentUser.Name; //username label
//set default radial button to the ticket's current priority
foreach (var ticket in codeHogEntities.Tickets) //find the current ticket in the DB
{
if (ticket.TicketID == ticketNumber) //if the ticket in the DB is the ticket we are looking for
{
//Radio Button and default selection setup, based on existing priority within the ticket
switch (ticket.TicketPriority)
{
case 1:
radioButton1.Checked = true;
chosenPriority = 1;
break;
case 2:
radioButton2.Checked = true;
chosenPriority = 2;
break;
case 3:
radioButton3.Checked = true;
chosenPriority = 3;
break;
case 4:
radioButton4.Checked = true;
chosenPriority = 4;
break;
case 5:
radioButton5.Checked = true;
chosenPriority = 5;
break;
}
}
}
}
public DeleteTicketMenu()
{
InitializeComponent();
codeHogEntities = new CodeHogEntities();
//ticketIDLabel.Text =
}
public DeleteTicketMenu(string ticketID)
{
InitializeComponent();
codeHogEntities = new CodeHogEntities();
ticketIDLabel.Text = ticketID;
}
private void ButtonNewTicket_Click(object sender, EventArgs e)
{
//Prioerity Checking
int Pri = -1;
if (RadioPri1.Checked)
{
Pri = 1;
}
else if (RadioPri2.Checked)
{
Pri = 2;
}
else if (RadioPri3.Checked)
{
Pri = 3;
}
else if (RadioPri4.Checked)
{
Pri = 4;
}
else if (RadioPri5.Checked)
{
Pri = 5;
}
//Checking if all the required fileds are tehere
if (TextName.TextLength == 0 || TextDesc.TextLength == 0 || Pri == -1)
{
MessageBox.Show("Bro this is empty");
}
else
{
//Setting up the database.
var Database = new CodeHogEntities();
//Reporter should be the person who logs in UserId. Just putting a placeholder here for future referecne.
int Reporter = 1;
var NewTicket = new Ticket()
{
TicketArchiveStatus = false,
TicketStatus = 0,
TicketReporter = Reporter,
TicketDescription = TextDesc.Text,
TicketName = TextName.Text,
TicketPriority = Pri,
};
Database.Tickets.Add(NewTicket);
Database.SaveChanges();
// Dependcies checking
//Gettingt he piramary ticket ID
var query = Database.Tickets.Where(s => s.TicketID == NewTicket.TicketID);
Ticket Ticketp = query.FirstOrDefault <Ticket>();
//Create a new dependecny, and add it to database
foreach (DataGridViewRow temp in dataGridView1.SelectedRows)
{
int ticketidrow = Int32.Parse(temp.Cells[0].Value.ToString());
query = Database.Tickets.Where(s => s.TicketID == ticketidrow);
Dependency dependency = new Dependency()
{
DependentTicketID = query.FirstOrDefault <Ticket>().TicketID,
TicketID = Ticketp.TicketID
};
Console.WriteLine("OOps" + dependency.DependencyID + "\tFUCK" + dependency.TicketID);
Database.Dependencies.Add(dependency);
Database.SaveChanges();
}
//query = Database.Dependencies.Where(s => s.DependentTicketID == );
//NewTicket.Dependencies=
dataGridView1.Refresh();
// This is the default values of a newly created ticket.
//var wow=Database.Database.ExecuteSqlCommand("FROM * SELECT *");
}
}
