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