/// <summary>
///
/// </summary>
/// <param name="RLOC"></param>
/// <returns></returns>
public bool FindEticketRecords(string RLOC)
{
bool rv = false;
String GetTick = "";
if (Request.QueryString["ET"] != null)
{
GetTick = Request.QueryString["ET"].ToString();
}
try
{
string strFormName = "";
if (m_GDS == "AU")
{
strFormName = "AXQIETICKETAUD";
}
else if (m_GDS == "SG")
{
strFormName = "AXQIETICKET";
}
else if (m_GDS == "IN")
{
strFormName = "AXQIETICKETINR";
}
DataSet m_ProcessPNRsDS = new DataSet();
MailRecordsBAL objMailRecordsBAL = new MailRecordsBAL("");
List <MailRecordsModel> lstMailRecordsModel = objMailRecordsBAL.FindEticketRecords(RLOC, GetTick, strFormName);
DataTable dt = Common.ListToDataTable(lstMailRecordsModel);
m_ProcessPNRsDS.Tables.Add(dt);
// check if the record exist already
//if (m_ProcessPNRsDS.Tables != null && m_ProcessPNRsDS.Tables.Count != 0 && m_ProcessPNRsDS.Tables[0].Rows != null)
// return rv;
string Created = "";
string Subject = "";
string LastSubject = "LastSubject";
foreach (DataRow myRow in m_ProcessPNRsDS.Tables[0].Rows)
{
string FormName = myRow["FormName"].ToString();
if (myRow["Created"].ToString() == Created && LastSubject == Subject)
{
// must be a copy record
continue;
}
Subject = myRow["Subject"].ToString();
if (FormName.ToUpper().IndexOf("QIETICKET") != -1)
{
Created = myRow["Created"].ToString();
LastSubject = Subject;
// look for matching surname
Match Ma = Regex.Match(Subject, GetNameCommand());
if (!Ma.Success)
{
continue;
}
string[] Names;
if (Ma.Groups["detail"].ToString().IndexOf("_") != -1)
{
Names = Ma.Groups["detail"].ToString().Split('_');
}
else
{
Names = Ma.Groups["detail"].ToString().Split('/');
}
string newName = Names[0].Trim();
if (newName == m_Surname)
{
if (myRow["FileName"] == null || myRow["FileName"].ToString().Length == 0)
{
continue;
}
string FileName = myRow["FileName"].ToString().ToUpper();
// now retrieve the doc and place it in the temp folder.
if (GetTransaction(ref FileName, myRow["TicketNumber"].ToString()))
{
Dictionary <string, string> dictionary = new Dictionary <string, string>();
dictionary.Add("c:/Temp/" + Path.GetFileName(FileName), myRow["Subject"].ToString());
var selectList = new SelectList(dictionary, "Key", "Value");
ViewData["ETicket"] = selectList;
//ListItem item = new ListItem(myRow["Subject"].ToString() + " ", "temp/" + Path.GetFileName(FileName)); //Need To Work
//DropDownList1.Items.Add(item);
if (GetTick.Length > 0)
{
Session["output"] = "c:/Temp/" + Path.GetFileName(FileName);
return(true);
//Response.Redirect("temp/" + Path.GetFileName(FileName), true);
}
}
rv = true;
}
}
}
m_ProcessPNRsDS.Dispose();
GC.Collect();
return(rv);
}
catch (InvalidOperationException ioExp)
{
m_LastError += "InvalidOperationException in FindMailrecords " + m_RLOC + " : " + ioExp.Message + "\r\n";
System.Diagnostics.Trace.WriteLine(ioExp.Message);
}
catch (MySqlException oleExp)
{
m_LastError += "MySqlException in FindMailrecords " + m_RLOC + " : " + oleExp.Message + "\r\n";
System.Diagnostics.Trace.WriteLine(oleExp.Message);
}
catch (Exception e)
{
m_LastError += "Exception in FindMailrecords " + m_RLOC + " : " + e.Message + "\r\n";
System.Diagnostics.Trace.WriteLine(e.Message);
}
return(rv);
}
