private async void btnDeleteSup_Click(object sender, EventArgs e)
{
if (dataSupliers.SelectedRows.Count == 1)
{
try
{
Suppliers supplier = (Suppliers)dataSupliers.SelectedRows[0].DataBoundItem;
await ControlerMethods.DeleteSupplier(supplier);
dataSupliers.DataSource = await ControlerMethods.GetSupliersAsync();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n",
"خطا",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("لطفا یک سطر را انتخاب نمایید " + "\n",
"خطا",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
private async void btnUpdateAddedProduct_Click(object sender, EventArgs e)
{
if (dataQtyProduct.SelectedRows.Count == 1)
{
Product product = (Product)dataQtyProduct.SelectedRows[0].DataBoundItem;
List <Category> categories = await ControlerMethods.GetCategoryAsync();
List <Suppliers> suppliers = await ControlerMethods.GetSupliersAsync();
comboCat.SelectedIndex = comboCat.Items.IndexOf(categories.Where(x => x.CategoryId.Equals(product.CategoryId)).FirstOrDefault <Category>().CategoryName);
comboSup.SelectedIndex = comboSup.Items.IndexOf(suppliers.Where(x => x.SupplierId.Equals(product.SupplierId)).FirstOrDefault <Suppliers>().CompanyName);
txtAddProductName.Text = product.ProductName;
txtAddProductCode.Text = product.ProuductCode;
txtAddProductQty.Text = (product.Qty).ToString();
txtAddProductTax.Text = (product.Tax * 100).ToString();
txtAddProductBuy.Text = product.UnitPriceBuy.ToString();
txtAddProductSale.Text = product.UnitPriceSales.ToString();
txtAddProductDiscount.Text = (product.Discount * 100).ToString();
btnDbAddProduct.Enabled = false;
txtAddProductCode.Enabled = false;
btnAddEditedProduct.Visible = true;
}
else
{
MessageBox.Show("لطفا یک سطر را انتخاب نمایید " + "\n",
"خطا",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
//tab selection change uncompited
private async void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
{
if (tabControl1.SelectedIndex == 2)
{
dataQtyProduct.DataSource = await ControlerMethods.GetProductsAsync();
dataSupliers.DataSource = await ControlerMethods.GetSupliersAsync();
DataCategory.DataSource = await ControlerMethods.GetCategoryAsync();
dataSupliers.Columns["SupplierId"].Visible = false;
DataCategory.Columns["CategoryId"].Visible = false;
if (comboCat.Items.Count < 1)
{
List <Category> categories = await ControlerMethods.GetCategoryAsync();
foreach (Category cat in categories)
{
comboCat.Items.Add(cat.CategoryName);
}
List <Suppliers> suppliers = await ControlerMethods.GetSupliersAsync();
foreach (Suppliers sup in suppliers)
{
comboSup.Items.Add(sup.CompanyName);
}
}
}
else if (tabControl1.SelectedIndex == 0)
{
FrmEmpMain_Load(sender, e);
}
else if (tabControl1.SelectedIndex == 3)
{
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("date1", dateSumOrder1.Value.Date));
sqlParameters.Add(new SqlParameter("date2", dateSumOrder2.Value.Date.AddMinutes(1439)));
dataSumOrders.DataSource = await DataAccessAsync.ExecSPAsync("Sales.dvgSumOrders", sqlParameters);
dataSumOrders.Columns["sumProfit"].DefaultCellStyle.Format = "#,#";
dataSumOrders.Columns["sumSell"].DefaultCellStyle.Format = "#,#";
dataSumOrders.Columns["sumBuy"].DefaultCellStyle.Format = "#,#";
dataSumOrders.Columns["Column1"].HeaderText = "نام کارمند";
dataSumOrders.Columns["sumProfit"].HeaderText = "مجموع سود";
dataSumOrders.Columns["sumBuy"].HeaderText = "محموع خرید";
dataSumOrders.Columns["sumSell"].HeaderText = "مجموع فروش ";
dataSumOrders.Columns["Column2"].Visible = false;
}
else if (tabControl1.SelectedIndex == 4)
{
dgvExistProduct.DataSource = await DataAccessAsync.ExecSPAsync("Production.GetProductByCode");
}
}
//add product available COMPITED
private async void btnDbAddProduct_Click(object sender, EventArgs e)
{
try
{
List <Category> categories = await ControlerMethods.GetCategoryAsync();
List <Suppliers> suppliers = await ControlerMethods.GetSupliersAsync();
List <Product> products = await ControlerMethods.GetProductsAsync();
Product product = new Product();
product.CategoryId = categories.Where(x => x.CategoryName.Equals(comboCat.Text.ToString())).FirstOrDefault <Category>().CategoryId;
product.SupplierId = suppliers.Where(x => x.CompanyName.Equals(comboSup.Text.ToString())).FirstOrDefault <Suppliers>().SupplierId;
product.ProductName = txtAddProductName.Text;
product.ProuductCode = txtAddProductCode.Text;
product.Qty = Convert.ToInt32(txtAddProductQty.Text);
product.Tax = Convert.ToInt32(txtAddProductTax.Text) / 100;
product.UnitPriceBuy = Convert.ToInt32(txtAddProductBuy.Text);
product.UnitPriceSales = Convert.ToInt32(txtAddProductSale.Text);
product.Discount = Convert.ToDouble(txtAddProductDiscount.Text) / 100;
FrmEmpMain_Load(sender, e);
if (products.Where(x => x.ProuductCode.Equals(product.ProuductCode)).Count() > 0)
{
DialogResult dialogResult = MessageBox.Show(String.Format("محصول موجود می باشد آیا مایل به افزودن تعداد وارد شده می باشید "),
"اخطار",
MessageBoxButtons.YesNo,
MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
await ControlerMethods.CheckAndSetProduct(product);
MessageBox.Show(String.Format("با موفقیت ثبت گردید "),
"موفق",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
else
{
await ControlerMethods.CheckAndSetProduct(product);
}
dataQtyProduct.DataSource = await ControlerMethods.GetProductsAsync();
}
catch (Exception ex)
{
MessageBox.Show("خطا در هنگام انجام عملایات " + "\n" + ex.GetBaseException().ToString(),
"خطا",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
// add edited product and update product
private async void btnAddEditedProduct_Click(object sender, EventArgs e)
{
try
{
List <Category> categories = await ControlerMethods.GetCategoryAsync();
List <Suppliers> suppliers = await ControlerMethods.GetSupliersAsync();
List <Product> products = await ControlerMethods.GetProductsAsync();
Product product = new Product();
product.ProductId = products.Where(x => x.ProuductCode.Equals(txtAddProductCode.Text)).FirstOrDefault <Product>().ProductId;
product.CategoryId = categories.Where(x => x.CategoryName.Equals(comboCat.Text.ToString())).FirstOrDefault <Category>().CategoryId;
product.SupplierId = suppliers.Where(x => x.CompanyName.Equals(comboSup.Text.ToString())).FirstOrDefault <Suppliers>().SupplierId;
product.ProductName = txtAddProductName.Text;
product.ProuductCode = txtAddProductCode.Text;
product.Qty = Convert.ToInt32(txtAddProductQty.Text);
product.Tax = Convert.ToInt32(txtAddProductTax.Text) / 100;
product.UnitPriceBuy = Convert.ToInt32(txtAddProductBuy.Text);
product.UnitPriceSales = Convert.ToInt32(txtAddProductSale.Text);
product.Discount = Convert.ToDouble(txtAddProductDiscount.Text) / 100;
FrmEmpMain_Load(sender, e);
await ControlerMethods.UpdateProductAsync(product);
MessageBox.Show(String.Format("با موفقیت ثبت گردید "),
"موفق",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
dataQtyProduct.DataSource = await ControlerMethods.GetProductsAsync();
btnAddEditedProduct.Visible = false;
btnDbAddProduct.Enabled = true;
txtAddProductCode.Enabled = true;
txtAddProductName.Text = "";
txtAddProductCode.Text = "";
txtAddProductQty.Text = "";
txtAddProductTax.Text = "0";
txtAddProductBuy.Text = "";
txtAddProductSale.Text = "";
txtAddProductDiscount.Text = "";
}
catch (Exception ex)
{
MessageBox.Show("خطا در هنگام انجام عملایات " + "\n" + ex.GetBaseException().ToString(),
"خطا",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
//btn add supliers COMPLITED
private async void btnAddSup_Click(object sender, EventArgs e)
{
if (!txtSupName.Text.Equals(""))
{
Suppliers supplier = new Suppliers();
supplier.CompanyName = txtSupName.Text;
supplier.Phone = txtSupPhone.Text;
await ControlerMethods.SetSuplierAsync(supplier);
txtSupPhone.Text = "";
txtSupName.Text = "";
}
dataSupliers.DataSource = await ControlerMethods.GetSupliersAsync();
}
private async void txtTabAddSupSearch_TextChanged(object sender, EventArgs e)
{
List <Suppliers> suppliersTab2 = await ControlerMethods.GetSupliersAsync();
if (txtTabAddSupSearch.Text.Equals(""))
{
if (suppliersTab2 != null)
{
dataSupliers.DataSource = suppliersTab2;
}
}
else
{
if (suppliersTab2 != null)
{
dataSupliers.DataSource = suppliersTab2.Where(x => x.CompanyName.Contains(txtTabAddSupSearch.Text.Trim())).ToList <Suppliers>();
}
}
}
//COMPLITED
private async void txtAddProductCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
try
{
List <Category> categories = await ControlerMethods.GetCategoryAsync();
List <Suppliers> suppliers = await ControlerMethods.GetSupliersAsync();
List <Product> products = await ControlerMethods.GetProductsAsync();
if (products.Where(x => x.ProuductCode.Equals(txtAddProductCode.Text)).Count() == 1)
{
DialogResult dialogResult = MessageBox.Show("محصول موجود می باشد \n یک عدد به محصول افزوده شود ؟ ", "توجه", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialogResult == DialogResult.Yes)
{
Product product = (Product)products.Where(x => x.ProuductCode.Equals(txtAddProductCode.Text)).FirstOrDefault <Product>();
product.Qty = 1;
await ControlerMethods.CheckAndSetProduct(product);
dataQtyProduct.DataSource = await ControlerMethods.GetProductsAsync();
if (CheckShowDialog.Equals(null))
{
CheckShowDialog =
MessageBox.Show("هر بار سوال شود ؟", "", MessageBoxButtons.YesNo, MessageBoxIcon.Warning).Equals(DialogResult.Yes) ? true : false;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("لطفا مقادیر را برسی نمایید " + "\n" + ex.Message.ToString(),
"خطا",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
}