private void DataPortal_Fetch(CriteriaOpenTicket criteria)
{
var rlce = RaiseListChangedEvents;
RaiseListChangedEvents = false;
IsReadOnly = false;
using (MySqlConnection cn = new MySqlConnection(Database.ConnectionString))
{
cn.Open();
MySqlCommand cm = cn.CreateCommand();
cm.CommandText = @"SELECT idticket, TicketNo, TicketSubject, Requester, CallerPosistion, Priority, TicketOwner, TicketType, TicketStatus, TicketDescription, Solution, Escalation, CreatedBy,
CreatedDate, UpdatedBy, UpdatedDate, UpdateCommand FROM ticket_his
WHERE TicketStatus=@TicketStatus";
cm.Parameters.AddWithValue("@TicketStatus", TicketStatus.Open.ToString());
SafeDataReader dr = new SafeDataReader(cm.ExecuteReader());
while (dr.Read())
{
TicketHistoryInfo info = TicketHistoryInfo.GetTicketHistoryInfo(dr);
Add(info);
}
cn.Close();
}
IsReadOnly = true;
RaiseListChangedEvents = rlce;
}
private void DataPortal_Fetch(CriteriaOpenTicket criteria)
{
var rlce = RaiseListChangedEvents;
RaiseListChangedEvents = false;
IsReadOnly = false;
using (MySqlConnection cn = new MySqlConnection(Database.ConnectionString))
{
cn.Open();
MySqlCommand cm = cn.CreateCommand();
cm.CommandText = @"SELECT t.idticket, t.TicketNo, t.TicketSubject, t.Requester, t.CallerPosistion, t.Priority, t.TicketOwner, t.TicketType, t.TicketStatus, t.TicketDescription,
t.Solution, t.Escalation, t.CreatedBy, t.CreatedDate, t.UpdatedBy, t.UpdatedDate, CONCAT_WS(' ', c.FirstName, c.LastName) AS CustomerName FROM ticket t
JOIN customer c ON t.requester = c.email
WHERE TicketStatus=@TicketStatus";
cm.Parameters.AddWithValue("@TicketStatus", TicketStatus.Open.ToString());
SafeDataReader dr = new SafeDataReader(cm.ExecuteReader());
while (dr.Read())
{
TicketInfo info = TicketInfo.GetTicketInfo(dr);
Add(info);
}
cn.Close();
}
IsReadOnly = true;
RaiseListChangedEvents = rlce;
}
