//listar contrato detalle
public List <eContratoDetalleVC> GetSelecionarContratoDetalle(eContratoDetalleVC o, out int total)
{
List <eContratoDetalleVC> list = new List <eContratoDetalleVC>();
int DBtotRow = 0;
try
{
conexion.Open();
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.CommandText = _db.sSelectContratoDetalle;
sqlcmd.Connection = conexion;
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@NRO_CONTRATO", SqlDbType.VarChar).Value = o._nro_Contrato;
sqlcmd.Parameters.Add("@PAGE_INDEX", SqlDbType.Int).Value = o._inicio;
sqlcmd.Parameters.Add("@PAGE_SIZE", SqlDbType.Int).Value = o._fin;
sqlcmd.Parameters.Add("@ORDERBY", SqlDbType.VarChar).Value = o._orderby;
sqlcmd.Parameters.Add("@TOTAL", SqlDbType.Int).Direction = ParameterDirection.Output;
SqlDataReader dr = sqlcmd.ExecuteReader();
while (dr.Read())
{
eContratoDetalleVC e = new eContratoDetalleVC();
e._ide_Contrato_Det = dr.GetInt32(1);
e._nro_Contrato = dr.GetString(2);
e._ide_Reasegurador = dr.GetString(3).Trim();
e._cod_Reasegurador = dr.GetString(4).Trim();
e._cal_Crediticia = dr.GetString(5).Trim();
e._cod_Empresa_Califica = dr.GetString(6).Trim();
e._mod_Contrato = dr.GetString(7).Trim();
e._prc_Retencion = dr.GetDecimal(8);
e._prc_Cesion = dr.GetDecimal(9);
e._prc_participacion_rea = dr.GetDecimal(10);
e._nombre_Rea = dr.GetString(11);
e._nro_Registro_Rea = dr.GetInt32(12);
e._estado = dr.GetString(13);
e._usu_reg = dr.GetString(14);
e._fec_reg = dr.GetDateTime(15);
list.Add(e);
}
dr.Close();
DBtotRow = (int)sqlcmd.Parameters["@TOTAL"].Value;
}
catch (Exception ex)
{
}
finally
{
conexion.Close();
}
total = DBtotRow;
return(list);
}
public Int32 SetInsertarContratoDetalle(eContratoDetalleVC o)
{
Int32 _bool = 0;
try
{
conexion.Open();
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.Connection = conexion;
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.CommandText = _db.sSinsertarContratoDet;
sqlcmd.Parameters.Add("@ID_EMPRESA", SqlDbType.Int).Value = o._id_Empresa;
sqlcmd.Parameters.Add("@NRO_CONTRATO", SqlDbType.VarChar).Value = o._nro_Contrato;
sqlcmd.Parameters.Add("@IDE_REASEGURADOR", SqlDbType.Char).Value = o._ide_Reasegurador;
sqlcmd.Parameters.Add("@COD_REASEGURADOR", SqlDbType.Char).Value = o._cod_Reasegurador;
sqlcmd.Parameters.Add("@CAL_CREDITICIA", SqlDbType.Char).Value = o._cal_Crediticia;
sqlcmd.Parameters.Add("@COD_EMPRESA_CALIFICA", SqlDbType.Char).Value = o._cod_Empresa_Califica;
sqlcmd.Parameters.Add("@MOD_CONTRATO", SqlDbType.Char).Value = o._mod_Contrato;
sqlcmd.Parameters.Add("@PRC_RETENCION", SqlDbType.Decimal).Value = o._prc_Retencion;
sqlcmd.Parameters.Add("@PRC_PARTICIPACION_REA", SqlDbType.Decimal).Value = o._prc_participacion_rea;
sqlcmd.Parameters.Add("@PRC_CESION", SqlDbType.Decimal).Value = o._prc_Cesion;
sqlcmd.Parameters.Add("@NOMBRE_REA", SqlDbType.VarChar).Value = o._nombre_Rea;
sqlcmd.Parameters.Add("@NRO_REGISTRO_REA", SqlDbType.Int).Value = o._nro_Registro_Rea;
sqlcmd.Parameters.Add("@ESTADO", SqlDbType.Char).Value = o._estado;
sqlcmd.Parameters.Add("@USU_REG", SqlDbType.VarChar).Value = o._usu_reg;
_bool = Int32.Parse(sqlcmd.ExecuteScalar().ToString());
if (_bool != 0)
{
String query = "UPDATE CONTRATO SET ESTADO = 'A' WHERE NRO_CONTRATO = " + o._nro_Contrato;
sqlcmd.CommandType = CommandType.Text;
sqlcmd.CommandText = query;
sqlcmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw (new Exception(ex.Message));
}
finally
{
conexion.Close();
}
return(_bool);
}
public static object ContratoDetalleList(int jtStartIndex, int jtPageSize, string jtSorting, String WhereBy)
{
int total;
int indexPage = jtStartIndex != 0 ? jtStartIndex / jtPageSize : jtStartIndex;
eContratoDetalleVC o = new eContratoDetalleVC();
o._inicio = indexPage;
o._fin = jtPageSize;
o._orderby = jtSorting.Substring(1).ToUpper();
o._nro_Contrato = WhereBy.Trim();
var list = new bContratoDetalleVC().GetSelecionarContratoDetalle(o, out total);
return(new { Result = "OK", Records = list, TotalRecordCount = total });
}
//funcion de insertar reaseguradores
private void SetInsertarActualizarContratoDetalle()
{
try
{
Int32 resp = 0;
eContratoDetalleVC d = new eContratoDetalleVC();
d._ide_Contrato_Det = Convert.ToInt32(txt_idContratoDetalle_c.Value);
d._id_Empresa = Convert.ToInt32(Session["idempresa"]);
d._nro_Contrato = ddl_contrato_r.SelectedItem.Value;
d._ide_Reasegurador = ddl_reasegurador_r.SelectedItem.Value;
d._cod_Reasegurador = ddl_reasegurador_r.SelectedItem.Value;
d._cod_Empresa_Califica = ddl_calificadora_r.SelectedItem.Value;
d._cal_Crediticia = ddl_crediticia_r.SelectedItem.Value;
d._mod_Contrato = ddl_tipcont_det_r.SelectedItem.Value;
d._prc_Retencion = Convert.ToDecimal(txt_retencion_r.Text);
d._prc_Cesion = Convert.ToDecimal(txt_cesion_r.Text);
d._prc_participacion_rea = Convert.ToDecimal(txt_participacion_cesion.Text);
d._nombre_Rea = txt_nombre_rea.Text;
d._nro_Registro_Rea = Convert.ToInt32(txt_nro_registro_rea.Text);
d._estado = "A";
d._usu_reg = Session["username"].ToString();
d._usu_mod = Session["username"].ToString();
bContratoDetalleVC icd = new bContratoDetalleVC();
if (d._ide_Contrato_Det == 0)
{
resp = icd.SetInsertarContratoDetalle(d);
MessageBox("Registro Grabado Correctamente!");
}
else
{
resp = icd.SetActualizarContratoDetalle(d);
MessageBox("Registro Actualizado Correctamente");
}
}
catch (Exception e) {
MessageBoxcCatch("ERROR =>" + e.Message);
}
}
//listar contrato detalle
public List<eContratoDetalleVC> GetSelecionarContratoDetalle(eContratoDetalleVC o,out int total) {
dSqlContratoDetalleVC cd = new dSqlContratoDetalleVC();
return cd.GetSelecionarContratoDetalle(o,out total);
}
//actualizar contrato detalle
public Int32 SetActualizarContratoDetalle(eContratoDetalleVC o) {
dSqlContratoDetalleVC cd = new dSqlContratoDetalleVC();
return cd.SetActualizarContratoDetalle(o);
}
public Int32 SetInsertarContratoDetalle(eContratoDetalleVC o) {
dSqlContratoDetalleVC cd = new dSqlContratoDetalleVC();
return cd.SetInsertarContratoDetalle(o);
}
