public void Actualizar(LectoraBE oLectoraBE) { dbConnectionMySql oDB = new dbConnectionMySql(); MySqlParameter[] sqlParameters = new MySqlParameter[4]; sqlParameters[0] = new MySqlParameter("?p_val_desc", oLectoraBE.val_desc); sqlParameters[1] = new MySqlParameter("?p_proy_oid_proy", oLectoraBE.proy_oid_proy); sqlParameters[2] = new MySqlParameter("?p_clie_oid_clie", oLectoraBE.clie_oid_clie); sqlParameters[3] = new MySqlParameter("?p_come_oid_come", oLectoraBE.come_oid_come_aten); sqlParameters[4] = new MySqlParameter("?p_ind_acti", oLectoraBE.ind_acti); oDB.EjecutarDML_SP("sp_Lectora_Upd", sqlParameters); }
public LectoraBE obtenerLectoraByOid(int oid) { LectoraBE oBE = new LectoraBE(); DataTable dt = new DataTable(); LectoraDAO oLectoraDAO = new LectoraDAO(); dt = oLectoraDAO.obtenerLectoraByOid(oid); foreach (DataRow dr in dt.Rows) { oBE.oid_lect = Int32.Parse(dr["oid_lect"].ToString()); oBE.val_desc = dr["val_desc"].ToString(); oBE.proy_oid_proy = Int32.Parse(dr["proy_oid_proy"].ToString()); oBE.clie_oid_clie = Int32.Parse(dr["clie_oid_clie"].ToString()); oBE.come_oid_come_aten = Int32.Parse(dr["come_oid_come_aten"].ToString()); oBE.ind_acti = Int32.Parse(dr["ind_acti"].ToString()); } return(oBE); }
private void btnGrabar_Click(object sender, EventArgs e) { LectoraBE oBE = new LectoraBE(); LectoraBR oBR = new LectoraBR(); oBE.val_desc = txtDescripcion.Text; oBE.proy_oid_proy = Global.oid_proy; DataRowView rvCome = cboComedor.SelectedItem as DataRowView; oBE.come_oid_come_aten = Int32.Parse(rvCome["Codigo"].ToString()); if ((cboEstado.SelectedItem as ComboBoxItem).Value.ToString() == "1") { oBE.ind_acti = 1; } else { oBE.ind_acti = 0; }; if (mod == "C") { oBR.Insertar(oBE); } else { oBE.oid_lect = Int32.Parse(txtOid.Text); oBR.Actualizar(oBE); } oFrm.CargarDGV(); this.Close(); }
public void Actualizar(LectoraBE oLectoraBE) { LectoraDAO oLectoraDAO = new LectoraDAO(); oLectoraDAO.Actualizar(oLectoraBE); }
public void Insertar(LectoraBE oLectoraBE) { LectoraDAO oLectoraDAO = new LectoraDAO(); oLectoraDAO.Insertar(oLectoraBE); }