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); }