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