public string Edit(DTipoExistencia Entity)
{
result = "";
using (SqlConnection connect = Dconexion.Getconectar())
{
connect.Open();
try
{
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "manto.SP_AddTipoExist";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idtip_exist", Entity.IdTipoExist);
cmd.Parameters.AddWithValue("@codigo", Entity.Codigo);
cmd.Parameters.AddWithValue("@descripcion", Entity.Descripcion);
result = cmd.ExecuteNonQuery() == 1 ? "Se Modifico Correctamente!" : "Error al Modificar";
cmd.Parameters.Clear();
}
}
catch (Exception ex)
{
result = ex.Message;
}
}
return(result);
}
public List <DTipoExistencia> Getdata(DTipoExistencia Entity)
{
using (SqlConnection connect = Dconexion.Getconectar())
{
connect.Open();
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "manto.SP_ShowTipoExist";
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dtr = cmd.ExecuteReader();
using (DataTable dt = new DataTable())
{
dt.Load(dtr);
dtr.Dispose();
listTipoExist = new List <DTipoExistencia>();
foreach (DataRow item in dt.Rows)
{
listTipoExist.Add(new DTipoExistencia()
{
IdTipoExist = Convert.ToInt32(item[0]),
Codigo = item[1].ToString(),
Descripcion = item[2].ToString()
});
}
}
}
}
return(listTipoExist);
}
public FrmTipoExistencia()
{
InitializeComponent();
dTipoExist = new DTipoExistencia();
rTipoExist = new RTipoExistencia();
Dgv_tipoExist.AutoGenerateColumns = false;
Show_TipoExist();
//Tabla();
}
private void CargarTipoExistencia()
{
DTipoExistencia bo = new DTipoExistencia();
if (bo.CuadroCombinado().Count > 0)
{
CbxTipoExistencia.DataSource = new BindingSource(bo.CuadroCombinado(), null);
CbxTipoExistencia.ValueMember = "Key";
CbxTipoExistencia.DisplayMember = "Value";
}
if (cbxtipoexistenciaselected != "")
{
CbxTipoExistencia.SelectedValue = cbxtipoexistenciaselected;
}
}
public string Delete(DTipoExistencia Entity)
{
using (SqlConnection conn = Dconexion.Getconectar())
{
conn.Open();
cmd = null;
using (cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "manto.SP_DeleteTipoExist";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idtip_exist", Entity.IdTipoExist);
result = cmd.ExecuteNonQuery() == 1 ? "Se Elimino Correctamente!" : "Error al Eliminar";
cmd.Parameters.Clear();
}
}
return(result);
}
public string Add(DTipoExistencia Entity)
{
using (SqlConnection connect = Dconexion.Getconectar())
{
connect.Open();
try
{
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "manto.SP_AddTipoExist";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@codigo", Entity.Codigo);
cmd.Parameters.AddWithValue("@descripcion", Entity.Descripcion);
result = cmd.ExecuteNonQuery() == 1 ? "Registrado Correctamente!" : "Error al Regsitrar";
cmd.Parameters.Clear();
}
}
catch (Exception ex)
{
SqlException sqlex = ex as SqlException;
if (sqlex != null && sqlex.Number == 2627)
{
result = "EL CODIGO INGRESADO YA SE ENCUENTRA REGISTRADO";
}
else
{
result = ex.Message;
}
}
} //aqui esta cerrando la conexion.
return(result);
}
