protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
HttpContext.Current.Server.ScriptTimeout = 900000;
string val = Request.Form["confirm_value"];
//string val1=string.Empty;
//string jsScript = "";
//jsScript += "var answer=confirm(\'Action Already Taken do you want to modify?\');\n";
//jsScript += "if(answer){\n";
//jsScript += "'" + val1 + "'='YES'}\n";
bl mod = new bl();
int refno = int.Parse(DropDownList1.SelectedItem.Text);
MySqlDataReader dd = null;
dd = mod.modreq(refno);
if (val == "YES")
{
if (acttak != null)
{
}
bl upd = new bl();
int Ref_No = int.Parse(DropDownList1.SelectedItem.Text);
string Req_Name = TextB.Text;
string Com_Type = DropDownList3.SelectedItem.Text;
string Prob_Desc = TextBox5.Text;
string Rec_Date = null;
//string Rec_Date = Convert.ToDateTime(TextBox6.Text).ToString("yyyy/MM/dd hh:mm:ss");
if ((TextBox12.Text == "") || (TextBox13.Text == ""))
{
string Rec_Date1 = Convert.ToDateTime(TextBox6.Text).ToShortDateString() + " " + "00" + ":" + "00";
Rec_Date = Convert.ToDateTime(Rec_Date1).ToString("yyyy/MM/dd hh:mm:ss");
}
else
{
string Rec_Date1 = Convert.ToDateTime(TextBox6.Text).ToShortDateString() + " " + TextBox12.Text + ":" + TextBox13.Text;
Rec_Date = Convert.ToDateTime(Rec_Date1).ToString("yyyy/MM/dd hh:mm:ss");
}
string Req_Email = TextBox9.Text;
string Action = acttak.Text;
string Action_By = DropDownList2.SelectedItem.Text;
string Remarks = DropDownList5.SelectedItem.Value; //select manual for REMARKS and save data in "tbl_srvmast"
string Com_Date = Convert.ToDateTime(TextBox7.Text).ToString("yyyy/MM/dd hh:mm:ss"); //select manual by user and save data in "tbl_srvmast"
string Req_Status = DropDownList4.SelectedItem.Text;
float Req_Times = Convert.ToInt32(TextBox11.Text);
string servType = ddlType.SelectedItem.Text;
DateTime Com_Dates = DateTime.Now; //complete date save in tbl_srvmast1 only
DateTime escalate;
//to calculate escalate time
if (dd["Escalate_Date"].ToString() == "".Trim())
{
escalate = DateTime.Now;
TextBox14.Text = escalate.ToString();
}
else
{
escalate = Convert.ToDateTime(dd["Escalate_Date"]);
}
DateTime date_now = DateTime.Now;
//Automation REMARK for bos only and save in TABLE "tbl_srvmast1"
string Type = dd.GetString("Type");
string Remark = "";
double d = double.Parse(TextBox11.Text); //time comparison
if (Type == "Normal")
{
if ((d >= 0.00) && (d <= 38.00))
{
Remark = "Meet Hours";
}
else
{
Remark = "Not Meet Hours";
}
//TextBox7.Text = Type + "" + Remarks;
}
if (Type == "Priority")
{
if ((d >= 0.00) && (d <= 8.00))
{
Remark = "Meet Hours";
}
else
{
Remark = "Not Meet Hours";
}
//TextBox7.Text = Type + "" + Remarks;
}
if (Type == "Urgent")
{
if ((d >= 0.00) && (d <= 4.00))
{
Remark = "Meet Hours";
}
else
{
Remark = "Not Meet Hours";
}
//TextBox7.Text = Type + "" + Remarks;
}
//end calculation
bool stat = false;
try
{
HttpContext.Current.Server.ScriptTimeout = 9000;
Server.ScriptTimeout = 900;
stat = upd.updreq(Ref_No, Req_Name, Com_Type, Prob_Desc, Rec_Date, Req_Email, Req_Status, Action, Action_By, Com_Date, Remarks, Req_Times, servType); //table for audit reference
stat = upd.updreq1(Ref_No, Req_Name, Com_Type, Prob_Desc, Rec_Date, Req_Email, Req_Status, Action, Action_By, Com_Dates, Remark, Req_Times, servType); //table for BUSWANI reference
if (stat)
{
Response.Write("<script>alert('UPDATED SUCCESSFULLY');</script>");
//ScriptManager.RegisterClientScriptBlock(this.Page, typeof(Page), "myscript", "alert('MODIFIED SUCCESSFULLY')", true);
string formattedcomdate = Convert.ToDateTime(Com_Date).ToShortDateString();
System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage();
message.To.Add(Req_Email);
message.Subject = "Mail from Aerologica Service Team";
message.From = new System.Net.Mail.MailAddress("*****@*****.**");
message.Body = "Respected : " + Req_Name +
Environment.NewLine
+ Environment.NewLine
+ Environment.NewLine
+ "Type of Service Request: " + servType
+ Environment.NewLine
+ Environment.NewLine
+ Environment.NewLine
+ "Your Problem Description: " + Prob_Desc + " has now been solved."
+ Environment.NewLine
+ Environment.NewLine
+ "Action Description : " + Action
+ Environment.NewLine
+ Environment.NewLine
+ "Action Taken By Aerologica IT Personnel: " + Action_By
+ Environment.NewLine
+ Environment.NewLine
+ "on this date : " + formattedcomdate
+ Environment.NewLine
+ Environment.NewLine
+ Environment.NewLine
+ "Thank you."
+ Environment.NewLine
+ "AeroLogica Sdn Bhd"
+ Environment.NewLine
+ "Tel No: 03 -7846 5112 Ext No: 273 / 314 /317 ";
System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient("128.2.11.11");
smtp.Port = 25;
try
{
Response.Write("<script>alert('Email sent to Requestor Successfully');</script>");
//ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "myscript1", "alert('Email Sent Successfully')", true);
smtp.Send(message);
}
catch
{
Response.Write("<script>alert('Email COULDNT BE sent to Requestor');</script>");
//ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "myscript2", "alert('Email Couldnt be Sent')", true);
}
}
}
catch
{
Response.Write("<script>alert('COULDNT UPDATE THE RECORD TRY AGAIN');</script>");
stat = false;
}
}
}