private void button1_Click(object sender, EventArgs e) { TrackingWebHYIP tracweb = new TrackingWebHYIP(); TrackingWebHYIPDatabase trackwebdata = new TrackingWebHYIPDatabase(); BUS_TrackingWebHYIP buss = new BUS_TrackingWebHYIP(); BUS_TrackingWebHYIPDatabase bussdata = new BUS_TrackingWebHYIPDatabase(); //Id web vua add vao co so du lieu tracweb.GetInformationAuto = 0; tracweb.Addrress = textBox_addrress.Text; tracweb.Good = 1; int ID = buss.InsertTrackingWebHYIP(tracweb); //lay dep va with trang web string timenow = DateTime.Now.ToString("MM-dd-yyyy HH:mm:ss.fff"); trackwebdata.MaWeb = ID; trackwebdata.Deposit = float.Parse(textBox_deposit.Text, CultureInfo.InvariantCulture.NumberFormat); trackwebdata.WithDraw = float.Parse(textBox_withdraw.Text, CultureInfo.InvariantCulture.NumberFormat); trackwebdata.Today = timenow; //insert TrackingWebHYIPDatabase int result = bussdata.InsertTrackingWebHYIPDatabase(trackwebdata); if (result != 0) { MessageBox.Show("OK"); this.Close(); p_frm.LoadDataTracking(); } }
private void button1_Click(object sender, EventArgs e) { try { float.Parse(textBox_dep.Text); validate_textbx_dep = true; errorProvider1.SetError(textBox_dep, ""); } catch (Exception) { validate_textbx_dep = false; errorProvider1.SetError(textBox_dep, "error"); } try { float.Parse(textBox_with.Text); validate_textbx_with = true; errorProvider1.SetError(textBox_with, ""); } catch (Exception) { validate_textbx_with = false; errorProvider1.SetError(textBox_with, "error"); } if (validate_textbx_dep && validate_textbx_with) { errorProvider1.Clear(); float dep = float.Parse(textBox_dep.Text); float withdraw = float.Parse(textBox_with.Text); string timenow = DateTime.Now.ToString(); //insert TrackingWebHYIPDatabase BUS_TrackingWebHYIPDatabase buss = new BUS_TrackingWebHYIPDatabase(); TrackingWebHYIPDatabase model = new TrackingWebHYIPDatabase(); model.MaWeb = ID; model.Deposit = dep; model.WithDraw = withdraw; model.Today = timenow; int result = buss.InsertTrackingWebHYIPDatabase(model); if (result != 0) { MessageBox.Show("OK"); this.Close(); p.LoadDataTracking(); } } else { MessageBox.Show("Check again !"); } }
public int InsertTableTrackingWebHYIPDATABASE(TrackingWebHYIPDatabase w) { try { string sql = " insert into TrackingWebHYIPDatabase values(" + w.MaWeb + "," + w.Deposit + "," + w.WithDraw + ",'" + w.Today + "')"; cmd = new SqlCommand(sql); cmd.Connection = conn; this.openConnection(); int result = cmd.ExecuteNonQuery(); this.closeConnection(); return(result); } catch (Exception ex) { throw ex; } }
public int excuteAutoUpdate(int id, string address) { TrackingWebHYIPDatabase trackwebdata = new TrackingWebHYIPDatabase(); BUS_TrackingWebHYIPDatabase bussdata = new BUS_TrackingWebHYIPDatabase(); GetDataWeb getdt = new GetDataWeb(); Tuple <string, string> info = getdt.GetDepositAndWithdraw(address); if (info.Item1 != "") { string timenow = DateTime.Now.ToString("MM-dd-yyyy HH:mm:ss.fff"); trackwebdata.MaWeb = id; trackwebdata.Deposit = float.Parse(info.Item1.ToString(), CultureInfo.InvariantCulture.NumberFormat); trackwebdata.WithDraw = float.Parse(info.Item2.ToString(), CultureInfo.InvariantCulture.NumberFormat); trackwebdata.Today = timenow; //insert TrackingWebHYIPDatabase int result = bussdata.InsertTrackingWebHYIPDatabase(trackwebdata); return(result); } return(-1); }
public int InsertTrackingWebHYIPDatabase(TrackingWebHYIPDatabase trac) { return(conector.InsertTableTrackingWebHYIPDATABASE(trac)); }
private void dataGridView2_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (dataGridView2.Columns[e.ColumnIndex].Name != "") { DataGridViewRow selectedRow = dataGridView2.Rows[e.RowIndex]; string Name = selectedRow.Cells["name"].Value.ToString(); if (Name != "") { bool checkname = CheckNameExits(Name, dataGridView2); if (checkname) { MessageBox.Show("Name Exits"); selectedRow.Cells["name"].Value = ""; } else { //insert vo TrackingWebHYIP BUS_TrackingWebHYIP buss = new BUS_TrackingWebHYIP(); BUS_TrackingWebHYIPDatabase bussdata = new BUS_TrackingWebHYIPDatabase(); TrackingWebHYIP tracweb = new TrackingWebHYIP(); TrackingWebHYIPDatabase trackwebdata = new TrackingWebHYIPDatabase(); tracweb.Addrress = Name; GetDataWeb getdt = new GetDataWeb(); Tuple <string, string> info = getdt.GetDepositAndWithdraw(Name); if (info.Item1.ToString() == "cloudfare") { DialogResult result = MessageBox.Show("This webste use Cloudfare . Add manual"); if (result == DialogResult.OK) { AddWebTracking frm = new AddWebTracking(this); frm.ShowDialog(); } } else if (info.Item1.ToString() == "Something Wrong" || info.Item1.ToString() == "" || info.Item2.ToString() == "") { DialogResult result = MessageBox.Show("Something wrong.Add manual"); if (result == DialogResult.OK) { AddWebTracking frm = new AddWebTracking(this); frm.ShowDialog(); } } else { //Id web vua add vao co so du lieu tracweb.GetInformationAuto = 1; tracweb.Good = 1; int ID = buss.InsertTrackingWebHYIP(tracweb); //lay dep va with trang web string timenow = DateTime.Now.ToString("MM-dd-yyyy HH:mm:ss.fff"); trackwebdata.MaWeb = ID; trackwebdata.Deposit = float.Parse(info.Item1.ToString(), CultureInfo.InvariantCulture.NumberFormat); trackwebdata.WithDraw = float.Parse(info.Item2.ToString(), CultureInfo.InvariantCulture.NumberFormat); trackwebdata.Today = timenow; //insert TrackingWebHYIPDatabase int result = bussdata.InsertTrackingWebHYIPDatabase(trackwebdata); if (result != 0) { LoadDataTracking(); } } } } } }