public static ClientsDetailsPackage getClientsDetailsPackage(LoginPackage lp)
{
if (!isClientExist(lp.Username, lp.Password))
{
return new ClientsDetailsPackage {
Exist = false
}
}
;
setLogOn(lp);
Client c = new Client();
c.getClient(lp.Username);
foreach (var item in lp.FileList)
{
int id = item.insertFile();
ClientFile cf = new ClientFile(lp.Username, id);
cf.insertClientFile();
}
return(new ClientsDetailsPackage {
Exist = true, Username = c.Username, UpPath = c.UpPath, DownPath = c.DownPath, IP = c.Ip, Port = c.Port
});
}
private static void setLogOn(LoginPackage lp)
{
string connectionString = ConfigurationManager.ConnectionStrings["MiniTorrentLibrary.Properties.Settings.MiniTorrentDBConnectionString"].ConnectionString;
string query = "UPDATE Clients SET Active = @active, Ip = @ip, Port = @port where Username = @username";
using (SqlConnection connection = new SqlConnection(connectionString))
using (SqlCommand command = new SqlCommand(query, connection))
{
connection.Open();
command.Parameters.AddWithValue("@username", lp.Username);
command.Parameters.AddWithValue("@active", true);
command.Parameters.AddWithValue("@ip", lp.IP);
command.Parameters.AddWithValue("@port", lp.Port);
command.ExecuteScalar();
}
}