public void DeleteProducer(int id) { PRODUCER producer = dataAccess.PRODUCERs.Single(p => p.PRODUCERID == id); dataAccess.PRODUCERs.DeleteOnSubmit(producer); dataAccess.SaveChanges(); }
//добавление строки private void AddData(Object o) { newRow = new PRODUCER(); newRow.PROD_NAME = ""; data.Add(newRow); selectedRow = newRow; isEnabled = true; focus(); }
public void UpdateProducer(PRODUCER producer) { PRODUCER p = dataAccess.PRODUCERs.Single(pp => pp.PRODUCERID == producer.PRODUCERID); p.NAME = producer.NAME; p.EMAIL = producer.EMAIL; p.ADDRESS = producer.ADDRESS; p.CONTACT = producer.CONTACT; dataAccess.SaveChanges(); }
//Удаление заказчика и всех его исследований private void DeleteData(PRODUCER focusedRow) { if (focusedRow == null || focusedRow.PROD_ID == 0) { return; } try { methodsEntities.PRODUCER.Remove( methodsEntities.PRODUCER.Where(p => p.PROD_ID == focusedRow.PROD_ID).FirstOrDefault()); methodsEntities.SaveChanges(); } catch (Exception) { MessageBox.Show("Строка не может быть удалена, т.к. ссылка на неё используется в других таблицах"); return; } RaisePropertyChanged(() => data); }
public ActionResult Edit(int id, PRODUCER producer) { try { if (ModelState.IsValid) { ProducerModel.Update(producer); ViewBag.Message = SuccessMessage.PRODUCER_EDITED; } else { ViewBag.ErrorMessage = ErrorMessage.REQUIRED_ASTERIC_FIELDS; } return(View()); } catch { ViewBag.ErrorMessage = ErrorMessage.INTERNAL_ERROR; return(View()); } }
public void InsertProducer(PRODUCER producer) { dataAccess.PRODUCERs.InsertOnSubmit(producer); dataAccess.SaveChanges(); }
internal static void Update(PRODUCER producer) { Services.UpdateProducer(producer); }
internal static void Create(PRODUCER producer) { Services.InsertProducer(producer); }