/// <summary> /// Selects the role. /// </summary> /// <param name="objActivity">The obj activity.</param> /// <returns></returns> public DataTable SelectActivityOutputMapDetail(ActivityOutputMapBO objActivityOutputMap) { DbCommand cmd = db.GetStoredProcCommand("PKG_ACTIVITY.PR_SELECT_ACTIVITY_OUTPUT_MAP", objActivityOutputMap.Lang, OracleDbType.RefCursor); DataSet ds = null; DataTable dt = null; ds = db.ExecuteDataSet(cmd); if (ds != null && ds.Tables.Count > 0) { dt = ds.Tables[0]; } return(dt); }
/// <summary> /// Loads all Activity. /// </summary> private void LoadAllActivityDetail() { objActivityOutputBo = new ActivityOutputMapBO(); objActivityOutputBo.Lang = Session["LanguageSetting"].ToString(); DataTable dt = new DataTable(); wbs = new ActivityManagementService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity(); dt = wbs.PopulateActivityOutputMapDetail(objActivityOutputBo); //Session["vdcList"] = dtvm; if (dt != null && dt.Rows.Count > 0) { lvRoles.DataSource = dt; lvRoles.DataBind(); } }
/// <summary> /// Populates the role by id. /// </summary> /// <param name="activityMapId">The activity map id.</param> private void PopulateActivityDetailById(int activityMapId) { objActivityOutputBo = new ActivityOutputMapBO(); objActivityOutputBo.Lang = Session["LanguageSetting"].ToString(); objActivityOutputBo.ActivityOutputMapId = activityMapId; DataTable dt = new DataTable(); wbs = new ActivityManagementService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity(); dt = wbs.SelectActivityOutputById(objActivityOutputBo); //Session["vdcList"] = dtvm; if (dt != null && dt.Rows.Count > 0) { WebService1 objWebService = new WebService1(); //bind Activity ddlActivityDetail.DataSource = objWebService.FindActivityBySectorID(dt.Rows[0]["ACTIVITY_SUB_SECTOR_ID"].ToString()); ddlActivityDetail.DataValueField = "ComboId"; ddlActivityDetail.DataTextField = "Name"; ddlActivityDetail.DataBind(); //bind output ddlOutput.DataSource = objWebService.FindActivityOutputBySectorID(dt.Rows[0]["ACTIVITY_SUB_SECTOR_ID"].ToString()); ddlOutput.DataValueField = "ComboId"; ddlOutput.DataTextField = "Name"; ddlOutput.DataBind(); // ddlSubSector.SelectedValue = dt.Rows[0]["ACTIVITY_SUB_SECTOR_ID"].ToString(); ddlActivityDetail.SelectedValue = dt.Rows[0]["ACTIVITY_DETAIL_ID"].ToString(); ddlOutput.SelectedValue = dt.Rows[0]["ACTIVITY_OUTPUT_ID"].ToString(); if (dt.Rows[0]["isenabled"].ToString() == "1") { IsActive.Checked = true; } else { IsActive.Checked = false; } //ddlSubSector.SelectedValue = dt.Rows[0]["ACTIVITY_SUB_SECTOR_ID"].ToString(); //ddlUnit.SelectedValue = dt.Rows[0]["ACTIVITY_UNIT_ID"].ToString(); } LoadAllActivityDetail(); ClientScript.RegisterStartupScript(this.GetType(), "name1", "<script> " + " $('#modal-form').modal(); var bsModal = $.fn.modal.noConflict();" + " </script>"); }
/// <summary> /// Adds the roles. /// </summary> /// <param name="objActivity">The obj activity.</param> /// <returns></returns> public int ActivityOutputMap(ActivityOutputMapBO objActivity) { int i = 0; DbCommand cmd = null; cmd = db.GetStoredProcCommand("PKG_ACTIVITY.PR_ACTIVITY_OUTPUT_MAP"); db.AddInParameter(cmd, "V_MODE", DbType.String, objActivity.Mode); db.AddInParameter(cmd, "V_ACTIVITY_OUTPUT_MAP_ID", DbType.Decimal, objActivity.ActivityOutputMapId); db.AddInParameter(cmd, "V_ACTIVITY_DETAIL_ID", DbType.Decimal, objActivity.ActivityDetailId); db.AddInParameter(cmd, "V_ACTIVITY_OUTPUT_ID", DbType.Decimal, objActivity.ActivityOutputId); db.AddInParameter(cmd, "V_FISCAL_YEAR_ID", DbType.Decimal, objActivity.FiscalYearId); db.AddInParameter(cmd, "V_ISENABLED", DbType.Int16, objActivity.Isenabled); db.AddInParameter(cmd, "V_ISLOCKED", DbType.Int16, objActivity.Islocked); i = db.ExecuteNonQuery(cmd); return(i); }
protected void btnAddRoles_Click(object sender, EventArgs e) { wbs = new ActivityManagementService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity(); objActivityOutputBo = new ActivityOutputMapBO(); if (hidActivityDetailId.Value.ToInt32() > 0) { objActivityOutputBo.Mode = "U"; objActivityOutputBo.ActivityOutputMapId = hidActivityDetailId.Value.ToInt32(); } else { objActivityOutputBo.Mode = "I"; } objActivityOutputBo.ActivityOutputId = hidOutputId.Value.ToInt32(); objActivityOutputBo.FiscalYearId = 1; objActivityOutputBo.Isenabled = IsActive.Checked == true ? 1 : 0; objActivityOutputBo.ActivityDetailId = hidSelectedActivityId.Value.ToInt32(); wbs.ActivityOutputMap(objActivityOutputBo); Response.Redirect(Constants.ConstantAppPath + "/Modules/ActivityManagement/ActivityOutputMap.aspx"); }
public DataTable SelectActivityOutputById(ActivityOutputMapBO objActivityDetail) { Authentication(); return(objActivity.SelectActivityOutputById(objActivityDetail)); }
public int ActivityOutputMap(ActivityOutputMapBO objActivityMapBo) { Authentication(); return(objActivity.ActivityOutputMap(objActivityMapBo)); }
public DataTable PopulateActivityOutputMapDetail(ActivityOutputMapBO objActivityOutputMap) { Authentication(); return(objActivity.SelectActivityOutputMapDetail(objActivityOutputMap)); }
protected void BtnEdit_Command(object sender, CommandEventArgs e) { int roleId = 0; if (e.CommandName == "edit") { roleId = int.Parse(e.CommandArgument.ToString()); SecureQueryString str = new SecureQueryString(); str["id"] = e.CommandArgument.ToString(); Response.Redirect(Constants.ConstantAppPath + "/Modules/ActivityManagement/ActivityOutputMap.aspx" + str.EncryptedString, false); } else if (e.CommandName == "delete") { int i = 0; wbs = new ActivityManagementService(); roleId = int.Parse(e.CommandArgument.ToString()); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity(); objActivityOutputBo = new ActivityOutputMapBO(); objActivityOutputBo.ActivityOutputMapId = roleId; objActivityOutputBo.Mode = "D"; i = wbs.ActivityOutputMap(objActivityOutputBo); //wbs.deleteDonar(donarId); if (i > 0) { Response.Redirect(Constants.ConstantAppPath + "/Modules/ActivityManagement/ActivityOutputMap.aspx"); } else { Response.Redirect("<script>alert('Delete failed')</script>"); } } else if (e.CommandName == "lock") { wbs = new ActivityManagementService(); int i = 0; roleId = int.Parse(e.CommandArgument.ToString()); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity(); objActivityOutputBo = new ActivityOutputMapBO(); objActivityOutputBo.ActivityOutputMapId = roleId; objActivityOutputBo.Mode = "L"; i = wbs.ActivityOutputMap(objActivityOutputBo); if (i > 0) { Response.Redirect(Constants.ConstantAppPath + "/Modules/ActivityManagement/ActivityOutputMap.aspx"); } else { Response.Redirect("<script>alert('Lock failed')</script>"); } } else { wbs = new ActivityManagementService(); wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity(); int i = 0; roleId = int.Parse(e.CommandArgument.ToString()); roleId = int.Parse(e.CommandArgument.ToString()); objActivityOutputBo = new ActivityOutputMapBO(); objActivityOutputBo.ActivityOutputMapId = roleId; objActivityOutputBo.Mode = "L"; i = wbs.ActivityOutputMap(objActivityOutputBo); if (i > 0) { Response.Redirect(Constants.ConstantAppPath + "/Modules/ActivityManagement/ActivityOutputMap.aspx"); } else { Response.Redirect("<script>alert('Delete failed')</script>"); } } }