private void getMainInformation() { var dt1 = new DataTable(); var dt2 = new DataTable(); var UsedClass = new BasicClass(); dt1 = UsedClass.selectdata("Casher_select_all_IDs", null); dt2 = UsedClass.selectdata("Casher_SelectUnUsedInvoices", null); textBoxPercentageTransfer.Text = dt1.Rows[0]["PercentageTransfer"].ToString(); if (dt2.Rows.Count > 0) { textBoxInvoiceNo.Text = dt2.Rows[0]["InvoiceNo"].ToString(); deletePrviousInvoices(); UnUsedId = true; } else { textBoxInvoiceNo.Text = dt1.Rows[0]["InvoiceNo"].ToString(); UsedClass.ExecuteCommand("Casher_IncreaseInvoiceNumber", null); //increase Invoice Number SaveInvoices("UNUSED", "UNUSED"); UnUsedId = true; } //else //{ //} }
private void buttonModifyUsers_Click(object sender, EventArgs e) { var dt = new DataTable(); var UsedClass = new BasicClass(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@ID", SqlDbType.Int); param[1] = new SqlParameter("@FullName", SqlDbType.NVarChar, 150); param[2] = new SqlParameter("@UserName", SqlDbType.NVarChar, 150); param[3] = new SqlParameter("@ReportPermision", SqlDbType.Bit); param[4] = new SqlParameter("@StorePermision", SqlDbType.Bit); param[5] = new SqlParameter("@CasherPermision", SqlDbType.Bit); param[6] = new SqlParameter("@SuperUser", SqlDbType.Bit); if (dataGridViewUsers.CurrentRow.Index >= 0 && changesInUserFlag == true) { for (int i = 0; i < dataGridViewUsers.Rows.Count; i++) { param[0].Value = Int32.Parse(dataGridViewUsers.Rows[i].Cells["ColumnUserID"].Value.ToString()); param[1].Value = dataGridViewUsers.Rows[i].Cells["ColumnUserFullName"].Value.ToString(); param[2].Value = dataGridViewUsers.Rows[i].Cells["ColumnUserName"].Value.ToString(); param[3].Value = Convert.ToBoolean(dataGridViewUsers.Rows[i].Cells["ColumnReportPermsion"].Value.ToString()); param[4].Value = Convert.ToBoolean(dataGridViewUsers.Rows[i].Cells["ColumnStorePermsion"].Value.ToString()); param[5].Value = Convert.ToBoolean(dataGridViewUsers.Rows[i].Cells["ColumnCasherPermsion"].Value.ToString()); param[6].Value = Convert.ToBoolean(dataGridViewUsers.Rows[i].Cells["ColumnSuper"].Value.ToString()); UsedClass.ExecuteCommand("Casher_UpdateUsers", param); } MessageBox.Show("DONE", "MESSAGE"); Application.Exit(); } else { //nothing } }
private void buttonPreventUser_Click(object sender, EventArgs e) { var dt = new DataTable(); var UsedClass = new BasicClass(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@ID", SqlDbType.Int); param[1] = new SqlParameter("@FullName", SqlDbType.NVarChar, 150); param[2] = new SqlParameter("@UserName", SqlDbType.NVarChar, 150); param[3] = new SqlParameter("@ReportPermision", SqlDbType.Bit); param[4] = new SqlParameter("@StorePermision", SqlDbType.Bit); param[5] = new SqlParameter("@CasherPermision", SqlDbType.Bit); param[6] = new SqlParameter("@SuperUser", SqlDbType.Bit); if (dataGridViewUsers.CurrentRow.Index >= 0) { param[0].Value = Int32.Parse(dataGridViewUsers.Rows[dataGridViewUsers.CurrentRow.Index].Cells["ColumnUserID"].Value.ToString()); param[1].Value = dataGridViewUsers.Rows[dataGridViewUsers.CurrentRow.Index].Cells["ColumnUserFullName"].Value.ToString(); param[2].Value = dataGridViewUsers.Rows[dataGridViewUsers.CurrentRow.Index].Cells["ColumnUserName"].Value.ToString(); param[3].Value = 0; param[4].Value = 0; param[5].Value = 0; param[6].Value = 0; UsedClass.ExecuteCommand("Casher_UpdateUsers", param); MessageBox.Show("تم حضر هذا المستخدم سوف يتم الخروج من البرنامج", "MESSAGE"); Application.Exit(); } }
private void buttondeleteCatSave_Click(object sender, EventArgs e) { var UsedClass = new BasicClass(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@CategoryID", SqlDbType.Int); if (comboBoxdeletechooseCat.Text == "") { MessageBox.Show("خطأ في ادخال المعلومات", "Message"); } else { param[0].Value = int.Parse((comboBoxdeletechooseCat.SelectedValue.ToString())); DialogResult Result = MessageBox.Show("عملية الحذف سوف تؤدي الى حذف العناصر التي تنتمي لهذا الصنف", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Hand); if (Result == DialogResult.Yes) { UsedClass.ExecuteCommand("Casher_deleteCategory", param); MessageBox.Show("DONE", "MESSAGE"); comboBoxdeletechooseCat_DropDown(sender, e); } else { } } }
private void buttonedititem_Click(object sender, EventArgs e) { var UsedClass = new BasicClass(); var dt = new DataTable(); SqlParameter[] param = new SqlParameter[7]; if (changesInItemFlag) { param[0] = new SqlParameter("@itemID", SqlDbType.Int); param[1] = new SqlParameter("@itemName", SqlDbType.NVarChar, 100); param[2] = new SqlParameter("@itemCategory", SqlDbType.NVarChar, 100); param[3] = new SqlParameter("@Barcode", SqlDbType.NVarChar, 100); param[4] = new SqlParameter("@ExpireDate", SqlDbType.NVarChar, 100); param[5] = new SqlParameter("@CriticalRange", SqlDbType.Int); param[6] = new SqlParameter("@PCS", SqlDbType.Int); for (int i = 0; i < dataGridVieweditItem.Rows.Count; i++) { param[0].Value = int.Parse(dataGridVieweditItem.Rows[i].Cells["ColumnItemID"].Value.ToString()); param[1].Value = dataGridVieweditItem.Rows[i].Cells["ColumnItemName"].Value.ToString(); param[2].Value = dataGridVieweditItem.Rows[i].Cells["ColumnItemCategory"].Value.ToString(); param[3].Value = dataGridVieweditItem.Rows[i].Cells["ColumnBarcode"].Value.ToString(); param[4].Value = dataGridVieweditItem.Rows[i].Cells["ColumnExpireDate"].Value.ToString(); param[5].Value = int.Parse(dataGridVieweditItem.Rows[i].Cells["ColumnCriticalRange"].Value.ToString()); param[6].Value = int.Parse(dataGridVieweditItem.Rows[i].Cells["ColumnpcsCarton"].Value.ToString()); UsedClass.ExecuteCommand("Casher_settingUpdateItem", param); } changesInItemFlag = false; MessageBox.Show("DONE", "MESSAGE"); textBoxEditItemSearch_TextChanged(sender, e); } else { } //if ( changesInItems.Rows.Count > 0 && changesInItemFlag == true ) //{ // param[0] = new SqlParameter ( "@itemID" , SqlDbType.Int ); // param[1] = new SqlParameter ( "@itemName" , SqlDbType.NVarChar , 100 ); // param[2] = new SqlParameter ( "@itemCategory" , SqlDbType.NVarChar , 100 ); // param[3] = new SqlParameter ( "@Barcode" , SqlDbType.NVarChar , 100 ); // param[4] = new SqlParameter ( "@ExpireDate" , SqlDbType.NVarChar , 100 ); // param[5] = new SqlParameter ( "@CriticalRange" , SqlDbType.Int ); // param[6] = new SqlParameter ( "@PCS" , SqlDbType.Int ); // for ( int i = 0 ; i < changesInItems.Rows.Count ; i++ ) // { // param[0].Value = changesInItems.Rows[i]["ItemID"].ToString (); // param[1].Value = changesInItems.Rows[i]["ItemName"].ToString (); // param[2].Value = changesInItems.Rows[i]["itemCategory"].ToString (); // param[3].Value = changesInItems.Rows[i]["ItemBarCode"].ToString (); // param[4].Value = changesInItems.Rows[i]["ItemExpire"].ToString (); // param[5].Value = int.Parse ( changesInItems.Rows[i]["Critical_Quantity"].ToString () ); // param[6].Value = int.Parse ( changesInItems.Rows[i]["Pcs_InsideCarton"].ToString () ); // UsedClass.ExecuteCommand ( "Casher_settingUpdateItem" , param ); // } // changesInItemFlag = false; // MessageBox.Show ( "DONE" , "MESSAGE" ); // textBoxEditItemSearch_TextChanged ( sender , e ); //} }
private void deletePrviousInvoices() { var UsedClass = new BasicClass(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@InvoiceNo", SqlDbType.Int); param[0].Value = int.Parse(textBoxInvoiceNo.Text); UsedClass.ExecuteCommand("CasherForm_deletePreviousInvoice", param); }
private void buttonnewUserSave_Click(object sender, EventArgs e) { var UsedClass = new BasicClass(); SqlParameter[] param = new SqlParameter[8]; param[0] = new SqlParameter("@UserFullName", SqlDbType.NVarChar, 150); param[1] = new SqlParameter("@UserName", SqlDbType.NVarChar, 150); param[2] = new SqlParameter("@UserPassword", SqlDbType.NVarChar, 150); param[3] = new SqlParameter("@SuperUserPermission", SqlDbType.Bit); param[4] = new SqlParameter("@CasherPermsion", SqlDbType.Bit); param[5] = new SqlParameter("@ReportPermision", SqlDbType.Bit); param[6] = new SqlParameter("@PurshacePermision", SqlDbType.Bit); param[7] = new SqlParameter("@AddbyUser", SqlDbType.NVarChar, 150); if (textBoxnewUserFullName.Text == "" || textBoxnewUserUserName.Text == "" || textBoxnewUserPassword.Text == "") { MessageBox.Show("خطأ في ادخال المعلومات", "Message"); } else { if (!checkBoxSuperUser.Checked && !checkBoxCasherPermision.Checked && !checkBoxPurshacePermision.Checked && !checkBoxReportPermision.Checked) { MessageBox.Show("يجب ادخال صلاحية واحدة على الاقل او الغاء العملية", "Message"); } else { try { param[0].Value = textBoxnewUserFullName.Text.Trim(); param[1].Value = textBoxnewUserUserName.Text.Trim(); param[2].Value = textBoxnewUserPassword.Text.Trim(); param[3].Value = checkBoxSuperUser.Checked; param[4].Value = checkBoxCasherPermision.Checked; param[5].Value = checkBoxReportPermision.Checked; param[6].Value = checkBoxPurshacePermision.Checked; param[7].Value = BasicClass.UserName; UsedClass.ExecuteCommand("Casher_InsertNewUser", param); MessageBox.Show("DONE", "MESSAGE"); ClearRecords(); } catch (Exception) { MessageBox.Show("المعلومات المدخلة موجودة مسبقا", "MESSAGE"); } } } }
private void buttondeleteItem_Click(object sender, EventArgs e) { var UsedClass = new BasicClass(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ItemID", SqlDbType.Int); if (dataGridVieweditItem.CurrentRow.Index >= 0) { if (dataGridVieweditItem.Rows[dataGridVieweditItem.CurrentRow.Index].Cells["ColumnItemID"].Value.ToString() != "") { param[0].Value = int.Parse(dataGridVieweditItem.Rows[dataGridVieweditItem.CurrentRow.Index].Cells["ColumnItemID"].Value.ToString()); UsedClass.ExecuteCommand("Casher_deleteItem", param); MessageBox.Show("DONE", "MESSAGE"); textBoxEditItemSearch_TextChanged(sender, e); } } }
private void buttonnewItemSave_Click(object sender, EventArgs e) { if (textBoxnewItemEnterName.Text == "" || comboBoxnewItemCategory.Text == "") { MessageBox.Show("يرجى التأكد من ادخال المعلومات بشكل كامل", "خــــطأ", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { var dt = new DataTable(); var UsedClass = new BasicClass(); SqlParameter[] param = new SqlParameter[8]; param[0] = new SqlParameter("@ItemID", SqlDbType.Int); param[1] = new SqlParameter("@itemName", SqlDbType.NVarChar, 150); param[2] = new SqlParameter("@itemCategory", SqlDbType.NVarChar, 150); param[3] = new SqlParameter("@PcsInsideCarton", SqlDbType.Int); param[4] = new SqlParameter("@CriticalQuantity", SqlDbType.Int); param[5] = new SqlParameter("@ItemBarcode", SqlDbType.NVarChar, 150); param[6] = new SqlParameter("@EnteredUser", SqlDbType.NVarChar, 150); param[7] = new SqlParameter("@ItemExpire", SqlDbType.NVarChar, 150); param[0].Value = getInformation("ItemID"); param[1].Value = textBoxnewItemEnterName.Text.Trim(); param[2].Value = comboBoxnewItemCategory.Text.Trim(); param[3].Value = int.Parse(textBoxnewItemEnterPCS.Text.Trim()); param[4].Value = int.Parse(textBoxnewItemEnterCriticalRange.Text.Trim()); param[5].Value = textBoxnewItemEnterBarcode.Text.Trim(); param[6].Value = BasicClass.UserName; if (checkBoxnewItemExpire.Checked) { param[7].Value = dateTimePickernewItemExpire.Text.Trim(); } else { param[7].Value = "لايوجد"; } UsedClass.ExecuteCommand("Casher_create_new_items", param); MessageBox.Show("DONE", "Message"); ClearRecords(); } }
private void buttonnewCatSave_Click(object sender, EventArgs e) { var UsedClass = new BasicClass(); SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@CategoryID", SqlDbType.Int); param[1] = new SqlParameter("@categoryName", SqlDbType.NVarChar, 50); param[2] = new SqlParameter("@EnteredUser", SqlDbType.NVarChar, 50); if (textBoxnewCatEnterCatName.Text == "") { MessageBox.Show("خطأ في ادخال المعلومات", "Message"); } else { param[0].Value = getInformation("CatID"); param[1].Value = textBoxnewCatEnterCatName.Text.Trim(); param[2].Value = BasicClass.UserName; UsedClass.ExecuteCommand("Casher_create_new_category", param); MessageBox.Show("DONE", "MESSAGE"); textBoxnewCatEnterCatName.Text = ""; } }
private void buttoneditCatSave_Click(object sender, EventArgs e) { var dt = new DataTable(); var UsedClass = new BasicClass(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@CategoryID", SqlDbType.Int); param[1] = new SqlParameter("@CategoryName", SqlDbType.NVarChar, 100); if (textBoxeditCatEnter.Text == "") { MessageBox.Show("خطأ في ادخال المعلومات", "Message"); } else { param[0].Value = int.Parse(comboBoxeditChooseCat.SelectedValue.ToString()); param[1].Value = textBoxeditCatEnter.Text.Trim(); UsedClass.ExecuteCommand("Casher_Re_nameCategory", param); MessageBox.Show("DONE", "MESSAGE"); textBoxeditCatEnter.Text = ""; dt.Rows.Clear(); comboBoxeditChooseCat.DataSource = dt; } }
private void SaveInvoices(string RUNORSAVE, string PayOrNot) { var UsedClass = new BasicClass(); SqlParameter[] param = new SqlParameter[6]; for (int i = 0; i < dataGridViewItems.Rows.Count; i++) { //all data will be inserted into Table_orders param[0] = new SqlParameter("@invoiceNo", SqlDbType.Int); param[0].Value = Int32.Parse(textBoxInvoiceNo.Text); // param[1] = new SqlParameter("@itemName", SqlDbType.NVarChar, 50); param[1].Value = dataGridViewItems.Rows[i].Cells["ColumnItemName"].Value; // param[2] = new SqlParameter("@Quantity", SqlDbType.Int); param[2].Value = int.Parse(dataGridViewItems.Rows[i].Cells["ColumnItemQuantity"].Value.ToString()) * -1; // param[3] = new SqlParameter("@price", SqlDbType.Float); param[3].Value = float.Parse(dataGridViewItems.Rows[i].Cells["ColumnItemPrice"].Value.ToString()); // param[4] = new SqlParameter("@totalPrice", SqlDbType.Float); param[4].Value = float.Parse(dataGridViewItems.Rows[i].Cells["ColumnTotal"].Value.ToString()); // param[5] = new SqlParameter("@CustomerName", SqlDbType.NVarChar, 250); param[5].Value = textBoxCustomerName.Text; // UsedClass.ExecuteCommand("insert_order", param); //all data will be inserted into Table_orders } SqlParameter[] param2 = new SqlParameter[12]; //below data will be inserted into two tables INVOICES_INFORMATION and INVOICES_MONEY //try //{ param2[0] = new SqlParameter("@InvoiceNo", SqlDbType.Int); param2[1] = new SqlParameter("@CustomerName", SqlDbType.NVarChar, 150); param2[2] = new SqlParameter("@InvoiceType", SqlDbType.NVarChar, 100); param2[3] = new SqlParameter("@InvoiceDate", SqlDbType.Date); param2[4] = new SqlParameter("@InvoicePaymentStatus", SqlDbType.NVarChar, 100); param2[5] = new SqlParameter("@InvoiceRunORnot", SqlDbType.NVarChar, 100); param2[6] = new SqlParameter("@IQAmountPaid", SqlDbType.Float); param2[7] = new SqlParameter("@USAmountPaid", SqlDbType.Float); param2[8] = new SqlParameter("@ConversionRate", SqlDbType.Float); param2[9] = new SqlParameter("@InvoiceDiscount", SqlDbType.Float); param2[10] = new SqlParameter("@Reminder", SqlDbType.Float); param2[11] = new SqlParameter("@EnteredUser", SqlDbType.NVarChar, 150); param2[0].Value = int.Parse(textBoxInvoiceNo.Text); param2[1].Value = textBoxCustomerName.Text; param2[2].Value = "بيع"; param2[3].Value = dateTimePickerInvoiceDate.Text; param2[4].Value = PayOrNot; param2[5].Value = RUNORSAVE; var currencyformat = CultureInfo.GetCultureInfo("AR-iq"); param2[6].Value = IQPaidAmount(); param2[7].Value = textBoxDollarSaveAmount.Text; param2[8].Value = textBoxPercentageTransfer.Text; var FinalAmount = 0.0; if (textBoxDiscountPercentage.Text != "" && textBoxDiscountPercentage.Text != "0") { currencyformat = CultureInfo.GetCultureInfo("AR-iq"); var TotalAmount = Convert.ToDouble(textBoxTotalInvoice.Text.Replace(currencyformat.NumberFormat.CurrencySymbol, "")); var PercentageDisount = 0.0; PercentageDisount = int.Parse(textBoxDiscountPercentage.Text); PercentageDisount = PercentageDisount * 1 / 100; PercentageDisount = PercentageDisount * TotalAmount; FinalAmount = PercentageDisount; } else if (textBoxDiscountAmount.Text != "" && textBoxDiscountAmount.Text != "0") { currencyformat = CultureInfo.GetCultureInfo("AR-iq"); var TotalAmount = Convert.ToDouble(textBoxTotalInvoice.Text.Replace(currencyformat.NumberFormat.CurrencySymbol, "")); var DiscountAmount = int.Parse(textBoxDiscountAmount.Text); FinalAmount = DiscountAmount; } param2[9].Value = FinalAmount; var Reminder = 0.0; if (textBoxReminderMoney.Text != "" || textBoxReminderMoney.Text != "0") { if (textBoxReminderMoney.Text.Contains("-")) { currencyformat = CultureInfo.GetCultureInfo("AR-iq"); Reminder = Convert.ToDouble(textBoxReminderMoney.Text.Replace(currencyformat.NumberFormat.CurrencySymbol, "").Replace("-", "")); Reminder *= -1; } else { currencyformat = CultureInfo.GetCultureInfo("AR-iq"); Reminder = Convert.ToDouble(textBoxReminderMoney.Text.Replace(currencyformat.NumberFormat.CurrencySymbol, "").Replace("-", "")); } } param2[10].Value = Reminder; param2[11].Value = textBoxUserName.Text; UsedClass.ExecuteCommand("Casher_InsertNewInvoice", param2); //} //catch ( Exception e ) //{ // MessageBox.Show ( e.Message ); //} }
private void SaveInvoices(string RUNORSAVE, string PayOrNot) { var UsedClass = new BasicClass(); if (dataGridViewItems.Rows.Count > 0) { SqlParameter[] param = new SqlParameter[6]; SqlParameter[] param2 = new SqlParameter[12]; for (int i = 0; i < dataGridViewItems.Rows.Count; i++) { //all data will be inserted into Table_orders param[0] = new SqlParameter("@invoiceNo", SqlDbType.Int); param[0].Value = Int32.Parse(textBoxInvoiceNo.Text); // param[1] = new SqlParameter("@itemName", SqlDbType.NVarChar, 50); param[1].Value = dataGridViewItems.Rows[i].Cells["ColumnItemName"].Value; // param[2] = new SqlParameter("@Quantity", SqlDbType.Int); param[2].Value = int.Parse(dataGridViewItems.Rows[i].Cells["ColumnItemQuantity"].Value.ToString()) * -1; // param[3] = new SqlParameter("@price", SqlDbType.Float); param[3].Value = float.Parse(dataGridViewItems.Rows[i].Cells["ColumnItemPrice"].Value.ToString()); // param[4] = new SqlParameter("@totalPrice", SqlDbType.Float); param[4].Value = float.Parse(dataGridViewItems.Rows[i].Cells["ColumnTotal"].Value.ToString()); // param[5] = new SqlParameter("@CustomerName", SqlDbType.NVarChar, 250); param[5].Value = textBoxCustomerName.Text; // UsedClass.ExecuteCommand("insert_order", param); //all data will be inserted into Table_orders } param2[0] = new SqlParameter("@InvoiceNo", SqlDbType.Int); param2[1] = new SqlParameter("@CustomerName", SqlDbType.NVarChar, 150); param2[2] = new SqlParameter("@InvoiceType", SqlDbType.NVarChar, 100); param2[3] = new SqlParameter("@InvoiceDate", SqlDbType.Date); param2[4] = new SqlParameter("@InvoicePaymentStatus", SqlDbType.NVarChar, 100); param2[5] = new SqlParameter("@InvoiceRunORnot", SqlDbType.NVarChar, 100); param2[6] = new SqlParameter("@IQAmountPaid", SqlDbType.Float); param2[7] = new SqlParameter("@USAmountPaid", SqlDbType.Float); param2[8] = new SqlParameter("@ConversionRate", SqlDbType.Float); param2[9] = new SqlParameter("@InvoiceDiscount", SqlDbType.Float); param2[10] = new SqlParameter("@Reminder", SqlDbType.Float); param2[11] = new SqlParameter("@EnteredUser", SqlDbType.NVarChar, 150); param2[0].Value = int.Parse(textBoxInvoiceNo.Text); param2[1].Value = textBoxCustomerName.Text; param2[2].Value = "بيع"; param2[3].Value = dateTimePickerInvoiceDate.Text; param2[4].Value = PayOrNot; param2[5].Value = RUNORSAVE; param2[6].Value = IQPaidAmount(); param2[7].Value = textBoxDollarSaveAmount.Text; param2[8].Value = textBoxPercentageTransfer.Text; var finalDiscountAmount = 0.0; if (textBoxDiscountPercentage.Text != "" && textBoxDiscountPercentage.Text != "0") { var TotalAmount = Convert.ToDouble(textBoxTotalInvoice.Text.Trim()); var PercentageDisount = 0.0; PercentageDisount = double.Parse(textBoxDiscountPercentage.Text); PercentageDisount = PercentageDisount * 1 / 100; PercentageDisount = PercentageDisount * TotalAmount; finalDiscountAmount = PercentageDisount; } else if (textBoxDiscountAmount.Text != "" && textBoxDiscountAmount.Text != "0") { var TotalAmount = Convert.ToDouble(textBoxTotalInvoice.Text.Trim()); var DiscountAmount = double.Parse(textBoxDiscountAmount.Text); finalDiscountAmount = DiscountAmount; } param2[9].Value = finalDiscountAmount; var Reminder = 0.0; if (textBoxReminderMoney.Text != "" || textBoxReminderMoney.Text != "0") { if (textBoxReminderMoney.Text.Contains("-")) { Reminder = Convert.ToDouble(textBoxReminderMoney.Text.Trim()); Reminder *= -1; } else { Reminder = Convert.ToDouble(textBoxReminderMoney.Text.Trim()); } } param2[10].Value = Reminder; param2[11].Value = BasicClass.UserName; UsedClass.ExecuteCommand("Casher_InsertNewInvoice", param2); } else { SqlParameter[] param = new SqlParameter[5]; param[0] = new SqlParameter("@InvoiceNum", SqlDbType.Int); param[1] = new SqlParameter("@CustomerName", SqlDbType.NVarChar, 100); param[2] = new SqlParameter("@PaymentSatus", SqlDbType.NVarChar, 100); param[3] = new SqlParameter("@RunORNot", SqlDbType.NVarChar, 100); param[4] = new SqlParameter("@User", SqlDbType.NVarChar, 150); param[0].Value = int.Parse(textBoxInvoiceNo.Text); if (textBoxCustomerName.Text == "") { textBoxCustomerName.Text = "زبون خارجي"; textBoxCustomerName.Enabled = false; } param[1].Value = textBoxCustomerName.Text; param[2].Value = PayOrNot; param[3].Value = RUNORSAVE; param[4].Value = BasicClass.UserName; UsedClass.ExecuteCommand("Casher_insertUnUsedInvoice", param); } if (BasicClass.flagModified) { this.Close(); } }