//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);
}
//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);
}
//METODO GUARDAR CAMBIOS
public string SaveChanges()
{
mensaje = "";
try
{
DempresaMaestra de = new DempresaMaestra();
de.Razon_social = razon_social;
de.Direccion = direccion;
de.Domicilio = domicilio;
de.Ruc = ruc;
de.Regimen = regimen;
de.Localidad = localidad;
de.Scodigo_sucursal = scodigo_sucursal;
de.Eidemp_maestra = eidemp_maestra;
de.Sid_empresa = sidempresa;
de.Sidem_maestra = sidem_maestra;
switch (state)
{
case EntityState.Guardar:
sucursal_reposi.Add(de);
mensaje = de.mesages;
break;
case EntityState.Modificar:
sucursal_reposi.Edit(de);
mensaje = "¡Modificado!";
break;
case EntityState.Remover:
sucursal_reposi.Delete(de);
mensaje = de.mesages;
break;
default:
mensaje = "Error in Transaction!";
break;
}
}
catch (Exception ex)
{
mensaje = ex.ToString();
}
finally { }
return(mensaje);
}
//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);
}
}
//REMOVE
public int Delete(DempresaMaestra entiti)
{
result = 0;
using (SqlConnection cnn = RConexion.Getconectar())
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cnn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_REMOVE_EMPRESA";
cmd.Parameters.Add("@id_maestra", SqlDbType.Int).Value = entiti.Eidemp_maestra;
cmd.Parameters.Add("@mesage", SqlDbType.VarChar, 50).Direction = ParameterDirection.Output;
result = cmd.ExecuteNonQuery();
entiti.mesages = cmd.Parameters["@mesage"].Value.ToString();
cmd.Parameters.Clear();
}
}
return(result);
}
