private void DataPortal_Fetch(CriteriaOpenTicketByUser criteria)
{
var rlce = RaiseListChangedEvents;
RaiseListChangedEvents = false;
IsReadOnly = false;
using (DatabaseManager ctx = new DatabaseManager())
{
MySqlCommand cm = ctx.CreateSelectCommand();
cm.CommandText = @"SELECT idticket, TicketNo, TicketSubject, Requester, CallerPosistion, Priority, TicketOwner, TicketType, TicketStatus, TicketDescription, Solution, Escalation, CreatedBy,
CreatedDate, UpdatedBy, UpdatedDate, UpdateCommand FROM ticket_his
WHERE Escalation=@Escalation AND TicketStatus=@TicketStatus";
cm.Parameters.AddWithValue("@Escalation", criteria.UserName);
cm.Parameters.AddWithValue("@TicketStatus", TicketStatus.Open.ToString());
SafeDataReader dr = ctx.Read(cm);
while (dr.Read())
{
TicketHistoryInfo info = TicketHistoryInfo.GetTicketHistoryInfo(dr);
Add(info);
}
}
IsReadOnly = true;
RaiseListChangedEvents = rlce;
}
private void DataPortal_Fetch(CriteriaOpenTicketByUser 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 FROM ticket
WHERE Escalation=@Escalation AND TicketStatus=@TicketStatus";
cm.Parameters.AddWithValue("@Escalation", criteria.UserName);
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;
}
