private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
Row = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[1].FormattedValue);
this.Hide();
AddBuyingInvoice BuyInvoice = new AddBuyingInvoice();
BuyInvoice.fromAnotherForm = 1;
BuyInvoice.Com_Suppliers.Enabled = false;
BuyInvoice.ComboSelected = Row - 1;
BuyInvoice.ShowDialog();
}
private void But_AddInvoice_Click(object sender, EventArgs e)
{
int found = 0;
for (int i = 0; i < DrugUnitValue.Count; i++)
{
for (int m = 0; m < DrugUnitValue.Count; m++)
{
if (DrugUnitValue[i] == DrugUnitValue[m])
{
found++;
}
}
}
if (found <= DrugUnitValue.Count)
{
serial = ConnectionClass.SerialNumber();
OutParameter.Direction = ParameterDirection.ReturnValue;
ConnectionClass.Parameters(new SqlParameter("@supplierId", Com_Suppliers.SelectedValue), new SqlParameter("@invoiceDate", Convert.ToDateTime(dateTimePicker1.Text)), new SqlParameter("@InvAutoNumber", serial), OutParameter);
ConnectionClass.SQLCommand("Cproc_AddBuyInvoice", CommandType.StoredProcedure, ExecuteReaderOrNonQuery.executeNonQuery);
int x = (int)OutParameter.Value;
for (int i = 0; i < PriceValueList.Count; i++)
{
int x1 = int.Parse(DrugUnitValue[i]);
decimal price = Convert.ToDecimal(PriceValueList[i]);
int quantity = int.Parse(QntyValueList[i]);
DateTime D = DatevalueList[i];
ConnectionClass.Parameters(new SqlParameter("@InvoiceId", x), new SqlParameter("@DrugId", x1), new SqlParameter("@pricePerUnit", price), new SqlParameter("@Qnty", quantity), new SqlParameter("@Expdate", D));
ConnectionClass.SQLCommand("AddInvoiceDetail", CommandType.StoredProcedure, ExecuteReaderOrNonQuery.executeNonQuery);
ConnectionClass.SQLCommandWithoutParameters("update pharmacy.drugs set Balance += " + quantity + " where DrugId= " + x1 + "", CommandType.Text, ExecuteReaderOrNonQuery.executeNonQuery);
}
var result = MessageBox.Show("تم اضافة الفاتورة بنجاح، هل تريد إضافة فاتورة أخرى", "إضافة أم خروج", MessageBoxButtons.YesNo);
if (result == System.Windows.Forms.DialogResult.No)
{
this.Close();
ConnectionClass.ParameterList.Clear();
}
else
{
DrugUnitValue.Clear();
PriceValueList.Clear();
QntyValueList.Clear();
DatevalueList.Clear();
LblValue.Clear();
DrugUnitList.Clear();
PriceTextboxList.Clear();
QntyTextboxList.Clear();
ExpDatList.Clear();
LblList.Clear();
this.Close();
this.Dispose();
ConnectionClass.ParameterList.Clear();
AddBuyingInvoice Buy = new AddBuyingInvoice();
Buy.ShowDialog();
}
}
else
{
But_Save.Enabled = true;
for (int N = 15; N < Controls.Count; N++)
{
Controls[N].Enabled = true;
}
MessageBox.Show("هناك عنصر مكرر بالفاتورة");
DrugUnitValue.Clear();
PriceValueList.Clear();
QntyValueList.Clear();
DatevalueList.Clear();
sum = 0;
But_AddInvoice.Visible = false;
}
}
