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