/// <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>");
}
}
}
