public int saveRole(DTORole role) { cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "prc_GuardarRol"; cmd.Parameters.AddWithValue("@cod_rol", role.Role_Code); cmd.Parameters.AddWithValue("@nom_rol", role.Role_Name); cmd.Parameters.AddWithValue("@desc_rol", role.Role_Description); try { if (verifyRole(role.Role_Code) == true) { return(3); } else { con.Open(); cmd.ExecuteNonQuery(); return(1); } } catch (SqlException ex) { Console.WriteLine("Error" + ex.Message); con.Close(); return(0); } }
public async Task <IHttpActionResult> add([FromBody] DTORole role) { #region /// 检查输入信息正确性 if (!ModelState.IsValid) { return(BadRequest(this.GetModelStateError(ModelState))); } #endregion try { // 调用服务创建 var result = await Service.CreateAsync(role); // 根据服务返回值确定返回 if (result.ResultType == Common.OperationResultType.Success) { return(Ok(true)); } return(BadRequest(result.Message)); } catch (BusinessException ex) { return(BadRequest(ex.Message)); } catch (ComponentException ex) { return(BadRequest(ex.Message)); } }
/// <summary> /// 创建实体 /// </summary> /// <param name="entity"></param> /// <returns></returns> public virtual async Task <OperationResult> CreateAsync(DTORole entity) { //校验参数!=NULL PublicHelper.CheckArgument(entity, "entity"); // 实体模型转换 var role = DtoMap.Map <SysRole>(entity); // 校验实体 var validateResult = await Validator.ValidateAsync(role); if (validateResult.ResultType != OperationResultType.Success) { return(validateResult); } try { // 添加到实体集合中 Repository.Insert(role, AutoSaved); // 返回正确 return(new OperationResult(OperationResultType.Success)); } catch (DataAccessException ex) { return(new OperationResult(OperationResultType.Error, ex.Message)); } }
public DataTable listRoles(DTORole rol) { cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "prc_ListarRoles"; DataTable data = new DataTable(); SqlDataAdapter sda = new SqlDataAdapter(cmd); con.Open(); sda.Fill(data); con.Close(); return(data); }
public void AgregarRole(DTORole role) { string sSel; string sSelCount; bool exist; sSelCount = "SELECT COUNT(*) FROM \"tbl_Role\" WHERE \"idRole\" = " + role.IdRole + ";"; NpgsqlDataAdapter daCount; DataSet dtCount = new DataSet(); try { daCount = new NpgsqlDataAdapter(sSelCount, sConexion); daCount.Fill(dtCount); if (dtCount.Tables[0].Rows[0][0].ToString() == "0") { exist = false; } else { exist = true; } } catch (Exception) { exist = false; } if (!exist) { sSel = "INSERT INTO \"tbl_Role\" VALUES(" + role.IdRole + ",'" + role.Title + "','" + role.Description + "');"; NpgsqlDataAdapter da; DataSet dt = new DataSet(); try { da = new NpgsqlDataAdapter(sSel, sConexion); da.Fill(dt); } catch (Exception) { } } }
public int deleteRole(DTORole role) { cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "prc_EliminarRol"; cmd.Parameters.AddWithValue("@cod_rol", role.Role_Code); try { con.Open(); cmd.ExecuteNonQuery(); return(1); } catch (Exception ex) { Console.WriteLine("Error" + ex.Message); con.Close(); return(0); } }
static void InsertRole(XmlDocument doc) { try { Console.WriteLine("Roles"); DTORole role = new DTORole(); XmlNodeList roles = doc.ChildNodes[3].ChildNodes[0].ChildNodes[2].ChildNodes[0].ChildNodes; foreach (XmlNode r in roles) { role.IdRole = Int64.Parse(r.Attributes["id"].Value); role.Title = r.Attributes["title"].Value; role.Description = r.Attributes["desc"].Value; conexion.AgregarRole(role); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
/// <summary> /// 更新实体 /// </summary> /// <param name="entity"></param> /// <returns></returns> public virtual async Task <OperationResult> UpdateAsync(DTORole entity) { /// 更新角色信息 /// 考虑是否需要限制更改角色名称 /// 其他更新信息同样存在这个问题 //校验参数!=NULL PublicHelper.CheckArgument(entity, "entity"); // 获取用户 var role = Repository.Entities.SingleOrDefault(m => m.Name.Equals(entity.Name)); if (role == null) { return(new OperationResult(OperationResultType.Warning, String.Format(CultureInfo.CurrentCulture, Systems.SysResources.RoleNotExist , entity.Name))); } // 实体模型转换 role = DtoMap.Map <DTORole, SysRole>(entity, role); // 校验实体 var validateResult = await Validator.ValidateAsync(role); if (validateResult.ResultType != OperationResultType.Success) { return(validateResult); } try { //更新实体 Repository.Update(role, AutoSaved); // 返回正确 return(new OperationResult(OperationResultType.Success)); } catch (DataAccessException ex) { return(await Task.FromResult <OperationResult>( new OperationResult(OperationResultType.Error, ex.Message))); } }