public int Edit(DSubsidios entiti)
{
result = 0;
using (SqlConnection cnn = RConexion.Getconectar())
{
cnn.Open();
cmd = null;
using (cmd = new SqlCommand())
{
cmd.Connection = cnn;
cmd.CommandText = "SP_MODIFY_SUBSIDIOS";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@cod_subsidio", entiti.Cod_subsidios);
cmd.Parameters.AddWithValue("@tipo_suspension", entiti.Tipo_supension);
cmd.Parameters.AddWithValue("@descripcion_corta", entiti.Descrip_corta);
cmd.Parameters.AddWithValue("@descrip_subsidio", entiti.Descripcion_subsidio);
cmd.Parameters.AddWithValue("@tipo_subsidio", entiti.Tipo_subsidio);
cmd.Parameters.AddWithValue("@descuento", entiti.Descuento);
cmd.Parameters.AddWithValue("@id_subsidios", entiti.Id_subsidios);
result = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
}
return(result);
}
public DataTable GetData(DRegimenSalud entiti)
{
DataTable dt;
using (SqlConnection cnn = RConexion.Getconectar())
{
cnn.Open();
cmd = null;
SqlDataAdapter da = new SqlDataAdapter();
using (cmd = new SqlCommand())
{
cmd.Connection = cnn;
cmd.CommandText = "SP_SHOW_REG_SALUD";
cmd.CommandType = CommandType.StoredProcedure;
da.SelectCommand = cmd;
using (dt = new DataTable())
{
da.Fill(dt);
da.Dispose();
}
}
}
return(dt);
}
public int Add(DSubsidios entiti)
{
result = 0;
cmd = null;
using (SqlConnection connect = RConexion.Getconectar())
{
connect.Open();
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "SP_ADD_SUBSIDIOS";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@cod_subsidio", entiti.Cod_subsidios);
cmd.Parameters.AddWithValue("@tipo_suspension", entiti.Tipo_supension);
cmd.Parameters.AddWithValue("@descripcion_corta", entiti.Descrip_corta);
cmd.Parameters.AddWithValue("@descripcion_subsidio", entiti.Descripcion_subsidio);
cmd.Parameters.AddWithValue("@tipo_subsidio", entiti.Tipo_subsidio);
cmd.Parameters.AddWithValue("@descuento", entiti.Descuento);
cmd.Parameters.Add("@mensaje", SqlDbType.VarChar, 25).Direction = ParameterDirection.Output;
result = cmd.ExecuteNonQuery();
entiti.mensaje = cmd.Parameters["@mensaje"].Value.ToString();
cmd.Parameters.Clear();
}
}
return(result);
}
public int Add(Dusuario entiti)
{
resul = 0;
using (SqlConnection cnn = RConexion.Getconectar())
{
cnn.Open();
cmd = null;
using (cmd = new SqlCommand())
{
cmd.Connection = cnn;
cmd.CommandText = "SP_INSERT_USUARIO";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@codigo_usu", entiti.Codigo_usu);
cmd.Parameters.AddWithValue("@nom_user", entiti.Nombre_refe);
cmd.Parameters.AddWithValue("@passwor", entiti.Password);
cmd.Parameters.AddWithValue("@genero", entiti.Genero);
cmd.Parameters.AddWithValue("@id_rol", entiti.Idrol);
cmd.Parameters.Add("@mesage", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output;
resul = cmd.ExecuteNonQuery();
entiti.mesage = cmd.Parameters["@mesage"].Value.ToString();
cmd.Parameters.Clear();
}
}
return(resul);
}
//EDIT
public int Edit(Dusuario entiti)
{
resul = 0;
using (SqlConnection cnn = RConexion.Getconectar())
{
cnn.Open();
cmd = null;
using (cmd = new SqlCommand())
{
cmd.Connection = cnn;
cmd.CommandText = "SP_UPDATE_USUARIO";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@codigo_usu", entiti.Codigo_usu);
cmd.Parameters.AddWithValue("@nom_user", entiti.Nombre_refe);
cmd.Parameters.AddWithValue("@passwor", entiti.Password);
cmd.Parameters.AddWithValue("@genero", entiti.Genero);
cmd.Parameters.AddWithValue("@id_rol", entiti.Idrol);
cmd.Parameters.AddWithValue("@idusu", entiti.Idusuario);
resul = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
}
return(resul);
}
public DataTable Show_planillaPrueba(DplanillaM entity)
{
DataTable dt = null;
using (SqlConnection conect = RConexion.Getconectar())
{
conect.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conect;
cmd.CommandText = "SP_SHOW_PLANILLAMANTO_PRUEBA";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idplanilla", entity.Pm_id_planilla);
cmd.Parameters.AddWithValue("@idmes", entity.Pid_mes);
SqlDataReader reader = cmd.ExecuteReader();
using (dt = new DataTable())
{
if (reader.HasRows)
{
dt.Load(reader);
reader.Close();
}
}
}
}
return(dt);
}
public int Add(DRegimen entiti)
{
result = 0;
using (SqlConnection conn = RConexion.Getconectar())
{
conn.Open();
cmd = null;
using (cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SP_ADD_REGIMEN";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@descripcion_corta", entiti.Descripcion_corta);
cmd.Parameters.AddWithValue("@descripcion", entiti.Descripcion);
cmd.Parameters.AddWithValue("@tipo_regimen", entiti.Tipo_regimen);
cmd.Parameters.Add("@mensaje", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output;
result = cmd.ExecuteNonQuery();
entiti.mensaje = cmd.Parameters["@mensaje"].Value.ToString();
cmd.Parameters.Clear();
}
}
return(result);
}
public DataTable Show_planillaM(DplanillaM entity)
{
DataTable dt = null;
using (SqlConnection conect = RConexion.Getconectar())
{
conect.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conect;
cmd.CommandText = "SP_ShowPlanillaManto";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idplanilla", entity.Pm_id_planilla);
cmd.Parameters.AddWithValue("@idmes", entity.Pid_mes);
cmd.Parameters.AddWithValue("@id_empresaMaestra", entity.Pid_empreMaestra);
//cmd.Parameters.AddWithValue("@fechaini", entity.Pfecha_inicio);
cmd.Parameters.AddWithValue("@fechafin", entity.Pfecha_fin);
SqlDataReader reader = cmd.ExecuteReader();
using (dt = new DataTable())
{
if (reader.HasRows)
{
dt.Load(reader);
reader.Close();
}
}
}
}
return(dt);
}
public DataTable GetData(DPlanilla entiti)
{
DataTable dt = null;
using (SqlConnection cnn = RConexion.Getconectar())
{
cnn.Open();
cmd = null;
SqlDataAdapter da = new SqlDataAdapter();
using (cmd = new SqlCommand())
{
cmd.Connection = cnn;
cmd.CommandText = "SP_SHOW_PLANILLA";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@codigo_empresam", entiti.Id_empresam);
cmd.Parameters.AddWithValue("@periodo", entiti.Id_periodo);
da.SelectCommand = cmd;
using (dt = new DataTable())
{
da.Fill(dt);
da.Dispose();
}
}
}
return(dt);
}
public int Add(DPlanilla entiti)
{
result = 0;
using (SqlConnection connect = RConexion.Getconectar())
{
connect.Open();
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "SP_INSERT_PLANILLA";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idtipo_planilla", entiti.Idtipo_planilla);
cmd.Parameters.AddWithValue("@id_periodo", entiti.Id_periodo);
cmd.Parameters.AddWithValue("@id_empMaestra", entiti.Id_empresam);
cmd.Parameters.AddWithValue("@id_mes", entiti.Id_mes);
cmd.Parameters.AddWithValue("@fecha_inicial", entiti.Fecha_inicial);
cmd.Parameters.AddWithValue("@fecha_final", entiti.Fecha_final);
cmd.Parameters.AddWithValue("@fecha_pago", entiti.Fecha_pago);
cmd.Parameters.AddWithValue("@dias_mes", entiti.Dias_mes);
cmd.Parameters.AddWithValue("@horas_mes", entiti.Horas_mes);
cmd.Parameters.AddWithValue("@topehora_nocturno", entiti.Tope_horario_nocturno);
cmd.Parameters.Add("@mesage", SqlDbType.VarChar, 50).Direction = ParameterDirection.Output;
result = cmd.ExecuteNonQuery();
entiti.mensaje = cmd.Parameters["@mesage"].Value.ToString();
cmd.Parameters.Clear();
}
}
return(result);
}
public DataTable GetData(DSubsidios entiti)
{
DataTable dt = null;
using (SqlConnection cnn = RConexion.Getconectar())
{
cnn.Open();
using (cmd = new SqlCommand())
{
cmd.Connection = cnn;
cmd.CommandText = "SP_MOSTRAR_SUBSIDIOS";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tip_subsidio", entiti.Tipo_subsidio);
SqlDataReader reader = cmd.ExecuteReader();
using (dt = new DataTable())
{
if (reader.HasRows)
{
dt.Load(reader);
reader.Close();
}
}
}
}
return(dt);
}
//GET SHOW ALL
public DataTable GetData(DempresaMaestra entiti)
{
DataTable dt;
using (SqlConnection cnn = RConexion.Getconectar())
{
cnn.Open();
SqlDataAdapter da = new SqlDataAdapter();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cnn;
cmd.CommandText = "SP_SHOW_EMPRESA";
cmd.CommandType = CommandType.StoredProcedure;
da.SelectCommand = cmd;
using (dt = new DataTable())
{
da.Fill(dt);
da.Dispose();
}
}
}
return(dt);
}
public DataTable Show_comisionafp(Dafp entity, string tipo_regimen)
{
DataTable dt = null;
using (SqlConnection conect = RConexion.Getconectar())
{
conect.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conect;
cmd.CommandText = "SP_SHOW_COMISIONPENSIONES";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idmes", entity.Idmes);
cmd.Parameters.AddWithValue("@idperiodo", entity.Idperiodo);
cmd.Parameters.AddWithValue("@tipo_regimen", tipo_regimen);
SqlDataReader reader = cmd.ExecuteReader();
using (dt = new DataTable())
{
if (reader.HasRows)
{
dt.Load(reader);
reader.Close();
}
}
}
}
return(dt);
}
public bool Business(List <object> lista)
{
bool valor = false;
using (SqlConnection cn = RConexion.Getconectar())
{
cn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandText = "SP_EMPRESAS_USUARIO";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@codigo_user", UserCache.IdUser);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
foreach (var item in reader)
{
lista.Add(item);
}
valor = true;
}
else
{
valor = false;
}
reader.Close();
}
}
return(valor);
}
public DataTable GetData(DDiasSubsidiados entiti)
{
DataTable dt = null;
cmd = null;
using (var conn = RConexion.Getconectar())
{
conn.Open();
using (cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SP_SHOW_DETSUBSIDIOS";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@idmes", SqlDbType.Int).Value = entiti.Id_mes;
cmd.Parameters.Add("@idperiodo", SqlDbType.Int).Value = entiti.Id_periodo;
cmd.Parameters.Add("@idempleado", SqlDbType.Int).Value = entiti.Id_empleado;
cmd.Parameters.Add("@tipoSubsidio", SqlDbType.VarChar, 30).Value = entiti.ValTipSubsidio;
SqlDataReader reader = cmd.ExecuteReader();
using (dt = new DataTable())
{
if (reader.HasRows)
{
dt.Load(reader);
reader.Close();
}
}
}
}
return(dt);
}
public bool Login(string user, string roles, string pass)
{
using (SqlConnection cn = RConexion.Getconectar())
{
cn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandText = "SP_LOGIN_USUARIO";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@user", user);
cmd.Parameters.AddWithValue("@descrip_rol", roles);
cmd.Parameters.AddWithValue("@pass", pass);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
UserCache.IdUser = dr.GetInt32(0);
UserCache.NombreUser = dr.GetString(1); //muestra el dato en el formulario principal
UserCache.Genero = dr.GetString(2); //para validar la imagen en el formulario principal. la foto.
UserCache.RolUser = dr.GetString(3); //muestra el dato en el formulario principal
}
dr.Close();
return(true);
}
else
{
return(false);
}
}
}
}
//EDITAR ONP
public int EditOnp(Dafp daf)
{
result = 0;
using (SqlConnection conect = RConexion.Getconectar())
{
conect.Open();
using (SqlTransaction sqltra = conect.BeginTransaction())
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "SP_UPDATE_COMISIONES_ONP";
cmd.Connection = conect;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Transaction = sqltra;
cmd.Parameters.Add("@comision", SqlDbType.Decimal).Value = daf.Comision;
cmd.Parameters.Add("@idcomision", SqlDbType.Int).Value = daf.Id_comision;
result = cmd.ExecuteNonQuery();
}
sqltra.Commit();
}
catch (Exception ex)
{
sqltra.Rollback();
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
}
return(result);
}
//MOSTRAR MES.
public DataTable Mostrar_mes()
{
List <Dafp> lista_mes = new List <Dafp>();
DataTable dt = null;
using (SqlConnection cn = RConexion.Getconectar())
{
cn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandText = "SP_SHOW_MES";
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
using (dt = new DataTable())
{
dt.Load(reader);
reader.Close();
}
}
}
}
return(dt);
}
public DataTable GetData(DConceptos entiti)
{
DataTable dt = null;
using (SqlConnection conect = RConexion.Getconectar())
{
conect.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conect;
cmd.CommandText = "SP_SHOW_CONCEPTOS";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idmes", entiti.Id_mes);
cmd.Parameters.AddWithValue("@idplanilla", entiti.Id_planilla);
SqlDataReader reader = cmd.ExecuteReader();
using (dt = new DataTable())
{
dt.Load(reader);
reader.Close();
}
}
}
return(dt);
}
//RECUPERA DATOS DE EMPLEDO Y CONTRATO
public DataTable GetDataEC(DEmpleadoContrato entiti)
{
DataTable dt;
using (SqlConnection cnn = RConexion.Getconectar())
{
cnn.Open();
cmd = null;
SqlDataAdapter da = new SqlDataAdapter();
using (cmd = new SqlCommand())
{
cmd.Connection = cnn;
cmd.CommandText = "SP_SHOW_EMPLEADO_CONTRATO";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@codigo_empleado", SqlDbType.Int).Value = entiti.Id_empleado;
da.SelectCommand = cmd;
using (dt = new DataTable())
{
da.Fill(dt);
cmd.Parameters.Clear();
da.Dispose();
}
}
}
return(dt);
}
public DataTable GetData(Dprivilegios entiti)
{
DataTable dt = null;
using (SqlConnection conect = RConexion.Getconectar())
{
conect.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conect;
cmd.CommandText = "SP_SHOW_PRIVILEGIOS";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id_rol", entiti.Id_rol);
SqlDataReader reader = cmd.ExecuteReader();
using (dt = new DataTable())
{
dt.Load(reader);
reader.Close();
}
}
}
return(dt);
}
//EDITAR EMPLEADO Y CONTRATO
public int Edit(DEmpleadoContrato entiti)
{
result = 0;
using (SqlConnection conn = RConexion.Getconectar())
{
conn.Open();
cmd = null;
try
{
using (cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SP_UPDATE_EMPLEADO";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@codigo", entiti.Codigo);
cmd.Parameters.AddWithValue("@nom_emp", entiti.Nom_emp);
cmd.Parameters.AddWithValue("@ape_pat", entiti.Ape_pat);
cmd.Parameters.AddWithValue("@ape_mat", entiti.Ape_mat);
cmd.Parameters.AddWithValue("@fec_nac", entiti.Fec_nac);
cmd.Parameters.AddWithValue("@nacionalidad", entiti.Nacionalidad);
cmd.Parameters.AddWithValue("@tip_ge", entiti.Tipo_genero);
cmd.Parameters.AddWithValue("@direccion", entiti.Direccion);
cmd.Parameters.AddWithValue("@telefono", entiti.Telefono);
cmd.Parameters.AddWithValue("@num_doc", entiti.Num_doc);
cmd.Parameters.AddWithValue("@estado", entiti.Estado);
cmd.Parameters.AddWithValue("@jornada_laboral", entiti.Jornada_laboral);
cmd.Parameters.AddWithValue("@codigo_regimen", entiti.Codigo_regimen);
cmd.Parameters.AddWithValue("@id_documento", entiti.Id_doc);
cmd.Parameters.AddWithValue("@id_cargo", entiti.Id_cargo);
cmd.Parameters.AddWithValue("@id_empleado", entiti.Id_empleado);
//UPDATE CONTRATO
cmd.Parameters.AddWithValue("@id_banco", entiti.Cid_banco);
cmd.Parameters.AddWithValue("@id_tcontrato", entiti.Cid_tcontrato);
cmd.Parameters.AddWithValue("@fecha_inicio", entiti.Cfecha_inicio);
cmd.Parameters.AddWithValue("@fecha_fin", entiti.Cfecha_fin);
cmd.Parameters.AddWithValue("@num_cuenta", entiti.Cnum_cuenta);
cmd.Parameters.AddWithValue("@remu_basica", entiti.Cremu_basica);
cmd.Parameters.AddWithValue("@asig_fami", entiti.Casig_fami);
cmd.Parameters.AddWithValue("@tipo_pago", entiti.Ctipo_pago);
cmd.Parameters.AddWithValue("@periodicidad", entiti.Cperiodicidad);
cmd.Parameters.AddWithValue("@tipo_modeda", entiti.Ctipo_moneda);
cmd.Parameters.AddWithValue("@cuenta_cts", entiti.Ccts);
cmd.Parameters.AddWithValue("@cussp", entiti.Ccussp);
cmd.Parameters.AddWithValue("@id_salud", entiti.Cid_regimenSalud);
result = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.ToString());
}
}
return(result);
}
//AGREGAR EMPLEADO Y CONTRATO
public int Add(DEmpleadoContrato entiti)
{
result = 0;
cmd = null;
using (SqlConnection connect = RConexion.Getconectar())
{
connect.Open();
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "SP_ADD_EMPLEADO";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@codigo", entiti.Codigo);
cmd.Parameters.AddWithValue("@nom_emp", entiti.Nom_emp);
cmd.Parameters.AddWithValue("@ape_pat", entiti.Ape_pat);
cmd.Parameters.AddWithValue("@ape_mat", entiti.Ape_mat);
cmd.Parameters.AddWithValue("@fec_nac", entiti.Fec_nac);
cmd.Parameters.AddWithValue("@nacionalidad", entiti.Nacionalidad);
cmd.Parameters.AddWithValue("@tip_ge", entiti.Tipo_genero);
cmd.Parameters.AddWithValue("@direccion", entiti.Direccion);
cmd.Parameters.AddWithValue("@telefono", entiti.Telefono);
cmd.Parameters.AddWithValue("@num_doc", entiti.Num_doc);
cmd.Parameters.AddWithValue("@estado", entiti.Estado);
cmd.Parameters.AddWithValue("@codigo_regimen", entiti.Codigo_regimen);
cmd.Parameters.AddWithValue("@id_documento", entiti.Id_doc);
cmd.Parameters.AddWithValue("@id_cargo", entiti.Id_cargo);
cmd.Parameters.AddWithValue("@id_empresa_maestra", entiti.Id_emp_maestra); //aqui pudes llamar ese id que esta en cache o si no.
cmd.Parameters.AddWithValue("@jornada_laboral", entiti.Jornada_laboral);
// INSERSION DE CONTRATO
cmd.Parameters.AddWithValue("@id_banco", entiti.Cid_banco);
cmd.Parameters.AddWithValue("@id_tcontrato", entiti.Cid_tcontrato);
cmd.Parameters.AddWithValue("@fecha_inicio", entiti.Cfecha_inicio);
cmd.Parameters.AddWithValue("@fecha_fin", entiti.Cfecha_fin);
cmd.Parameters.AddWithValue("@num_cuenta", entiti.Cnum_cuenta);
cmd.Parameters.AddWithValue("@remu_basica", entiti.Cremu_basica);
cmd.Parameters.AddWithValue("@asig_fami", entiti.Casig_fami);
cmd.Parameters.AddWithValue("@tipo_pago", entiti.Ctipo_pago);
cmd.Parameters.AddWithValue("@periodicidad", entiti.Cperiodicidad);
cmd.Parameters.AddWithValue("@tipo_modeda", entiti.Ctipo_moneda);
cmd.Parameters.AddWithValue("@cuenta_cts", entiti.Ccts);
cmd.Parameters.AddWithValue("@cussp", entiti.Ccussp);
cmd.Parameters.AddWithValue("@id_salud", entiti.Cid_regimenSalud);
cmd.Parameters.Add("@mensaje", SqlDbType.VarChar, 200).Direction = ParameterDirection.Output;
result = cmd.ExecuteNonQuery();
entiti.mensaje = cmd.Parameters["@mensaje"].Value.ToString();
cmd.Parameters.Clear();
}
}
return(result);
}
//GUARDAR
public int Add(DempresaMaestra entiti)
{
result = 0;
using (SqlConnection conn = RConexion.Getconectar())
{
conn.Open();
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SP_INSERT_EMPRESA_MAESTRA";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@razon_social", entiti.Razon_social);
cmd.Parameters.AddWithValue("@direccion", entiti.Direccion);
cmd.Parameters.AddWithValue("@domicilio", entiti.Domicilio);
cmd.Parameters.AddWithValue("@ruc", entiti.Ruc);
cmd.Parameters.AddWithValue("@regimen", entiti.Regimen);
cmd.Parameters.AddWithValue("@localidad", entiti.Localidad);
cmd.Parameters.AddWithValue("@cod_empresa_validar", entiti.Ecodigo_empresa);
cmd.Parameters.Add("@mesage", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output;
using (SqlCommand cmd1 = new SqlCommand())
{
cmd1.Connection = conn;
cmd1.CommandText = "SP_INSERT_EMPRESA";
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@cod_empresa", entiti.Ecodigo_empresa);
cmd1.Parameters.AddWithValue("@id_usuario", entiti.Eidusuario);
result = cmd.ExecuteNonQuery();
entiti.mesages = cmd.Parameters["@mesage"].Value.ToString();
if (result > 0)
{
result = cmd1.ExecuteNonQuery();
}
cmd.Parameters.Clear();
cmd1.Parameters.Clear();
}
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.ToString());
}
}
return(result);
}
//EDIT
public int Edit(DempresaMaestra entiti)
{
result = 0;
using (SqlConnection conn = RConexion.Getconectar())
{
conn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SP_UPDATE_EMPRESAMAESTRA";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@razon_social", SqlDbType.VarChar, 50).Value = entiti.Razon_social;
cmd.Parameters.Add("@direccion", SqlDbType.NVarChar, 250).Value = entiti.Direccion;
cmd.Parameters.Add("@domicilio", SqlDbType.NVarChar, 250).Value = entiti.Domicilio;
cmd.Parameters.Add("@ruc", SqlDbType.Char, 11).Value = entiti.Ruc;
cmd.Parameters.Add("@regimen", SqlDbType.VarChar, 50).Value = entiti.Regimen;
cmd.Parameters.Add("@localidad", SqlDbType.VarChar, 50).Value = entiti.Localidad;
cmd.Parameters.Add("@id_emmaestra", SqlDbType.Int).Value = entiti.Eidemp_maestra;
using (SqlCommand cmd1 = new SqlCommand())
{
cmd1.Connection = conn;
cmd1.CommandText = "SP_UPDATE_EMPRESA";
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add("@cod_empresa", SqlDbType.VarChar, 8).Value = entiti.Ecodigo_empresa;
cmd1.Parameters.Add("@id_usuario", SqlDbType.Int).Value = entiti.Eidusuario;
cmd1.Parameters.Add("@id_emmaestra", SqlDbType.Int).Value = entiti.Eidemp_maestra;
result = cmd.ExecuteNonQuery();
if (result > 0)
{
result = cmd1.ExecuteNonQuery();
}
cmd.Parameters.Clear();
cmd1.Parameters.Clear();
}
}
}
return(result);
}
public int Add(DempresaMaestra entiti)
{
result = 0;
using (SqlConnection conn = RConexion.Getconectar())
{
using (SqlCommand cmd = new SqlCommand())
{
conn.Open();
cmd.Connection = conn;
cmd.CommandText = "SP_INSERT_EMPRESA_MAESTRA";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@razon_social", SqlDbType.VarChar, 50).Value = entiti.Razon_social;
cmd.Parameters.Add("@direccion", SqlDbType.NVarChar, 250).Value = entiti.Direccion;
cmd.Parameters.Add("@domicilio", SqlDbType.NVarChar, 250).Value = entiti.Domicilio;
cmd.Parameters.Add("@ruc", SqlDbType.Char, 11).Value = entiti.Ruc;
cmd.Parameters.Add("@regimen", SqlDbType.VarChar, 50).Value = entiti.Regimen;
cmd.Parameters.Add("@localidad", SqlDbType.VarChar, 50).Value = entiti.Localidad;
cmd.Parameters.Add("@cod_empresa_validar", SqlDbType.VarChar, 50).Value = entiti.Scodigo_sucursal;
cmd.Parameters.Add("@mesage", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output;
using (SqlCommand cmd1 = new SqlCommand())
{
cmd1.Connection = conn;
cmd1.CommandText = "SP_INSERT_SUCURSAL";
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add("@cod_sucursal", SqlDbType.VarChar, 8).Value = entiti.Scodigo_sucursal;
cmd1.Parameters.Add("@id_empresa", SqlDbType.Int).Value = entiti.Sid_empresa;
result = cmd.ExecuteNonQuery();
entiti.mesages = cmd.Parameters["@mesage"].Value.ToString();
if (result > 0)
{
result = cmd1.ExecuteNonQuery();
}
cmd.Parameters.Clear();
cmd1.Parameters.Clear();
}
}
return(result);
}
}
public int SaveAddUpdate(DConceptos entiti)
{
result = 0;
using (SqlConnection conect = RConexion.Getconectar())
{
conect.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conect;
cmd.CommandText = "SP_RegistroConceptos";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id_conceptos", entiti.Id_conceptos);
cmd.Parameters.AddWithValue("@id_mes", entiti.Id_mes);
cmd.Parameters.AddWithValue("@id_planilla", entiti.Id_planilla);
cmd.Parameters.AddWithValue("@hextraDiurna", entiti.HextraDiurna);
cmd.Parameters.AddWithValue("@hextraNocturna", entiti.HextraNocturna);
cmd.Parameters.AddWithValue("@feriadoDomi", entiti.FeriadoDomi);
cmd.Parameters.AddWithValue("@boniNocturna", entiti.BoniNoctur);
cmd.Parameters.AddWithValue("@primeromayo", entiti.PrimeroMayo);
cmd.Parameters.AddWithValue("@tarda", entiti.Tarda);
cmd.Parameters.AddWithValue("@subsi", entiti.Subsidi);
cmd.Parameters.AddWithValue("@thoraex", entiti.Thoraex);
cmd.Parameters.AddWithValue("@otroreinte", entiti.Otroreinte);
cmd.Parameters.AddWithValue("@prest_aliment", entiti.Prest_aliment);
cmd.Parameters.AddWithValue("@gratif", entiti.Gratif);
cmd.Parameters.AddWithValue("@vaca", entiti.Vaca);
cmd.Parameters.AddWithValue("@truncas", entiti.Trunca);
cmd.Parameters.AddWithValue("@reinte_gratiboni", entiti.Reinte_gratiboni);
cmd.Parameters.AddWithValue("@essa_vida", entiti.Essa_vida);
cmd.Parameters.AddWithValue("@adela", entiti.Adela);
cmd.Parameters.AddWithValue("@presta", entiti.Presta);
cmd.Parameters.AddWithValue("@rentquinta", entiti.Rentquinta);
cmd.Parameters.AddWithValue("@reten_judici", entiti.Reten_judici);
cmd.Parameters.AddWithValue("@otrodescu", entiti.Otrodescu);
cmd.Parameters.AddWithValue("@recarg_consu", entiti.Recarg_consu);
result = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
}
return(result);
}
public int Add(Drol entiti)
{
resul = 0;
using (SqlConnection cnn = RConexion.Getconectar())
{
cnn.Open();
cmd = null;
using (cmd = new SqlCommand())
{
cmd.Connection = cnn;
cmd.CommandText = "SP_INSERT_ROL";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@rol", SqlDbType.VarChar, 30).Value = entiti.Nombre_rol;
resul = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return(resul);
}
}
}
//ELIMINAR
public int Delete(DDiasSubsidiados entiti)
{
result = 0;
cmd = null;
using (SqlConnection connect = RConexion.Getconectar())
{
connect.Open();
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "SP_DELETE_SUBSIDIOS";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id_detSubsidios", SqlDbType.Int).Value = entiti.Id_det_subsidios;
result = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
}
return(result);
}
public int Add(Dafp daf)
{
result = 0;
using (SqlConnection conect = RConexion.Getconectar())
{
conect.Open();
using (SqlTransaction sqltra = conect.BeginTransaction())
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "SP_INSERT_COMISIONES";
cmd.Connection = conect;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Transaction = sqltra;
cmd.Parameters.Add("@codigo_regimen", SqlDbType.Int).Value = daf.Codigo_regimen;
cmd.Parameters.Add("@comision", SqlDbType.Decimal).Value = daf.Comision;
cmd.Parameters.Add("@saldo", SqlDbType.Decimal).Value = daf.Saldo;
cmd.Parameters.Add("@seguro", SqlDbType.Decimal).Value = daf.Seguro;
cmd.Parameters.Add("@aporte", SqlDbType.Decimal).Value = daf.Aporte;
cmd.Parameters.Add("@tope", SqlDbType.Decimal).Value = daf.Tope;
cmd.Parameters.Add("@idmes", SqlDbType.Int).Value = daf.Idmes;
cmd.Parameters.Add("@idperiodo", SqlDbType.Int).Value = daf.Idperiodo;
result = cmd.ExecuteNonQuery();
//System.Windows.Forms.MessageBox.Show("EXECUTE: " + result);
}
sqltra.Commit();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
sqltra.Rollback();
}
}
}
return(result);
}
