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