private void buttondeleteTransaction_Click(object sender, EventArgs e) { if (dataGridViewMoney.CurrentCell.RowIndex >= 0) { var UsedClass = new BasicClass(); if (Check_if_cell_Empty()) { DialogResult deleteMSG = MessageBox.Show("سيتم حذف هذه الحركة", "MESSAGE", MessageBoxButtons.OKCancel); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@ID", SqlDbType.BigInt); param[1] = new SqlParameter("@date", SqlDbType.Date); var date = dateTimePickerTransaction.Value.Date.ToString("yyyy-MM-dd"); param[0].Value = dataGridViewMoney.Rows[dataGridViewMoney.CurrentCell.RowIndex].Cells["ColumnTransactionID"].Value; param[1].Value = date; UsedClass.ExecuteCommand("Casher_DeleteTransaction", param); //MessageBox.Show ( "DONE" , "MESSAGE" ); dataGridViewMoney.Rows.Clear(); initializeFunction(); dataGridViewMoney.Enabled = true; } else { dataGridViewMoney.Rows.RemoveAt(dataGridViewMoney.CurrentCell.RowIndex); } } else { MessageBox.Show("يجب تحديد السطر الذي تريد حذفه", "MESSAGE"); } }
private void save_Transaction() { SqlParameter[] param = new SqlParameter[10]; var UsedClass = new BasicClass(); param[0] = new SqlParameter("@TransactionID", SqlDbType.BigInt); param[1] = new SqlParameter("@TransactionType", SqlDbType.NVarChar, 100); param[2] = new SqlParameter("@currencyType", SqlDbType.NVarChar, 100); param[3] = new SqlParameter("@Payment", SqlDbType.Money); param[4] = new SqlParameter("@paymentTotal", SqlDbType.Money); param[5] = new SqlParameter("@TransferRate", SqlDbType.Money); param[6] = new SqlParameter("@Customer", SqlDbType.NVarChar, 150); param[7] = new SqlParameter("@Details", SqlDbType.Text); param[8] = new SqlParameter("@Date", SqlDbType.Date); param[9] = new SqlParameter("@EnteredUser", SqlDbType.NVarChar, 150); for (int rowindex = 0; rowindex < dataGridViewMoney.Rows.Count; rowindex++) { param[0].Value = Convert.ToInt64(dataGridViewMoney.Rows[rowindex].Cells["ColumnTransactionID"].Value.ToString()); if (BasicClass.PaidOrGet) { if (BasicClass.USorIQ) { param[1].Value = "مدفوعات دولار"; } else { param[1].Value = "مدفوعات دينار"; } } else { if (BasicClass.USorIQ) { param[1].Value = "مقبوضات دولار"; } else { param[1].Value = "مقبوضات دينار"; } } param[2].Value = dataGridViewMoney.Rows[rowindex].Cells["ColumnmoneyType"].Value.ToString(); param[3].Value = dataGridViewMoney.Rows[rowindex].Cells["ColumnMoneyAmount"].Value; param[4].Value = dataGridViewMoney.Rows[rowindex].Cells["ColumnTotal"].Value; param[5].Value = dataGridViewMoney.Rows[rowindex].Cells["ColumnTansferPercentage"].Value.ToString(); param[6].Value = dataGridViewMoney.Rows[rowindex].Cells["ColumnCutomerName"].Value.ToString(); param[7].Value = dataGridViewMoney.Rows[rowindex].Cells["ColumnNotes"].Value.ToString(); param[8].Value = dateTimePickerTransaction.Value.Date; param[9].Value = "Mustafa"; UsedClass.ExecuteCommand("Casher_InsertNewTransaction", param); } MessageBox.Show("DONE", "MESSAGE"); }
private void button_changePrices_Click(object sender, EventArgs e) { SqlParameter[] parameter = new SqlParameter[2]; parameter[0] = new SqlParameter("@ID", SqlDbType.Int); parameter[1] = new SqlParameter("@Price", SqlDbType.Float); if (dataGridViewPrices_displayitems.Rows.Count >= 0 && changesInPriceFlag) { for (int i = 0; i < dataGridViewPrices_displayitems.Rows.Count; i++) { parameter[0].Value = int.Parse(dataGridViewPrices_displayitems.Rows[i].Cells["ColumnitemID"].Value.ToString()); parameter[1].Value = float.Parse(dataGridViewPrices_displayitems.Rows[i].Cells["Column_price_for_buy"].Value.ToString()); usedClass.ExecuteCommand("Casher_UpdateItemsPrices", parameter); } MessageBox.Show("DONE", "MESSAGE"); changesInPriceFlag = false; dt.Rows.Clear(); dataGridViewPrices_displayitems.DataSource = dt; checkBox_all_items_without_price.Checked = false; txtprice_searchByitemName.Text = ""; comboBoxPriceChooseCatg.DataSource = dt; } }
private void get_TransactionID() { var dt = new DataTable(); var UsedClass = new BasicClass(); dt = UsedClass.selectdata("Casher_select_all_IDs", null); if (dt.Rows.Count > 0) { dataGridViewMoney.Rows[dataGridViewMoney.Rows.Count - 1].Cells["ColumnTransactionID"].Value = Convert.ToInt64(dt.Rows[0]["TransactionID"].ToString()); dataGridViewMoney.Rows[dataGridViewMoney.Rows.Count - 1].Cells["ColumnTransactionID"].Selected = true; } UsedClass.ExecuteCommand("Casher_IncreaseTrnasactionID", null); }
private void delete_Transaction() { SqlParameter[] param = new SqlParameter[2]; var UsedClass = new BasicClass(); param[0] = new SqlParameter("@ID", SqlDbType.BigInt); param[1] = new SqlParameter("@date", SqlDbType.Date); param[1].Value = dateTimePickerTransaction.Value.Date.ToString("yyyy-MM-dd"); for (int i = 0; i < dataGridViewMoney.Rows.Count; i++) { param[0].Value = Int64.Parse(dataGridViewMoney.Rows[i].Cells["ColumnTransactionID"].Value.ToString()); UsedClass.ExecuteCommand("Casher_DeleteTransaction", param); } }