protected void ddlRole_SelectedIndexChanged(object sender, EventArgs e)
{
if (this.ddlRole.SelectedIndex <= 0)
{
return;
}
TicketUsersType tmpType = (TicketUsersType)int.Parse(this.ddlRole.SelectedValue);
if (tmpType == TicketUsersType.Dev)
{
this.rptAssignUser.DataSource = userList.FindAll(r => (r.Role == RolesEnum.DEV ||
r.Role == RolesEnum.Leader || r.Role == RolesEnum.Contactor));
}
else if (tmpType == TicketUsersType.QA)
{
this.rptAssignUser.DataSource = userList.FindAll(r => r.Role == RolesEnum.QA);
}
else if (tmpType == TicketUsersType.Other)
{
this.rptAssignUser.DataSource = from a in userList
where (from b in tiketUserEntityList
where a.UserID.Equals(b.UserID)
select b.UserID).Count() == 0
select a;
}
this.rptAssignUser.DataBind();
}
private string GetUnameByRoleTypeAndTicketId(int ticketID, TicketUsersType role)
{
List <TicketUsersEntity> list = ticketsUserRpst.GetListUsersByTicketId(ticketID);
TicketUsersEntity tu = new TicketUsersEntity();
switch (role)
{
case TicketUsersType.PM:
tu = list.FindAll(x => x.Type == TicketUsersType.PM)[0];
break;
case TicketUsersType.Dev:
break;
case TicketUsersType.QA:
break;
case TicketUsersType.Other:
break;
case TicketUsersType.Create:
break;
default:
break;
}
if (null != tu)
{
return(GetNameById(tu.UserID));
}
return("");
}
public string ShowIsExitsInTicketUser(int uid)
{
string check = "";
TicketUsersType tmpType = (TicketUsersType)int.Parse(this.ddlRole.SelectedValue);
TicketUsersEntity tmpTicketUsersEntity = tiketUserEntityList.Find(r => r.UserID == uid && r.Type == tmpType);
if (null != tmpTicketUsersEntity)
{
check = string.Format("<input type='checkbox' checked='checked'id='{0}' />", uid);
}
else
{
check = string.Format("<input type='checkbox' id='{0}' />", uid);
}
return(check);
}
public void UpdateTicketUserType(int userID, TicketUsersType type, int ticketID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dbo.TicketUsers set type=@type ")
.Append(" where User=@User and TicketID =@ticketID ");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
db.AddInParameter(dbCommand, "userID", DbType.Int32, userID);
db.AddInParameter(dbCommand, "type", DbType.Int32, (int)type);
db.AddInParameter(dbCommand, "ticketID", DbType.Int32, (int)ticketID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
db.ExecuteNonQuery(dbCommand);
}
}
}
public List <TicketUsersEntity> GetTicketUser(int ticketID, TicketUsersType type)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from TicketUsers ");
strSql.AppendFormat(" where TicketID=@TicketID and [type] = {0} ", (int)type);
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "TicketID", DbType.Int32, ticketID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
var list = new List <TicketUsersEntity>();
while (dataReader.Read())
{
list.Add(TicketUsersEntity.ReaderBind(dataReader));
}
return(list);
}
return(null);
}
public List <TicketUsersEntity> GetTicketUser(int ticketID, TicketUsersType type)
{
return(ticketUserRpst.GetTicketUser(ticketID, type));
}
public void UpdateTicketUserType(int userID, TicketUsersType type, int ticketID)
{
ticketUserRpst.UpdateTicketUserType(userID, type, ticketID);
}
