public static bool Update(DTOInfor infor) { bool result = true; OleDbConnection connect = null; try { connect = openConnect(); string strCommand = "UPDATE [Infor] SET [FileName] = @file,[Size] = @size,[IPClient] = @ip,[PortClient] = @port,[FromClient] = @client,[Finish] = @flag WHERE FileName = @file AND FromClient = @client"; OleDbCommand command = new OleDbCommand(strCommand, connect); OleDbParameter parameter; parameter = new OleDbParameter("@file", OleDbType.VarChar); parameter.Value = infor.FileName; command.Parameters.Add(parameter); parameter = new OleDbParameter("@size", OleDbType.Integer); parameter.Value = infor.Size; command.Parameters.Add(parameter); parameter = new OleDbParameter("@ip", OleDbType.VarChar); parameter.Value = infor.IpClient; command.Parameters.Add(parameter); parameter = new OleDbParameter("@port", OleDbType.Integer); parameter.Value = infor.PortClient; command.Parameters.Add(parameter); parameter = new OleDbParameter("@client", OleDbType.VarChar); parameter.Value = infor.FromClient; command.Parameters.Add(parameter); parameter = new OleDbParameter("@flag", OleDbType.Boolean); parameter.Value = infor.Flag; command.Parameters.Add(parameter); parameter = new OleDbParameter("@file", OleDbType.VarChar); parameter.Value = infor.FileName; command.Parameters.Add(parameter); parameter = new OleDbParameter("@client", OleDbType.VarChar); parameter.Value = infor.FromClient; command.Parameters.Add(parameter); command.ExecuteNonQuery(); } catch (Exception) { result = false; } finally { if (connect == null && connect.State == System.Data.ConnectionState.Open) { connect.Close(); } } return(result); }
public ThreadDownload(String ip, String port, String sourse, String nameFile, Socket sockDownload, bool online, String username, String mePort, String meIp, int index, Download my, DTOInfor data) { C_online = online; IP_connect = ip; Port_connect = port; Str_sourse = sourse; Str_nameFile = nameFile; S_server = sockDownload; UserName = username; MePort = port; MeIP = ip; i_index = index; me = my; DataInfor = data; me.Sema_addClient.Release(); this.downloadFile(); }
public static List <DTOInfor> getListInfor() { OleDbConnection connect = null; List <DTOInfor> listInfor = new List <DTOInfor>(); try { connect = openConnect(); string strCommand = "SELECT * FROM Infor"; OleDbCommand command = new OleDbCommand(strCommand, connect); OleDbDataReader read = command.ExecuteReader(); while (read.Read()) { DTOInfor infor = new DTOInfor(); infor.Id = read.GetInt32(0); infor.FileName = read.GetString(1); infor.Size = read.GetInt32(2); infor.IpClient = read.GetString(3); infor.PortClient = read.GetInt32(4); infor.FromClient = read.GetString(5); infor.Flag = read.GetBoolean(6); listInfor.Add(infor); } read.Close(); } catch (Exception) { listInfor = new List <DTOInfor>(); } finally { if (connect == null && connect.State == System.Data.ConnectionState.Open) { connect.Close(); } } return(listInfor); }
public static bool Update(DTOInfor infor) { return(DAOInfor.Update(infor)); }
public static bool Insert(DTOInfor infor) { return(DAOInfor.Insert(infor)); }