private void button1_Click(object sender, EventArgs e) { using (EquipReDataContext dbContext = new EquipReDataContext()) { try { EquipmentReturn submitchanges = dbContext.EquipmentReturns.SingleOrDefault(X => X.IDText.Contains(RID)); submitchanges.EscalationAgent = comboBox1.Text; submitchanges.EscalationStatus = true; submitchanges.EscalationDate = DateTime.Now; submitchanges.Notes += "\r\n\r\nEmail of Escalation Supervisor: " + textBox2.Text; eemail = textBox2.Text; submitchanges.TicketStatus = 'C'; sendemail(submitchanges.TagID, textBox2.Text, submitchanges.Phone_Number.ToString(), submitchanges.Assignee.ToString(), comboBox1.Text); dbContext.SubmitChanges(); owner.Close(); this.Close(); } catch (Exception explanation) { MessageBox.Show("Error! Unable to connect to server\r\n\r\n" + explanation); } } }
private void button5_Click(object sender, EventArgs e) { using (EquipReDataContext dbContext = new EquipReDataContext()) { try { EquipmentReturn submitchanges = dbContext.EquipmentReturns.SingleOrDefault(X => X.IDText.Contains(RID)); //notes if (textBox3.Text != "" && submitchanges.AdditionalNotes == "") { submitchanges.AdditionalNotes += username + " (" + DateTime.Now.ToString() + "): " + textBox3.Text; } else if (textBox3.Text != "" && submitchanges.AdditionalNotes != "" && submitchanges.AdditionalNotes != textBox2.Text) { submitchanges.AdditionalNotes += "\r\n\r\n" + username + " (" + DateTime.Now.ToString() + "): " + textBox3.Text; } submitchanges.TicketStatus = 'F'; //level of priority if (comboBox1.SelectedIndex == 0) { submitchanges.Priority = 'H'; } if (comboBox1.SelectedIndex == 1) { submitchanges.Priority = 'M'; } if (comboBox1.SelectedIndex == 2) { submitchanges.Priority = 'L'; } if (submitchanges.AdditionalNotes == textBox3.Text || (textBox3.Text == "" && submitchanges.AdditionalNotes == "") || textBox3.Text == "") { MessageBox.Show("Error! Enter all details before continuing"); } else { //Status if (radioButton1.Checked == true) { submitchanges.TicketStatus = 'O'; } if (radioButton2.Checked == true) { email ReturnClosed = new email(); ReturnClosed.sendemail("Return Ticket Closed", "This is a notice that a ticket for equipment returns has been closed. \r\n\r\nDevice ID: " + submitchanges.TagID + "\r\nPhone Number Called: " + submitchanges.Phone_Number + "\r\nDevice Assigned to: " + submitchanges.Assignee, submitchanges.IDText, "*****@*****.**"); submitchanges.TicketStatus = 'C'; } if (radioButton3.Checked == true) { submitchanges.TicketStatus = 'P'; } if (radioButton4.Checked == true) { submitchanges.TicketStatus = 'F'; } dbContext.SubmitChanges(); this.Close(); } } catch { MessageBox.Show("Error Submiting Data. Please contact your Network Administrator or IT team."); } } }
partial void DeleteEquipmentReturn(EquipmentReturn instance);
partial void UpdateEquipmentReturn(EquipmentReturn instance);
partial void InsertEquipmentReturn(EquipmentReturn instance);
private void button1_Click(object sender, EventArgs e) { if ((comboBox1.SelectedIndex == 4 && textBox2.Text == "") || textBox1.Text == "" || textBox3.Text == "") { MessageBox.Show("Please enter details in all fields"); } else { using (EquipReDataContext dbContext = new EquipReDataContext()) { DateTime blank = new DateTime(1990, 1, 1, 0, 0, 0); Random rnd = new Random(); string ID = "E" + long.Parse(DateTime.Now.ToString("MMddyyyyhhmm") + rnd.Next(1, 1000).ToString()); string reasons = ""; if (textBox2.Text != "") { reasons = comboBox1.Text + ": " + textBox2.Text; } else { reasons = comboBox1.Text; } EquipmentReturn returns = new EquipmentReturn() { Id = long.Parse(DateTime.Now.ToString("MMddyyyyhhmm") + rnd.Next(1, 1000).ToString()), IDText = ID, FirstContactPerson = "None", SecondContactPerson = "None", ThirdContactperson = "None", EscalationAgent = "None", EscalationStatus = false, FirstContactDate = blank, SecondContactDate = blank, ThirdContactDate = blank, EscalationDate = blank, Notes = "Device Assigned to: " + textBox3.Text + "\r\n", TicketStatus = 'P', Priority = 'L', Phone_Number = "000-000-0000", Assignee = textBox3.Text, Ticketor = username, DateCreated = DateTime.Now, Reason = reasons, TagID = textBox1.Text }; dbContext.EquipmentReturns.InsertOnSubmit(returns); try { dbContext.SubmitChanges(); } catch (Exception r) { MessageBox.Show("Error, unable to save to database. Check connection\r\n\r\n" + r.ToString()); } email ReturnSetup = new email(); ReturnSetup.sendemail("Return Ticket Created.", "A new Return ticket has been created.Please review this in the IT ticketing system for further information.\r\nThe ticket ID is: " + ID + "\r\nEquipmentID: " + textBox1.Text + "Assigned to: " + textBox3.Text, ID, "*****@*****.**"); this.Close(); } } }