public string Edit(DTipoOperacion Entity)
{
result = "";
using (SqlConnection connect = Dconexion.Getconectar())
{
connect.Open();
try
{
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "manto.SP_EditTipoOper";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idtipOper", Entity.IdTipo_Oper);
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 <DTipoOperacion> Getdata(DTipoOperacion Entity)
{
using (SqlConnection connect = Dconexion.Getconectar())
{
connect.Open();
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "manto.SP_ShowTipoOper";
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dtr = cmd.ExecuteReader();
using (DataTable dt = new DataTable())
{
dt.Load(dtr);
dtr.Dispose();
listTipoOper = new List <DTipoOperacion>();
foreach (DataRow item in dt.Rows)
{
listTipoOper.Add(new DTipoOperacion()
{
IdTipo_Oper = Convert.ToInt32(item[0]),
Codigo = item[1].ToString(),
Descripcion = item[2].ToString()
});
}
}
}
}
return(listTipoOper);
}
public FrmTipoOperacion()
{
InitializeComponent();
dtipoOper = new DTipoOperacion();
rtipoOper = new RTipoOperacion();
Show_TipoOper();
//Tabla();
}
public string Delete(DTipoOperacion Entity)
{
using (SqlConnection conn = Dconexion.Getconectar())
{
conn.Open();
cmd = null;
using (cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "manto.SP_DeleteTipoOpera";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idtipOper", Entity.IdTipo_Oper);
result = cmd.ExecuteNonQuery() == 1 ? "Se Elimino Correctamente!" : "Error al Eliminar";
cmd.Parameters.Clear();
}
}
return(result);
}
public string Add(DTipoOperacion Entity)
{
using (SqlConnection connect = Dconexion.Getconectar())
{
connect.Open();
try
{
using (cmd = new SqlCommand())
{
cmd.Connection = connect;
cmd.CommandText = "manto.SP_AddTipoOper";
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);
}
public Frm_VTipoOper()
{
InitializeComponent();
dTipoOperacion = new DTipoOperacion();
rTipoOperacion = new RTipoOperacion();
}
