public RoleInfo GetRoleByName(string roleName)
{
RoleDal dal = new RoleDal();
DataSet ds = dal.GetRoleByName(roleName);
RoleInfo roleInfo = new RoleInfo();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
roleInfo = ConvertToModel(ds.Tables[0].Rows[0]);
}
return roleInfo;
}
public void AddRole(RoleInfo roleInfo)
{
string sql = "insert into U_RoleInfo(RoleName,Introduction)values(@RoleName,@Introduction)";
List<SqlParameter> lstParamter = new List<SqlParameter>();
SqlParameter paramter = new SqlParameter("@RoleName", roleInfo.RoleName);
lstParamter.Add(paramter);
paramter = new SqlParameter("@Introduction", roleInfo.Introduction);
lstParamter.Add(paramter);
SQLHelp.ExecuteNonQuery(sql, lstParamter);
}
public void UpdateRole(RoleInfo roleInfo)
{
string sql = "update U_RoleInfo set RoleName=@RoleName,Introduction=@Introduction where RoleId=@RoleId";
List<SqlParameter> lstParamter = new List<SqlParameter>();
SqlParameter paramter = new SqlParameter("@RoleName", roleInfo.RoleName);
lstParamter.Add(paramter);
paramter = new SqlParameter("@Introduction", roleInfo.Introduction);
lstParamter.Add(paramter);
paramter = new SqlParameter("@RoleId", roleInfo.RoleId);
lstParamter.Add(paramter);
SQLHelp.ExecuteNonQuery(sql, lstParamter);
}
public void UpdateRole(RoleInfo roleInfo)
{
RoleDal dal = new RoleDal();
dal.UpdateRole(roleInfo);
}
public void AddRole(RoleInfo roleInfo)
{
RoleDal dal = new RoleDal();
dal.AddRole(roleInfo);
}
private RoleInfo ConvertToModel(DataRow dr)
{
RoleInfo roleInfo = new RoleInfo();
if(dr!=null)
{
if (dr["RoleId"] is DBNull == false)
{
int roleId = 0;
int.TryParse(dr["RoleId"].ToString(), out roleId);
roleInfo.RoleId = roleId;
}
if (dr["RoleName"] is DBNull == false)
{
roleInfo.RoleName = dr["RoleName"].ToString();
}
if (dr["Introduction"] is DBNull == false)
{
roleInfo.Introduction = dr["Introduction"].ToString();
}
}
return roleInfo;
}
private RoleInfo GetModel()
{
RoleInfo roleInfo = new RoleInfo();
roleInfo.RoleName = txtRoleName.Text.Trim();
roleInfo.Introduction = txtRoleName.Text.Trim();
return roleInfo;
}