public firmware[] GetAllfirmwares() { DataSet ds = new DataSet(); ArrayList firmwarearr = new ArrayList(); string cmdStr = "SELECT * FROM [firmwaretbl]"; using (OleDbCommand command = new OleDbCommand(cmdStr)) { ds = GetMultipleQuery(command); } DataTable dt = new DataTable(); try { dt = ds.Tables[0]; } catch { } foreach (DataRow tType in dt.Rows) { firmware firmware = new firmware(); //firmware frimware = new firmware(); firmware.Id = int.Parse(tType[0].ToString()); firmware.BinaryFile = tType[1].ToString(); //package.FirmwareList = tType[2].ToString(); firmware.firmwareType = tType[2].ToString(); firmwarearr.Add(firmware); } return((firmware[])firmwarearr.ToArray(typeof(firmware))); }
//firmware functions private firmware[] Getfirmware(string cmdStr) { DataSet ds = new DataSet(); ArrayList firmware = new ArrayList(); using (OleDbCommand command = new OleDbCommand(cmdStr)) { ds = GetMultipleQuery(command); } DataTable dt = new DataTable(); try { dt = ds.Tables[0]; } catch { } foreach (DataRow tType in dt.Rows) { firmware firm = new firmware(); firm.Id = int.Parse(tType[0].ToString()); firmware.Add(firm); } return((firmware[])firmware.ToArray(typeof(firmware))); }
public void deleteFirmware(firmware deleteFirmware) { string cmdStr = "DELETE FROM firmwaretbl WHERE user ='******'"; using (OleDbCommand command = new OleDbCommand(cmdStr)) { base.ExecuteSimpleQuery(command); } }
public void addfirmware(firmware firm1) { string cmdStr = "INSERT INTO Firmwaretbl ([id],binaryfile,firmwaretype)VALUES(@id,@binaryfile,@firmwaretype)"; using (OleDbCommand command = new OleDbCommand(cmdStr)) { command.Parameters.AddWithValue("@id", firm1.Id); command.Parameters.AddWithValue("@binaryFile", firm1.BinaryFile); command.Parameters.AddWithValue("@firmwaretype", firm1.firmwareType); base.ExecuteSimpleQuery(command); } }
public void UpdateFirmware(firmware updateFirmware) { //query to update the user fields by take the name string cmdStr = "UPDATE [firmwaretbl] SET BinaryFile=@BinaryFile WHERE id=@id"; using (OleDbCommand command = new OleDbCommand(cmdStr)) { //update user fields to the database command.Parameters.AddWithValue("@BinaryFile", updateFirmware.BinaryFile); command.Parameters.AddWithValue("@id", updateFirmware.Id); base.ExecuteSimpleQuery(command); } }