private void LoadOwnerGridData(Int32 ownerCode) { //WUIN-746 clearing sort hidden files hdnSortExpression.Value = string.Empty; hdnSortDirection.Value = string.Empty; royaltorStatementBL = new RoyaltorStatementBL(); DataSet ownerStmtData = royaltorStatementBL.GetOwnerStmtData(ownerCode, out errorId); royaltorStatementBL = null; if (ownerStmtData.Tables.Count != 0 && errorId != 2) { //If there are royaltors, stmt periods to be added or removed then show owner record if (ownerStmtData.Tables[0].Rows.Count > 0) { DataTable tempDt = ownerStmtData.Tables[0].Copy(); DataView dv = new DataView(tempDt); DataTable dtResults = dv.ToTable(true, "owner_code", "owner_name", "statement_period_id", "statement_type_code", "stmt_period", "add_owner", "remove_owner"); Session["RoyStmtChangesOwnerData"] = dtResults; gvOwnerStmt.DataSource = dtResults; if (dtResults.Rows.Count == 0) { gvOwnerStmt.EmptyDataText = "No data found for the selected owner."; hdnAddBtnEnable.Value = string.Empty; hdnRemoveBtnEnable.Value = string.Empty; } gvOwnerStmt.DataBind(); Session["StmtsToBeProcessed"] = ownerStmtData.Tables[0]; } else { dtEmpty = new DataTable(); gvOwnerStmt.DataSource = dtEmpty; gvOwnerStmt.EmptyDataText = "No data found for the selected owner."; gvOwnerStmt.DataBind(); hdnAddBtnEnable.Value = string.Empty; hdnRemoveBtnEnable.Value = string.Empty; } } else if (ownerStmtData.Tables.Count == 0 && errorId != 2) { dtEmpty = new DataTable(); gvOwnerStmt.DataSource = dtEmpty; gvOwnerStmt.EmptyDataText = "No data found for the selected owner."; gvOwnerStmt.DataBind(); hdnAddBtnEnable.Value = string.Empty; hdnRemoveBtnEnable.Value = string.Empty; } else { ExceptionHandler("Error in loading grid data.", string.Empty); } }
private void LoadDropdowns() { royaltorStatementBL = new RoyaltorStatementBL(); DataSet royaltors = royaltorStatementBL.GetRoyaltors(out errorId); royaltorStatementBL = null; if (royaltors.Tables.Count != 0 && errorId != 2) { Session["StmtChangesOwnerList"] = royaltors.Tables[0]; } else if (royaltors.Tables.Count == 0 && errorId != 2) { Session["StmtChangesOwnerList"] = royaltors.Tables[0]; } else { ExceptionHandler("Error in loading royaltors dropdown.", string.Empty); } }
private void LoadGridData(Int32 royaltorId) { //WUIN-746 clearing sort hidden files hdnSortExpression.Value = string.Empty; hdnSortDirection.Value = string.Empty; royaltorStatementBL = new RoyaltorStatementBL(); DataSet royStmtData = royaltorStatementBL.GetRoyStmtData(royaltorId, out errorId); royaltorStatementBL = null; if (royStmtData.Tables.Count != 0 && errorId != 2) { Session["RoyStmtChangesRoyData"] = royStmtData.Tables[0]; gvRoyStmt.DataSource = royStmtData.Tables[0]; if (royStmtData.Tables[0].Rows.Count == 0) { gvRoyStmt.EmptyDataText = "No data found for the selected royaltor."; hdnAddBtnEnable.Value = string.Empty; hdnRemoveBtnEnable.Value = string.Empty; } gvRoyStmt.DataBind(); } else if (royStmtData.Tables.Count == 0 && errorId != 2) { dtEmpty = new DataTable(); gvRoyStmt.DataSource = dtEmpty; gvRoyStmt.EmptyDataText = "No data found for the selected royaltor."; gvRoyStmt.DataBind(); hdnAddBtnEnable.Value = string.Empty; hdnRemoveBtnEnable.Value = string.Empty; } else { ExceptionHandler("Error in loading grid data.", string.Empty); } }
private void UpdateRoyStmtRun() { List <int> stmtsToAdd = new List <int>(); List <int> stmtsToRemove = new List <int>(); CheckBox cbAdd; CheckBox cbRemove; string stmtPeriodID; //loop thorugh grid and get selected list of statement ids to be add/removed foreach (GridViewRow row in gvRoyStmt.Rows) { cbAdd = (CheckBox)row.FindControl("cbAdd"); cbRemove = (CheckBox)row.FindControl("cbRemove"); stmtPeriodID = (row.FindControl("hdnStmtPeriodID") as Label).Text; if (cbAdd.Enabled == true && cbAdd.Checked == true) { stmtsToAdd.Add(Convert.ToInt32(stmtPeriodID)); } else if (cbRemove.Enabled == true && cbRemove.Checked == true) { stmtsToRemove.Add(Convert.ToInt32(stmtPeriodID)); } } royaltorStatementBL = new RoyaltorStatementBL(); string loggedUserID = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString()); royaltorId = Convert.ToInt32(txtRoyaltor.Text.Substring(0, txtRoyaltor.Text.IndexOf("-") - 1)); DataSet royStmtData = royaltorStatementBL.UpdateRoyStmt(royaltorId.ToString(), stmtsToAdd.ToArray(), stmtsToRemove.ToArray(), loggedUserID, out errorId); royaltorStatementBL = null; //WUIN-746 clearing sort hidden files hdnSortExpression.Value = string.Empty; hdnSortDirection.Value = string.Empty; if (errorId == 1) { ExceptionHandler("Error in triggering statement removal job.", string.Empty); return; } else if (errorId == 2) { ExceptionHandler("Error in updating data.", string.Empty); return; } else if (royStmtData.Tables.Count != 0) { gvRoyStmt.DataSource = royStmtData.Tables[0]; if (royStmtData.Tables[0].Rows.Count == 0) { gvRoyStmt.EmptyDataText = "Data updated and no data found to display for the selected royaltor."; hdnAddBtnEnable.Value = string.Empty; hdnRemoveBtnEnable.Value = string.Empty; } gvRoyStmt.DataBind(); } else if (royStmtData.Tables.Count == 0) { dtEmpty = new DataTable(); gvRoyStmt.DataSource = dtEmpty; gvRoyStmt.EmptyDataText = "Data updated and no data found to display for the selected royaltor."; gvRoyStmt.DataBind(); hdnAddBtnEnable.Value = string.Empty; hdnRemoveBtnEnable.Value = string.Empty; } else { ExceptionHandler("Error in updating data.", string.Empty); } EnableDisableButtons(); }
private void UpdateOwnerStmtRun() { if (gvOwnerStmt.Rows.Count > 0) { if (Session["StmtsToBeProcessed"] == null) { ExceptionHandler("Error in updating data.", string.Empty); return; } List <int> royaltors = new List <int>(); List <int> stmtsToAdd = new List <int>(); List <int> stmtsToRemove = new List <int>(); CheckBox cbAdd; CheckBox cbRemove; string stmtPeriodID; DataTable dtStmtsToBeProcessed = Session["StmtsToBeProcessed"] as DataTable; //foreach (DataRow dRow in dtStmtsToBeProcessed.Rows) //{ // royaltors.Add(Convert.ToInt32(dRow["royaltor_id"].ToString())); // stmtsToAdd.Add(Convert.ToInt32(dRow["statement_period_id"].ToString())); // stmtsToRemove.Add(Convert.ToInt32(dRow["statement_period_id"].ToString())); //} //GridViewRow gvRow = gvOwnerStmt.Rows[0]; //if ((gvRow.FindControl("cbAdd") as CheckBox).Checked) //{ // stmtsToRemove.Clear(); //} //else if ((gvRow.FindControl("cbRemove") as CheckBox).Checked) //{ // stmtsToAdd.Clear(); //} //loop thorugh grid and get selected list of statement ids to be add/removed foreach (GridViewRow row in gvOwnerStmt.Rows) { cbAdd = (CheckBox)row.FindControl("cbAdd"); cbRemove = (CheckBox)row.FindControl("cbRemove"); stmtPeriodID = (row.FindControl("hdnStmtPeriodID") as Label).Text; if (cbAdd.Enabled == true && cbAdd.Checked == true) { //loop through the datatable to get royaltor id foreach (DataRow dRow in dtStmtsToBeProcessed.Rows) { if (dRow["statement_period_id"].ToString() == stmtPeriodID) { royaltors.Add(Convert.ToInt32(dRow["royaltor_id"].ToString())); stmtsToAdd.Add(Convert.ToInt32(stmtPeriodID)); } } } else if (cbRemove.Enabled == true && cbRemove.Checked == true) { foreach (DataRow dRow in dtStmtsToBeProcessed.Rows) { if (dRow["statement_period_id"].ToString() == stmtPeriodID) { royaltors.Add(Convert.ToInt32(dRow["royaltor_id"].ToString())); stmtsToRemove.Add(Convert.ToInt32(stmtPeriodID)); } } } } royaltorStatementBL = new RoyaltorStatementBL(); string loggedUserID = WebUtility.HtmlDecode(System.Security.Principal.WindowsIdentity.GetCurrent().Name.ToString()); int ownerCode = Convert.ToInt32(txtOwner.Text.Substring(0, txtOwner.Text.IndexOf("-") - 1)); DataSet ownerStmtData = royaltorStatementBL.UpdateOwnerStmt(ownerCode, royaltors.ToArray(), stmtsToAdd.ToArray(), stmtsToRemove.ToArray(), loggedUserID, out errorId); royaltorStatementBL = null; if (ownerStmtData.Tables.Count != 0 && errorId != 2) { //WUIN-746 clearing sort hidden files hdnSortExpression.Value = string.Empty; hdnSortDirection.Value = string.Empty; //If there are royaltors, stmt periods to be added or removed then show owner record if (ownerStmtData.Tables[0].Rows.Count > 0) { DataTable tempDt = ownerStmtData.Tables[0].Copy(); DataView dv = new DataView(tempDt); DataTable dtResults = dv.ToTable(true, "owner_code", "owner_name", "statement_period_id", "statement_type_code", "stmt_period", "add_owner", "remove_owner"); gvOwnerStmt.DataSource = dtResults; if (dtResults.Rows.Count == 0) { gvOwnerStmt.EmptyDataText = "No data found for the selected owner."; hdnAddBtnEnable.Value = string.Empty; hdnRemoveBtnEnable.Value = string.Empty; } gvOwnerStmt.DataBind(); Session["StmtsToBeProcessed"] = ownerStmtData.Tables[0]; } else { dtEmpty = new DataTable(); gvOwnerStmt.DataSource = dtEmpty; gvOwnerStmt.EmptyDataText = "Data updated and no data found to display for the selected owner."; gvOwnerStmt.DataBind(); hdnAddBtnEnable.Value = string.Empty; hdnRemoveBtnEnable.Value = string.Empty; } } else if (ownerStmtData.Tables.Count == 0 && errorId != 2) { dtEmpty = new DataTable(); gvOwnerStmt.DataSource = dtEmpty; gvOwnerStmt.EmptyDataText = "Data updated and no data found to display for the selected owner."; gvOwnerStmt.DataBind(); hdnAddBtnEnable.Value = string.Empty; hdnRemoveBtnEnable.Value = string.Empty; } else { ExceptionHandler("Error in updating data.", string.Empty); } EnableDisableButtons(); } }