public IHttpActionResult EditGrantType(dto_grant_type_updateC _dto) { var _grantTypeService = _ServiceFactory.GetService<IGrantTypeService>(); _grantTypeService.controller_key = _controller_key; var _updated = _grantTypeService.Update(_dto).Result; if (!this.ModelState.IsValid) { return BadRequest(this.ModelState.ToErrorMessage());; } return Ok(_updated); }
public Task <bool> Update(dto_grant_type_updateC _dto) { bool _updated = false; if (string.IsNullOrEmpty(_dto.grant_type_name)) { AddErrorMessage("Update Error", "Save Error", "Grant Type Name Is Null!"); return(Task.FromResult(_updated)); } if (fnn.LOGGED_USER.DoesNotHaveRight(em.right_menu_types.can_edit_grant_info)) { _updated = false; AddErrorMessage("Limited Rights Error", "Limited Rights Error", "You Are Not Authorized To Perform This Operation"); return(Task.FromResult(_updated)); } using (var _trans = new ZUpdateContext()) { var _existing = _trans.Context.GRANT_TYPES.Where(e => e.grant_type_id == _dto.grant_type_id & e.delete_id == 0).FirstOrDefault(); if (_existing == null) { _updated = false; AddErrorMessage("Update Error", "Save Error", "Unable To Find Grant Type Object"); return(Task.FromResult(_updated)); } if (_existing.grant_type_name.ToLower() != _dto.grant_type_name.ToLower()) { var _ret = DbHelper.UpdatePrimaryKeyColumn(new DbHelperPrimarykeyUpdateC { col_to_update = "grant_type_name", new_col_value = _dto.grant_type_name.Trim().ToProperCase(), table_name = DbHelper.GetTableSchemaName(_table_name), pk_col_name = "grant_type_id", pk_id = _dto.grant_type_id }, _trans.Context); if (_ret == null || _ret.Value == false) { AddErrorMessage("Error", "Update Error", "Grant Type Name Already Exists"); _updated = false; return(Task.FromResult(_updated)); } else { _updated = true; _trans.Context.SaveChanges(); _trans.Commit(); } } _updated = true; if (_updated) { List <DbParameter> _para = new List <DbParameter>(); _para.Clear(); int _cat_type_id = em.resource_cat_typeS.grant_type.ToInt32(); var _r_list = (from k in _trans.Context.VOICE_RESOURCE_CATEGORIES where k.resource_cat_type_id == _cat_type_id & k.resource_cat_id == _existing.grant_type_id & k.delete_id == 0 select k).ToList(); foreach (var _v in _r_list) { _para.Clear(); _para.Add(fnn.GetDbParameters("@v1", _existing.grant_type_id)); _para.Add(fnn.GetDbParameters("@v2", fnn.GetServerDate().ToUnixTimestamp())); _para.Add(fnn.GetDbParameters("@v3", System.DBNull.Value)); _para.Add(fnn.GetDbParameters("@v4", _dto.grant_type_name.Trim().ToProperCase())); var _sql = string.Format(string.Format("update {0} set fs_timestamp=@v2,resource_cat_img_url=@v3" + ",resource_cat_name=@v4 where un_id = @v1 and delete_id = 0", DbHelper.GetTableSchemaName("voice_resource_cat_tb"))); _trans.Context.Database.ExecuteSqlCommand(_sql, _para.ToArray()); _trans.Context.SaveChanges(); } } } return(Task.FromResult(_updated)); }