public void MakeTicket()
{
TicketProcess ticketProcess = new TicketProcess();
int count = ticketProcess.GetTickets().Count;
Ticket ticket = new Ticket();
ticket.SenderName = "Sender";
ticket.SenderAddress = "*****@*****.**";
ticket.Subject = "Subject";
ticket.Body = "Body";
ticket.Source = new Source()
{
Provider = "System.Data.SqlClient",
Value = "select top 1000 userName as name, userEmail as address from Member where userEmail like '*****@*****.**'",
ConnectionString = "Data Source=tiger02;Initial Catalog=ALToolsMember;Integrated Security=False;User Id=svcinfra;Password=dkdlvhsy10;MultipleActiveResultSets=True"
};
string fileName = string.Empty;
ticketProcess.SaveTicket(ticket);
Assert.IsTrue(Directory.GetFiles(PathInfo.Ticket).Length == ++count);
ticketProcess = new TicketProcess();
Assert.IsTrue(ticketProcess.GetTickets().Count > 0);
}
private void EmptyTicket()
{
TicketProcess ticketProcess = new TicketProcess();
ticketProcess.EmptyTicket();
Assert.IsTrue(ticketProcess.GetTickets().Count == 0);
}
public void GetTickets()
{
TicketProcess ticketProcess = new TicketProcess();
List <Ticket> tickets = ticketProcess.GetTickets();
Source source = tickets[0].DecryptedSource;
Assert.IsTrue(!string.IsNullOrEmpty(source.Provider));
Assert.IsTrue(!string.IsNullOrEmpty(source.Value));
Assert.IsTrue(!string.IsNullOrEmpty(source.ConnectionString));
}
public void RemoveTicket()
{
EmptyTicket();
MakeTicket();
TicketProcess ticketProcess = new TicketProcess();
List <Ticket> tickets = ticketProcess.GetTickets();
ticketProcess.RemoveTicket(tickets[0]);
Assert.IsTrue(tickets.Count == (ticketProcess.GetTickets().Count + 1));
}
public void BuildQueue()
{
TicketTest ticketTest = new TicketTest();
ticketTest.MakeTicket();
//TicketInfo.GetTickets();
TicketProcess ticketProcess = new TicketProcess();
QueueProcess queueProcess = new QueueProcess();
queueProcess.BuildQueueFromTicket(ticketProcess, 100);
}
protected void btnSave_Click(object sender, EventArgs e)
{
Ticket ticket = new Ticket();
ticket.SenderName = txtSenderName.Text.Trim();
ticket.SenderAddress = txtSenderAddress.Text.Trim();
if (rdoRecipeints.SelectedIndex >= 0)
{
ticket.Source = sourceList[rdoRecipeints.SelectedValue];
}
else
{
List <string> recipients = new List <string>();
foreach (string r in txtRecipientAddress.Text.Split(new char[] { ',', ';' }, StringSplitOptions.RemoveEmptyEntries))
{
recipients.Add(r.Trim());
}
ticket.Source = new Source
{
Provider = "System.String[]",
Value = string.Join(";", recipients),
ConnectionString = "NODATA"
};
}
ticket.Subject = txtSubject.Text.Trim();
ticket.Body = txtHtml.Text;
TicketProcess ticketProcess = new TicketProcess();
ticketProcess.SaveTicket(ticket); // TODO: check result is success?
try
{
history.SetHistory(ticket);
history.ClearHistory(100);
}
catch { }
Response.Redirect("~/Logs.aspx", false);
}
public void Process()
{
if (processing)
{
return;
}
lock (lockObj)
{
processing = true;
}
TicketProcess ticketProcess = new TicketProcess();
QueueProcess queueProcess = new QueueProcess();
queueProcess.BuildQueueFromTicket(
ticketProcess,
Convert.ToInt32(ConfigurationManager.AppSettings["BlockCount"])
);
processing = false;
}
public void GetSourceFromTicket()
{
MakeTicket();
TicketProcess ticketProcess = new TicketProcess();
List <Ticket> tickets = ticketProcess.GetTickets();
Source source = tickets[0].DecryptedSource;
string value = source.Value;
string connectionString = source.ConnectionString;
if (source.Provider == "System.Data.SqlClient")
{
Database db = new SqlDatabase(source.ConnectionString);
DataSet ds = db.ExecuteDataSet(CommandType.Text, source.Value);
Assert.IsTrue(ds.Tables.Count > 0 && ds.Tables[0].Rows.Count >= 0);
}
else
{
throw new NotSupportedException();
}
}
