/// <summary>
/// Update a record
/// </summary>
public bool Update(HideUserEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE dbo.HideUsers SET ");
strSql.Append("UserID=@UserID, ");
strSql.Append("HideUserIds=@HideUserIds ");
strSql.Append("WHERE ID=@ID; ");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "UserID", DbType.Int32, model.UserID);
db.AddInParameter(dbCommand, "HideUserIds", DbType.String, model.HideUserIds);
db.AddInParameter(dbCommand, "ID", DbType.Int32, model.ID);
int rows = db.ExecuteNonQuery(dbCommand);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(false);
}
}
}
/// <summary>
/// Add a record
/// </summary>
public int Insert(HideUserEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO dbo.HideUsers ");
strSql.Append("( UserID, HideUserIds )");
strSql.Append("VALUES (@UserID,@HideUserIds); ");
strSql.Append(";SELECT ISNULL( SCOPE_IDENTITY(),0);");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "UserID", DbType.Int32, model.UserID);
db.AddInParameter(dbCommand, "HideUserIds", DbType.String, model.HideUserIds);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(0);
}
}
}
public HideUserEntity GetHideUserByUserId(int userId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT TOP 1 * FROM dbo.HideUsers AS HU ");
strSql.Append("WHERE HU.UserID = @UserID; ");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "UserID", DbType.Int32, userId);
HideUserEntity model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = HideUserEntity.ReaderBind(dataReader);
}
}
return(model);
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(null);
}
}
}
public HideUserEntity GetHideUserByUserId(int userId)
{
this.ClearBrokenRuleMessages();
HideUserEntity hideUserEntity = mgr.GetHideUserByUserId(userId);
this.AddBrokenRuleMessages(mgr.BrokenRuleMessages);
return(hideUserEntity);
}
public bool UpdateHideUsers(HideUserEntity hideUser)
{
this.ClearBrokenRuleMessages();
bool updated = mgr.UpdateHideUsers(hideUser);
this.AddBrokenRuleMessages(mgr.BrokenRuleMessages);
return(updated);
}
public int AddHideUsers(HideUserEntity hideUser)
{
this.ClearBrokenRuleMessages();
int id = mgr.AddHideUsers(hideUser);
this.AddBrokenRuleMessages(mgr.BrokenRuleMessages);
return(id);
}
public bool UpdateHideUsers(HideUserEntity hideUser)
{
this.ClearBrokenRuleMessages();
BaseValidator <HideUserEntity> validator = new UpdateHideUserValidator();
if (!validator.Validate(hideUser))
{
this.AddBrokenRuleMessages(validator.BrokenRuleMessages);
return(false);
}
if (!hideUserRepository.Update(hideUser))
{
this.AddBrokenRuleMessage();
return(false);
}
return(true);
}
public int AddHideUsers(HideUserEntity hideUser)
{
this.ClearBrokenRuleMessages();
BaseValidator <HideUserEntity> validator = new AddHideUserValidator();
if (!validator.Validate(hideUser))
{
this.AddBrokenRuleMessages(validator.BrokenRuleMessages);
return(0);
}
int id = hideUserRepository.Insert(hideUser);
if (id <= 0)
{
this.AddBrokenRuleMessage();
return(0);
}
hideUser.ID = id;
return(id);
}
private string GetUserTickets(int currentUserId)
{
List <RolesEnum> roles = new List <RolesEnum>();
roles.Add(RolesEnum.PM);
roles.Add(RolesEnum.DEV);
roles.Add(RolesEnum.QA);
roles.Add(RolesEnum.Leader);
HideUserEntity entity = userApp.GetHideUserByUserId(currentUserId);
string hideUserIds = "";
if (entity != null)
{
hideUserIds = entity.HideUserIds;
}
List <UserTicketModel> userTickets = userApp.SearchUserWithRole(roles, hideUserIds);
string strUserTickets = JsonConvert.SerializeObject(userTickets);
return(strUserTickets);
}