public void Update(GenmTipoDocumentoEntity objTypeDoc)
{
con = objCon.Conectar();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "USP_UPD_TIPODOCUMENTO";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = objTypeDoc.IdTipoDocumento;
cmd.Parameters.Add("@Nombre", SqlDbType.VarChar, 50).Value = objTypeDoc.Descripcion;
cmd.Parameters.Add("@Sigla", SqlDbType.NVarChar, 20).Value = objTypeDoc.Sigla;
cmd.Parameters.Add("@Estado", SqlDbType.NVarChar, 1).Value = objTypeDoc.Estado;
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
public void SearchTipoDocumento(DataGridView dgv, string textoBuscar)
{
GenmTipoDocumentoEntity objEnt = new GenmTipoDocumentoEntity();
objEnt.Descripcion = textoBuscar;
objTypeDocModel.SearchTipoDocumentoDescripcion(dgv, objEnt);
}
private void btnGuardar_Click(object sender, EventArgs e)
{
if (lblTitle.Text == "Agregar Nuevo Tipo Documento")
{
if (this.Validation() == "")
{
GenmTipoDocumentoEntity objEnt = new GenmTipoDocumentoEntity();
// obj.IdTipoDocumento =int.Parse( txtId.Text);
objEnt.Descripcion = txtDescription.Text;
objEnt.Sigla = txtSigla.Text;
try
{
objTipDoc.Add(objEnt);
MessageConfirmation("El Tipo de Documento ha sido registrado correctamente.");
ClearCampus();
}
catch (Exception)
{
}
}
else
{
MessageError(Validation());
}
}
else if (lblTitle.Text == "Actualizar Tipo Documento")
{
if (this.Validation() == "")
{
GenmTipoDocumentoEntity objEnt = new GenmTipoDocumentoEntity();
objEnt.IdTipoDocumento = int.Parse(txtId.Text);
objEnt.Descripcion = txtDescription.Text;
objEnt.Sigla = txtSigla.Text;
if (chkEstatus.Checked)
{
objEnt.Estado = "1";
}
else
{
objEnt.Estado = "0";
}
try
{
objTipDoc.Update(objEnt);
MessageConfirmation("El Tipo de Documento ha sido actualizado correctamente.");
//ClearCampus();
this.Close();
}
catch (Exception)
{
}
}
else
{
MessageError(Validation());
}
}
}
private void dgvDataList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex != -1)
{
if (e.ColumnIndex == dgvDataList.Columns[4].Index)
{
var dato = new TipoDocumentoController();
var obj = FrmModal.GetInstancia();
obj.txtId.Text = Convert.ToString(this.dgvDataList.CurrentRow.Cells[0].Value);
obj.txtDescription.Text = Convert.ToString(this.dgvDataList.CurrentRow.Cells[1].Value);
obj.txtSigla.Text = Convert.ToString(this.dgvDataList.CurrentRow.Cells[2].Value);
if (this.dgvDataList.CurrentRow.Cells[3].Value.ToString() == "1")
{
obj.chkEstatus.Checked = true;
}
else
{
obj.chkEstatus.Checked = false;
}
obj.lblTitle.Text = "Actualizar Tipo Documento";
obj.btnGuardar.Text = "Actualizar";
obj.ShowDialog();
dato.VerLista(dgvDataList);
}
if (e.ColumnIndex == dgvDataList.Columns[5].Index)
{
DialogResult r = MessageBox.Show("Esta seguro que desea eliminar el registro?\n\n\t*" + Convert.ToString(this.dgvDataList.CurrentRow.Cells[1].Value), "Sistema de Tramite Documentario",
MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (r == DialogResult.OK)
{
int tipo_id = int.Parse(dgvDataList.Rows[e.RowIndex].Cells[0].Value.ToString());
TipoDocumentoController objCon = new TipoDocumentoController();
GenmTipoDocumentoEntity objEnt = new GenmTipoDocumentoEntity();
objEnt.IdTipoDocumento = tipo_id;
objCon.Delete(objEnt);
dgvDataList.Rows.RemoveAt(e.RowIndex);
MensajeOk("El registro ha sido eliminado correctamente.");
objCon.VerLista(dgvDataList);
}
else
{
//MessageBox.Show("Cancelando Operacion");
}
}
}
}
public DataTable SearchId(GenmTipoDocumentoEntity objTypeDoc)
{
con = objCon.Conectar();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SP_BUSCA_TIPODOCUMENTO_POR_ID", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@ID", SqlDbType.Int).Value = objTypeDoc.IdTipoDocumento;
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public void Delete(GenmTipoDocumentoEntity objTypeDoc)
{
con = objCon.Conectar();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "USP_DEL_TIPODOCUMENTO";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = objTypeDoc.IdTipoDocumento;
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
public void SearchTipoDocumentoDescripcion(DataGridView dgv, GenmTipoDocumentoEntity objTipDoc)
{
var tabla = this.SearchTIpoDocumento(objTipDoc.Descripcion);
this.ListarGrid(dgv, tabla);
}
public DataTable SearchId(GenmTipoDocumentoEntity objTipDocEnt)
{
return(objTypeDocModel.SearchId(objTipDocEnt));
}
public void Delete(GenmTipoDocumentoEntity obj)
{
objTypeDocModel.Delete(obj);
}
public void Update(GenmTipoDocumentoEntity obj)
{
objTypeDocModel.Update(obj);
}
public void Add(GenmTipoDocumentoEntity objEnt)
{
objTypeDocModel.Add(objEnt);
}
