private void btnRemove_Click(object sender, EventArgs e) { var result = MessageBox.Show("آیا از حذف شخص مطمئنید ؟", "اخطار", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.No) { return; } if (dgvPersons.SelectedRows.Count == 0) { return; } var id = Convert.ToInt32(dgvPersons.SelectedRows[0].Cells["clnId"].Value); var db = new shampazEntities(); var p = db.Persons.Where(x => x.Id == id).FirstOrDefault(); try { db.Persons.Remove(p); db.SaveChanges(); DesktopAlert.Show("شخص حذف شد", eDesktopAlertColor.Green, eAlertPosition.BottomRight); dgvPersonsRefresh(); } catch { DesktopAlert.Show("امکان حذف شخص نیست", eDesktopAlertColor.Red, eAlertPosition.BottomRight); } }
private void btnRemove_Click(object sender, EventArgs e) { if (dgvFactors.SelectedRows.Count == 0) { return; } var result = MessageBox.Show("آیا مطئن هستید?", "اخطار", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.No) { return; } var db = new shampazEntities(); foreach (DataGridViewRow row in dgvFactors.SelectedRows) { var id = Convert.ToInt32(row.Cells["clnId"].Value); var factor = db.BuyFactors.Where(x => x.Id == id).FirstOrDefault(); var items = db.BuyFactorItems.Where(x => x.BuyFactorId == factor.Id).ToList(); db.BuyFactorItems.RemoveRange(items); db.BuyFactors.Remove(factor); } db.SaveChanges(); DesktopAlert.Show("فاکتور حذف شد", eDesktopAlertColor.Green, eAlertPosition.BottomRight); btnFilter.PerformClick(); }
private void save() { var db = new shampazEntities(); var factor = new SellFactor { Date = (DateTime)pdpDate.GeorgianDate + dtpTime.Value.TimeOfDay, PersonId = SelectedPerson.Id, TotalPrice = Convert.ToDecimal(txtTotalPrice.Text), Description = txtDescription.Text, }; db.SellFactors.Add(factor); foreach (DataGridViewRow r in dgvItems.Rows) { factor.SellFactorItems.Add( new SellFactorItem { Name = r.Cells["clnProductName"].Value.ToString(), Numbers = Convert.ToInt32(r.Cells["clnNumber"].Value), Price = Convert.ToDecimal(r.Cells["clnProductPrice"].Value), ProductId = Convert.ToInt32(r.Cells["clnProductId"].Value), TotalPrice = Convert.ToDecimal(r.Cells["clnTotalPrice"].Value), } ); } db.SaveChanges(); DesktopAlert.Show("فاکتور ذخیره شد", eDesktopAlertColor.Green, eAlertPosition.BottomRight); EditedSellFactor = factor; }
private void editPerson() { var db = new shampazEntities(); var p = db.Persons.Where(x => x.Id == PersonId).FirstOrDefault(); p.Name = txtName.Text.Trim(); p.Mobile = txtMobile.Text.Trim(); p.Address = txtAddress.Text.Trim(); DesktopAlert.Show("شخص ویرایش شد", eDesktopAlertColor.Green, eAlertPosition.BottomRight); db.SaveChanges(); }
private void addPerson() { var db = new shampazEntities(); db.Persons.Add(new Person { Name = txtName.Text.Trim(), Address = txtAddress.Text.Trim(), Mobile = txtMobile.Text.Trim() }); db.SaveChanges(); DesktopAlert.Show("شخص افزوده شد", eDesktopAlertColor.Green, eAlertPosition.BottomRight); }
private void update() { var db = new shampazEntities(); var factor = db.BuyFactors.Where(x => x.Id == EditedFactor.Id).FirstOrDefault(); factor.Date = (DateTime)pdpDate.GeorgianDate + dtpTime.Value.TimeOfDay; factor.PersonId = SelectedPerson.Id; factor.TotalPrice = Convert.ToDecimal(txtTotalPrice.Text); factor.Description = txtDescription.Text; try { factor.PaymentPrice = Convert.ToDecimal(txtPayment.Text); } catch { factor.PaymentPrice = 0; } //MessageBox.Show(factor.Id.ToString()); db.BuyFactorItems.RemoveRange(factor.BuyFactorItems); //foreach( var item in factor.SellFactorItems ) //{ // db.SellFactorItems.Remove(item); // db.SaveChanges(); //} foreach (DataGridViewRow r in dgvItems.Rows) { factor.BuyFactorItems.Add( new BuyFactorItem { Name = r.Cells["clnProductName"].Value.ToString(), Quantity = Convert.ToDouble(r.Cells["clnNumber"].Value), Price = Convert.ToDecimal(r.Cells["clnProductPrice"].Value), ProductId = Convert.ToInt32(r.Cells["clnProductId"].Value), TotalPrice = Convert.ToDecimal(r.Cells["clnTotalPrice"].Value) } ); } db.SaveChanges(); DesktopAlert.Show("فاکتور بروزرسانی شد", eDesktopAlertColor.Green, eAlertPosition.BottomRight); EditedFactor = factor; }
private void btnSave_Click(object sender, EventArgs e) { if (txtName.Text.Trim().Length == 0) { DesktopAlert.Show("نام نمی تواند خالی باشد", eDesktopAlertColor.Red, eAlertPosition.BottomRight); return; } decimal price; try { price = Convert.ToDecimal(txtPrice.Text); } catch { price = 0; } if (price == 0) { DesktopAlert.Show("قیمت کالا را وارد کنید", eDesktopAlertColor.Red, eAlertPosition.BottomRight); return; } // Profit decimal profit; try { profit = Convert.ToDecimal(txtProfit.Text); } catch { profit = 0; } // save data var db = new shampazEntities(); Product p; if (EditMode) { p = db.Products.Where(x => x.Id == ProductId).FirstOrDefault(); p.Name = txtName.Text.Trim(); p.Price = price; p.Profit = profit; DesktopAlert.Show("محصول بروزرسانی شد", eDesktopAlertColor.Green, eAlertPosition.BottomRight); } else { db.Products.Add(new Product { Name = txtName.Text.Trim(), Price = price, Profit = profit }); DesktopAlert.Show("محصول ثبت شد", eDesktopAlertColor.Green, eAlertPosition.BottomRight); } db.SaveChanges(); DialogResult = DialogResult.OK; Close(); }
private void deleteFactor(SellFactor factor) { var db = new shampazEntities(); db.SaveChanges(); }