internal override DtoBase PopulateDto(OracleDataReader reader)
{
var profesional = new ProfesionalDto();
//
if (!reader.IsDBNull(_ordProId))
{
profesional.ProId = reader.GetInt32(_ordProId);
}
//
if (!reader.IsDBNull(_ordProMatricula))
{
profesional.ProMatricula = reader.GetInt32(_ordProMatricula);
}
//
if (!reader.IsDBNull(_ordProTelefonoInterno))
{
profesional.ProTelefonoInterno = reader.GetString(_ordProTelefonoInterno);
}
//
if (!reader.IsDBNull(_ordProPsnId))
{
profesional.ProPsnId = reader.GetInt32(_ordProPsnId);
}
// IsNew
profesional.IsNew = false;
return(profesional);
}
//__________________________________________________________________________
// Update Paciente
public static void GrabarProfesionalUpdate(ref ProfesionalDto profesional, ref string error, ref int errorNro)
{
try
{
var newDoc = profesional.PsnNroDcto;
var objPro = ProfesionalDb.ConsultoUnProfesionalPk(profesional.ProId);
if (newDoc != objPro.PsnNroDcto)
{
var objPacNew = ProfesionalDb.ConsultoUnProfesional(newDoc);//Funciona pancientes y profesional ya busca DNI de personas
if (objPacNew == null)
{
ProfesionalDb.GrabarProfesionalUpdate(ref profesional);
}
else if (objPro.ProId == objPacNew.ProId)
{
ProfesionalDb.GrabarProfesionalUpdate(ref profesional);
}
else
{
errorNro = -2;
error = " Verifique el DOCUMENTO, ya existe!";
}
}
else
{
ProfesionalDb.GrabarProfesionalUpdate(ref profesional);
}
var objPac = PacienteDb.ConsultoUnPaciente(profesional.PsnNroDcto);
if (objPac == null)
{
ProfesionalDb.GrabarProfesionalUpdate(ref profesional);
}
else
{
errorNro = -2;
error = " Verifique el DOCUMENTO, ya existe!";
}
}
catch (Exception e)
{
errorNro = -1;
error = " Error Grabar.(Editado)";
}
}
protected void OnSelectedIndexChanged(object sender, EventArgs e)
{
var script = "editarProfesional();";
ScriptManager.RegisterStartupScript(this, typeof(Page), "editarProfesional", script, true);
var varPro = gvPro.SelectedRow.Cells[0].Text;
if (!string.IsNullOrEmpty(varPro))
{
var pro = new ProfesionalDto();
pro = ManagerProfesional.ExisteProfesional(varPro);
if (pro != null)
{
lbl.Text = "Existe";
CargarDatosPantalla(pro);
PanelPantalla.Visible = true;
btnConfirmar.Visible = true;
}
}
}
protected void btnConfirmar_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
string error = null; string msj = null; int errorNro = 0;
var profesional = new ProfesionalDto();
ObtenerDatosPantalla(profesional);
var varEstado = Request.QueryString["e"];
if (varEstado == "N")
{
ManagerProfesional.GrabarProfesionalInsert(ref profesional, ref error, ref errorNro);
msj = "Kinesiólogo Guardado.";
}
else if (varEstado == "B")
{
ManagerProfesional.GrabarProfesionalUpdate(ref profesional, ref error, ref errorNro);
msj = "Kinesiólogo Actualizado.";
}
if (error == null)
{
var script = "showAlert('" + msj + "','1');";
ScriptManager.RegisterStartupScript(this, typeof(Page), "showAlert", script, true);
Limpiar();
var script2 = "ocultarFormProfesional();";
ScriptManager.RegisterStartupScript(this, typeof(Page), "ocultarFormPaciente", script2, true);
}
else
{
if (errorNro == -2)
{
var script = "showAlert('" + error + "','3');";
ScriptManager.RegisterStartupScript(this, typeof(Page), "showAlert", script, true);
}
if (errorNro == -1)
{
var script = "showAlert('" + error + "','2');";
ScriptManager.RegisterStartupScript(this, typeof(Page), "showAlert", script, true);
}
}
}
}
//__________________________________________________________________________
// Insertar Profesional
public static void GrabarProfesionalInsert(ref ProfesionalDto profesional, ref string error, ref int errorNro)
{
try
{
var objPac = ProfesionalDb.ConsultoUnProfesional(profesional.PsnNroDcto);
if (objPac == null)
{
ProfesionalDb.GrabarProfesionalInsert(ref profesional);
}
else
{
errorNro = -2;
error = " Verifique el DOCUMENTO, ya existe!";
}
}
catch (Exception e)
{
errorNro = -1;
error = " Error Grabar.(Nuevo)";
}
}
private void ObtenerDatosPantalla(ProfesionalDto profesional)
{
#region Persona -----------------------------------------
string aux;
profesional.PsnNroDcto = txtDocumento.Value;
if (!string.IsNullOrEmpty(txtNombre.Value))
{
aux = txtNombre.Value; profesional.PsnNombre = aux.ToUpper();
}
if (!string.IsNullOrEmpty(txtApellido.Value))
{
aux = txtApellido.Value; profesional.PsnApellido = aux.ToUpper();
}
profesional.PsnFechaNac = txtFecNac.Value;
profesional.PsnTelefono = txtTel.Value;
if (!string.IsNullOrEmpty(txtDire.Value))
{
aux = txtDire.Value; profesional.PsnDomicilio = aux.ToUpper();
}
if (!string.IsNullOrEmpty(txtMail.Value))
{
aux = txtMail.Value; profesional.PsnEmail = aux.ToUpper();
}
if (rbM.Checked)
{
profesional.PsnSexo = "M";
}
else if (rbF.Checked)
{
profesional.PsnSexo = "F";
}
profesional.ProActivo = "S";
#endregion
#region Matriculas --------------------------------------
if (ViewState["DadaTableMat"] != null)
{
var dtMat = (DataTable)ViewState["DadaTableMat"];
var listaMatricula = new List <ProfesionalMatriculaDto>();
foreach (DataRow dtRow in dtMat.Rows)
{
var matricula = new ProfesionalMatriculaDto();
if (!DBNull.Value.Equals(dtRow[0]))
{
matricula.PmtId = Convert.ToInt32(dtRow[0].ToString());
}
matricula.PmtMttId = Convert.ToInt32(dtRow[1].ToString());
if (!DBNull.Value.Equals(dtRow["PMTNRO"]))
{
matricula.PmtNro = dtRow["PMTNRO"].ToString();
}
listaMatricula.Add(matricula);
}
profesional.ProListMatriculas = listaMatricula;
}
#endregion
#region Especialidades ----------------------------------
profesional.ProListEspecialidades = listaEspecialidades;
#endregion
#region Agenda ------------------------------------------
if (ViewState["DataTableAge"] != null)
{
var dtAge = (DataTable)ViewState["DataTableAge"];
var listaAgenda = new List <AgendaDto>();
foreach (DataRow dtRow in dtAge.Rows)
{
var agenda = new AgendaDto();
if (!DBNull.Value.Equals(dtRow[0]))
{
agenda.AgeId = Convert.ToInt32(dtRow[0].ToString());
}
agenda.AgeDiaId = Convert.ToInt32(dtRow[1].ToString());
// Descripcion del tipo de dia = dtRow[2].ToString()
agenda.AgeHoraDesde = dtRow[3].ToString();
agenda.AgeHoraHasta = dtRow[4].ToString();
listaAgenda.Add(agenda);
}
profesional.ProListAgenda = listaAgenda;
}
#endregion
var varEstado = Request.QueryString["e"];
if (varEstado == "B")
{
if (lblProId != null)
{
profesional.ProId = Convert.ToInt32(lblProId.Text);
}
if (lblPsnId != null)
{
profesional.PsnId = Convert.ToInt32(lblPsnId.Text);
}
var opcionSeleccionada = ddlEstado.SelectedItem.ToString();
if (opcionSeleccionada == "NO")
{
profesional.ProActivo = "N";
}
else
{
profesional.ProActivo = "S";
}
}
}
private void CargarDatosPantalla(ProfesionalDto profesional)
{
#region Persona ----------------------------------------
lblPsnId.Text = profesional.PsnId.ToString();
txtDocumento.Value = profesional.PsnNroDcto;
txtNombre.Value = profesional.PsnNombre;
txtApellido.Value = profesional.PsnApellido;
txtFecNac.Value = profesional.PsnFechaNac;
txtTel.Value = profesional.PsnTelefono;
txtDire.Value = profesional.PsnDomicilio;
txtMail.Value = profesional.PsnEmail;
switch (profesional.PsnSexo)
{
case "M":
rbM.Checked = true;
rbF.Checked = false;
break;
case "F":
rbM.Checked = false;
rbF.Checked = true;
break;
}
#endregion
#region Profesional ------------------------------------
lblProId.Text = profesional.ProId.ToString();
#endregion
#region Especialidad ---------------------------
for (var i = 0; i < arregloCheckBoxs.Count(); i++)
{
arregloCheckBoxs[i].Checked = false;
}
var listaespecialPeorfesional = ManagerEspecialidades.ListEspecialidadProfesional(profesional.ProId);
for (var i = 0; i < arregloCheckBoxs.Count(); i++)
{
foreach (var le in listaespecialPeorfesional)
{
var varEsp = arregloCheckBoxs[i].ID;
varEsp = varEsp.Substring(varEsp.Length - 2, 2);
if (Convert.ToInt32(varEsp) == le.EspId)
{
arregloCheckBoxs[i].Checked = true;
var especial = new ProfesionalEspecialidadesDto();
especial.PepEpcId = Convert.ToInt32(varEsp);
listaEspecialidades.Add(especial);
}
}
}
#endregion
#region Matricula --------------------------------------
try
{
MatriculaIniFila();
var dtMat = (DataTable)ViewState["DadaTableMat"];
var listaMat = ManagerProfesionalMatriculas.ListProfesionalMatricula(profesional.ProId);
var dtCurrentTable = (DataTable)ViewState["DadaTableMat"];
foreach (var lm in listaMat)
{
DataRow drCurrentRow;
drCurrentRow = dtCurrentTable.NewRow();
drCurrentRow["PMT_MTTID"] = lm.PmtMttId;
drCurrentRow["MTTDESCRIPCION"] = lm.MttDescripcion;
if (!string.IsNullOrEmpty(lm.PmtNro))
{
drCurrentRow["PMTNRO"] = lm.PmtNro;
}
else
{
drCurrentRow["PMTNRO"] = "0";
}
dtCurrentTable.Rows.Add(drCurrentRow);
ViewState["DadaTableMat"] = dtCurrentTable;
}
gvMat.DataSource = dtMat;
gvMat.DataBind();
}
catch (Exception e)
{
var script = "showAlert('Error al cargar Matrícula','2');";
ScriptManager.RegisterStartupScript(this, typeof(Page), "showAlert", script, true);
}
#endregion
#region Agenda -----------------------------------------
try
{
AgendaIniFila();
var dtAge = (DataTable)ViewState["DataTableAge"];
var listaAge = ManagerAgendas.ListAgendaProfesional(profesional.ProId);
var dtCurrentTable = (DataTable)ViewState["DataTableAge"];
foreach (var la in listaAge)
{
DataRow drCurrentRow;
drCurrentRow = dtCurrentTable.NewRow();
drCurrentRow[1] = la.AgeDiaId;
drCurrentRow[2] = la.DiaDescripcion;
drCurrentRow[3] = la.AgeHoraDesde;
drCurrentRow[4] = la.AgeHoraHasta;
dtCurrentTable.Rows.Add(drCurrentRow);
ViewState["DataTableAge"] = dtCurrentTable;
}
gvAgenda.DataSource = dtAge;
gvAgenda.DataBind();
}
catch (Exception e)
{
var script = "showAlert('Error al cargar Agenda','2');";
ScriptManager.RegisterStartupScript(this, typeof(Page), "showAlert", script, true);
}
#endregion
}
internal override DtoBase PopulateDto(OracleDataReader reader)
{
var profesional = new ProfesionalDto();
//
if (!reader.IsDBNull(_ordProId))
{
profesional.ProId = reader.GetInt32(_ordProId);
}
//
if (!reader.IsDBNull(_ordProPsnId))
{
profesional.ProPsnId = reader.GetInt32(_ordProPsnId);
}
//
if (!reader.IsDBNull(_ordProActivo))
{
profesional.ProActivo = reader.GetString(_ordProActivo);
}
// Profesional - Persona
if (!reader.IsDBNull(_ordPsnId))
{
profesional.PsnId = reader.GetInt32(_ordPsnId);
}
//
if (!reader.IsDBNull(_ordPsnTpdId))
{
profesional.PsnTpdId = reader.GetInt32(_ordPsnTpdId);
}
//
if (!reader.IsDBNull(_ordPsnNroDcto))
{
profesional.PsnNroDcto = reader.GetString(_ordPsnNroDcto);
}
//
if (!reader.IsDBNull(_ordPsnNombre))
{
profesional.PsnNombre = reader.GetString(_ordPsnNombre);
}
//
if (!reader.IsDBNull(_ordPsnApellido))
{
profesional.PsnApellido = reader.GetString(_ordPsnApellido);
}
//
if (!reader.IsDBNull(_ordPsnFechaNac))
{
profesional.PsnFechaNac = reader.GetString(_ordPsnFechaNac);
}
//
if (!reader.IsDBNull(_ordPsnTelefono))
{
profesional.PsnTelefono = reader.GetString(_ordPsnTelefono);
}
//
if (!reader.IsDBNull(_ordPsnEmail))
{
profesional.PsnEmail = reader.GetString(_ordPsnEmail);
}
//
if (!reader.IsDBNull(_ordPsnSexo))
{
profesional.PsnSexo = reader.GetString(_ordPsnSexo);
}
//
if (!reader.IsDBNull(_ordPsnDomId))
{
profesional.PsnDomId = reader.GetInt32(_ordPsnDomId);
}
//
if (!reader.IsDBNull(_ordPsnDomicilio))
{
profesional.PsnDomicilio = reader.GetString(_ordPsnDomicilio);
}
// IsNew
profesional.IsNew = false;
return(profesional);
}
//________________________________________________________________________________________________________
// Update Profesional
public static void GrabarProfesionalUpdate(ref ProfesionalDto profesional)
{
try
{
var con = GetConn();
con.Open();
var tran = con.BeginTransaction();
#region UPDATE PERSONA -------------------------------------------------------------------
var cmdPer = new OracleCommand("PRC_PERSONA_UPDATE")
{
CommandType = CommandType.StoredProcedure,
Connection = con
};
cmdPer.Parameters.Add(CreateParameter("iPSNID", profesional.PsnId)); //NUMBER
cmdPer.Parameters.Add(CreateParameter("iPSNNRODCTO", profesional.PsnNroDcto, 9)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNNOMBRE", profesional.PsnNombre, 45)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNAPELLIDO", profesional.PsnApellido, 45)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNFECHANAC", profesional.PsnFechaNac, 12)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNTELEFONO", profesional.PsnTelefono, 20)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNSEXO", profesional.PsnSexo, 1)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNEMAIL", profesional.PsnEmail, 100)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNDOMICILIO", profesional.PsnDomicilio, 50)); //VARCHAR
cmdPer.Transaction = tran;
cmdPer.ExecuteNonQuery();
#endregion
#region UPDATE PROFESIONAL ----------------------------------------------------------------
/*NADA PARA ACTUALIZAR*/
#endregion
#region UPDATE ESPECIALIDADES -------------------------------------------------------------
OracleCommand cmdEsp = null;
//---------------------------------------------------------
cmdEsp = new OracleCommand("PRC_PROFESIONALESP_DELETE")
{
CommandType = CommandType.StoredProcedure,
Connection = con
};
cmdEsp.Parameters.Add(CreateParameter("iPEP_PROID", profesional.ProId)); //NUMBER
cmdEsp.Transaction = tran;
cmdEsp.ExecuteNonQuery(); //EJECUTO CONSULTA
//---------------------------------------------------------
foreach (var oPe in profesional.ProListEspecialidades)
{
cmdEsp = new OracleCommand("PRC_PROFESIONALESP_INSERT")
{
CommandType = CommandType.StoredProcedure,
Connection = con
};
cmdEsp.Parameters.Add(CreateParameter("iPEP_PROID", profesional.ProId)); //NUMBER
cmdEsp.Parameters.Add(CreateParameter("iPEP_EPCID", oPe.PepEpcId)); //NUMBER
cmdEsp.Transaction = tran;
cmdEsp.ExecuteNonQuery();//EJECUTO CONSULTA
}
#endregion
#region UPDATE MATRICULAS -----------------------------------------------------------------
OracleCommand cmdMat = null;
//---------------------------------------------------------
cmdMat = new OracleCommand("PRC_PROFESIONALMAT_DELETE")
{
CommandType = CommandType.StoredProcedure,
Connection = con
};
cmdMat.Parameters.Add(CreateParameter("iPMT_PROID", profesional.ProId)); //NUMBER
cmdMat.Transaction = tran;
cmdMat.ExecuteNonQuery(); //EJECUTO CONSULTA
//---------------------------------------------------------
foreach (var oPm in profesional.ProListMatriculas)
{
cmdMat = new OracleCommand("PRC_PROFESIONALMAT_INSERT")
{
CommandType = CommandType.StoredProcedure,
Connection = con
};
cmdMat.Parameters.Add(CreateParameter("iPMT_PROID", profesional.ProId)); //NUMBER
cmdMat.Parameters.Add(CreateParameter("iPMT_MTTID", oPm.PmtMttId)); //NUMBER
cmdMat.Parameters.Add(CreateParameter("iPMTNRO", oPm.PmtNro, 45)); //VARCHAR
cmdMat.Transaction = tran;
cmdMat.ExecuteNonQuery();
}
#endregion
#region UPDATE AGENDA ---------------------------------------------------------------------
OracleCommand cmdAge = null;
//---------------------------------------------------------
cmdAge = new OracleCommand("PRC_PROFESIONALAGE_DELETE")
{
CommandType = CommandType.StoredProcedure,
Connection = con
};
cmdAge.Parameters.Add(CreateParameter("iAGE_PROID", profesional.ProId)); //NUMBER
cmdAge.Transaction = tran;
cmdAge.ExecuteNonQuery(); //EJECUTO CONSULTA
//---------------------------------------------------------
foreach (var oPa in profesional.ProListAgenda)
{
cmdAge = new OracleCommand("PRC_PROFESIONALAGE_INSERT")
{
CommandType = CommandType.StoredProcedure,
Connection = con
};
cmdAge.Parameters.Add(CreateParameter("iAGE_PROID", profesional.ProId)); //NUMBER
cmdAge.Parameters.Add(CreateParameter("iAGE_DIAID", oPa.AgeDiaId)); //NUMBER
cmdAge.Parameters.Add(CreateParameter("iAGEHORADESDE", oPa.AgeHoraDesde, 15)); //DATETIME
cmdAge.Parameters.Add(CreateParameter("iAGEHORAHASTA", oPa.AgeHoraHasta, 15)); //DATETIME
cmdAge.Transaction = tran;
cmdAge.ExecuteNonQuery();
}
#endregion
tran.Commit();//COMMIT LA TRANSACCION
#region Cerrar Conexiones
cmdPer.Connection.Close();//CERRAR
cmdPer.Connection.Dispose();
cmdEsp.Connection.Close();//CERRAR
cmdEsp.Connection.Dispose();
cmdMat.Connection.Close();//CERRAR
cmdMat.Connection.Dispose();
cmdAge.Connection.Close();//CERRAR
cmdAge.Connection.Dispose();
#endregion
}
catch (Exception e)
{
throw e;
}
}
//________________________________________________________________________________________________________
// Insert Profesional
public static void GrabarProfesionalInsert(ref ProfesionalDto profesional)
{
try
{
var con = GetConn();
con.Open();
var tran = con.BeginTransaction();
#region INSERT PERSONA -------------------------------------------------------------------
var cmdPer = new OracleCommand("PRC_PERSONA_INSERT")
{
CommandType = CommandType.StoredProcedure,
Connection = con
};
cmdPer.Parameters.Add(CreateParameter("iPSNNRODCTO", profesional.PsnNroDcto, 9)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNNOMBRE", profesional.PsnNombre, 45)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNAPELLIDO", profesional.PsnApellido, 45)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNFECHANAC", profesional.PsnFechaNac, 12)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNTELEFONO", profesional.PsnTelefono, 20)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNSEXO", profesional.PsnSexo, 1)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNEMAIL", profesional.PsnEmail, 100)); //VARCHAR
cmdPer.Parameters.Add(CreateParameter("iPSNDOMICILIO", profesional.PsnDomicilio, 50)); //VARCHAR
cmdPer.Parameters.Add(CrearParametroSalida("oPSNID", OracleDbType.Int32)); //NUMBER
cmdPer.Transaction = tran;
cmdPer.ExecuteNonQuery();
var varPsnid = cmdPer.Parameters["oPSNID"].Value;
profesional.ProPsnId = Convert.ToInt16(varPsnid.ToString());
#endregion
#region INSERT PROFESIONAL ----------------------------------------------------------------
var cmdPro = new OracleCommand("PRC_PROFESIONAL_INSERT");
cmdPro.CommandType = CommandType.StoredProcedure;
cmdPro.Connection = con;
cmdPro.Parameters.Add(CreateParameter("iPRO_PSNID", profesional.ProPsnId)); //NUMBER
cmdPro.Parameters.Add(CrearParametroSalida("oPROID", OracleDbType.Int32)); //NUMBER
cmdPro.Transaction = tran;
cmdPro.ExecuteNonQuery();//EJECUTO CONSULTA
var varProid = cmdPro.Parameters["oPROID"].Value;
profesional.ProId = Convert.ToInt16(varProid.ToString());
#endregion
#region INSERT ESPECIALIDADES -------------------------------------------------------------
OracleCommand cmdEsp = null;
foreach (var oPe in profesional.ProListEspecialidades)
{
cmdEsp = new OracleCommand("PRC_PROFESIONALESP_INSERT")
{
CommandType = CommandType.StoredProcedure,
Connection = con
};
cmdEsp.Parameters.Add(CreateParameter("iPEP_PROID", profesional.ProId)); //NUMBER
cmdEsp.Parameters.Add(CreateParameter("iPEP_ESPID", oPe.PepEpcId)); //NUMBER
cmdEsp.Transaction = tran;
cmdEsp.ExecuteNonQuery();//EJECUTO CONSULTA
}
#endregion
#region INSERT MATRICULAS -----------------------------------------------------------------
OracleCommand cmdMat = null;
foreach (var oPm in profesional.ProListMatriculas)
{
cmdMat = new OracleCommand("PRC_PROFESIONALMAT_INSERT")
{
CommandType = CommandType.StoredProcedure,
Connection = con
};
cmdMat.Parameters.Add(CreateParameter("iPMT_PROID", profesional.ProId)); //NUMBER
cmdMat.Parameters.Add(CreateParameter("iPMT_MTTID", oPm.PmtMttId)); //NUMBER
cmdMat.Parameters.Add(CreateParameter("iPMTNRO", oPm.PmtNro, 45)); //VARCHAR
cmdMat.Transaction = tran;
cmdMat.ExecuteNonQuery();
}
#endregion
#region INSERT AGENDA ---------------------------------------------------------------------
OracleCommand cmdAge = null;
foreach (var oPa in profesional.ProListAgenda)
{
cmdAge = new OracleCommand("PRC_PROFESIONALAGE_INSERT")
{
CommandType = CommandType.StoredProcedure,
Connection = con
};
cmdAge.Parameters.Add(CreateParameter("iAGE_PROID", profesional.ProId)); //NUMBER
cmdAge.Parameters.Add(CreateParameter("iAGE_DIAID", oPa.AgeDiaId)); //NUMBER
cmdAge.Parameters.Add(CreateParameter("iAGEHORADESDE", oPa.AgeHoraDesde, 15)); //DATETIME
cmdAge.Parameters.Add(CreateParameter("iAGEHORAHASTA", oPa.AgeHoraHasta, 15)); //
cmdAge.Transaction = tran;
cmdAge.ExecuteNonQuery();
}
#endregion
tran.Commit();//COMMIT LA TRANSACCION
#region Cerrar Conexiones
cmdPer.Connection.Close();//CERRAR
cmdPer.Connection.Dispose();
cmdPro.Connection.Close();//CERRAR
cmdPro.Connection.Dispose();
if (cmdEsp != null)
{
cmdEsp.Connection.Close();//CERRAR
cmdEsp.Connection.Dispose();
}
if (cmdMat != null)
{
cmdMat.Connection.Close();//CERRAR
cmdMat.Connection.Dispose();
}
if (cmdAge != null)
{
cmdAge.Connection.Close();//CERRAR
cmdAge.Connection.Dispose();
}
#endregion
}
catch (Exception e)
{
throw e;
}
}
