private void dataGridViewSaleGrid_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var crp = new Reports.SaleInvoiceReport();
var dt = new DataTable();
var usedClass = new BasicClass();
var form = new PrintForm();
if (e.ColumnIndex == 0)
{
if (e.RowIndex >= 0)
{
string InvoiceNo = dataGridViewSaleGrid.Rows[e.RowIndex].Cells["ColumnInvoiceNo"].Value.ToString();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@InvoiceNo", SqlDbType.Int);
param[0].Value = int.Parse(InvoiceNo);
dt = usedClass.selectdata("Report_Select_SaleInvoice_usingInvoiceNo", param);
TextObject InvoicePayment = (TextObject)crp.ReportDefinition.Sections["Section1"].ReportObjects["Text7"];
InvoicePayment.Text = dataGridViewSaleGrid.Rows[e.RowIndex].Cells["ColumnInvoiceStatus"].Value.ToString();
TextObject InvoiceType = (TextObject)crp.ReportDefinition.Sections["Section1"].ReportObjects["Text17"];
InvoiceType.Text = "قائمة شراء";
crp.SetDataSource(dt);
form.crystalReportViewer1.ReportSource = crp;
form.ShowDialog();
}
}
}
private void buttonShowSaleInvoices_Click(object sender, EventArgs e)
{
var usedClass = new BasicClass();
var dt = new DataTable();
if (checkBoxDateSearch.Checked)
{
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@InvoiceType", SqlDbType.NVarChar, 250);
param[1] = new SqlParameter("@beginDate", SqlDbType.NVarChar, 250);
param[2] = new SqlParameter("@endDate", SqlDbType.NVarChar, 250);
param[3] = new SqlParameter("@invoiceStatus", SqlDbType.NVarChar, 150);
param[0].Value = "شراء";
param[1].Value = dateTimePickerFrom.Text.ToString();
param[2].Value = dateTimePickerTo.Text.ToString();
param[3].Value = "RUN";
dt = usedClass.selectdata("Report_Select_invoices_usingDates_and_InvoiceType", param);
dataGridViewSaleGrid.DataSource = dt;
}
else
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@InvoiceType", SqlDbType.NChar, 250);
param[1] = new SqlParameter("@InvoiceStatus", SqlDbType.NChar, 250);
param[0].Value = "شراء";
param[1].Value = "RUN";
dt = usedClass.selectdata("Report_SelectAll_Invoices_usingType", param);
dataGridViewSaleGrid.DataSource = dt;
}
}
private void textBoxFilterSalesGrid_TextChanged(object sender, EventArgs e)
{
var usedClass = new BasicClass();
var dt = new DataTable();
if (textBoxFilterSalesGrid.Text != "")
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@InvoiceType", SqlDbType.NChar, 250);
param[1] = new SqlParameter("@Filter", SqlDbType.NVarChar, 250);
param[2] = new SqlParameter("@InvoiceStatus", SqlDbType.NVarChar, 250);
param[0].Value = "شراء";
param[1].Value = textBoxFilterSalesGrid.Text;
param[2].Value = "RUN";
dt = usedClass.selectdata("Report_SelectAll_Invoices_usingTypeAndFilter", param);
dataGridViewSaleGrid.DataSource = dt;
}
else
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@InvoiceType", SqlDbType.NChar, 250);
param[1] = new SqlParameter("@InvoiceStatus", SqlDbType.NChar, 250);
param[0].Value = "شراء";
param[1].Value = "RUN";
dt = usedClass.selectdata("Report_SelectAll_Invoices_usingType", param);
dataGridViewSaleGrid.DataSource = dt;
}
}
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 getAllTransaction(string TransactionType, string TransactionDate)
{
var dt = new DataTable();
var UsedClass = new BasicClass();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@TransactionType", SqlDbType.NVarChar, 150);
param[1] = new SqlParameter("@TransactionDate", SqlDbType.NVarChar, 100);
param[0].Value = TransactionType;
param[1].Value = TransactionDate;
dt = UsedClass.selectdata("Casher_SelectTransaction", param);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
var ID = dt.Rows[i]["TransactionID"].ToString();
var currencyType = dt.Rows[i]["CurrecncyType"].ToString();
var payment = Convert.ToDecimal(dt.Rows[i]["Payment"].ToString());
var RateTransfer = Convert.ToDecimal(dt.Rows[i]["TransferPercentage"].ToString());
var Total = Convert.ToDecimal(dt.Rows[i]["PaymentTotal"].ToString());
var Customer = dt.Rows[i]["CutomerPaid"].ToString();
var Details = dt.Rows[i]["TransactionDetails"].ToString();
dataGridViewMoney.Rows.Add(ID, currencyType, payment, RateTransfer, Total, Customer, Details);
}
dataGridViewMoney.ReadOnly = true;
}
}
private void button_showAllCustomers_Click(object sender, EventArgs e)
{
var usedClass = new BasicClass();
var dt = new DataTable();
dt = usedClass.selectdata("Reports_Select_Users", null);
dataGridView_displayCustomers.DataSource = dt;
}
private void button_showAllitems_Click(object sender, EventArgs e)
{
var usedClass = new BasicClass();
var dt = new DataTable();
dt = usedClass.selectdata("Report_SelectAllitemsWithPrices", null);
dataGridView_displayitems.DataSource = dt;
}
private void buttonEnter_Click(object sender, EventArgs e)
{
var dt = new DataTable();
var UsedClass = new BasicClass();
var form = new ControlingForm();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@UserName", SqlDbType.NVarChar, 250);
param[1] = new SqlParameter("@Passwrod", SqlDbType.NVarChar, 50);
param[0].Value = textBoxUserName.Text;
param[1].Value = textBoxPassword.Text;
dt = UsedClass.selectdata("Login_Select_Users", param);
if (dt.Rows.Count > 0)
{
BasicClass.UserName = dt.Rows[0]["UserName"].ToString();
BasicClass.Password = dt.Rows[0]["Password"].ToString();
if (dt.Rows[0]["ReportPermission"].ToString() == "True")
{
form.btn_PurshaceForm.Enabled = true;
}
if (dt.Rows[0]["CasherPermission"].ToString() == "True")
{
form.btn_CasherForm.Enabled = true;
}
if (dt.Rows[0]["StorePermission"].ToString() == "True")
{
form.btn_PurshaceForm.Enabled = true;
form.btn_ReportingForm.Enabled = true;
}
if (dt.Rows[0]["SuperUser"].ToString() == "True")
{
form.btn_CasherForm.Enabled = true;
form.btn_PurshaceForm.Enabled = true;
form.btn_ReportingForm.Enabled = true;
form.btn_SettingForm.Enabled = true;
}
if (dt.Rows[0]["ReportPermission"].ToString() == "False" && dt.Rows[0]["SuperUser"].ToString() == "False" && dt.Rows[0]["StorePermission"].ToString() == "False" && dt.Rows[0]["CasherPermission"].ToString() == "False")
{
MessageBox.Show("هذا المستخدم تم حضره من قبل مدير النظام", "MESSAGE");
Application.Exit();
}
BasicClass.UserName = textBoxUserName.Text.Trim();
BasicClass.Password = textBoxPassword.Text.Trim();
form.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("خطا في ادخال اسم المعلومات");
}
}
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 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);
}
}
private void textBoxFilteritemsGrid_TextChanged(object sender, EventArgs e)
{
var usedClass = new BasicClass();
var dt = new DataTable();
if (textBoxFilteritemsGrid.Text != "")
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Filter", SqlDbType.NVarChar, 250);
param[0].Value = textBoxFilteritemsGrid.Text;
dt = usedClass.selectdata("Report_SelectAllitemswithPrices_UsingFilter", param);
dataGridView_displayitems.DataSource = dt;
}
else
{
dt = usedClass.selectdata("Report_SelectAllitemsWithPrices", null);
dataGridView_displayitems.DataSource = dt;
}
}
private void textBoxFilteritemsGrid_TextChanged(object sender, EventArgs e)
{
var dt = new DataTable();
var UsedClass = new BasicClass();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Filter", SqlDbType.NVarChar);
if (textBoxFilteritemsGrid.Text != "")
{
param[0].Value = textBoxFilteritemsGrid.Text.Trim();
dt = UsedClass.selectdata("Reports_SelectUsers_byFilter", param);
dataGridView_displayCustomers.DataSource = dt;
}
else
{
dt = UsedClass.selectdata("Reports_Select_Users", null);
dataGridView_displayCustomers.DataSource = dt;
}
}
private void dataGridViewBuyGridInvoice_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var crp = new Reports.SaleInvoiceReport();
var dt = new DataTable();
var usedClass = new BasicClass();
var form = new PrintForm();
if (e.ColumnIndex == 0)
{
if (e.RowIndex >= 0)
{
int InvoiceNo = int.Parse(dataGridViewBuyGridInvoice.Rows[e.RowIndex].Cells["ColumnInvoiceNo"].Value.ToString());
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@InvoiceNo", SqlDbType.Int);
param[0].Value = InvoiceNo;
dt = usedClass.selectdata("Report_Select_SaleInvoice_usingInvoiceNo", param);
if (dt.Rows.Count > 0)
{
string y = string.Concat(crp.DataDefinition.FormulaFields["ItemQuantity"].Text, "*-1");
crp.DataDefinition.FormulaFields["ItemQuantity"].Text = y;
TextObject InvoicePayment = (TextObject)crp.ReportDefinition.Sections["Section1"].ReportObjects["Text7"];
InvoicePayment.Text = dataGridViewBuyGridInvoice.Rows[e.RowIndex].Cells["ColumnInvoiceStatus"].Value.ToString();
TextObject InvoiceType = (TextObject)crp.ReportDefinition.Sections["Section1"].ReportObjects["Text17"];
InvoiceType.Text = "قائمة بيع";
crp.SetDataSource(dt);
form.crystalReportViewer1.ReportSource = crp;
form.ShowDialog();
}
else
{
MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE");
}
}
}
}
private void dataGridView_displayCustomers_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var dt = new DataTable();
var UsedClass = new BasicClass();
var crp = new Reports.CustomerReports_Sale_buy();
var form = new PrintForm();
TextObject CustomerName = (TextObject)crp.ReportDefinition.Sections["Section1"].ReportObjects["Text2"];
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@CustomerName", SqlDbType.NVarChar, 250);
param[1] = new SqlParameter("@InvoiceType", SqlDbType.NVarChar, 250);
param[2] = new SqlParameter("@InvoiceStatus", SqlDbType.NVarChar, 250);
if (e.RowIndex >= 0)
{
param[0].Value = dataGridView_displayCustomers.Rows[e.RowIndex].Cells["ColumnCustomerName"].Value.ToString();
CustomerName.Text = dataGridView_displayCustomers.Rows[e.RowIndex].Cells["ColumnCustomerName"].Value.ToString();
switch (e.ColumnIndex)
{
case 0:
//invoiceType.Text = "فواتير الشراء";
param[1].Value = "شراء";
param[2].Value = "Run";
dt = UsedClass.selectdata("Reports_Customers_Select_invoicesDepandonInvoiceType_and_invoiceStatus", param);
crp.SetDataSource(dt);
form.crystalReportViewer1.ReportSource = crp;
if (dt.Rows.Count == 0)
{
MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE");
}
else
{
form.ShowDialog();
}
break;
case 1:
//invoiceType.Text = "فواتير البيع";
param[1].Value = "بيع";
param[2].Value = "Run";
dt = UsedClass.selectdata("Reports_Customers_Select_invoicesDepandonInvoiceType_and_invoiceStatus", param);
crp.SetDataSource(dt);
form.crystalReportViewer1.ReportSource = crp;
if (dt.Rows.Count == 0)
{
MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE");
}
else
{
form.ShowDialog();
}
//crp.SetDataSource ( dt );
//form.crystalReportViewer1.ReportSource = crp;
//form.ShowDialog ();
break;
case 2:
//invoiceType.Text = "فواتير المحجوزة";
param[1].Value = "بيع";
param[2].Value = "Save";
dt = UsedClass.selectdata("Reports_Customers_Select_invoicesDepandonInvoiceType_and_invoiceStatus", param);
crp.SetDataSource(dt);
form.crystalReportViewer1.ReportSource = crp;
if (dt.Rows.Count == 0)
{
MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE");
}
else
{
form.ShowDialog();
}
break;
case 3:
param[1].Value = "شراء";
param[2].Value = "Save";
dt = UsedClass.selectdata("Reports_Customers_Select_invoicesDepandonInvoiceType_and_invoiceStatus", param);
crp.SetDataSource(dt);
form.crystalReportViewer1.ReportSource = crp;
if (dt.Rows.Count == 0)
{
MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE");
}
else
{
form.ShowDialog();
}
break;
case 4:
SqlParameter[] parameter = new SqlParameter[1];
parameter[0] = new SqlParameter("@CustomerName", SqlDbType.NVarChar, 150);
parameter[0].Value = dataGridView_displayCustomers.Rows[e.RowIndex].Cells["ColumnCustomerName"].Value.ToString();
dt = UsedClass.selectdata("Reports_Summery", parameter);
var Crp2 = new Reports.SummeryReport();
Crp2.SetDataSource(dt);
form.crystalReportViewer1.ReportSource = Crp2;
if (dt.Rows.Count == 0)
{
MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE");
}
else
{
form.ShowDialog();
}
break;
default:
break;
}
}
}
private void dataGridView_displayitems_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
var dt = new DataTable();
var UsedClass = new BasicClass();
var crp = new Reports.ItemsReport();
var form = new PrintForm();
string itemName = dataGridView_displayitems.Rows[e.RowIndex].Cells["ColumnItemName"].Value.ToString();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@ItemName", SqlDbType.NVarChar, 250);
param[1] = new SqlParameter("@InvoiceType", SqlDbType.NVarChar, 250);
param[2] = new SqlParameter("@InvoiceSatus", SqlDbType.NVarChar, 250);
TextObject invoiceType = (TextObject)crp.ReportDefinition.Sections["Section1"].ReportObjects["Text11"];
TextObject itemNameHeader = (TextObject)crp.ReportDefinition.Sections["Section1"].ReportObjects["Text17"];
switch (e.ColumnIndex)
{
case 0: //Purshace Invoices
param[0].Value = itemName;
param[1].Value = "شراء";
param[2].Value = "Run";
dt = UsedClass.selectdata("Report_Select_items_using_itemName_and_InvoiceType", param);
if (dt.Rows.Count > 0)
{
invoiceType.Text = "قائمة مشتريات";
itemNameHeader.Text = itemName;
crp.SetDataSource(dt);
form.crystalReportViewer1.ReportSource = crp;
form.ShowDialog();
}
else
{
MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE");
}
break;
case 1: //Sale Invoices
param[0].Value = itemName;
param[1].Value = "بيع";
param[2].Value = "Run";
dt = UsedClass.selectdata("Report_Select_items_using_itemName_and_InvoiceType", param);
if (dt.Rows.Count > 0)
{
invoiceType.Text = "قائمة مبيعات";
itemNameHeader.Text = itemName;
crp.SetDataSource(dt);
form.crystalReportViewer1.ReportSource = crp;
form.ShowDialog();
}
else
{
MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE");
}
break;
case 2: //Save Invoices
param[0].Value = itemName;
param[1].Value = "بيع";
param[2].Value = "SAVE";
dt = UsedClass.selectdata("Report_Select_items_using_itemName_and_InvoiceType", param);
if (dt.Rows.Count > 0)
{
invoiceType.Text = "قائمة مبيعات";
itemNameHeader.Text = itemName;
crp.SetDataSource(dt);
form.crystalReportViewer1.ReportSource = crp;
form.ShowDialog();
}
else
{
MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE");
}
break;
case 3:
param[0].Value = itemName;
param[1].Value = "شراء";
param[2].Value = "SAVE";
dt = UsedClass.selectdata("Report_Select_items_using_itemName_and_InvoiceType", param);
if (dt.Rows.Count > 0)
{
invoiceType.Text = "قائمة مبيعات";
itemNameHeader.Text = itemName;
crp.SetDataSource(dt);
form.crystalReportViewer1.ReportSource = crp;
form.ShowDialog();
}
else
{
MessageBox.Show("لا توجد بيانات لعرضها", "MESSAGE");
}
break;
default:
break;
}
}
}
