public void Update(RcdMultiTablaEntity obj)
{
con = objCon.Conectar();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "USP_UPD_MULTITABLA";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.Add("@IdTabla", SqlDbType.Int).Value = obj.IdTabla;
cmd.Parameters.Add("@IdSubTabla", SqlDbType.Int).Value = obj.IdTablaDetalle;
cmd.Parameters.Add("@Descripcion", SqlDbType.VarChar, 100).Value = obj.Descripcion1;
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
public void ViewListProfesional(DataGridView dgv, RcdMultiTablaEntity obj)
{
RcdMultiTablaEntity objent = new RcdMultiTablaEntity();
//objent.IdTabla = obj;
//objent.IdTablaDetalle = idtabladetalle;
objModel.ListMultiTablaPorIdTabla(dgv, obj);
}
private void FrmListCorrelative_Load(object sender, EventArgs e)
{
var obj = new CorrelativoController();
RcdMultiTablaEntity ent = new RcdMultiTablaEntity();
obj.View(dgvDataList);
lblTotal.Text = "Total de Registros: " + Convert.ToString(dgvDataList.Rows.Count);
}
private void FrmListProfesion_Load(object sender, EventArgs e)
{
var obj = new MultiTablaController();
RcdMultiTablaEntity objent = new RcdMultiTablaEntity();
objent.IdTabla = 3;
obj.ViewListProfesional(dgvDataList, objent);
lblTotal.Text = "Total de registros: " + Convert.ToString(dgvDataList.Rows.Count);
}
private void BtnGuardar_Click(object sender, EventArgs e)
{
if (lblTitle.Text == "Agregar Nuevo Profesion")
{
if (this.ValidationTextbox() == "")
{
RcdMultiTablaEntity objEnt = new RcdMultiTablaEntity();
objEnt.IdTabla = int.Parse(txtId.Text);
objEnt.Descripcion1 = txtProfesion.Text;
//objEnt.Descripcion2 = txtAbreviatura.Text;
try
{
objContMultiTbl.Add(objEnt);
MessageOk("La Profesion ha sido registrado correctamente.");
ClearCampus();
}
catch (Exception)
{
}
}
else
{
MessageError(ValidationTextbox());
}
}
else if (lblTitle.Text == "Actualizar Profesion")
{
if (this.ValidationTextbox() == "")
{
RcdMultiTablaEntity objEnt = new RcdMultiTablaEntity();
objEnt.IdTabla = int.Parse(txtId.Text);
objEnt.IdTablaDetalle = int.Parse(txtIdDetalle.Text);
objEnt.Descripcion1 = txtProfesion.Text;
//objEnt.Descripcion2 = txtAbreviatura.Text;
try
{
objContMultiTbl.Update(objEnt);
MessageOk("La Profesion ha sido actualizado correctamente.");
//ClearCampus();
this.Close();
}
catch (Exception)
{
}
}
else
{
MessageError(ValidationTextbox());
}
}
}
public DataTable SearchIdTabla(RcdMultiTablaEntity obj)
{
con = objCon.Conectar();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("USP_SEL_MULTITABLA", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@CodigoTabla", SqlDbType.Int).Value = obj.IdTabla;
//da.SelectCommand.Parameters.Add("@CodigoValor1",SqlDbType.Int).Value=obj.IdTablaDetalle;
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
private void DgvDataList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex != -1)
{
if (e.ColumnIndex == dgvDataList.Columns[7].Index)
{
var objContMultTbl = new MultiTablaController();
var objEntMultTbl = new RcdMultiTablaEntity();
var objModal = FrmModalProfesional.GetInstancia();
objModal.txtId.Text = Convert.ToString(dgvDataList.CurrentRow.Cells[0].Value);
objModal.txtIdDetalle.Text = Convert.ToString(dgvDataList.CurrentRow.Cells[2].Value);
objModal.txtProfesion.Text = Convert.ToString(dgvDataList.CurrentRow.Cells[4].Value);
objModal.lblTitle.Text = "Actualizar Profesion";
objModal.btnGuardar.Text = "&Actualizar";
objEntMultTbl.IdTabla = 3;
objModal.ShowDialog();
objContMultTbl.ViewListProfesional(dgvDataList, objEntMultTbl);
}
else if (e.ColumnIndex == dgvDataList.Columns[8].Index)
{
DialogResult r = MessageBox.Show("Esta seguro que desea eliminar el registro?\n\n\t*" + Convert.ToString(this.dgvDataList.CurrentRow.Cells[4].Value), "Sistema de Tramite Documentario",
MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (r == DialogResult.OK)
{
int idTabla = int.Parse(dgvDataList.CurrentRow.Cells[0].Value.ToString());
RcdMultiTablaEntity objEnt = new RcdMultiTablaEntity();
objEnt.IdTabla = int.Parse(dgvDataList.CurrentRow.Cells[0].Value.ToString());
objEnt.IdTablaDetalle = int.Parse(dgvDataList.CurrentRow.Cells[2].Value.ToString());
objCon.Delete(objEnt);
dgvDataList.Rows.RemoveAt(e.RowIndex);
MensajeOk("El registro ha sido eliminado con Exito.");
lblTotal.Text = "Total de registros: " + Convert.ToString(dgvDataList.Rows.Count);
}
}
}
}
public void Delete(RcdMultiTablaEntity obj)
{
objModel.Delete(obj);
}
public void Update(RcdMultiTablaEntity obj)
{
objModel.Update(obj);
}
public void Add(RcdMultiTablaEntity obj)
{
objModel.Add(obj);
}
public void ListMultiTablaPorIdTabla(DataGridView dgv, RcdMultiTablaEntity obj)
{
var tabla = this.SearchIdTabla(obj);
this.ListarGrid(dgv, tabla);
}
