public ActionResult <NoteListItem> NoteGet(Guid rowGuid)
{
CU_B_NOTE Item = DBContext.CU_B_NOTE.FirstOrDefault(E => E.ROWGUID == rowGuid);
if (Item == null)
{
throw new NotFoundException($"No note found with RowGuid:{rowGuid}");
}
NoteListItem Result = EntityMapper.Map <NoteListItem, CU_B_NOTE>(DBContext, Item);
return(Result);
}
public override void LoadData <T>(DbContext context, dynamic entity)
{
base.LoadData <T>(context, (T)entity);
CustomersContext DBContext = (CustomersContext)context;
if (entity is CU_B_NOTE)
{
CU_B_NOTE Item = (CU_B_NOTE)entity;
ActivityTypeDescription = Item.SY_ACTIVITY_TYPE?.ACTIVITY_TYPE_DESCR;
if (Item.EMPLOYEE_CODE != null)
{
EmployeeDescription = DBContext.CM_S_EMPLOYEE.FirstOrDefault(E => E.EMPLOYEE_CODE == Item.EMPLOYEE_CODE)?.EMPLOYEE_DESCR;
}
DocumentTypeDescription = Item.SY_DOCUMENT_TYPE?.DOCUMENT_TYPE_DESCR;
}
}
public void NotePut(Guid rowGuid, [FromBody] NoteBase value)
{
if (value == null)
{
throw new ArgumentNullException($"Argument value cannot be null");
}
CU_B_NOTE Item = DBContext.CU_B_NOTE.SingleOrDefault(E => E.COMPANY_CODE == Settings.Value.CompanyCode && E.DIVISION_CODE == Settings.Value.DivisionCode && E.ROWGUID == rowGuid);
if (Item == null)
{
throw new NotFoundException($"No note found with RowGuid:{rowGuid}");
}
EntityMapper.UpdateEntity(value, Item);
value.SaveData <CU_B_NOTE>(DBContext, Item);
DBContext.SaveChanges();
}
public ActionResult <NoteListItem> NotePost([FromBody] NoteBase value)
{
if (value == null)
{
throw new ArgumentNullException($"Argument value cannot be null");
}
CU_B_NOTE Item = EntityMapper.CreateEntity <CU_B_NOTE>();
EntityMapper.UpdateEntity(value, Item);
Item.NOTE_DATE = DateTime.Today;
CU_B_NOTE LastNote = DBContext.CU_B_NOTE.Where(E => E.CUSTOMER_CODE == Item.CUSTOMER_CODE && E.NOTE_DATE == Item.NOTE_DATE).OrderByDescending(E => E.NOTE_COUNTER).FirstOrDefault();
Item.NOTE_COUNTER = LastNote != null ? LastNote.NOTE_COUNTER + 1 : 1;
value.SaveData <CU_B_NOTE>(DBContext, Item);
DBContext.CU_B_NOTE.Add(Item);
DBContext.SaveChanges();
return(NoteGet(Item.ROWGUID));
}
