protected void btnMove_Click(object sender, EventArgs e) { if (Page.IsValid) { string strID = string.Empty; if (Request.QueryString["id"] != null) { strID = Request.QueryString["id"].ToString(); } if (Request.QueryString["did"] != null) { strID = Request.QueryString["did"].ToString(); } if (strID.Length > 0) { dsRequestorsTableAdapters.licenseeTableTableAdapter licenseeTableTA = new dsRequestorsTableAdapters.licenseeTableTableAdapter(); dsRequestors.licenseeTableDataTable licenseeTableDT = new dsRequestors.licenseeTableDataTable(); licenseeTableDT = licenseeTableTA.GetLicenseesByRequestorTable(Convert.ToInt32(strID)); string tmp = string.Empty; foreach (DataRow dr in licenseeTableDT) { if (dr["RequestorID"] != DBNull.Value) { dr["RequestorID"] = Convert.ToInt32(ddlMLBContacts.SelectedValue); //tmp += dr["id"].ToString() + ":"; } //tmp += dr["RequestorID"].ToString() + ":"; //if (cblLicensees.Items.FindByValue(dr["id"].ToString()).Selected) //{ // dr["RequestorID"] = Convert.ToInt32(strID); //} //else //{ // dr["RequestorID"] = DBNull.Value; //} } //lblMoveDone.Text = tmp; licenseeTableTA.Update(licenseeTableDT); //Display the requester name dsRequestorsTableAdapters.requestorsTableAdapter requestorsTA = new dsRequestorsTableAdapters.requestorsTableAdapter(); dsRequestors.requestorsDataTable requestorsDT = new dsRequestors.requestorsDataTable(); requestorsDT = requestorsTA.GetRequestorByID(Convert.ToInt32(strID)); string ln = ddlMLBContacts.SelectedItem.Text.Substring(0, ddlMLBContacts.SelectedItem.Text.IndexOf(" ") - 1); string fn = ddlMLBContacts.SelectedItem.Text.Substring(ddlMLBContacts.SelectedItem.Text.IndexOf(" ") + 1); lblMoveDone.Text = requestorsDT[0]["FirstName"].ToString() + " " + requestorsDT[0]["LastName"].ToString() + "'s ALL users been assigned to <br>'" + fn + " " + ln + "' SUCCESSFULLY!"; // Response.Redirect("RequesterMgr.aspx?id=" + ddlMLBContacts.SelectedValue); PopulateCblLicensees(); } } }
protected void btnSave_Click(object sender, EventArgs e) { string strID = string.Empty; if (Request.QueryString["id"] != null) { strID = Request.QueryString["id"].ToString(); } if (Request.QueryString["did"] != null) { strID = Request.QueryString["did"].ToString(); } if (strID.Length > 0) { dsRequestorsTableAdapters.licenseeTableTableAdapter licenseeTableTA = new dsRequestorsTableAdapters.licenseeTableTableAdapter(); dsRequestors.licenseeTableDataTable licenseeTableDT = new dsRequestors.licenseeTableDataTable(); licenseeTableDT = licenseeTableTA.GetLicenseesByRequestorTable(Convert.ToInt32(strID)); foreach (DataRow dr in licenseeTableDT) { if (cblLicensees.Items.FindByValue(dr["id"].ToString()).Selected) { dr["RequestorID"] = Convert.ToInt32(strID); } else { dr["RequestorID"] = DBNull.Value; } } licenseeTableTA.Update(licenseeTableDT); /* * dsRequestorsTableAdapters.licenseeTableAdapter licenseeTA = new dsRequestorsTableAdapters.licenseeTableAdapter(); * dsRequestors.licenseeDataTable licenseeDT = new dsRequestors.licenseeDataTable(); * licenseeDT = licenseeTA.GetLicenseesByRequestor(Convert.ToInt32(Request.QueryString["id"].ToString())); * foreach (DataRow dr in licenseeDT) * { * if (cblLicensees.Items.FindByValue(dr["ID"].ToString()).Selected) * { * dr["RequestorID"] = Convert.ToInt32(Request.QueryString["id"].ToString()); * * } * * * * } * */ //Display the requester name dsRequestorsTableAdapters.requestorsTableAdapter requestorsTA = new dsRequestorsTableAdapters.requestorsTableAdapter(); dsRequestors.requestorsDataTable requestorsDT = new dsRequestors.requestorsDataTable(); requestorsDT = requestorsTA.GetRequestorByID(Convert.ToInt32(strID)); lblDone.Text = requestorsDT[0]["FirstName"].ToString() + " " + requestorsDT[0]["LastName"].ToString() + "'s user list has been updated SUCCESSFULLY!"; ddlMLBContacts.Enabled = false; btnMove.Enabled = false; lblDone.Visible = true; pnlEdit.Visible = true; pnlUsers.Visible = false; } else { Response.Redirect("RequesterMgr.aspx"); } }