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