protected void Page_Load(object sender, EventArgs e)
{
if (!User.Identity.IsAuthenticated)
FormsAuthentication.RedirectToLoginPage();
m_ticketId = new Guid(Request.QueryString["Id"]);
if (!Page.IsPostBack)
{
TicketsUsersTableAdapter trta = new TicketsUsersTableAdapter();
Tracker.TicketsUsersDataTable dt = trta.GetTicketsByTicketId(m_ticketId);
foreach (GridViewRow row in Resources.Rows)
{
Label id = row.FindControl("Id") as Label;
foreach (Tracker.TicketsUsersRow tr in dt)
{
if (tr.UserId.ToString().Equals(id.Text))
{
CheckBox cb = row.FindControl("SelectUser") as CheckBox;
cb.Checked = true;
}
}
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Assign_Click(object sender, EventArgs e)
{
int count = Resources.Rows.Count;
TicketsUsersTableAdapter trta = new TicketsUsersTableAdapter();
MembershipUser myObject = Membership.GetUser();
string UserID = myObject.ProviderUserKey.ToString();
bool atLeastOneChecked = false;
foreach (GridViewRow row in Resources.Rows)
{
object name = row.FindControl("Username") as object;
CheckBox cb = row.FindControl("SelectUser") as CheckBox;
Label txt = row.FindControl("Id") as Label;
Guid id = new Guid(txt.Text);
int nRecords = (int)trta.DoesRecordExist(m_ticketId, id);
if ((nRecords == 0) && cb.Checked)
{
// store data in database...
trta.Insert(id, m_ticketId, DateTime.Now, new Guid(UserID));
atLeastOneChecked = true;
}
else if ((nRecords > 0) && !cb.Checked)
{
// delete record...
trta.DeleteTicketByUserId(id, m_ticketId);
}
}
Context.Items.Add("TicketId", m_ticketId);
TicketsBLL bll = new TicketsBLL();
bll.statusId = (Guid)Utility.StatusId(atLeastOneChecked ? "In Progress" : "Pending");
bll.Id = new Guid(Request.QueryString["Id"]);
bll.Update();
GoBack();
}
public static bool IsAssigned(object id)
{
TicketsUsersTableAdapter trta = new TicketsUsersTableAdapter();
return (int)trta.spIsAssigned((Guid)id) > 0;
}
