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