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);
}
}
