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