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 update() { var db = new shampazEntities(); var factor = db.SellFactors.Where(x => x.Id == EditedSellFactor.Id).FirstOrDefault(); factor.Date = (DateTime)pdpDate.GeorgianDate + dtpTime.Value.TimeOfDay; factor.PersonId = SelectedPerson.Id; factor.TotalPrice = Convert.ToDecimal(txtTotalPrice.Text); factor.Description = txtDescription.Text; //MessageBox.Show(factor.Id.ToString()); db.SellFactorItems.RemoveRange(factor.SellFactorItems); //foreach( var item in factor.SellFactorItems ) //{ // db.SellFactorItems.Remove(item); // db.SaveChanges(); //} 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 deleteFactor(SellFactor factor) { var db = new shampazEntities(); db.SaveChanges(); }