public CallRecord GetRecord(int ID) { string com = "SELECT * FROM IncomingCalls WHERE ID = " + ID.ToString(); MySqlCommand command = new MySqlCommand(com, con); MySqlDataReader reader = command.ExecuteReader(); CallRecord record = new CallRecord(); int counter = 0; while (reader.Read()) { counter++; record.ID = ID; record.Date = reader["Date"].ToString(); record.Time = reader["Time"].ToString(); record.Name = reader["Name"].ToString(); record.Phone = reader["PhoneNumber"].ToString(); record.Type = reader["TechType"].ToString(); record.Brand = reader["Brand"].ToString(); record.Reason = reader["Reason"].ToString(); record.Status = CallRecord.StringToStatus(reader["State"].ToString()); record.DiagnosticDate = reader["DiagnosticDate"].ToString(); record.RecallDate = reader["RecallDate"].ToString(); } reader.Close(); return(record); }
public string WriteRecord(CallRecord record) { string com = (new StringBuilder()).AppendFormat("INSERT INTO IncomingCalls (Date,Time,Name,PhoneNumber,TechType,Brand,Reason,State) VALUES ('{0}','{1}','{2}','+7{3}','{4}','{5}','{6}','{7}')", record.Date, record.Time, record.Name, record.Phone, record.Type, record.Brand, record.Reason, CallRecord.StatusToString(record.Status)).ToString(); MySqlCommand comm = new MySqlCommand(com, con); comm.ExecuteNonQuery(); RecordReceived(); return(com); }
public int[] GetTotalCallsToday() { string com = "SELECT * FROM IncomingCalls WHERE Date = '" + DateTime.Now.ToShortDateString() + "'"; MySqlCommand command = new MySqlCommand(com, con); MySqlDataReader reader = command.ExecuteReader(); int counter = 0; int wrongCounter = 0; while (reader.Read()) { counter++; if (reader["State"].ToString() == CallRecord.StatusToString(ApplicationStatus.WrongCall)) { wrongCounter++; } } reader.Close(); int[] ar = new int[2]; ar[0] = counter; ar[1] = wrongCounter; return(ar); }
public List <CallRecord> GetAllAtDiagnostic() { List <CallRecord> records = new List <CallRecord>(); string com = "SELECT * FROM IncomingCalls WHERE DiagnosticDate = '" + DateTime.Now.ToShortDateString() + "'"; MySqlCommand command = new MySqlCommand(com, con); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { CallRecord rec = new CallRecord(); rec.Name = reader["Name"].ToString(); rec.Phone = reader["PhoneNumber"].ToString(); rec.Reason = reader["Reason"].ToString(); rec.Status = CallRecord.StringToStatus(reader["State"].ToString()); records.Add(rec); } reader.Close(); return(records); }
public bool UpdateRecord(CallRecord record) { string com = " "; try { com = new StringBuilder().AppendFormat("" + "UPDATE" + " IncomingCalls" + " SET" + " Date = '{0}'," + " Time = '{1}'," + " Name = '{2}'," + " PhoneNumber = '{3}'," + " TechType = '{4}'," + " Brand = '{5}'," + " Reason = '{6}'," + " State = '{7}'," + " DiagnosticDate = '{8}'," + " RecallDate = '{9}'" + " WHERE ID= {10}" , record.Date, record.Time, record.Name, record.Phone, record.Type, record.Brand, record.Reason, CallRecord.StatusToString(record.Status), record.DiagnosticDate, record.RecallDate, record.ID.ToString()).ToString(); MySqlCommand command = new MySqlCommand(com, con); command.ExecuteNonQuery(); RecordReceived(); return(true); } catch (MySqlException e) { return(false); } }
public List <CallRecord> GetAllRecievedRecords() { List <CallRecord> records = new List <CallRecord>(); string com = "SELECT ID, Date, Time, Name, PhoneNumber, TechType, Brand, Reason, State FROM IncomingCalls WHERE State = 'Звонок принят'"; MySqlCommand command = new MySqlCommand(com, con); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { records.Add(new CallRecord(Convert.ToInt32(reader["ID"].ToString()), reader["Date"].ToString(), reader["Time"].ToString(), reader["Name"].ToString(), reader["PhoneNumber"].ToString(), reader["TechType"].ToString(), reader["Brand"].ToString(), reader["Reason"].ToString(), CallRecord.StringToStatus(reader["State"].ToString()))); } reader.Close(); return(records); }