public Form_ApproveExpense(Form1 form, DBinterface dbInterface, List <string> id) { InitializeComponent(); this.StartPosition = FormStartPosition.CenterScreen; InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("en-US")); localInterface = dbInterface; mainForm = form; this.ids = id; DataTable dt = localInterface.Select("SELECT approved,date,amount FROM expenses WHERE id=" + ids[0]).Tables[0]; approved = (bool)dt.Rows[0][0]; comboBox1.SelectedIndex = 0; if (approved) { comboBox1.SelectedIndex = 1; } date = MyUtills.dateFromSQL(dt.Rows[0][1].ToString()); dateTimePicker1.Value = date; if (this.ids.Count > 1) { checkBoxDate.Checked = false; textBox1.Visible = false; label1.Visible = false; } else { textBox1.Text = String.Format("{0:0,0.00}", double.Parse(dt.Rows[0][2].ToString())); } }
private void buttonUserEnter_Click(object sender, EventArgs e) { string username = textBoxUsername.Text; string pass = textBoxPassword.Text; if (username == String.Empty || pass == String.Empty) { return; } pass = MyUtills.ConvertToMd5(pass); string adminUsername = "******"; string adminPassword = MyUtills.ConvertToMd5("bnrbnr"); DataTable userTable = localInterface.Select("SELECT type FROM users WHERE username='******' AND password='******'").Tables[0]; int res = userTable.Rows.Count; if (username == adminUsername && pass == adminPassword) { mainForm.UserEnter(1); this.Close(); } else if (res > 0) { mainForm.UserEnter((int)userTable.Rows[0][0]); this.Close(); } else { labelStatus.Text = "שם משתמש או סיסמא לא נכונים"; labelStatus.ForeColor = Color.Red; } }
private void buttonYes_Click(object sender, EventArgs e) { string app = comboBox1.SelectedIndex.ToString(); if (ids.Count > 1) { foreach (string id in ids) { if (checkBoxDate.Checked) { if (checkBoxPaiment.Checked) { localInterface.Update("UPDATE expenses SET date='" + MyUtills.dateToSQL(dateTimePicker1.Value) + "',approved='" + app + "' WHERE id=" + id); } else { localInterface.Update("UPDATE expenses SET date='" + MyUtills.dateToSQL(dateTimePicker1.Value) + "' WHERE id=" + id); } } else { if (checkBoxPaiment.Checked) { localInterface.Update("UPDATE expenses SET approved='" + app + "' WHERE id=" + id); } } } } else { string amount = textBox1.Text.Replace(",", ""); if (checkBoxDate.Checked) { if (checkBoxPaiment.Checked) { localInterface.Update("UPDATE expenses SET date='" + MyUtills.dateToSQL(dateTimePicker1.Value) + "',approved='" + app + "',amount='" + amount + "' WHERE id=" + ids[0]); } else { localInterface.Update("UPDATE expenses SET date='" + MyUtills.dateToSQL(dateTimePicker1.Value) + "',amount='" + amount + "' WHERE id=" + ids[0]); } } else { localInterface.Update("UPDATE expenses SET approved='" + app + "',amount='" + amount + "' WHERE id=" + ids[0]); } } this.Close(); mainForm.showFinance(); }
private void buttonYes_Click(object sender, EventArgs e) { DateTime newDate = dateTimePicker1.Value; if (this.definite) { localInterface.Update("UPDATE bills SET payDate='" + MyUtills.dateToSQL(newDate) + "' WHERE id=" + this.id); } else { localInterface.Update("UPDATE bills SET toPayDate='" + MyUtills.dateToSQL(newDate) + "' WHERE id=" + this.id); } this.Close(); mainForm.showFinance(); }
private void buttonAddUser_Click(object sender, EventArgs e) { if (textBoxNewUsername.Text == String.Empty || textBoxNewPassword.Text == String.Empty) { return; } string pass = MyUtills.ConvertToMd5(textBoxNewPassword.Text); bool res = localInterface.InsertSql("INSERT INTO users (username,password,type) VALUES ('" + textBoxNewUsername.Text + "','" + pass + "','" + comboBoxUserTypes.SelectedValue + "')"); if (res == true) { showUsers(); } }
private void buttonSave_Click(object sender, EventArgs e) { if (textBoxText.Text == String.Empty) { labelText.ForeColor = Color.Red; return; } textBoxText.Text = textBoxText.Text.Replace(@"\", @"\\").Replace("'", @"\'").Replace('"', '\"'); string date = MyUtills.dateToSQL(DateTime.Now) + " " + DateTime.Now.Hour.ToString() + ":" + DateTime.Now.Minute.ToString() + ":" + DateTime.Now.Second.ToString(); localInterface.Insert("notes", "idBill,name,date,text", idBill + "','" + textBoxName.Text + "','" + date + "','" + textBoxText.Text); MessageBox.Show("הודעת מעקב חדשה נשמרה במערכת", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); mainForm.refreshBillNotes(idBill); this.Close(); }
public Form_EditIncome(Form1 form, DBinterface dbInterface, string id, bool def) { InitializeComponent(); this.StartPosition = FormStartPosition.CenterScreen; InputLanguage.CurrentInputLanguage = InputLanguage.FromCulture(new System.Globalization.CultureInfo("en-US")); localInterface = dbInterface; mainForm = form; this.id = id; this.definite = def; if (definite) { dateTimePicker1.Value = MyUtills.dateFromSQL(localInterface.Select("SELECT payDate FROM bills WHERE id=" + this.id).Tables[0].Rows[0][0].ToString()); } else { dateTimePicker1.Value = MyUtills.dateFromSQL(localInterface.Select("SELECT toPayDate FROM bills WHERE id=" + this.id).Tables[0].Rows[0][0].ToString()); } }
private void labelUpdateVat_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); double newVat = 0; string inputNewVat = textBoxNewVat.Text; if (inputNewVat == "") { inputNewVat = "0"; } if (!Double.TryParse(inputNewVat, out newVat)) { MessageBox.Show("מע\"מ לא חוקי", "שגיאה", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); return; } String newDateFormatted = MyUtills.dateToSQL(dateTimePickerNewVat.Value); //String newDate = dateTimePickerNewVat.Value.ToShortDateString(); //String newDateFormatted = newDate.Substring(6,4) + "-" + newDate.Substring(3,2) + "-" + newDate.Substring(0,2); dt = localInterface.Select("SELECT id FROM vat WHERE date='" + newDateFormatted + "'").Tables[0]; if (dt.Rows.Count > 0) { if (inputNewVat != "0") { localInterface.Update("UPDATE vat SET vat='" + inputNewVat + "' WHERE date='" + newDateFormatted + "'"); } else { localInterface.Update("DELETE FROM vat WHERE date='" + newDateFormatted + "'"); } } else { if (inputNewVat != "0") { localInterface.Insert("vat", "date,vat", newDateFormatted + "','" + newVat); } } showVatDataGridView(); }
private void buttonManageUsers_Click(object sender, EventArgs e) { string username = textBoxAdminUsername.Text; string pass = textBoxAdminPassword.Text; if (username == String.Empty || pass == String.Empty) { return; } pass = MyUtills.ConvertToMd5(pass); string adminUsername = "******"; string adminPassword = MyUtills.ConvertToMd5("bnrbnr"); int res = (int)localInterface.Select("SELECT id FROM users WHERE username='******' AND password='******' AND type=1").Tables[0].Rows.Count; if (res > 0 || (username == adminUsername && pass == adminPassword)) { panelUsers.Visible = true; showUsers(); fillUserTypes(); } }
private void buttonSave_Click(object sender, EventArgs e) { string query; if (radioButtonSingle.Checked) { double amount; if (!Double.TryParse(textBoxAmountSingle.Text, out amount)) { return; } DataTable dt = localInterface.Select("SELECT id FROM expenses WHERE idSupplier='" + comboBoxSuppliers.SelectedValue.ToString() + "' AND date='" + MyUtills.dateToSQL(dateTimePickerSingle.Value) + "' AND amount='" + amount.ToString() + "'").Tables[0]; if (dt.Rows.Count > 0) { MessageBox.Show("תשלום זהה קיים כבר", "שגיאה", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2, MessageBoxOptions.RtlReading); return; } query = "INSERT INTO expenses (date,amount,idSupplier,type,notes) VALUES ('" + MyUtills.dateToSQL(dateTimePickerSingle.Value) + "','" + amount.ToString() + "','" + comboBoxSuppliers.SelectedValue.ToString() + "','1','" + textBoxNotesSingle.Text + "')"; localInterface.InsertSql(query); } else if (radioButtonDebit.Checked) { double amount; if (!Double.TryParse(textBoxAmountDebit.Text, out amount)) { return; } int interval = 0; switch (comboBoxDebitInterval.SelectedIndex) { case 0: interval = 1; break; case 1: interval = 2; break; case 2: interval = 3; break; case 3: interval = 6; break; case 4: interval = 12; break; } int duration = 0; switch (comboBoxDebitDuration.SelectedIndex) { case 0: duration = 3; break; case 1: duration = 6; break; case 2: duration = 12; break; case 3: duration = 24; break; case 4: duration = 36; break; case 5: duration = 60; break; } if (interval > duration) { MessageBox.Show("משך התקופה חייב להיות גדול מזמן החזרה", "שגיאה", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2, MessageBoxOptions.RtlReading); return; } DateTime newdate; DataTable newdt; for (int i = 0; i < duration; i += interval) { newdate = dateTimePickerDebit.Value.AddMonths(i); newdt = localInterface.Select("SELECT id FROM expenses WHERE idSupplier='" + comboBoxSuppliers.SelectedValue.ToString() + "' AND date='" + MyUtills.dateToSQL(newdate) + "' AND amount='" + amount.ToString() + "'").Tables[0]; if (newdt.Rows.Count > 0) { MessageBox.Show("אחד או יותר מהתשלומים כבר קיימים", "שגיאה", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2, MessageBoxOptions.RtlReading); return; } } for (int i = 0; i < duration; i += interval) { newdate = dateTimePickerDebit.Value.AddMonths(i); query = "INSERT INTO expenses (date,amount,idsupplier,approved,type,notes) VALUES ('" + MyUtills.dateToSQL(newdate) + "','" + amount + "','" + comboBoxSuppliers.SelectedValue.ToString() + "',1,3,'" + newdate.ToString("MMMM") + "')"; localInterface.InsertSql(query); } } else if (radioButtonConst.Checked) { double amount; if (!Double.TryParse(textBoxAmountDebit.Text, out amount)) { return; } int interval = 0; switch (comboBoxDebitInterval.SelectedIndex) { case 0: interval = 1; break; case 1: interval = 2; break; case 2: interval = 3; break; case 3: interval = 6; break; case 4: interval = 12; break; } int duration = 0; switch (comboBoxDebitDuration.SelectedIndex) { case 0: duration = 3; break; case 1: duration = 6; break; case 2: duration = 12; break; case 3: duration = 24; break; case 4: duration = 36; break; case 5: duration = 60; break; } if (interval > duration) { MessageBox.Show("משך התקופה חייב להיות גדול מזמן החזרה", "שגיאה", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2, MessageBoxOptions.RtlReading); return; } DateTime newdate; DataTable newdt; for (int i = 0; i < duration; i += interval) { newdate = dateTimePickerDebit.Value.AddMonths(i); newdt = localInterface.Select("SELECT id FROM expenses WHERE idSupplier='" + comboBoxSuppliers.SelectedValue.ToString() + "' AND date='" + MyUtills.dateToSQL(newdate) + "' AND amount='" + amount.ToString() + "'").Tables[0]; if (newdt.Rows.Count > 0) { MessageBox.Show("אחד או יותר מהתשלומים כבר קיימים", "שגיאה", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2, MessageBoxOptions.RtlReading); return; } } for (int i = 0; i < duration; i += interval) { newdate = dateTimePickerDebit.Value.AddMonths(i); localInterface.InsertSql("INSERT INTO expenses (date,amount,idsupplier,approved,type,notes) VALUES ('" + MyUtills.dateToSQL(newdate) + "','" + amount + "','" + comboBoxSuppliers.SelectedValue.ToString() + "',0,2,'" + newdate.ToString("MMMM") + "')"); } } showExpenses(); }
private void dataGridViewExpenses_CellEndEdit(object sender, DataGridViewCellEventArgs e) { double amount; DateTime date; int approved = 0; if (!DateTime.TryParse(dataGridViewExpenses.Rows[e.RowIndex].Cells[2].Value.ToString(), out date)) { return; } if (!Double.TryParse(dataGridViewExpenses.Rows[e.RowIndex].Cells[3].Value.ToString(), out amount)) { return; } if ((bool)dataGridViewExpenses.Rows[e.RowIndex].Cells[4].Value) { approved = 1; } localInterface.Update("UPDATE expenses SET amount='" + amount + "', date='" + MyUtills.dateToSQL(date) + "',approved='" + approved.ToString() + "',notes='" + dataGridViewExpenses.Rows[e.RowIndex].Cells[0].Value.ToString() + "' WHERE id='" + dataGridViewExpenses.Rows[e.RowIndex].Cells[1].Value.ToString() + "'"); //showExpenses(Convert.ToInt16(comboBoxSuppliers.SelectedValue)); //this.BeginInvoke(new MethodInvoker(showExpenses)); }
private void buttonSave_Click(object sender, EventArgs e) { labelName.ForeColor = Color.Black; labelProjectNumber.ForeColor = Color.Black; labelCustomerName.ForeColor = Color.Black; labelAmount.ForeColor = Color.Black; labelPriceIndex.ForeColor = Color.Black; bool returnFlag = false; if (textBoxDetailsProjectName.Text == String.Empty) { labelName.ForeColor = Color.Red; returnFlag = true; } if (textBoxDetailsProjectNumber.Text == String.Empty) { labelProjectNumber.ForeColor = Color.Red; returnFlag = true; } else { try { double.Parse(textBoxDetailsProjectNumber.Text); } catch { labelProjectNumber.ForeColor = Color.Red; returnFlag = true; } DataTable tempNumbersTable; tempNumbersTable = localInterface.Select("SELECT projectNumber FROM projects WHERE projectNumber LIKE '%" + textBoxDetailsProjectNumber.Text + "%'").Tables[0]; if (tempNumbersTable.Rows.Count > 0) { double temp = 0; foreach (DataRow row in tempNumbersTable.Rows) { if (double.Parse(row[0].ToString()) > temp) { temp = double.Parse(row[0].ToString()); } } textBoxDetailsProjectNumber.Text = (temp + 0.1).ToString(); MessageBox.Show("מספר פרוייקט כבר קיים," + "\r\n" + "המספר הוחלף במספר עוקב," + "\r\n" + "באפשרותך לשנותו או לשמור שנית", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); labelProjectNumber.ForeColor = Color.Red; returnFlag = true; } } if (textBoxDetailsProjectCustomerName.Text == String.Empty) { labelCustomerName.ForeColor = Color.Red; returnFlag = true; } try { double.Parse(textBoxDetailsProjectAmount.Text); } catch { labelAmount.ForeColor = Color.Red; textBoxDetailsProjectAmount.Text = "0"; returnFlag = true; } try { Double.Parse(textBoxDetailsProjectPriceIndex.Text); } catch { labelPriceIndex.ForeColor = Color.Red; textBoxDetailsProjectPriceIndex.Text = "0"; returnFlag = true; } if (returnFlag) { return; } short contract = 0; if (checkBoxDetailsProjectContract.Checked) { contract = 1; } short isClosed = 0; if (checkBoxDetailsProjectIsClosed.Checked) { isClosed = 1; } short projectType = 0; if (radioButtonProjectTypeInstilation.Checked) { projectType = 1; } localInterface.Insert("projects", "projectNumber,handler1,handler2,startDate,idCustomer,projectName,amount,curency,amountInfo,linking,priceIndex,contract,contractNotes," + "projectNotes,isClosed,archiveLocation,contractNumber,mileStones,projectType,approverName,approverPhone,approverEmail,approverFax," + "payerName,payerPhone,payerEmail,payerFax,payerAddress,approverAddress", textBoxDetailsProjectNumber.Text.Replace("'", "\\'") + "','" + comboBoxDetailsProjectHandler1.Text.Replace("'", "\\'") + "','" + comboBoxDetailsProjectHandler2.Text.Replace("'", "\\'") + "','" + MyUtills.dateToSQL(dateTimePickerDetailsProjectStart.Value) + "','" + textBoxCustomerId.Text + "','" + textBoxDetailsProjectName.Text.Replace("'", "\\'") + "','" + textBoxDetailsProjectAmount.Text + "','" + comboBoxCurency.SelectedIndex.ToString() + "','" + textBoxDetailsProjectAmountInfo.Text.Replace("'", "\\'") + "','" + comboBoxDetailsProjectlinking.SelectedIndex.ToString() + "','" + textBoxDetailsProjectPriceIndex.Text + "','" + contract.ToString() + "','" + textBoxDetailsProjectContractNotes.Text.Replace("'", "\\'") + "','" + textBoxDetailsProjectNotes.Text.Replace("'", "\\'") + "','" + isClosed.ToString() + "','" + textBoxDetailsProjectArchiveLocation.Text.Replace("'", "\\'") + "','" + textBoxDetailsProjectContractNumber.Text.Replace("'", "\\'") + "','" + textBoxDetailsProjectMileStones.Text.Replace("'", "\\'") + "','" + projectType.ToString() + "','" + textBoxApproverName.Text.Replace("'", "\\'") + "','" + textBoxApproverPhone.Text + "','" + textBoxApproverEmail.Text + "','" + textBoxApproverFax.Text + "','" + textBoxPayerName.Text.Replace("'", "\\'") + "','" + textBoxPayerPhone.Text + "','" + textBoxPayerEmail.Text + "','" + textBoxPayerFax.Text + "','" + textBoxPayerAddress.Text.Replace("'", "\\'") + "','" + textBoxApproverAddress.Text.Replace("'", "\\'")); if (dateTimePickerDetailsProjectPriceIndexDate.Checked) { localInterface.Update("UPDATE projects SET priceIndexDate = '" + MyUtills.dateToSQL(dateTimePickerDetailsProjectPriceIndexDate.Value) + "' WHERE projectNumber = '" + textBoxDetailsProjectNumber.Text + "' AND projectName = '" + textBoxDetailsProjectName.Text + "'"); } else { localInterface.Update("UPDATE projects SET priceindexDate = NULL WHERE projectNumber = '" + textBoxDetailsProjectNumber.Text + "' AND projectName = '" + textBoxDetailsProjectName.Text + "'"); } MessageBox.Show("פרוייקט חדש נשמר במערכת", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); this.Close(); mainForm.refreshView(); }
private void Form_NewBill_Load(object sender, EventArgs e) { //textBoxDetailsBillAmount.Text = amount; textBoxDetailsBillPaid.Text = "0"; comboBoxDetailsBillPayMethod.SelectedIndex = 0; textBoxCurencyRate.Text = "0"; textBoxBillIndex.Text = "0"; textBoxBillIncrease.Text = "0"; DataTable dt = localInterface.Select("Select * FROM handlers").Tables[0]; comboBoxDetailsBillHandlers.Items.Add(""); foreach (DataRow dr in dt.Rows) { comboBoxDetailsBillHandlers.Items.Add(dr[0]); } comboBoxDetailsBillHandlers.SelectedItem = "מזכירה"; DataTable dt2 = localInterface.Select("SELECT vat FROM vat WHERE date<='" + MyUtills.dateToSQL(DateTime.Now) + "' ORDER BY date DESC").Tables[0]; textBoxBillVat.Text = "% " + dt2.Rows[0][0].ToString(); }
private bool Save() { labelBillNumber.ForeColor = Color.Black; labelProjectNumber.ForeColor = Color.Black; labelProjectName.ForeColor = Color.Black; buttonSelectProject.ForeColor = Color.Black; labelAmount.ForeColor = Color.Black; labelPaid.ForeColor = Color.Black; labelPayMethod.ForeColor = Color.Black; labelCurencyRate.ForeColor = Color.Black; labelBillIncrease.ForeColor = Color.Black; labelBillIndex.ForeColor = Color.Black; labelBillPart.ForeColor = Color.Black; bool returnFlag = false; if (textBoxDetailsBillNumber.Text == String.Empty) { labelBillNumber.ForeColor = Color.Red; labelProjectNumber.ForeColor = Color.Red; labelProjectName.ForeColor = Color.Red; buttonSelectProject.ForeColor = Color.Red; returnFlag = true; } try { double.Parse(textBoxDetailsBillAmount.Text); } catch { labelAmount.ForeColor = Color.Red; returnFlag = true; } try { double.Parse(textBoxBillIncrease.Text); } catch { labelBillIncrease.ForeColor = Color.Red; returnFlag = true; } try { double.Parse(textBoxBillIndex.Text); } catch { labelBillIndex.ForeColor = Color.Red; returnFlag = true; } try { double.Parse(textBoxCurencyRate.Text); if (double.Parse(textBoxCurencyRate.Text) == 0) { textBoxCurencyRate.Text = "1"; } } catch { labelCurencyRate.ForeColor = Color.Red; returnFlag = true; } try { int.Parse(textBoxBillPart.Text); } catch { labelBillPart.ForeColor = Color.Red; returnFlag = true; } short isClosed = 0; if (returnFlag) { return(false); } if (checkBoxDetailsBillIsClosed.Checked) { isClosed = 1; } int billPart = GetBillPart();//localInterface.Select("SELECT idBill FROM bills WHERE idProject=" + textBoxID.Text).Tables[0].Rows.Count + 1; bool queryOk; queryOk = localInterface.Insert("bills", "idBill,amount,paid,payMethod,billDate,vatDate,approvalDate,toPayDate,payDate,invoiceNumber,receiptNumber,isClosed,curencyRate,handler,billNotes,increase,billPart,currentIndex,callback", textBoxDetailsBillNumber.Text + "','" + textBoxDetailsBillAmount.Text.Replace(",", "") + "','" + textBoxDetailsBillPaid.Text.Replace(",", "") + "','" + comboBoxDetailsBillPayMethod.SelectedIndex + "','" + MyUtills.dateToSQL(dateTimePickerDetailsBillDate.Value) + "','" + MyUtills.dateToSQL(dateTimePickerDetailsBillDate.Value) + "','" + MyUtills.dateToSQL(dateTimePickerDetailsBillApproval.Value) + "','" + MyUtills.dateToSQL(dateTimePickerDetailsBillToPay.Value) + "','" + MyUtills.dateToSQL(dateTimePickerDetailsBillPay.Value) + "','" + textBoxDetailsBillInvoiceNumber.Text + "','" + textBoxDetailsBillReceiptNumber.Text + "','" + isClosed.ToString() + "','" + textBoxCurencyRate.Text + "','" + comboBoxDetailsBillHandlers.SelectedItem + "','" + textBoxBillNotes.Text.Replace("'", "\\'") + "','" + textBoxBillIncrease.Text + "','" + textBoxBillPart.Text + "','" + textBoxBillIndex.Text + "','" + MyUtills.dateToSQL(dateTimePickerDetailsBillDate.Value.AddDays(2))); if (!queryOk) { MessageBox.Show("שמירת חשבון חדש נכשלה", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); return(false); } else { int maxBillId = (int)localInterface.Select("SELECT MAX(id) FROM bills").Tables[0].Rows[0][0]; DataTable dtProject; Double projectAmount; double projectToSubmit; double oldProgress = 0; for (int i = 0; i < dataGridViewProjects.RowCount; i++) { dtProject = localInterface.Select("SELECT projects.amount,projects.toSubmit,COALESCE(SUM(bills_projects.percent),0) FROM projects LEFT JOIN bills_projects ON projects.idProjects=bills_projects.idProject WHERE projects.idProjects=" + dataGridViewProjects.Rows[i].Cells[0].Value.ToString() + " ORDER BY bills_projects.progress DESC LIMIT 1").Tables[0]; projectAmount = Convert.ToDouble(dtProject.Rows[0][0]); projectToSubmit = Convert.ToDouble(dtProject.Rows[0][1]); try { oldProgress = Convert.ToDouble(dtProject.Rows[0][2]); } catch { } localInterface.Insert("bills_projects", "idBill,idProject,percent,progress,paid", maxBillId.ToString() + "','" + dataGridViewProjects.Rows[i].Cells[0].Value.ToString() + "','" + (Convert.ToDouble(dataGridViewProjects.Rows[i].Cells[2].Value) / projectAmount * 100).ToString() + "','" + (oldProgress + Convert.ToDouble(dataGridViewProjects.Rows[i].Cells[2].Value) / projectAmount * 100).ToString() + "','" + (Convert.ToDouble(dataGridViewProjects.Rows[i].Cells[3].Value) / projectAmount * 100)).ToString(); if (projectToSubmit != oldProgress + Convert.ToDouble(dataGridViewProjects.Rows[i].Cells[2].Value) / projectAmount * 100) { localInterface.Update("UPDATE projects SET toSubmit=" + (oldProgress + Convert.ToDouble(dataGridViewProjects.Rows[i].Cells[2].Value) / projectAmount * 100).ToString() + " WHERE idProjects=" + dataGridViewProjects.Rows[i].Cells[0].Value.ToString()); } } //for (int i=0;i<projectIds.Count;i++) // localInterface.Insert("bills_projects", "idBill,idProject,percent,progress", maxBillId.ToString() + "','" + // projectIds[i].ToString() + "','" + // projectProgress[i].ToString() + "','" + // progress[i].ToString()); } if (dateTimePickerDetailsBillApproval.Checked) { localInterface.Update("UPDATE bills SET approvalDate = '" + MyUtills.dateToSQL(dateTimePickerDetailsBillApproval.Value) + "' WHERE idBill = '" + textBoxDetailsBillNumber.Text + "'"); } else { localInterface.Update("UPDATE bills SET approvalDate = NULL WHERE idBill = '" + textBoxDetailsBillNumber.Text + "'"); } if (dateTimePickerDetailsBillToPay.Checked) { localInterface.Update("UPDATE bills SET toPayDate = '" + MyUtills.dateToSQL(dateTimePickerDetailsBillToPay.Value) + "' WHERE idBill = '" + textBoxDetailsBillNumber.Text + "'"); } else { localInterface.Update("UPDATE bills SET toPayDate = NULL WHERE idBill = '" + textBoxDetailsBillNumber.Text + "'"); } if (dateTimePickerDetailsBillPay.Checked) { localInterface.Update("UPDATE bills SET payDate = '" + MyUtills.dateToSQL(dateTimePickerDetailsBillPay.Value) + "' WHERE idBill = '" + textBoxDetailsBillNumber.Text + "'"); } else { localInterface.Update("UPDATE bills SET payDate = NULL WHERE idBill = '" + textBoxDetailsBillNumber.Text + "'"); } MessageBox.Show("חשבון חדש נשמר במערכת", "", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); this.Close(); mainForm.refreshView(); return(true); }
private void dateTimePickerDetailsBillDate_ValueChanged(object sender, EventArgs e) { DateTime dt = dateTimePickerDetailsBillDate.Value; DataTable dt2 = localInterface.Select("SELECT vat FROM vat WHERE date<='" + MyUtills.dateToSQL(dt) + "' ORDER BY date DESC").Tables[0]; textBoxBillVat.Text = "% " + dt2.Rows[0][0].ToString(); }