private void SoftDelete(tblM_Menu menu) { if (menu != null) { menu.Status_FK = (int)RecordStatus.Deleted; } }
public SaveResult <MenuEntryModel> Save(MenuDTO menuDTO, DateTime dateStamp) { ModelValidationResult validationResult = menuValidator.Validate(menuDTO); bool success = false; MenuEntryModel model = null; if (!validationResult.IsValid) { return(new SaveResult <MenuEntryModel> { Success = success, Message = validationResult.IsValid ? "Data successfully created." : "Validation error occured.", Model = model, ValidationResult = validationResult }); } tblM_Menu menu = AddMenu(menuDTO, dateStamp); Db.SaveChanges(); success = true; model = menuEntryDataProvider.Get(menu.Menu_PK); return(new SaveResult <MenuEntryModel> { Success = success, Message = validationResult.IsValid ? "Data successfully created." : "Validation error occured.", Model = model, ValidationResult = validationResult }); }
private void HardDelete(tblM_Menu menu) { if (menu != null) { Db.tblM_Menu.Remove(menu); } }
public void UpdateMenu(MenuDTO menuDTO, DateTime dateStamp) { if (menuDTO == null) { throw new ArgumentNullException("Menu model is null."); } tblM_Menu menu = menuFactory.CreateFromDbAndUpdateFromDTO(menuDTO, dateStamp); }
public tblM_Menu AddMenu(MenuDTO menuDTO, DateTime dateStamp) { if (menuDTO == null) { throw new ArgumentNullException("Menu model is null."); } tblM_Menu menu = menuFactory.CreateFromDTO(menuDTO, dateStamp); return(Db.tblM_Menu.Add(menu)); }
public tblM_Menu CreateFromDTO(MenuDTO menuDTO, DateTime dateStamp) { if (menuDTO == null) { throw new ArgumentNullException("Menu model is null."); } menuDTO.Status_FK = (int)RecordStatus.Active; menuDTO.CreatedBy = User.Username; menuDTO.CreatedDate = dateStamp; menuDTO.UpdatedBy = User.Username; menuDTO.UpdatedDate = dateStamp; tblM_Menu menu = menuDTO.ToObject <tblM_Menu>(); return(menu); }
public OutputModel AddMenu([FromBody] tblM_Menu menu) { OutputModel output = new OutputModel(); try { menu.isActive = 1; menu.DateCreated = DateTime.Now; db_masakin.tblM_Menu.Add(menu); db_masakin.SaveChanges(); var data = db_masakin.tblM_Menu.Where(p => p.MerchantID == menu.MerchantID && p.Name == menu.Name && p.Description == menu.Description && p.Price == menu.Price && p.isActive == 1).FirstOrDefault(); if (data != null) { output.status = "success"; output.message = null; output.data = data; } else { output.status = "failed"; output.message = "Menu not found"; output.data = null; } } catch (Exception ex) { output.status = "error"; output.message = ex.Message; output.data = null; } return(output); }
public DeleteResult <tblM_Menu> Execute(int menuPK, DeleteMethod deleteMethod) { tblM_Menu menu = Db.tblM_Menu.Find(menuPK); if (menu == null) { return(new DeleteResult <tblM_Menu>() { Success = false, Message = $"Id '{menuPK}' is not found.", Record = null }); } switch (deleteMethod) { case DeleteMethod.Soft: SoftDelete(menu); break; case DeleteMethod.Hard: HardDelete(menu); break; default: break; } Db.SaveChanges(); return(new DeleteResult <tblM_Menu>() { Success = true, Message = $"Menu with Id '{menuPK}' successfully deleted.", Record = menu }); }
public OutputModel UpdateMenu([FromBody] tblM_Menu menu) { OutputModel output = new OutputModel(); try { var data = db_masakin.tblM_Menu.Where(p => p.MenuID == menu.MenuID && p.MerchantID == menu.MerchantID).FirstOrDefault(); if (data != null) { data.Name = menu.Name; data.Description = menu.Description; data.Price = menu.Price; data.ImageURL = menu.ImageURL; data.ThumbnailURL = menu.ThumbnailURL; db_masakin.SaveChanges(); output.status = "success"; output.message = null; output.data = data; } else { output.status = "failed"; output.message = "Menu not found"; output.data = null; } } catch (Exception ex) { output.status = "error"; output.message = ex.Message; output.data = null; } return(output); }