public void SaveImages(ArrayList arrImages)
{
conn = new SqlConnection(strConn);
conn.Open();
SqlTransaction tr;
tr = conn.BeginTransaction();
try
{
for (int i = 0; i < arrImages.Count; i++)
{
SaveTicketImages objImages = new SaveTicketImages();
objImages = (SaveTicketImages)arrImages[i];
comm = new SqlCommand("sp_save_ticket_documents", conn);
comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
comm.CommandTimeout = 0;
comm.Transaction = tr;
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.AddWithValue("@sz_ticket_number", objImages.TicketNumber);
comm.Parameters.AddWithValue("@sz_file_name", objImages.FileName);
comm.Parameters.AddWithValue("@sz_file_path", objImages.FilePath);
comm.ExecuteNonQuery();
}
tr.Commit();
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
tr.Rollback();
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
protected void btnCreate_Click(object sender, EventArgs e)
{
if (this.validateFormInput())
{
SrvTickets srvTicket = new SrvTickets();
TicketDAO ticketDAO = new TicketDAO();
ticketDAO.RaisedBy = this.tRaisedBy.Text;
ticketDAO.Subject = this.tSubject.Text;
ticketDAO.Description = this.tDescription.Text;
ticketDAO.EmailCC = this.tEmailCC.Text;
ticketDAO.EmailDefault = this.tDefaultEmail.Text;
ticketDAO.CompanyID = this.objCompany.SZ_COMPANY_ID;
ticketDAO.CallbackPhone = this.tCallBack.Text;
ticketDAO.Priority = this.ddlPriority.Value.ToString();
string str = this.cIssueType.Value.ToString();
string str1 = str;
if (str != null)
{
if (str1 == "backend_support")
{
ticketDAO.Type = TicketType.BACKEND_SUPPORT;
}
else if (str1 == "data_import")
{
ticketDAO.Type = TicketType.DATA_IMPORT;
}
else if (str1 == "feature_request")
{
ticketDAO.Type = TicketType.FEATURE_REQUEST;
}
else if (str1 == "website_problem")
{
ticketDAO.Type = TicketType.WEBSITE_PROBLEM;
}
}
if (this.cSubTypes.Value != null)
{
string str2 = this.cSubTypes.Value.ToString();
string str3 = str2;
if (str2 != null)
{
switch (str3)
{
case "samd_patient":
{
ticketDAO.SubType = "SAMD-P";
break;
}
case "samd_visit":
{
ticketDAO.SubType = "SAMD-V";
break;
}
case "samd_procedure":
{
ticketDAO.SubType = "SAMD-PR";
break;
}
case "samd_diagnosis":
{
ticketDAO.SubType = "SAMD-D";
break;
}
case "samd_bill":
{
ticketDAO.SubType = "SAMD-B";
break;
}
case "excel_import":
{
ticketDAO.SubType = "EXI";
break;
}
case "manual_import":
{
ticketDAO.SubType = "MNI";
break;
}
case "routine_import":
{
ticketDAO.SubType = "RTI";
break;
}
case "application_error":
{
ticketDAO.SubType = "AE";
break;
}
case "reporting_error":
{
ticketDAO.SubType = "RE";
break;
}
case "thrown_out":
{
ticketDAO.SubType = "TO";
break;
}
}
}
}
ticketDAO = srvTicket.AddTicket(ticketDAO);
if (ticketDAO != null)
{
if (ticketDAO.TicketNumber == null)
{
this.lblErrorMessage.Text = "Oops! Some technical problem occurred while creating a ticket for you. Please contact adminisrator for assistance.";
this.lblErrorMessage.Visible = true;
return;
}
if (ticketDAO.TicketNumber == "")
{
this.lblErrorMessage.Text = "Oops! Some technical problem occurred while creating a ticket for you. Please contact adminisrator for assistance.";
this.lblErrorMessage.Visible = true;
return;
}
ArrayList arrayLists = new ArrayList();
string empty = string.Empty;
string fileName = string.Empty;
string empty1 = string.Empty;
if (this.fuFirst.HasFile)
{
empty = this.fuFirst.FileName;
SaveTicketImages saveTicketImage = new SaveTicketImages();
saveTicketImage.FileName = empty;
saveTicketImage.FilePath = string.Concat("Ticket/", ticketDAO.TicketNumber, "/");
saveTicketImage.TicketNumber = ticketDAO.TicketNumber;
arrayLists.Add(saveTicketImage);
}
if (this.fuSecond.HasFile)
{
fileName = this.fuSecond.FileName;
SaveTicketImages saveTicketImage1 = new SaveTicketImages();
saveTicketImage1.FileName = fileName;
saveTicketImage1.FilePath = string.Concat("Ticket/", ticketDAO.TicketNumber, "/");
saveTicketImage1.TicketNumber = ticketDAO.TicketNumber;
arrayLists.Add(saveTicketImage1);
}
if (this.fuThird.HasFile)
{
empty1 = this.fuThird.FileName;
SaveTicketImages saveTicketImage2 = new SaveTicketImages();
saveTicketImage2.FileName = empty1;
saveTicketImage2.FilePath = string.Concat("Ticket/", ticketDAO.TicketNumber, "/");
saveTicketImage2.TicketNumber = ticketDAO.TicketNumber;
arrayLists.Add(saveTicketImage2);
}
if (empty != string.Empty || fileName != string.Empty || empty1 != string.Empty)
{
string str4 = ConfigurationManager.AppSettings["BASEPATH"].ToString();
string str5 = string.Concat(str4, "Ticket/", ticketDAO.TicketNumber, "/");
if (!Directory.Exists(str5))
{
Directory.CreateDirectory(str5);
}
if (empty != string.Empty && !File.Exists(string.Concat(str5, empty)))
{
this.fuFirst.SaveAs(string.Concat(str5, empty));
}
if (fileName != string.Empty && !File.Exists(string.Concat(str5, fileName)))
{
this.fuFirst.SaveAs(string.Concat(str5, fileName));
}
if (empty1 != string.Empty && !File.Exists(string.Concat(str5, empty1)))
{
this.fuFirst.SaveAs(string.Concat(str5, empty1));
}
}
if (arrayLists.Count > 0)
{
(new SaveTicketImages()).SaveImages(arrayLists);
}
this.lblMessage.Text = "Ticket submitted successfully. We will ensure that your request is attended at the earliest. We request you to be patient and visit the View Tickets page to see the updates on your ticket.";
this.lblTicketNumber.Text = "Use your ticket reference number - " + ticketDAO.TicketNumber + " for all further communication related to this issue. Thank You.";
this.SendEmail(ticketDAO.TicketNumber);
this.btnCreate.Enabled = false;
this.resetControls();
return;
}
this.lblErrorMessage.Text = "Oops! Some technical problem occurred while creating a ticket for you. Please contact adminisrator for assistance.";
this.lblErrorMessage.Visible = true;
}
}
