public DataResponse <EntityMarketingCategories> Update(EntityMarketingCategories entity)
        {
            var response = new DataResponse <EntityMarketingCategories>();

            try
            {
                base.DBInit();


                #region Prepare model
                var model = DBEntity.LookupMarketingCategories.FirstOrDefault(a => a.Id == entity.Id);
                model.Category  = entity.Category;
                model.UpdatedBy = entity.UpdatedBy;
                model.UpdatedOn = entity.UpdatedOn;
                #endregion

                if (base.DBSaveUpdate(model) > 0)
                {
                    return(GetMarketingCategoryById(model.Id));
                }
                else
                {
                    response.CreateResponse(DataResponseStatus.InternalServerError);
                }
            }
            catch (Exception ex)
            {
                ex.Log();
            }
            finally
            {
                base.DBClose();
            }
            return(response);
        }
        public IHttpActionResult InsertMarketingCategoryData(EntityMarketingCategories model)
        {
            var response = new DataResponse <EntityMarketingCategories>();

            if (ModelState.IsValid)
            {
                model.UpdatedBy  = model.CreatedBy = CurrentUserId;
                model.BusinessId = CurrentBusinessId.Value;
                if (model.Id > 0)
                {
                    response = new RepositoryMarketingCategories().Update(model);
                }
                else
                {
                    response = new RepositoryMarketingCategories().Insert(model);
                }
                return(Ok <DataResponse>(response));
            }
            else
            {
                var errorList = ModelState.Where(a => a.Value.Errors.Any()).Select(s => new
                {
                    Key     = s.Key.Split('.').Last(),
                    Message = s.Value.Errors[0].ErrorMessage
                });
                return(Ok <dynamic>(new { Status = HttpStatusCode.BadRequest, Model = errorList }));
            }
        }
        public DataResponse <EntityMarketingCategories> Insert(EntityMarketingCategories entity)
        {
            var response = new DataResponse <EntityMarketingCategories>();

            try
            {
                base.DBInit();

                var model = new Database.LookupMarketingCategory
                {
                    Category   = entity.Category,
                    BusinessId = entity.BusinessId,
                    CreatedOn  = entity.CreatedOn,
                    CreatedBy  = entity.CreatedBy
                };
                if (base.DBSave(model) > 0)
                {
                    return(GetMarketingCategoryById(model.Id));
                }
                else
                {
                    response.CreateResponse(DataResponseStatus.InternalServerError);
                }
            }
            catch (Exception ex)
            {
                ex.Log();
            }
            finally
            {
                base.DBClose();
            }
            return(response);
        }