public DataSet GetAll2(string empresaid, tb_rrhh_personal BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbRrhhPersonal_SEARCH2", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public DataSet GetAll(string empresaid, tb_rrhh_personal BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbRrhhPersonal_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@empresaid", SqlDbType.Char, 2).Value = BE.empresaid;
cmd.Parameters.Add("@DDNNI", SqlDbType.Char, 8).Value = BE.DDNNI;
cmd.Parameters.Add("@NOMBS", SqlDbType.VarChar, 73).Value = BE.NOMBS;
cmd.Parameters.Add("@FLVIS", SqlDbType.Bit).Value = BE.flvis;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
public bool Delete(string empresaid, tb_rrhh_personal BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbRrhhPersonal_DELETE", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@DDNNI", SqlDbType.Char, 8).Value = BE.DDNNI;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
private Boolean InsertWeb()
{
Boolean result = false;
rrhh_personalBL BL = new rrhh_personalBL();
tb_rrhh_personal BE = new tb_rrhh_personal();
BE.empresaid = EmpresaID.ToString();
BE.DDNNI = txt_dni.Text.Trim();
BE.APPAT = txt_apepat.Text.Trim().ToUpper();
BE.APMAT = txt_apemat.Text.Trim().ToUpper();
BE.NOMBR = txt_nombre.Text.Trim().ToUpper();
BE.NOMBS = txt_vendorname.Text.Trim().ToUpper();
if (txt_fechnac.Text.Length > 0)
BE.FENAC = Convert.ToDateTime(txt_fechnac.Text);
BE.UBIGE = "150101"; // LIMA
BE.IDEDU = "09"; // EDUCACION TECNICA COMPLETA
BE.ECIVI = "1"; // SOLTERO
if (txt_fechini.Text.Length > 0)
BE.FEING = Convert.ToDateTime(txt_fechini.Text);
BE.DIREC = txt_direcc.Text.Trim().ToUpper();
BE.TELEF = txt_telefono.Text.Trim().ToUpper();
// NO PASO IDCC2 PORQUE DESDE BD LO VALIDO EN CAMBIO DE ESO MANDO OTRO PARAMETRO @idold
//BE.IDCC2 = Equivalencias.Right(txt_local.Text,2).Trim();
BE.idold = Equivalencias.Right(txt_local.Text, 2).Trim();
BE.BASIC = Convert.ToDouble(txt_remunebas.Text);
BE.ASFAM = "N";
BE.IDAFP = "99";
BE.NMAFI = "";
if (txt_fechcese.Text.Length > 0)
BE.IDSIT = "13"; // CESADO
else
BE.IDSIT = "11"; // ACTIVO SUBSIDIADO
if (txt_fechcese.Text.Length > 0)
BE.FECES = Convert.ToDateTime(txt_fechcese.Text);
if (rb_sexo.EditValue.ToString() == "M")
BE.SEXXO = "1";
else
BE.SEXXO = "2";
BE.IDTUR = "01";
BE.USUAR = VariablesPublicas.Usuar.Trim();
BE.FEACT = System.DateTime.Now.Date;
BE.IDOCU = "572037"; // VENDEDOR, PRENDAS DE VESTIR
BE.PAISS = "9589"; // PERU
BE.flvis = false;
try
{
result = BL.Insert(EmpresaID, BE);
}
catch (Exception ex)
{
throw ex;
}
return result;
}
private void Insert()
{
try
{
if (U_Validacion())
{
// CLASES PARA LA INSERCION DE VENDEDORES
var BL = new tb_me_vendedorBL();
var BE = new tb_me_vendedor();
// CLASES PARA EL LLAMADO DEL INSERCION DE RRHH
rrhh_personalBL BLR = new rrhh_personalBL();
tb_rrhh_personal BER = new tb_rrhh_personal();
BE.vendorname = txt_vendorname.Text.Trim().ToUpper();
BE.appat = txt_apepat.Text.ToUpper();
BE.apmat = txt_apemat.Text.ToUpper();
BE.nombre = txt_nombre.Text.ToUpper();
BE.ddnni = txt_dni.Text.Trim();
BE.direcc = txt_direcc.Text.Trim();
if (txt_fechnac.Text.Length > 0)
BE.fechnac = Convert.ToDateTime(txt_fechnac.Text);
BE.local = txt_local.Text.Trim();
if (txt_fechini.Text.Length > 0)
BE.fechini = Convert.ToDateTime(txt_fechini.Text);
if (txt_fechcese.Text.Length > 0)
BE.fechcese = Convert.ToDateTime(txt_fechcese.Text);
BE.telefono = txt_telefono.Text;
BE.remunebas = Convert.ToDecimal(txt_remunebas.Text);
BE.cargoid = txt_cargoid.Text.Trim();
if (txt_fechasig.Text.Length > 0)
BE.fechasig = Convert.ToDateTime(txt_fechasig.Text);
BE.sexo = rb_sexo.EditValue.ToString();
BE.conhijos = chk_conhijos.Checked;
BE.comisiona = chk_comisiona.Checked;
BE.observac = txt_observ.Text.Trim();
BE.status = "0";
BE.usuar = VariablesPublicas.Usuar.Trim().ToUpper();
String xxMessage = "";
if (BL.Insert(EmpresaID, BE))
{
xxMessage = "1";
// Verificamos en el Datapi Si Existe un Personal con el Dni
if (SearchWebDNI() > 0)
{
if (UpdateWeb())
{
xxMessage = xxMessage + " / 2";
}
}
else
{
if (InsertWeb())
{
xxMessage = xxMessage + " / 2";
}
}
MessageBox.Show("Datos " + xxMessage + " Grabados Correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information);
procesado = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool Update3(string empresaid, tb_rrhh_personal BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbRrhhPersonal_UPDATE3", cnx))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@empresaid", SqlDbType.Char, 2).Value = BE.empresaid;
cmd.Parameters.Add("@DDNNI", SqlDbType.Char, 8).Value = BE.DDNNI;
cmd.Parameters.Add("@APPAT", SqlDbType.VarChar, 20).Value = BE.APPAT;
cmd.Parameters.Add("@APMAT", SqlDbType.VarChar, 20).Value = BE.APMAT;
cmd.Parameters.Add("@NOMBR", SqlDbType.VarChar, 30).Value = BE.NOMBR;
cmd.Parameters.Add("@NOMBS", SqlDbType.VarChar, 73).Value = BE.NOMBS;
cmd.Parameters.Add("@FOTOG", SqlDbType.VarChar, 24).Value = BE.FOTOG;
cmd.Parameters.Add("@FENAC", SqlDbType.DateTime).Value = BE.FENAC;
cmd.Parameters.Add("@UBIGE", SqlDbType.Char, 6).Value = BE.UBIGE;
cmd.Parameters.Add("@IDEDU", SqlDbType.Char, 2).Value = BE.IDEDU;
cmd.Parameters.Add("@ECIVI", SqlDbType.Char, 1).Value = BE.ECIVI;
cmd.Parameters.Add("@FEING", SqlDbType.DateTime).Value = BE.FEING;
cmd.Parameters.Add("@DIREC", SqlDbType.VarChar, 70).Value = BE.DIREC;
cmd.Parameters.Add("@TELEF", SqlDbType.VarChar, 25).Value = BE.TELEF;
cmd.Parameters.Add("@IDCC1", SqlDbType.Char, 2).Value = BE.IDCC1;
cmd.Parameters.Add("@IDCC2", SqlDbType.Char, 3).Value = BE.IDCC2;
cmd.Parameters.Add("@FEINP", SqlDbType.DateTime).Value = BE.FEINP;
cmd.Parameters.Add("@ESSAL", SqlDbType.VarChar, 15).Value = BE.ESSAL;
cmd.Parameters.Add("@BASIC", SqlDbType.Float).Value = BE.BASIC;
cmd.Parameters.Add("@IDCAO", SqlDbType.Char).Value = BE.IDCAO;
cmd.Parameters.Add("@ASFAM", SqlDbType.Char).Value = BE.ASFAM;
cmd.Parameters.Add("@IDAFP", SqlDbType.Char, 2).Value = BE.IDAFP;
cmd.Parameters.Add("@NMAFI", SqlDbType.VarChar, 15).Value = BE.NMAFI;
cmd.Parameters.Add("@IDSIT", SqlDbType.Char, 2).Value = BE.IDSIT;
cmd.Parameters.Add("@FECES", SqlDbType.DateTime).Value = BE.FECES;
cmd.Parameters.Add("@IDPER", SqlDbType.Char).Value = BE.IDPER;
cmd.Parameters.Add("@AFER5", SqlDbType.Char).Value = BE.AFER5;
cmd.Parameters.Add("@SEXXO", SqlDbType.Char).Value = BE.SEXXO;
cmd.Parameters.Add("@NMCTA", SqlDbType.VarChar, 20).Value = BE.NMCTA;
cmd.Parameters.Add("@RETJU", SqlDbType.Float).Value = BE.RETJU;
cmd.Parameters.Add("@IDTUR", SqlDbType.Char, 2).Value = BE.IDTUR;
cmd.Parameters.Add("@CLAVE", SqlDbType.VarChar, 6).Value = BE.CLAVE;
cmd.Parameters.Add("@IDOCU", SqlDbType.Char, 6).Value = BE.IDOCU;
cmd.Parameters.Add("@PAISS", SqlDbType.Char, 4).Value = BE.PAISS;
cmd.Parameters.Add("@USUAR", SqlDbType.Char, 15).Value = BE.USUAR;
//cmd.Parameters.Add("@FEACT", SqlDbType.DateTime).Value = BE.FEACT;
//cmd.Parameters.Add("@FLTAG", SqlDbType.Char).Value = BE.FLTAG;
cmd.Parameters.Add("@flvis", SqlDbType.Bit).Value = BE.flvis;
cmd.Parameters.Add("@idold", SqlDbType.Char, 2).Value = BE.idold;
}
try
{
cnx.Open();
if (cmd.ExecuteNonQuery() > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}