public void addToDataGridAgregar(int row, int column, bool b)
{
this.row = row;
if (row != -1)
{
int columnas = Convert.ToInt32(this.dataGridAgregar.Columns.Count); //obtengo el total de columnas que tiene esa fila
string[] seleccionado = new string[columnas - 1]; //En mi caso pongo el -1 porque tengo un boton y cuenta como otra celda mas
string query;
if (b)
{
query = "insert into organizersTmp (name,institution) values (";
for (int i = 1; i < columnas; i++)
{
seleccionado[i - 1] = this.dataGridAgregar.Rows[row].Cells[i].Value.ToString();
if (i == columnas - 1)
{
query = query + "'" + seleccionado[i - 1] + "')";
}
else
{
query = query + "'" + seleccionado[i - 1] + "',";
}
}
}
else
{
query = "insert into usersTmp ([id],[name],[lastname],[username],[password],[birthDate],[address],[phone],[cellphone],[emailEspol],[emailPersonal],[registrationNumber],[careerId],[userStateId],[userTreatmentId],[created])" +
"(select * from users where id = '" + this.dataGridAgregar.Rows[row].Cells[2].Value.ToString() + "')";
}
SqlManager.executeQuery(query, conn);
fillDatagridAgregar();
fillDatagridRemover();
}
}
private void Form_modifyEvent_FormClosing(object sender, FormClosingEventArgs e)
{
this.formMain.Enabled = true;
this.formEvent.btnBuscarPorTipoC_Click(new object(), new EventArgs());//Para Actualizar el DataGridEventos
SqlManager.executeQuery("delete from organizersTmp", conn);
SqlManager.executeQuery("delete from usersTmp", conn);
}
private void savePassword()
{
String q = "UPDATE users SET password = '******' WHERE username = '******'";
SqlManager.executeQuery(q, this.conn);
}
private void insertUser()
{
String query1 = "", query2 = "", query3 = "", query4 = "", query5 = "";
String idCareer = myReader("SELECT id FROM career WHERE name='" + this.career + "';");
String idDirectorship = "", idBranch = "";
if (radioButton_Miembro.Checked)
{
/*Inserto Usuario*/
query1 = "INSERT INTO users (id,name,lastname,username,birthdate,address,phone,cellphone,emailESPOL,emailPersonal,registrationNumber,careerId,userStateId,userTreatmentId,created)" +
" VALUES ('" + this.id + "','" + this.name + "','" + this.lastName + "','" + this.emailESPOL + "','" +
this.birthDate + "','" + this.address + "','" + this.phone + "','" + this.cellPhone +
"','" + this.emailESPOL + "@espol.edu.ec" + "','" + this.personalEmail + "','" + this.regnumber + "','" +
idCareer + "','" + addtoUserState() + "','" + addToUserTreatment() + "',GETDATE());";
SqlManager.executeQuery(query1, conn);
/*Busco id Directorship*/
idDirectorship = myReader("SELECT id FROM directorship WHERE name='" + this.directorship + "';");
//Inserto DirectorshipHistorial
query2 = "INSERT INTO directorshipHistorial (directorshipId,usersId,observation,chargeTakenDate)" +
"VALUES('" + idDirectorship + "','" + this.id + "','" + this.observationUserDirectorship +
"',GETDATE())";
SqlManager.executeQuery(query2, conn);
//Busco idBranch
idBranch = myReader("SELECT id FROM branch WHERE name='" + this.branchOne + "'");
//Inserto en user Branch
query4 = "INSERT INTO userBranch (userId,branchId,observation) VALUES ('" + this.id + "','" + idBranch + "','" + this.branchOneObservation + "');";
SqlManager.executeQuery(query4, conn);
//Inserto Segunda Rama
if (this.branchTwo != "Escoja una Rama")
{
idBranch = myReader("SELECT id FROM branch WHERE name='" + this.branchTwo + "'");
query5 = "INSERT INTO userBranch (userId,branchId,observation) VALUES ('" + this.id + "','" + idBranch + "','" + this.branchTwoObservation + "');";
SqlManager.executeQuery(query5, conn);
}
}
else
{
query3 = "INSERT INTO users (id,name,lastname,username,birthdate,address,phone,cellphone,emailESPOL,emailPersonal,registrationNumber,careerId,userTreatmentId,created)" +
" VALUES ('" + this.id + "','" + this.name + "','" + this.lastName + "','" + this.emailESPOL + "','" +
this.birthDate + "','" + this.address + "','" + this.phone + "','" + this.cellPhone +
"','" + this.emailESPOL + "@espol.edu.ec" + "','" + this.personalEmail + "','" + this.regnumber + "','" +
idCareer + "','" + addToUserTreatment() + "',GETDATE());";
SqlManager.executeQuery(query3, conn);
}
}
public Form_modifyEvent(string idEvento, Form_main formMain, Form_event formEvent, SqlDataReader DR, Connector conn)
{
InitializeComponent();
this.idEvento = idEvento;
this.formMain = formMain;
this.formEvent = formEvent;
this.DR = DR;
this.conn = conn;
this.sqlString = null;
this.eventoBase = new ArrayList();
this.eventoForm = new ArrayList();
if (idEvento.Length > 0)
{
sqlString = "select * from SACMEDB.dbo.event where id = '" + idEvento + "'";
fillArrayList(eventoBase, sqlString);
sqlString = "SELECT [id] as 'ID', [name] as 'NOMBRE DE EVENTO',[description] as 'DESCRIPCION',(SELECT SACMEDB.dbo.users.name + ' ' + SACMEDB.dbo.users.lastname from SACMEDB.dbo.users where id = responsible) as 'RESPONSABLE',[duration] as 'DURACION',[start] as 'FECHA DE INICIO',(select name from [SACMEDB].[dbo].[eventType] where id=eventTypeId) as 'TIPO DE EVENTO',(select name from [SACMEDB].[dbo].[branch] where id=branchId) as 'RAMA ENCARGADA',[created] as 'FECHA DE CREACION',(SELECT SACMEDB.dbo.users.name + ' ' + SACMEDB.dbo.users.lastname from SACMEDB.dbo.users where id = createdBy) as 'CREADO POR' FROM [SACMEDB].[dbo].[event] where id = '" + idEvento + "'";
fillArrayList(eventoForm, sqlString);
SqlManager.executeQuery("delete from organizersTmp", conn);
sqlString = "INSERT INTO [SACMEDB].[dbo].[organizersTmp]([name],[institution]) select name,institution from [SACMEDB].[dbo].[organizers] where id = any (select organizerId from [SACMEDB].[dbo].[eventOrganizer] where eventOrganizer.eventId = '" + idEvento + "')";
SqlManager.executeQuery(sqlString, conn);
SqlManager.executeQuery("delete from usersTmp", conn);
sqlString = "INSERT INTO [SACMEDB].[dbo].[usersTmp] select * from [SACMEDB].[dbo].[users] where id = any(select userId from eventParticipant where eventId = '" + idEvento + "')";
SqlManager.executeQuery(sqlString, conn);
actualizarDataGrids();
/*
* 0)id___________________int
* 1)nombre
* 2)descripcion
* 3)encargado
* 4)duracion
* 5)fecha de inicio______date
* 6)tipo de evento_______int
* 7)id de rama___________int
* 8)fecha de creacion____date
* 9)creado por
*/
this.txtNombreM.Text = eventoForm[1].ToString();
this.txtDescripcionM.Text = eventoForm[2].ToString();
this.txtEncargadoM.Text = eventoForm[3].ToString();
this.txtDuracionM.Text = eventoForm[4].ToString();
this.dateFechaInicioM.Text = eventoForm[5].ToString(); fechaInicioOriginal = eventoForm[5].ToString();
this.txtTipoM.Text = eventoForm[6].ToString();
this.txtRamaEncargadaM.Text = eventoForm[7].ToString();
}
}
/**<summary>Metodo que maneja el evento de clic en el boton guardar rama.
* Antes de guardar la rama verifica que no haya ningun problema </summary> */
/**<return> No devuelve nada </return>*/
/**<param name="sender">Objeto</param>*/
/**<param name="e">Evento</param>*/
private void btnSave_Click(object sender, EventArgs b)
{
if (isValidRegistryForm())
{
try
{
conn.getConnection();
Branch br = new Branch();
Branch resultB = new Branch();
br.setName(this.txtNameBranch.Text);
br.setShortName(this.txtShortName.Text);
String state = this.cmbState.Value.ToString();
DateTime thisDay = DateTime.Today;
if (state == "Activado")
{
br.setIsEnable(true);
}
else
{
br.setIsEnable(false);
}
resultB = isExitsBranch(br);
if (resultB.getName() == null)
{
sqlString = "insert into branch (name,shortName, isEnable)VALUES('" + br.getName() + "',"
+ "'" + br.getShortName() + "','" + br.getIsEnable() + "')";
MessageBox.Show(sqlString);
bool result = SqlManager.executeQuery(sqlString, conn);
MessageBox.Show(result.ToString());
if (result)
{
MessageBox.Show("Rama registrada con exito ");
emptyFieldForm();
}
else
{
MessageBox.Show("No se pudo guardar los datos");
}
}
else
{
MessageBox.Show("La rama ya se encuentra registrada en el sistema\n ");
emptyFieldForm();
}
}
catch (Exception ex)
{
emptyFieldForm();
MessageBox.Show("La rama ya se encuentra registrada en el sistema\n ");
}
}
}
private void updateData()
{
String q = "UPDATE users SET name = '" + this.editName +
"', lastname = '" + this.editLastname +
"', address = '" + this.editAddress +
"', phone = '" + this.editPhone +
"', cellphone = '" + this.editCellphone +
"', emailPersonal = '" + this.editEmailPersona +
"' WHERE username='******';";
SqlManager.executeQuery(q, this.conn);
}
private void btnEliminarEvento_Click(object sender, EventArgs e)
{
DialogResult dialogo = MessageBox.Show("¿Esta seguro(a) de querer eliminar este evento?", "Advertencia", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogo == DialogResult.Yes)
{
if (SqlManager.executeQuery("delete from eventParticipant where eventId = '" + idEvento + "'; delete from eventOrganizer where eventId = '" + idEvento + "'; delete from event where id = '" + idEvento + "'", conn))
{
MessageBox.Show("El Evento fue eliminado satisfactoriamente", "Evento Eliminado", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Close();
}
}
}
/*************************************************************************************************************************************************************/
private void clearRegistryForm()
{
this.txtNombreR.Clear();
this.txtDescripcionR.Clear();
this.cmbRamaEncargadaR.Items.Clear();
this.cmbEncargadoR.Items.Clear();
this.NumericEditorDuracionR.Value = 0;
this.cmbDuracion.Text = null;
this.dateFechaDeInicioR.ResetDateTime();
this.cmbTipoR.Items.Clear();
this.cmbOrganizadorR.Items.Clear();
this.cmbParticipantesR.Items.Clear();
SqlManager.executeQuery("delete from organizersTmp", conn);
SqlManager.executeQuery("delete from usersTmp", conn);
}
private void ultraButton_savecourse_Click(object sender, EventArgs e)
{
String academicTerm = null, name = null, institution = null, duration = null, insertedBy = null, gainedCoursePoints = null, ced = null;
academicTerm = ultraComboEditor_termcurso.Text + " " + ultraTextEditor_anio1course.Text + "-" + ultraTextEditor_anio2course.Text;
name = ultraTextEditor_nameofcourse.Text;
institution = ultraTextEditor_institutioncourse.Text;
duration = numericUpDown_durationcountcourse.Value.ToString() + " " + ultraComboEditor_typedurationcourse.Text;
insertedBy = userSession.getId();
ced = ultraTextEditor_searchcourse.Value.ToString();
gainedCoursePoints = ultraTextEditor_pointgetcourse.Text;
if (ultraButton_savecourse.Text == "GUARDAR")
{
String burnCquery = "INSERT INTO dbo.course (name,gainedPoints,academicTerm,institution,duration,insertedBy,userId) VALUES ('" + name + "'," + gainedCoursePoints + ",'" + academicTerm + "','" + institution + "','" + duration + "','" + insertedBy + "','" + ced + "');";
bool burn = SqlManager.executeQuery(burnCquery, conn);
if (burn)
{
MessageBox.Show("Registro guardado exitosamente.");
this.Close();
}
else
{
MessageBox.Show("Su registro no ha podido ser guardado.");
}
}
else if (ultraButton_savecourse.Text == "ACTUALIZAR")
{
String updateCquery = "UPDATE dbo.course SET name='" + name + "', gainedPoints='" + gainedCoursePoints + "', academicTerm='" + academicTerm + "', institution='" + institution + "',duration='" + duration + "',userId='" + ced + "' WHERE id=" + referenceId;
MessageBox.Show(updateCquery);
bool burn = SqlManager.executeQuery(updateCquery, conn);
if (burn)
{
MessageBox.Show("Registro actualizado exitosamente.");
this.Close();
}
else
{
MessageBox.Show("Su registro no ha podido ser actualizado.");
}
}
}
public void addToDataGridRemover(int row, int column, bool b)
{
this.row = row;
if (row != -1)
{
string query;
if (b)
{
query = "delete from organizersTmp where name = '" + this.dataGridRemover.Rows[row].Cells[1].Value.ToString() + "'";
}
else
{
query = "delete from usersTmp where id = '" + this.dataGridRemover.Rows[row].Cells[2].Value.ToString() + "'";
}
SqlManager.executeQuery(query, conn);
fillDatagridAgregar();
fillDatagridRemover();
}
}
/**<summary>Metodo que maneja el evento click del boton Actualizar. Actualiza los datos
* de la rama en la base de datos</summary> */
/**<return> No devuelve nada </return>*/
/**<param name="sender">Objeto</param>*/
/**<param name="e">Evento</param>*/
private void btnSave_Click(object sender, EventArgs e)
{
try {
conn.getConnection();
Branch br1 = new Branch();
br1.setName(this.txtNameBranch_up.Text);
br1.setShortName(this.txtShorNamet_up.Text);
String state = this.cmbState_up.Value.ToString();
if (state == "Activado")
{
br1.setIsEnable(true);
}
else
{
br1.setIsEnable(false);
}
br1.setCreated((DateTime)this.dateCreateBranch_up.Value);
int idB = br.getId();
sqlString = "update branch set name='" + br1.getName() + "', shortName='" + br1.getShortName() + "', isEnable='" + br1.getIsEnable() + "'" +
"where id='" + idB + "'";
bool result = SqlManager.executeQuery(sqlString, conn);
if (result)
{
MessageBox.Show("Datos actualizados con exito ");
this.habilitarDeshabilitarCampos(false);
}
else
{
MessageBox.Show("No se pudo guardar los datos");
}
}
catch (Exception ex)
{
MessageBox.Show("No se pudo actualizar la rama:\n " + ex);
}
}
/*************************************************************************************************************************************************************/
private bool insertEvent(Event e)
{
try
{
conn.getConnection();
this.sqlString = "insert into event(name,description,responsible,duration,start,eventTypeId,branchId,createdBy)" +
"VALUES('" + e.getName() + "',"
+ "'" + e.getDescription() + "',"
+ "'" + e.getResponsible() + "',"
+ "'" + e.getDuration() + "',"
+ "'" + dateToSQL(e.getStart()) + "',"
+ "'" + e.getEventTypeId() + "',"
+ "'" + e.getBranchId() + "',"
+ "'" + e.getCreatedBy() + "')";
SqlManager.executeQuery(sqlString, conn);
}
catch (DbException ex)
{
MessageBox.Show("No se pudo Agregar evento:\n " + ex);
return(false);
}
return(true);
}
private void ultraButton_Guardar_Click(object sender, EventArgs e)
{
pass = ultraTextEditor_Contrasenia.Text;
confirPass = ultraTextEditor_ConfirmContrasenia.Text;
if (pass == "" || confirPass == "")
{
MessageBox.Show("Ingrese correctamente los valores correspondientes");
}
else if (pass != confirPass)
{
MessageBox.Show("Contraseñas no coinciden");
}
else
{
this.query = "UPDATE users SET password='******' WHERE username='******';";
if (SqlManager.executeQuery(query, conn))
{
Form_main formmain = new Form_main(ini, conn, user);
this.Hide();
formmain.Show();
}
}
}
private void btnGuardarM_Click(object sender, EventArgs e)
{
bool cambiosValidos = false;
int j = 0;
if (this.checkBoxFechaInicio.Checked)
{
if (Convert.ToDateTime(fechaInicioOriginal).CompareTo(DateTime.Today) < 0)
{
MessageBox.Show("No puede seleccionar una fecha del pasado", "Fecha Inválida", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Convert.ToDateTime(fechaInicioOriginal).CompareTo(DateTime.Today) == 0)
{
MessageBox.Show("El evento es HOY, no puede cambiar la fecha", "Fecha Inválida", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
cambiosValidos = true;
}
}
if (cambiosValidos)
{
if (checkBoxFechaInicio.Checked)
{
sqlString = "update SACMEDB.dbo.event set start = '" + formEvent.dateToSQL(this.dateFechaInicioM.DateTime) + "' where id = '" + idEvento + "'";
SqlManager.executeQuery(sqlString, conn);
this.fechaInicioOriginal = formEvent.dateToSQL(dateFechaInicioM.DateTime);
this.dateFechaInicioM.DateTime = Convert.ToDateTime(fechaInicioOriginal);
}
}
if (this.checkBoxEncargado.Checked)
{
if (this.cmbEncargadoM.Text == "")
{
MessageBox.Show("No ha seleccionado a un encargado", "Encargado Sin especificar", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
cambiosValidos = true;
}
}
if (cambiosValidos)
{
if (checkBoxEncargado.Checked)
{
this.cmbEncargadosId.SelectedIndex = this.cmbEncargadoM.SelectedIndex;
sqlString = "update SACMEDB.dbo.event set responsible = '" + cmbEncargadosId.SelectedItem.ToString() + "' where id = '" + idEvento + "'";
SqlManager.executeQuery(sqlString, conn);
}
}
sqlString = "delete from eventParticipant where eventId = '" + idEvento + "'; delete from eventOrganizer where eventId = '" + idEvento + "'";
for (int i = 0; i < this.cmbOrganizadoresM.Items.Count; i++)
{
sqlString = "insert into [SACMEDB].[dbo].[eventOrganizer] (eventId,organizerId) values ((select id from [SACMEDB].[dbo].[event] where name = '" + this.txtNombreM.Text + "' and description = '" + this.txtDescripcionM.Text + "'),(select id from organizers where name = '" + this.cmbOrganizadoresM.Items[i].ToString() + "'))";
SqlManager.executeQuery(sqlString, conn);
j++;
}
for (int i = 0; i < this.cmbIdParticipantesM.Items.Count; i++)
{
sqlString = "insert into [SACMEDB].[dbo].[eventParticipant] (userId,eventId,rol) values ('" + this.cmbIdParticipantesM.Items[i].ToString() + "',(select id from [SACMEDB].[dbo].[event] where name = '" + this.txtNombreM.Text + "' and description = '" + this.txtDescripcionM.Text + "'),'Participante Evento " + this.txtNombreM.Text + "') ";
SqlManager.executeQuery(sqlString, conn);
j++;
}
if (cambiosValidos)
{
MessageBox.Show("Cambios Guardados");
}
if (j > 0)
{
MessageBox.Show("Organizadores o Participantes Actualizados");
}
}
/*************************************************************************************************************************************************************/
private void btnGuardarEvento_Click(object sender, EventArgs e)
{
int branchId = 0;
int eventTypeId = 0;
if (isValidRegistryForm())
{
try
{
conn.getConnection();
DR = SqlManager.getQuery("select id from SACMEDB.dbo.branch where name = '" + this.cmbRamaEncargadaR.Text + "'", conn);
if (DR != null)
{
while (DR.Read())
{
branchId = Convert.ToInt32(DR["id"].ToString());
}
}
DR.Close();
}
catch (DbException ex) { MessageBox.Show("No Se Pudo Obtener El Id De La Rama:\n " + ex); }
try
{
conn.getConnection();
DR = SqlManager.getQuery("select id from [SACMEDB].[dbo].[eventType] where name = '" + this.cmbTipoR.Text + "'", conn);
if (DR != null)
{
while (DR.Read())
{
eventTypeId = Convert.ToInt32(DR["id"].ToString());
}
}
DR.Close();
}
catch (DbException ex) { MessageBox.Show("No Se Pudo Obtener El Id De La Rama:\n " + ex); }
Event ev = new Event();
ev.setName(this.txtNombreR.Text);
ev.setDescription(this.txtDescripcionR.Text);
this.idEncargado.SelectedIndex = this.cmbEncargadoR.SelectedIndex;
ev.setResponsible(idEncargado.SelectedItem.ToString());
ev.setDuration(this.NumericEditorDuracionR.Value.ToString() + " " + this.cmbDuracion.Text);
ev.setStart((DateTime)this.dateFechaDeInicioR.Value);
ev.setEventTypeId(eventTypeId);
ev.setBranchId(branchId);
ev.setCreatedBy(eventCreator);
insertEvent(ev);
for (int i = 0; i < this.cmbOrganizadorR.Items.Count; i++)
{
sqlString = "insert into [SACMEDB].[dbo].[eventOrganizer] (eventId,organizerId) values ((select id from [SACMEDB].[dbo].[event] where name = '" + this.txtNombreR.Text + "' and description = '" + this.txtDescripcionR.Text + "'),(select id from organizers where name = '" + this.cmbOrganizadorR.Items[i].ToString() + "'))";
SqlManager.executeQuery(sqlString, conn);
}
for (int i = 0; i < this.cmbParticipantesR.Items.Count; i++)
{
sqlString = "insert into [SACMEDB].[dbo].[eventParticipant] (userId,eventId,rol) values ('" + this.idParticipants.Items[i].ToString() + "',(select id from [SACMEDB].[dbo].[event] where name = '" + this.txtNombreR.Text + "' and description = '" + this.txtDescripcionR.Text + "'),'Participante Evento " + this.txtNombreR.Text + "') ";
SqlManager.executeQuery(sqlString, conn);
}
clearRegistryForm();
MessageBox.Show("Evento Creado Satisfactoriamente");
}
}
private void ultraButton2_Click(object sender, EventArgs e)
{
String academicTerm = null, observation = null, espolAvg = null, ced = null;
int gainedPoints = 0, totalPoints = 0, totalPoints_update = 0;
float espolAvg_float;
academicTerm = ultraComboEditor_term.Text + " " + ultraTextEditor_anio1.Text + "-" + ultraTextEditor_anio2.Text;
ced = ultraTextEditor_search.Text;
observation = ultraTextEditor_observation.Text;
espolAvg = ultraTextEditor_espolAvg.Text;
bool parse = Int32.TryParse(ultraTextEditor_gainedPoints.Text, out gainedPoints);
if (false == parse)
{
MessageBox.Show("Formato puntos ganados incorrecto.\nDebe ser un entero.");
}
else
{
String qTotalP = "SELECT acper.totalPoints FROM dbo.academicPerformance acper WHERE acper.userId='" + ced + "'" +
"AND acper.inserted = (SELECT MAX(ap.inserted) FROM dbo.academicPerformance ap WHERE ap.userId='" + ced + "');";
SqlDataReader myReader = SqlManager.getQuery(qTotalP, conn);
if (myReader.HasRows)
{
myReader.Read();
totalPoints = Int32.Parse(myReader[0].ToString());
totalPoints_update = totalPoints - gainedPointsLast + gainedPoints;
totalPoints = totalPoints + gainedPoints;
}
else
{
totalPoints = gainedPoints;
}
myReader.Close();
}
parse = float.TryParse(espolAvg, NumberStyles.Any, CultureInfo.InvariantCulture, out espolAvg_float);
if (parse == true)
{
String insertedBy = null;
if (ultraButton_saveEspol.Text == "GUARDAR")
{
String burnAPquery = "INSERT INTO dbo.academicPerformance (userId,academicTerm,gainedPoints,totalPoints,espolAverage,observation,insertedBy)" +
"VALUES ('" + ced + "','" + academicTerm + "'," + gainedPoints + "," + totalPoints + "," + espolAvg_float + ",'" + observation + "','" + insertedBy + "');";
bool burn = SqlManager.executeQuery(burnAPquery, conn);
if (burn)
{
MessageBox.Show("Registro se ha guardado exitosamente.");
this.Close();
}
else
{
MessageBox.Show("Su registro no ha podido ser guardado.");
}
}
else if (ultraButton_saveEspol.Text == "ACTUALIZAR")
{
String updateAPquery = "UPDATE dbo.academicPerformance SET userId='" + ced + "',academicTerm='" + academicTerm + "',gainedPoints=" + gainedPoints + ",totalPoints=" + totalPoints_update + ",espolAverage=" + espolAvg_float + ",observation='" + observation + "' " +
"WHERE id=" + referenceId;
MessageBox.Show(updateAPquery);
bool update = SqlManager.executeQuery(updateAPquery, conn);
if (update)
{
MessageBox.Show("Registro ha sido actualizado exitosamente.");
this.Close();
}
else
{
MessageBox.Show("Su registro no ha podido ser actualizado.");
}
}
}
else
{
MessageBox.Show("El formato ingresado de promedio ESPOL es incorrecto.");
}
}
