protected void InsertCPOpportunity(int RoleAlignment, int iCharacterID, int iEventID, int iRegistrationID, string PointsFrom) { int iReasonID = 0; switch (ddlRoles.SelectedItem.Text) { case "PC": iReasonID = 3; break; case "NPC": iReasonID = 1; break; case "Staff": RoleAlignment = 12; break; default: break; } Classes.cPoints cPoints = new Classes.cPoints(); cPoints.CreateRegistrationCPOpportunity(Master.UserID, Master.CampaignID, RoleAlignment, iCharacterID, iReasonID, iEventID, iRegistrationID, PointsFrom); }
protected void AddOpportunityAndAudit(int AddAudit) { // Add Opportunity record Classes.cPoints Points = new Classes.cPoints(); int Qty = Int32.Parse(ddlQtyClaim.SelectedValue); int CharacterID = 0; int RegistrationID = 0; int CPOppID = 0; int CPOpportunityID = Convert.ToInt32(Session["CampaignCPOpportunityDefaultID"]); int PlayerReceivingCP = Int32.Parse(ddlReceivingPlayer.SelectedValue); string DeliveryMethod = ddlDelivery.SelectedItem.ToString(); int PlayerEarningCP = Int32.Parse(Session["CampaignPlayerID"].ToString()); int EventID = Convert.ToInt32(Session["EventID"].ToString()); int DonationID = Convert.ToInt32(Session["DonationID"].ToString()); string URL = ""; int ReasonID = 2; int ApprovedByID = 0; int StatusID; int ReceivedByID = 0; int AcceptedBy = 0; string PlayerComments = tbCommentsToStaff.Text; string StaffComments = ""; string Comments = ""; // DonationClaimID -1 = Claiming player getting points / -2 = Points going to another player int DonationClaimID = -1; if (PlayerReceivingCP != PlayerEarningCP) { DonationClaimID = -2; } DateTime CPAssignmentDate = DateTime.Today; DateTime ReceiptDate = DateTime.Parse("0001-01-01"); int AddedByID = Master.UserID; double CPValue = double.Parse(Session["Worth"].ToString()) * double.Parse(ddlQtyClaim.SelectedValue); // If AddAudit is 1 then add Opportunity AND Audit record. If AddAudit = 0 then only add Opportunity. if (AddAudit == 1) // Opp and audit { StatusID = 21; } else // Opportunity only { StatusID = 19; } Points.AddDonationOpportunity(Master.UserID, PlayerReceivingCP, CharacterID, CPOpportunityID, EventID, Master.CampaignID, lblItem.Text, PlayerComments, URL, ReasonID, StatusID, AddedByID, CPValue, ApprovedByID, ReceiptDate, ReceivedByID, CPAssignmentDate, "", "Donation", AddAudit, DonationClaimID, PlayerEarningCP); DonationClaimID = -1; CPOppID = Convert.ToInt32(Session["CampaignCPOpportunityID"].ToString()); Classes.cDonation Claim = new Classes.cDonation(); Claim.SaveDonationClaims(Master.UserID, DonationClaimID, DonationID, PlayerEarningCP, Qty, RegistrationID, CPOppID, PlayerComments, StaffComments, DeliveryMethod, PlayerEarningCP, ReceiptDate, AcceptedBy, Comments); }
protected void btnApproveAll_Click(object sender, EventArgs e) { MethodBase lmth = MethodBase.GetCurrentMethod(); string lsRoutineName = lmth.DeclaringType + "." + lmth.Name; DataView dvPELs = Session["PELApprovalList_dvPELs"] as DataView; dvPELs.RowFilter = dvPELs.RowFilter + " and (DateApproved is null)"; foreach (DataRowView dRow in dvPELs) { int iRegistrationID; if (int.TryParse(dRow["RegistrationID"].ToString(), out iRegistrationID)) { int iPELID; int.TryParse(dRow["PELID"].ToString(), out iPELID); SortedList sParams = new SortedList(); sParams.Add("@UserID", Master.UserID); sParams.Add("@PELID", iPELID); double dCPAwarded; if (double.TryParse(dRow["CPValue"].ToString(), out dCPAwarded)) { sParams.Add("@CPAwarded", dCPAwarded); } sParams.Add("@DateApproved", DateTime.Now); Classes.cUtilities.PerformNonQuery("uspInsUpdCMPELs", sParams, "LARPortal", Master.UserName); Classes.cPoints Points = new Classes.cPoints(); //int UserID = 0; int CampaignPlayerID = 0; int CharacterID = 0; int CampaignCPOpportunityDefaultID = 0; int EventID = 0; int ReasonID = 0; int CampaignID = 0; double CPAwarded = 0.0; DateTime dtDateSubmitted = DateTime.Now; //int.TryParse(Session["UserID"].ToString(), out UserID); int.TryParse(dRow["CampaignPlayerID"].ToString(), out CampaignPlayerID); int.TryParse(dRow["CharacterID"].ToString(), out CharacterID); int.TryParse(dRow["CampaignCPOpportunityDefaultID"].ToString(), out CampaignCPOpportunityDefaultID); int.TryParse(dRow["ReasonID"].ToString(), out ReasonID); int.TryParse(dRow["CampaignID"].ToString(), out CampaignID); int.TryParse(dRow["EventID"].ToString(), out EventID); double.TryParse(dRow["CPValue"].ToString(), out CPAwarded); DateTime.TryParse(dRow["DateSubmitted"].ToString(), out dtDateSubmitted); Points.AssignPELPoints(Master.UserID, CampaignPlayerID, CharacterID, CampaignCPOpportunityDefaultID, EventID, dRow["EventName"].ToString(), ReasonID, CampaignID, CPAwarded, dtDateSubmitted); } } }
protected void gvNewPoints_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { int index = gvNewPoints.EditIndex; int iTemp; int UserID = 0; int OppID = 0; double dblTemp = 0; double CP = 0; if (int.TryParse(Session["UserID"].ToString(), out iTemp)) { UserID = iTemp; } HiddenField hidPointID = (HiddenField)gvNewPoints.Rows[e.RowIndex].FindControl("hidPointID"); if (int.TryParse(hidPointID.Value.ToString(), out iTemp)) { OppID = iTemp; } string strComments = ""; if (Session["EditMode"].ToString() == "Edit") { GridViewRow row = gvNewPoints.Rows[index]; TextBox txtComments = row.FindControl("tbStaffComments") as TextBox; strComments = txtComments.Text; TextBox txtCP = row.FindControl("txtNewCPValue") as TextBox; if (double.TryParse(txtCP.Text.ToString(), out dblTemp)) { CP = dblTemp; } Session["EditMode"] = "Assign"; } else { Label lblCPValue = (Label)gvPoints.Rows[e.RowIndex].FindControl("lblCPValue"); Label lblStaffComents = (Label)gvPoints.Rows[e.RowIndex].FindControl("lblStaffComments"); if (double.TryParse(lblCPValue.Text, out dblTemp)) { CP = dblTemp; } strComments = lblStaffComents.Text; } Classes.cPoints Point = new Classes.cPoints(); Point.UpdateTentativeOpportunity(UserID, OppID, CP, strComments, 80); // 80 - Tentative --> 68 - Ready to send --> 69 Sent to campaign // Audit status 78 - Emailed } catch (Exception ex) { string l = ex.Message; } gvNewPoints.EditIndex = -1; FillGridNewPoints(); }
protected void btnApproveAll_Click(object sender, EventArgs e) { DataTable dtPELs = ViewState["PELsDisplayed"] as DataTable; DataView dvPELs = new DataView(dtPELs, "DateApproved is null", "", DataViewRowState.CurrentRows); foreach (DataRowView dRow in dvPELs) { int iRegistrationID; if (int.TryParse(dRow["RegistrationID"].ToString(), out iRegistrationID)) { int iPELID; int.TryParse(dRow["PELID"].ToString(), out iPELID); SortedList sParams = new SortedList(); sParams.Add("@UserID", Session["UserID"].ToString()); sParams.Add("@PELID", iPELID); double dCPAwarded; if (double.TryParse(dRow["CPValue"].ToString(), out dCPAwarded)) { sParams.Add("@CPAwarded", dCPAwarded); } sParams.Add("@DateApproved", DateTime.Now); Classes.cUtilities.PerformNonQuery("uspInsUpdCMPELs", sParams, "LARPortal", Session["UserName"].ToString()); Classes.cPoints Points = new Classes.cPoints(); int UserID = 0; int CampaignPlayerID = 0; int CharacterID = 0; int CampaignCPOpportunityDefaultID = 0; int EventID = 0; int ReasonID = 0; int CampaignID = 0; double CPAwarded = 0.0; DateTime dtDateSubmitted = DateTime.Now; int.TryParse(Session["UserID"].ToString(), out UserID); int.TryParse(dRow["CampaignPlayerID"].ToString(), out CampaignPlayerID); int.TryParse(dRow["CharacterID"].ToString(), out CharacterID); int.TryParse(dRow["CampaignCPOpportunityDefaultID"].ToString(), out CampaignCPOpportunityDefaultID); int.TryParse(dRow["ReasonID"].ToString(), out ReasonID); int.TryParse(dRow["CampaignID"].ToString(), out CampaignID); int.TryParse(dRow["EventID"].ToString(), out EventID); double.TryParse(dRow["CPValue"].ToString(), out CPAwarded); DateTime.TryParse(dRow["DateSubmitted"].ToString(), out dtDateSubmitted); Points.AssignPELPoints(UserID, CampaignPlayerID, CharacterID, CampaignCPOpportunityDefaultID, EventID, dRow["EventName"].ToString(), ReasonID, CampaignID, CPAwarded, dtDateSubmitted); } } }
//protected void CharacterHistoryEmailNotificaiton() //{ // if (hidPlayerEMail.Value.Length > 0) // { // string strSubject = "Character History Approved for Character " + lblCharacter.Text; // string strBody = "Your character history for " + lblCharacter.Text + " has been approved.<br>"; // strBody += "You have been awarded " + tbCPAwarded.Text + " CP.<br><br>"; // strBody = strBody + "History Text:<br>" + lblHistory.Text; // strBody = strBody.Replace(System.Environment.NewLine, "<br />"); // Classes.cEmailMessageService SubmitCharacterHistory = new Classes.cEmailMessageService(); // try // { // SubmitCharacterHistory.SendMail(strSubject, strBody, hidPlayerEMail.Value, "", ""); // } // catch (Exception) // { // } // } //} protected void btnApprove_Command(object sender, CommandEventArgs e) { int iCharID; if (int.TryParse(Request["CharID"], out iCharID)) { Classes.cCharacter cChar = new Classes.cCharacter(); cChar.LoadCharacter(iCharID); if (e.CommandName == "APPROVE") { cChar.DateHistoryApproved = DateTime.Now; cChar.SaveCharacter(Session["UserName"].ToString(), (int)Session["UserID"]); lblCharApprovedMessage.Text = "The character history for " + cChar.AKA + " has been approved."; Classes.cPoints Points = new Classes.cPoints(); int UserID = 0; int CharacterID = 0; int CampaignCPOpportunityDefaultID = 0; double CPAwarded = 0.0; int.TryParse(Session["UserID"].ToString(), out UserID); int.TryParse(hidCampaignCPOpportunityDefaultID.Value, out CampaignCPOpportunityDefaultID); double.TryParse(tbCPAwarded.Text, out CPAwarded); Points.AssignHistoryPoints(UserID, cChar.PlayerID, CharacterID, CampaignCPOpportunityDefaultID, cChar.CampaignID, CPAwarded, DateTime.Now); ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal();", true); if (hidPlayerEMail.Value.Length > 0) { string strSubject = "Character History Approved for Character " + lblCharacter.Text; string strBody = "Your character history for " + lblCharacter.Text + " has been approved.<br>"; strBody += "You have been awarded " + tbCPAwarded.Text + " CP.<br><br>"; strBody = strBody + "History Text:<br>" + lblHistory.Text; strBody = strBody.Replace(System.Environment.NewLine, "<br />"); Classes.cEmailMessageService SubmitCharacterHistory = new Classes.cEmailMessageService(); try { SubmitCharacterHistory.SendMail(strSubject, strBody, hidPlayerEMail.Value, "", "", "CharacterHistory", Session["Username"].ToString()); } catch (Exception) { } } } } }
protected void gvPoints_RowDeleting(object sender, GridViewDeleteEventArgs e) { HiddenField hidCPOpp = (HiddenField)gvPoints.Rows[e.RowIndex].FindControl("hidPointID"); int iTemp = 0; int intCPOpp = 0; int UserID = 0; if (int.TryParse(Session["UserID"].ToString(), out iTemp)) { UserID = iTemp; } if (int.TryParse(hidCPOpp.Value.ToString(), out iTemp)) { intCPOpp = iTemp; } Classes.cPoints Points = new Classes.cPoints(); Points.DeleteCPOpportunity(UserID, intCPOpp); gvPoints.EditIndex = -1; FillGrid(hidUserName.Value, hidCampaignID.Value); }
protected void InsertCPOpportunity(int RoleAlignment, int iCharacterID, int iEventID, int iRegistrationID) { int iCampaignID = 0; int iUserID = 0; if (Session["UserID"] != null) { int.TryParse(Session["UserID"].ToString(), out iUserID); } if (Session["CampaignID"] != null) { int.TryParse(Session["CampaignID"].ToString(), out iCampaignID); } int iReasonID = 0; switch (ddlRoles.SelectedItem.Text) { case "PC": iReasonID = 3; break; case "NPC": iReasonID = 1; break; case "Staff": RoleAlignment = 12; break; default: break; } Classes.cPoints cPoints = new Classes.cPoints(); // Currently have no need to delete. The Opportunty should be there currently. Leaving in case we need it. // cPoints.DeleteRegistrationCPOpportunity(iUserID, iRegistrationID); cPoints.CreateRegistrationCPOpportunity(iUserID, iCampaignID, RoleAlignment, iCharacterID, iReasonID, iEventID, iRegistrationID); }
protected void btnRunTest_Click(object sender, EventArgs e) { // Procedure to test - Change variable types accordingly //Test CP Opportunity Add from registration //int UserID, int CampaignID, int RoleAlignment, int CharacterID, int ReasonID, int EventID, int RegistrationID int Value01 = 0; Int32.TryParse(Session["UserID"].ToString(), out Value01); int Value02 = 0; Int32.TryParse(txtValue02.Text, out Value02); int Value03 = 0; Int32.TryParse(txtValue03.Text, out Value03); int Value04 = 0; Int32.TryParse(txtValue04.Text, out Value04); int Value05 = 0; Int32.TryParse(txtValue05.Text, out Value05); int Value06 = 0; Int32.TryParse(txtValue06.Text, out Value06); int Value07 = 0; Int32.TryParse(txtValue07.Text, out Value07); string Value08 = txtValue08.Text; string Value09 = txtValue09.Text; string Value10 = txtValue10.Text; string Value11 = txtValue11.Text; string Value12 = txtValue12.Text; string Value13 = txtValue13.Text; string Value14 = txtValue14.Text; string Value15 = txtValue15.Text; Classes.cPoints Points = new Classes.cPoints(); Points.CreateRegistrationCPOpportunity(Value01, Value02, Value03, Value04, Value05, Value06, Value07); }
protected void btnApprove_Click(object sender, EventArgs e) { int iCharacterID = -1; int iTemp; if (int.TryParse(hidCharacterID.Value, out iTemp)) { iCharacterID = iTemp; } Classes.cCharacter cChar = new Classes.cCharacter(); cChar.LoadCharacter(iCharacterID); SortedList sParams = new SortedList(); sParams.Add("@UserID", Session["UserID"].ToString()); sParams.Add("@CharacterID", iCharacterID); sParams.Add("@DateHistoryApproved", DateTime.Now); Classes.cUtilities.PerformNonQuery("uspInsUpdCHCharacters", sParams, "LARPortal", Session["UserName"].ToString()); Session["UpdateHistoryMessage"] = "alert('The character history has been approved.');"; Classes.cPoints Points = new Classes.cPoints(); int UserID = 0; int CampaignPlayerID = 0; int CharacterID = 0; int CampaignCPOpportunityDefaultID = 0; int CampaignID = 0; double CPAwarded = 0.0; int.TryParse(Session["UserID"].ToString(), out UserID); int.TryParse(hidCampaignPlayerID.Value, out CampaignPlayerID); int.TryParse(hidCharacterID.Value, out CharacterID); int.TryParse(hidCampaignCPOpportunityDefaultID.Value, out CampaignCPOpportunityDefaultID); int.TryParse(hidCampaignID.Value, out CampaignID); double.TryParse(tbCPAwarded.Text, out CPAwarded); DateTime dtDateSubmitted; if (!DateTime.TryParse(hidSubmitDate.Value, out dtDateSubmitted)) { dtDateSubmitted = DateTime.Now; } Classes.cUser User = new Classes.cUser(Session["UserName"].ToString(), "PasswordNotNeeded"); string sSubject = "Character history for " + hidCharacterAKA.Value + " had been approved."; string sBody = hidCampaignName.Value + " staff has approved the character history for " + hidCharacterAKA.Value + "<br><br>" + "You have been awarded " + CPAwarded.ToString() + " CP."; //"<br><br>Character History:<br><br>" + ckHistory.Text; string sEmailToSendTo = hidEmail.Value; Classes.cEmailMessageService cEMS = new Classes.cEmailMessageService(); cEMS.SendMail(sSubject, sBody, sEmailToSendTo, "", "", "CharacterHistory", Session["Username"].ToString()); //Classes.cSendNotifications SendNot = new Classes.cSendNotifications(); //SendNot.SubjectText = sSubject; //SendNot.EMailBody = sBody; //SendNot.NotifyType = Classes.cNotificationTypes.HISTORYAPPROVE; //SendNot.SendNotification(cChar.CurrentUserID, _UserName); Points.AssignHistoryPoints(UserID, CampaignPlayerID, CharacterID, CampaignCPOpportunityDefaultID, CampaignID, CPAwarded, dtDateSubmitted); Response.Redirect("ApprovalList.aspx", true); }
protected void ProcessButton(object sender, CommandEventArgs e) { int iPELID = -1; int iTemp; if (int.TryParse(hidPELID.Value, out iTemp)) { iPELID = iTemp; } if ((e.CommandName.ToUpper() == "SAVE") || (e.CommandName.ToUpper() == "SUBMIT")) { foreach (RepeaterItem item in rptQuestions.Items) { if (item.ItemType == ListItemType.Item || item.ItemType == ListItemType.AlternatingItem) { SortedList sParams = new SortedList(); TextBox tbAnswer = (TextBox)item.FindControl("tbAnswer"); HiddenField hidQuestionID = (HiddenField)item.FindControl("hidQuestionID"); HiddenField hidAnswerID = (HiddenField)item.FindControl("hidAnswerID"); int iQuestionID = 0; int iAnswerID = 0; if (hidQuestionID != null) { int.TryParse(hidQuestionID.Value, out iQuestionID); } if (hidAnswerID != null) { int.TryParse(hidAnswerID.Value, out iAnswerID); } if (iPELID == 0) { iPELID = -1; } if (iAnswerID == 0) { iAnswerID = -1; } sParams.Add("@PELAnswerID", iAnswerID); sParams.Add("@PELQuestionsID", iQuestionID); sParams.Add("@PELID", iPELID); sParams.Add("@Answer", tbAnswer.Text); sParams.Add("@RegistrationID", hidRegistrationID.Value); DataSet dsPELS = new DataSet(); dsPELS = Classes.cUtilities.LoadDataSet("uspPELsAnswerInsUpd", sParams, "LARPortal", Session["UserName"].ToString(), "PELEdit.btnSave_Click"); if ((dsPELS.Tables.Count > 1) && (iPELID == -1)) { if (int.TryParse(dsPELS.Tables[1].Rows[0]["PELID"].ToString(), out iTemp)) { iPELID = iTemp; hidPELID.Value = iTemp.ToString(); } } } Session["UpdatePELMessage"] = "alert('The PEL has been saved.');"; } } if (e.CommandName.ToUpper() == "SUBMIT") { SortedList sParams = new SortedList(); sParams.Add("@UserID", Session["UserID"].ToString()); sParams.Add("@PELID", iPELID); sParams.Add("@DateSubmitted", DateTime.Now); Classes.cUtilities.PerformNonQuery("uspInsUpdCMPELs", sParams, "LARPortal", Session["UserName"].ToString()); Session["UpdatePELMessage"] = "alert('The PEL has been saved and submitted.');"; } if (e.CommandName.ToUpper() == "APPROVE") { SortedList sParams = new SortedList(); sParams.Add("@UserID", Session["UserID"].ToString()); sParams.Add("@PELID", iPELID); double dCPAwarded; if (double.TryParse(tbCPAwarded.Text, out dCPAwarded)) { sParams.Add("@CPAwarded", dCPAwarded); } sParams.Add("@DateApproved", DateTime.Now); Classes.cUtilities.PerformNonQuery("uspInsUpdCMPELs", sParams, "LARPortal", Session["UserName"].ToString()); Session["UpdatePELMessage"] = "alert('The PEL has been approved.');"; Classes.cPoints Points = new Classes.cPoints(); int UserID = 0; int CampaignPlayerID = 0; int CharacterID = 0; int CampaignCPOpportunityDefaultID = 0; int EventID = 0; int ReasonID = 0; int CampaignID = 0; double CPAwarded = 0.0; int.TryParse(Session["UserID"].ToString(), out UserID); int.TryParse(hidCampaignPlayerID.Value, out CampaignPlayerID); int.TryParse(hidCharacterID.Value, out CharacterID); int.TryParse(hidCampaignCPOpportunityDefaultID.Value, out CampaignCPOpportunityDefaultID); int.TryParse(hidReasonID.Value, out ReasonID); int.TryParse(hidCampaignID.Value, out CampaignID); int.TryParse(hidEventID.Value, out EventID); double.TryParse(tbCPAwarded.Text, out CPAwarded); DateTime dtDateSubmitted; if (!DateTime.TryParse(hidSubmitDate.Value, out dtDateSubmitted)) { dtDateSubmitted = DateTime.Now; } Points.AssignPELPoints(UserID, CampaignPlayerID, CharacterID, CampaignCPOpportunityDefaultID, EventID, hidEventDesc.Value, ReasonID, CampaignID, CPAwarded, dtDateSubmitted); } Response.Redirect("PELApprovalList.aspx", true); }
protected void btnAddNewReg_Click(object sender, EventArgs e) { // Add new player "Add" button to change from tentative to ready to send btnPreview.Visible = true; ddlRegistrant.Enabled = true; ddlEvent.Enabled = true; ddlDescription.Enabled = true; ddlRegistrant.SelectedIndex = 0; btnAddNewRegCancel.Visible = false; btnAddNewReg.Visible = false; gvNewPoints.Visible = false; btnEditNewPoints.Visible = true; // Update the opportunities as ready to send int UserID = 0; if (Session["UserID"] != null) { int.TryParse(Session["UserID"].ToString(), out UserID); } Classes.cPoints Point = new Classes.cPoints(); foreach (GridViewRow gvrow in gvNewPoints.Rows) { try { int index = gvNewPoints.EditIndex; int iTemp; double dblTemp = 0; double CP = 0; HiddenField hidCPOpp = (HiddenField)gvNewPoints.Rows[gvrow.RowIndex].FindControl("hidPointID"); int intCPOpp = 0; if (int.TryParse(hidCPOpp.Value.ToString(), out iTemp)) { intCPOpp = iTemp; } string strComments = ""; GridViewRow row = gvNewPoints.Rows[gvrow.RowIndex]; Label lblCPValue = (Label)gvNewPoints.Rows[gvrow.RowIndex].FindControl("lblNewCPValue"); Label lblStaffComments = (Label)gvNewPoints.Rows[gvrow.RowIndex].FindControl("lblStaffComments"); strComments = lblStaffComments.Text; if (double.TryParse(lblCPValue.Text.ToString(), out dblTemp)) { CP = dblTemp; } else { string jsString = "alert('Point value must be a number.');"; ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "MyApplication", jsString, true); return; } Point.UpdateTentativeOpportunity(UserID, intCPOpp, CP, strComments, 68); } catch (Exception ex) { string l = ex.Message; } } gvPoints.EditIndex = -1; FillGrid(hidUserName.Value, hidCampaignID.Value); }
protected void gvPoints_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { int index = gvPoints.EditIndex; int iTemp; int UserID = 0; double dblTemp = 0; double CP = 0; if (int.TryParse(Session["UserID"].ToString(), out iTemp)) { UserID = iTemp; } HiddenField hidCPOpp = (HiddenField)gvPoints.Rows[e.RowIndex].FindControl("hidPointID"); HiddenField hidCmpPlyrID = (HiddenField)gvPoints.Rows[e.RowIndex].FindControl("hidCampaignPlayer"); HiddenField hidCharID = (HiddenField)gvPoints.Rows[e.RowIndex].FindControl("hidCharacterID"); HiddenField hidEvntID = (HiddenField)gvPoints.Rows[e.RowIndex].FindControl("hidEventID"); HiddenField hidOppDefID = (HiddenField)gvPoints.Rows[e.RowIndex].FindControl("hidCPOpportunityDefaultID"); HiddenField hidRsnID = (HiddenField)gvPoints.Rows[e.RowIndex].FindControl("hidReasonID"); HiddenField hidAddID = (HiddenField)gvPoints.Rows[e.RowIndex].FindControl("hidAddedByID"); HiddenField hidOppNotes = (HiddenField)gvPoints.Rows[e.RowIndex].FindControl("hidOpportunityNotes"); HiddenField hidExURL = (HiddenField)gvPoints.Rows[e.RowIndex].FindControl("hidExampleURL"); HiddenField hidRole = (HiddenField)gvPoints.Rows[e.RowIndex].FindControl("hidRole"); HiddenField hidNPCCampaignID = (HiddenField)gvPoints.Rows[e.RowIndex].FindControl("hidNPCCampaignID"); HiddenField hidRegistrationID = (HiddenField)gvPoints.Rows[e.RowIndex].FindControl("hidRegistrationID"); Label lblEarnDesc = (Label)gvPoints.Rows[e.RowIndex].FindControl("lblEarnDescription"); int intCmpPlyrID = 0; int intCharID = 0; int intEvntID = 0; int intCPOpp = 0; int intOppDefID = 0; int intRsnID = 0; int intAddID = 0; int intRole = 0; int intNPCCampaignID = 0; int intRegistrationID = 0; int intCampaignID = 0; int.TryParse(Session["CampaignID"].ToString(), out intCampaignID); string strOppNotes = hidOppNotes.Value.ToString(); string strExURL = hidExURL.Value.ToString(); string strDesc = lblEarnDesc.Text; if (int.TryParse(hidCmpPlyrID.Value.ToString(), out iTemp)) { intCmpPlyrID = iTemp; } if (int.TryParse(hidCharID.Value.ToString(), out iTemp)) { intCharID = iTemp; } if (int.TryParse(hidEvntID.Value.ToString(), out iTemp)) { intEvntID = iTemp; } if (int.TryParse(hidCPOpp.Value.ToString(), out iTemp)) { intCPOpp = iTemp; } if (int.TryParse(hidOppDefID.Value.ToString(), out iTemp)) { intOppDefID = iTemp; } if (int.TryParse(hidRsnID.Value.ToString(), out iTemp)) { intRsnID = iTemp; } if (int.TryParse(hidAddID.Value.ToString(), out iTemp)) { intAddID = iTemp; } if (int.TryParse(hidNPCCampaignID.Value.ToString(), out iTemp)) { intNPCCampaignID = iTemp; } if (int.TryParse(hidRegistrationID.Value.ToString(), out iTemp)) { intRegistrationID = iTemp; } string strComments = ""; if (Session["EditMode"].ToString() == "Edit") { GridViewRow row = gvPoints.Rows[index]; TextBox txtComments = row.FindControl("tbStaffComments") as TextBox; strComments = txtComments.Text; TextBox txtCP = row.FindControl("txtCPValue") as TextBox; if (double.TryParse(txtCP.Text.ToString(), out dblTemp)) { CP = dblTemp; } Session["EditMode"] = "Assign"; } else { Label lblCPValue = (Label)gvPoints.Rows[e.RowIndex].FindControl("lblCPValue"); Label lblStaffComents = (Label)gvPoints.Rows[e.RowIndex].FindControl("lblStaffComments"); if (double.TryParse(lblCPValue.Text, out dblTemp)) { CP = dblTemp; } strComments = lblStaffComents.Text; } Classes.cPoints Point = new Classes.cPoints(); Point.UpdateCPOpportunity(UserID, intCPOpp, intCmpPlyrID, intCharID, intOppDefID, intEvntID, strDesc, strOppNotes, strExURL, intRsnID, intAddID, CP, UserID, DateTime.Now, UserID, strComments, intRole, intNPCCampaignID, intCampaignID); } catch (Exception ex) { string l = ex.Message; } gvPoints.EditIndex = -1; FillGrid(hidUserName.Value, hidCampaignID.Value); }