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);
}
