private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { if (textBoxEdit.Text == "") { MessageBox.Show("יש להזין שם לספק", "שגיאה", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2, MessageBoxOptions.RtlReading); return; } localInterface.Update("UPDATE suppliers SET name='" + textBoxEdit.Text.Replace("'", "\\'") + "' WHERE id='" + dataGridViewSuppliers.SelectedRows[0].Cells[0].Value.ToString() + "'"); showSuppliers(""); }
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 buttonSave_Click(object sender, EventArgs e) { string input = textBoxMain.Text.Replace(@"\", @"\\").Replace("'", @"\'").Replace('"', '\"'); string query = "UPDATE notes SET text ='" + input + "' WHERE idNotes='" + id + "'"; interf.Update(query); this.Close(); mainForm.refreshView(); }
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 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 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 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 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); }