private void DataPortal_Fetch(CriteriaCloseTicketByUser 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.Closed.ToString()); SafeDataReader dr = ctx.Read(cm); while (dr.Read()) { TicketHistoryInfo info = TicketHistoryInfo.GetTicketHistoryInfo(dr); Add(info); } } IsReadOnly = true; RaiseListChangedEvents = rlce; }
private void DataPortal_Fetch(CriteriaCloseTicketByUser 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.Closed.ToString()); SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()); while (dr.Read()) { TicketInfo info = TicketInfo.GetTicketInfo(dr); Add(info); } cn.Close(); } IsReadOnly = true; RaiseListChangedEvents = rlce; }