private void button7_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("Esta Seguro que Quiere Eliminar a este Jugador ", "AFC - ELIMINAR JUGADOR", MessageBoxButtons.YesNoCancel); if (result == DialogResult.Yes) { ClassConnectDataBase delete = new ClassConnectDataBase(); MessageBox.Show(delete.delete_user(textBox3.Text), "AFC - JUGADOR ELIMINADO", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
protected virtual void registerUser() { SetStatus("Registrando..."); ClassConnectDataBase crud = new ClassConnectDataBase(); string result = crud.insert(txt_name.Text, txt_lastname.Text, teamName, txt_carnet.Text + " " + ciudadaCarnet, txt_phono.Text, "", "", "", positionName, txt_date.Text, nameCode, arrayTemplate[0], arrayTemplate[1], iddivision, idteam); SetStatus("REGISTRO REALIZADO CORRECTAMENTE"); Message(result); }
private void RegisterUser_Load(object sender, EventArgs e) { ClassConnectDataBase db = new ClassConnectDataBase(); combo_division.DataSource = db.getDivision(); combo_division.DisplayMember = "name"; combo_division.ValueMember = "id"; combo_team.DataSource = db.getTeam(); combo_team.DisplayMember = "name"; combo_team.ValueMember = "id"; }
private void VerificationUser_Load(object sender, EventArgs e) { try { search = new ClassConnectDataBase(); Init(); Start(); } catch { MessageBox.Show("ERROR", "Iniciando lector de huella"); } //Verify(); //Init(); //Start(); }
protected override void registerUser() { MemoryStream fingerdata = new MemoryStream(); base.Enroller.Template.Serialize(fingerdata); fingerdata.Position = 0; BinaryReader br = new BinaryReader(fingerdata); Byte[] bytes = br.ReadBytes((Int32)fingerdata.Length); ClassConnectDataBase c = new ClassConnectDataBase(); string result = c.update(int.Parse(textBox3.Text), txt_name.Text, txt_lastname.Text, teamName, txt_carnet.Text + " " + ciudadaCarnet, txt_phono.Text, "", "", "", positionName, txt_date.Text, nameCode, arrayTemplate[0], arrayTemplate[1]); SetStatus("Datos Actualizados Correctamente"); Message(result); }
public void Verify() { ClassConnectDataBase classBio = new ClassConnectDataBase(); DataTable table = classBio.getDataWithTwoFingers(""); int i = table.Rows.Count; for (int items = 0; items < i; items++) { byte[] fingerBufferOne = (byte[])table.Rows[items]["fingerOne"]; byte[] fingerBufferTwo = (byte[])table.Rows[items]["fingerTwo"]; DPFP.Template[] arrayTemplate = new DPFP.Template[2]; arrayTemplate[0] = getTemplate(fingerBufferOne); arrayTemplate[1] = getTemplate(fingerBufferTwo); ListTemplate.Add(table.Rows[items]["Id"].ToString(), arrayTemplate); } }
/// <summary> /// This is a examplo method. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button5_Click(object sender, EventArgs e) { try { ClassConnectDataBase db = new ClassConnectDataBase(); DataTable tabla = db.getDivisionTeamsID(combo_division.SelectedValue.ToString(), combo_team.SelectedValue.ToString()); string iddivison = tabla.Rows[0]["id"].ToString(); MessageBox.Show(iddivison); tabla = db.getChampionsId(combo_division.SelectedValue.ToString()); string idchampion = tabla.Rows[0]["championship_id"].ToString(); MessageBox.Show(idchampion); // this is a examplo db.insertDivisionTeamsPLayers("5334", iddivison, idchampion); } catch { MessageBox.Show("El Equipo Seleccionado no tiene la Division Seleccionada", "AFC Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void getUerData(string keysTemplate) { try { MakeReport("Jugador no Encontrado en la Base de Datos de AFC "); ClassConnectDataBase classBiometric = new ClassConnectDataBase(); DataTable table = classBiometric.getDatawithTwoFinger(keysTemplate); name = table.Rows[0]["Name"].ToString(); last_name = table.Rows[0]["last_name"].ToString(); nickname = table.Rows[0]["nickname"].ToString(); ci = table.Rows[0]["ci"].ToString(); height = table.Rows[0]["height"].ToString(); weight = table.Rows[0]["weight"].ToString(); skillful_leg = table.Rows[0]["skillful_leg"].ToString(); position = table.Rows[0]["position"].ToString(); birthday = table.Rows[0]["birthday"].ToString(); ftp ftpClient = new ftp(@"ftp://sidbol.com", ConstactsCreadentials.userName, ConstactsCreadentials.pass); /* Upload a File */ ftpClient.download("public_html/afc/app/webroot/img/players/sm_" + table.Rows[0]["image"].ToString() + ".jpg", Application.StartupPath + "\\Images\\sm_" + table.Rows[0]["image"].ToString() + ".jpg"); pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage; pictureBox1.Image = Image.FromFile(Application.StartupPath + "\\Images\\sm_" + table.Rows[0]["image"].ToString() + ".jpg"); UserName(name, last_name, nickname, ci, height, weight, skillful_leg, position, birthday); btn(); } catch { //Message("*************** There is a Problem, please try again ******************"); } }
private void button1_Click_1(object sender, EventArgs e) { search = new ClassConnectDataBase(); dataGridView1.DataSource = search.search_Users(textBox1.Text); }
private void Search_Users_Load(object sender, EventArgs e) { search = new ClassConnectDataBase(); }
private void button5_Click(object sender, EventArgs e) { ClassConnectDataBase delete = new ClassConnectDataBase(); MessageBox.Show(delete.delete_user(textBox3.Text), "Eleminar Jugador"); }