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();
}
