private void btnDone_Click(object sender, EventArgs e) { uDB.OpenConnection(); myConfig.ID = Convert.ToInt32(txtRCID.Text); myConfig.DataFinish = dateTimePicker1.Value.Date.ToString("d"); myConfig.PeriodsLeft = Convert.ToInt32(upDown.Value); myConfig.FirstPay = Convert.ToInt32(numericUpDown1.Value); myConfig.PriceAppM2 = Convert.ToDouble(txtbEditAppPrice.Text); myConfig.PriceComAreaM2 = Convert.ToDouble(txtbEditComPrice.Text); myConfig.PriceFooterM2 = Convert.ToDouble(txtbEditFooterPrice.Text); myConfig.PriceParking = Convert.ToDouble(txtbEditParkingPrice.Text); uDB.UpdateConfig(myConfig); uDB.CloseCon(); ClearBinding(); update(); gpEdit.Visible = false; cbRC.Enabled = true; btnEdit.Enabled = true; btnEditImage.Enabled = true; txtbWatchAppPrice.Enabled = true; txtbWatchComPrice.Enabled = true; txtbWatchDateFinish.Enabled = true; txtbWatchFirstPay.Enabled = true; txtbWatchFooterPrice.Enabled = true; txtbWatchParkingPrice.Enabled = true; txtbWatchPeriodsLeft.Enabled = true; }
private void rbSold_CheckedChanged(object sender, EventArgs e) { bl = true; uDB.OpenConnection(); tComArea = uDB.SearchComArea(6, "ComArea.Sold", "", 0, 0, bl, 2); dgvComArea.DataSource = tComArea; uDB.CloseCon(); }
private void rbSold_CheckedChanged(object sender, EventArgs e) { bl = true; uDB.OpenConnection(); tFooter = uDB.SearchFooter(6, "Footer.Sold", "", 0, 0, bl, 2); dgvFooter.DataSource = tFooter; uDB.CloseCon(); }
private void rbSold_CheckedChanged(object sender, EventArgs e) { bl = true; uDB.OpenConnection(); tParking = uDB.SearchParking(6, "Parking.Sold", "", 0, 0, bl, 2); dgvParking.DataSource = tParking; uDB.CloseCon(); }
private void Clients_Load(object sender, EventArgs e) { uDB.OpenConnection(); tClient = uDB.GetTable(tname); dataGridSource(); dgvClients.DataSource = tClient; BindingAdd(); uDB.CloseCon(); }
private void Houses_Load(object sender, EventArgs e) { uDB.OpenConnection(); tRC = uDB.GetTable("RC"); DataGridSource(); dgvRC.DataSource = tRC; BindingAdd(); uDB.CloseCon(); }
private void Apps_Load(object sender, EventArgs e) { uDB.OpenConnection(); tApps = uDB.GetApps(); DataGridSource(); dgvApps.DataSource = tApps; BindingAdd(); uDB.CloseCon(); }
private void btnDelete_Click(object sender, EventArgs e) { uDB.OpenConnection(); if (cbAppNum.Text != "") { if (appID != 0 && typeID != 0 && rcID != 0) { uDB.DeleteByIntNum("Apps", "ID", appID); } } uDB.CloseCon(); }
private void Bclient_Click(object sender, EventArgs e) { uDB.OpenConnection(); login = uDB.GetLogin(textBox1.Text, textBox2.Text); if (login.Rows[0][0].ToString() == "1") { for (int i = 0; i < 30; i++) { Thread.Sleep(30); } fm.Show(); this.Hide(); } else { MessageBox.Show("Incorect login or password"); } uDB.CloseCon(); }
private void AddContract_Load(object sender, EventArgs e) { uDB.OpenConnection(); tRC = uDB.GetTable("RC"); cbRC.DataSource = tRC; cbRC.DisplayMember = "Name"; txtRCID.DataBindings.Add(new System.Windows.Forms.Binding("Text", tRC, "ID", true)); txtTerm.DataBindings.Add(new System.Windows.Forms.Binding("Text", tRC, "PeriodsLeft", true)); uDB.CloseCon(); }
private void btnAdd_Click(object sender, EventArgs e) { Client myClient = new Client(); UseDB uDB = new UseDB(); myClient.Name = txtbName.Text; myClient.Phone = Convert.ToInt32(txtbPhone.Text); myClient.PassportSer = txtbPassSer.Text; myClient.PassportNum = Convert.ToInt32(txtbPassNum.Text); uDB.OpenConnection(); uDB.InsertClient(myClient); uDB.CloseCon(); this.Hide(); }
private void btnDelete_Click(object sender, EventArgs e) { uDB.OpenConnection(); switch (index) { case 0: if (txtbClientDel.Text != "") { int id = Convert.ToInt32(txtbClientDel.Text); uDB.DeleteByIntNum(tname, "ID", id); } break; case 1: if (txtbClientDel.Text != "") { string name = txtbClientDel.Text; uDB.DeleteByString(tname, "Name", name); } break; case 2: if (txtbClientDel.Text != "") { int phone = Convert.ToInt32(txtbClientDel.Text); uDB.DeleteByIntNum(tname, "Phone", phone); } break; case 3: if (txtbClientDel.Text != "") { int num = Convert.ToInt32(txtbClientDel.Text); string ser = txtbClientDel2.Text; uDB.DeleteByPassPort(ser, num); } break; } uDB.CloseCon(); txtbClientDel.Text = ""; cbClientDel.Text = ""; }
private void btnPaymentS_Click(object sender, EventArgs e) { uDB.OpenConnection(); if (txtbPaymentS.Text != "") { switch (cbPaymentS.SelectedIndex) { case 0: { int id = Convert.ToInt32(txtbPaymentS.Text); tPayment = uDB.SearchPayment(1, "Payment.ID", "", id); } break; case 1: { string name = txtbPaymentS.Text; tPayment = uDB.SearchPayment(0, "Clients.Name", name, 0); } break; case 2: { int id = Convert.ToInt32(txtbPaymentS.Text); tPayment = uDB.SearchPayment(1, "Contract.ID", "", id); } break; case 3: { string date = txtbPaymentS.Text; tPayment = uDB.SearchPayment(0, "Contract.Data", date, 0); } break; case 4: { string date = txtbPaymentS.Text; tPayment = uDB.SearchPayment(0, "Payment.Data", date, 0); } break; } } dgvPayment.DataSource = tPayment; uDB.CloseCon(); }
private void btnCancel_Click(object sender, EventArgs e) { uDB.CloseCon(); this.Hide(); }
private void btnAddAppType_Click(object sender, EventArgs e) { uDB.OpenConnection(); if (txtAppTypeName.Text != "" && txtAppRoomAm.Text != "" && txtAppLiveArea.Text != "" && txtAppTotalArea.Text != "") { myType.RC_ID = Convert.ToInt32(txtAppRcID.Text); myType.Typee = txtAppTypeName.Text; myType.RoomAm = Convert.ToInt32(txtAppRoomAm.Text); myType.LiveArea = Convert.ToDouble(txtAppLiveArea.Text); myType.TotalArea = Convert.ToDouble(txtAppTotalArea.Text); double m2price = Convert.ToDouble(txtAppM2Price.Text); myType.TotalPrice = myType.TotalArea * m2price; myType.Object = "App"; myType.Picture = pbAddImage.Image; uDB.InsertType(myType); pbAddImage.Image = null; tType = uDB.GetAppType("App"); dgvAppTypes.DataSource = tType; } uDB.CloseCon(); }