public Boolean saveBadgeRequestManager(BadgeRequestManager badgeRequest)
{
Boolean success;
OleDbCommand cmd = DBConnection.getInstance.getDbCommand();
cmd.CommandText = "INSERT INTO BADGE_REQUEST_MANAGER (BGRM_USER, BGRM_PASSWORD, BGRM_HOST, BGRM_PORT) VALUES (?,?,?,?)";
cmd.Parameters.Add("BGRM_USER", OleDbType.VarChar).Value = badgeRequest.user;
cmd.Parameters.Add("BGRM_PASSWORD", OleDbType.VarChar).Value = badgeRequest.password;
cmd.Parameters.Add("BGRM_HOST", OleDbType.VarChar).Value = badgeRequest.host;
cmd.Parameters.Add("BGRM_PORT", OleDbType.Integer).Value = badgeRequest.port;
try
{
cmd.ExecuteNonQuery();
success = true;
}
catch (Exception e)
{
Console.WriteLine("Erro ao salvar!" + e);
success = false;
}
DBConnection.getInstance.closeConnection();
return(success);
}
public Boolean updateBadgeRequestManager(BadgeRequestManager badgeRequest)
{
Boolean success;
OleDbCommand cmd = DBConnection.getInstance.getDbCommand();
cmd.CommandText = "UPDATE BADGE_REQUEST_MANAGER SET BGRM_USER=?, BGRM_PASSWORD=?, BGRM_HOST=?, BGRM_PORT=?, BGRM_LAST_MARKING_NSR=? WHERE ID_BGRM=?";
cmd.Parameters.Add("BGRM_USER", OleDbType.VarChar).Value = badgeRequest.user;
cmd.Parameters.Add("BGRM_PASSWORD", OleDbType.VarChar).Value = badgeRequest.password;
cmd.Parameters.Add("BGRM_HOST", OleDbType.VarChar).Value = badgeRequest.host;
cmd.Parameters.Add("BGRM_PORT", OleDbType.Integer).Value = badgeRequest.port;
cmd.Parameters.Add("ID_BGRM", OleDbType.Integer).Value = badgeRequest.idBadgeRequest;
try
{
cmd.ExecuteNonQuery();
success = true;
}
catch (Exception e)
{
Console.WriteLine("Erro ao alterar!" + e);
success = false;
}
DBConnection.getInstance.closeConnection();
return(success);
}
public BadgeRequestManager getBadgeRequestManager()
{
BadgeRequestManager badgeRequest = null;
OleDbCommand cmd = DBConnection.getInstance.getDbCommand();
cmd.CommandText = "SELECT * FROM BADGE_REQUEST_MANAGER";
OleDbDataReader result = cmd.ExecuteReader();
if (result.HasRows)
{
while (result.Read())
{
badgeRequest = new BadgeRequestManager();
badgeRequest.idBadgeRequest = result.GetInt32(0);
badgeRequest.user = result.GetString(1);
badgeRequest.password = result.GetString(2);
badgeRequest.host = result.GetString(3);
badgeRequest.port = result.GetInt32(4);
}
}
result.Close();
return(badgeRequest);
}
private void saveBadgeRequestManager()
{
BadgeRequestManager badgeRequestManager = new BadgeRequestManager();
badgeRequestManager.user = TBBadgeRequestUser.Text;
badgeRequestManager.password = TBBadgeRequestPassword.Password;
badgeRequestManager.host = TBBadgeRequestHost.Text;
badgeRequestManager.port = Convert.ToInt32(TBBadgeRequestPort.Text);
if (idBadgeRequestManager == 0)
{
badgeRequestManagerControl.saveBadgeRequestManager(badgeRequestManager);
}
else
{
badgeRequestManager.idBadgeRequest = idBadgeRequestManager;
badgeRequestManagerControl.updateBadgeRequestManager(badgeRequestManager);
}
}
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 updateBadgeRequestManager(BadgeRequestManager badgeRequest)
{
return(badgeRequestDAO.updateBadgeRequestManager(badgeRequest));
}
public Boolean saveBadgeRequestManager(BadgeRequestManager badgeRequest)
{
return(badgeRequestDAO.saveBadgeRequestManager(badgeRequest));
}
