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