public Boolean saveOpenCallManager(OpenCallManager openCall) { Boolean success; OleDbCommand cmd = DBConnection.getInstance.getDbCommand(); cmd.CommandText = "INSERT INTO OPEN_CALL_MANAGER (OCM_USER, OCM_PASSWORD, OCM_HOST, OCM_PORT) VALUES (?,?,?,?)"; cmd.Parameters.Add("OCM_USER", OleDbType.VarChar).Value = openCall.user; cmd.Parameters.Add("OCM_PASSWORD", OleDbType.VarChar).Value = openCall.password; cmd.Parameters.Add("OCM_HOST", OleDbType.VarChar).Value = openCall.host; cmd.Parameters.Add("OCM_PORT", OleDbType.Integer).Value = openCall.port; try { cmd.ExecuteNonQuery(); success = true; } catch (Exception e) { Console.WriteLine("Erro ao salvar!" + e); success = false; } DBConnection.getInstance.closeConnection(); return(success); }
public Boolean updateOpenCallManager(OpenCallManager openCall) { Boolean success; OleDbCommand cmd = DBConnection.getInstance.getDbCommand(); cmd.CommandText = "UPDATE OPEN_CALL_MANAGER SET OCM_USER=?, OCM_PASSWORD=?, OCM_HOST=?, OCM_PORT=?, OCM_LAST_MARKING_NSR=? WHERE ID_OCM=?"; cmd.Parameters.Add("OCM_USER", OleDbType.VarChar).Value = openCall.user; cmd.Parameters.Add("OCM_PASSWORD", OleDbType.VarChar).Value = openCall.password; cmd.Parameters.Add("OCM_HOST", OleDbType.VarChar).Value = openCall.host; cmd.Parameters.Add("OCM_PORT", OleDbType.Integer).Value = openCall.port; cmd.Parameters.Add("ID_OCM", OleDbType.Integer).Value = openCall.idOpenCallManager; try { cmd.ExecuteNonQuery(); success = true; } catch (Exception e) { Console.WriteLine("Erro ao alterar!" + e); success = false; } DBConnection.getInstance.closeConnection(); return(success); }
public OpenCallManager getOpenCallManager() { OpenCallManager openCall = null; OleDbCommand cmd = DBConnection.getInstance.getDbCommand(); cmd.CommandText = "SELECT * FROM OPEN_CALL_MANAGER"; OleDbDataReader result = cmd.ExecuteReader(); if (result.HasRows) { while (result.Read()) { openCall = new OpenCallManager(); openCall.idOpenCallManager = result.GetInt32(0); openCall.user = result.GetString(1); openCall.password = result.GetString(2); openCall.host = result.GetString(3); openCall.port = result.GetInt32(4); } } result.Close(); return(openCall); }
private void saveOpenCallManager() { OpenCallManager openCallManager = new OpenCallManager(); openCallManager.user = TBCallOpenUser.Text; openCallManager.password = TBCallOpenPassword.Password; openCallManager.host = TBCallOpenHost.Text; openCallManager.port = Convert.ToInt32(TBCallOpenPort.Text); if (idOpenCallManager == 0) { openCallManagerControl.saveOpenCallManager(openCallManager); } else { openCallManager.idOpenCallManager = idOpenCallManager; openCallManagerControl.updateOpenCallManager(openCallManager); } }
private void loadFields() { OpenCallManager openCallManager = openCallManagerControl.getOpenCallManager(); BobbinRequestManager bobbinRequestManager = bobbinRequestManagerControl.getBobbinRequestManager(); BadgeRequestManager badgeRequestManager = badgeRequestManagerControl.getBadgeRequestManager(); if (openCallManager != null) { TBCallOpenUser.Text = openCallManager.user; TBCallOpenPassword.Password = openCallManager.password; TBCallOpenHost.Text = openCallManager.host; TBCallOpenPort.Text = Convert.ToString(openCallManager.port); idOpenCallManager = openCallManager.idOpenCallManager; } if (bobbinRequestManager != null) { TBBobbinRequestUser.Text = bobbinRequestManager.user; TBBobbinRequestPassword.Password = bobbinRequestManager.password; TBBobbinRequestHost.Text = bobbinRequestManager.host; TBBobbinRequestPort.Text = Convert.ToString(bobbinRequestManager.port); idBobbinRequestManager = bobbinRequestManager.idBobbinRequest; } if (badgeRequestManager != null) { TBBadgeRequestUser.Text = badgeRequestManager.user; TBBadgeRequestPassword.Password = badgeRequestManager.password; TBBadgeRequestHost.Text = badgeRequestManager.host; TBBadgeRequestPort.Text = Convert.ToString(badgeRequestManager.port); idBadgeRequestManager = badgeRequestManager.idBadgeRequest; } }
public Boolean updateOpenCallManager(OpenCallManager openCall) { return(openCallDAO.updateOpenCallManager(openCall)); }
public Boolean saveOpenCallManager(OpenCallManager openCall) { return(openCallDAO.saveOpenCallManager(openCall)); }