public override void Fill(List<ProxyLetter> list, Profile user) { list.Clear(); SqlConnection _connection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Gleb\Desktop\GEMC\GEMC\EMCdataBase.mdf;Integrated Security=True;"); SqlCommand cmd = new SqlCommand(); SqlDataReader dr; cmd.Connection = _connection; _connection.Open(); cmd.CommandText = "select * from Mail where ProfileId='" + user.Id + "' and AdressTo='" + user.Adress + "'"; dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { ProxyLetter proxy = new ProxyLetter(dr[0].ToString(), dr[2].ToString(), Convert.ToDateTime(dr[7])); proxy.Interlocutor = dr[4].ToString(); list.Add(proxy); } } _connection.Close(); }
public static ProxyList GetSended(Profile user) { ProxyList proxies = new ProxyList("Отправленные", user.Id); LocalSQLConnection sqlconnectionClass = new LocalSQLConnection(); SqlCommand cmd = sqlconnectionClass.DeployConnectionAndCommand(); cmd.CommandText = "select * from Mail where ProfileId='" + user.Id + "' and Category='Outbox'"; SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { ProxyLetter proxy = new ProxyLetter(dr[0].ToString(), dr[2].ToString(), Convert.ToDateTime(dr[7])); proxy.Interlocutor = dr[5].ToString(); proxies.ProxyMailList.Add(proxy); } } sqlconnectionClass.CloseConnection(); return proxies; }
public static void ChangeLetterFolderInDB(ProxyLetter letter, string folderName) { LocalSQLConnection sqlconnectionClass = new LocalSQLConnection(); SqlCommand cmd = sqlconnectionClass.DeployConnectionAndCommand(); cmd.CommandText = "Update Mail SET Category = '" + folderName + "' where Id = '" + letter.Id + "'"; cmd.ExecuteNonQuery(); sqlconnectionClass.CloseConnection(); }