public List <Combo> FindActivityOutputBySectorID(string sectorId)
{
ActivityManagementService wbs = new ActivityManagementService();
ActivityDetailBO objActivityDetailBo = new ActivityDetailBO();
DataTable dtActivity = null;
List <Combo> objList = new List <Combo>();
wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity();
objActivityDetailBo.Lang = Session["LanguageSetting"].ToString();
objActivityDetailBo.ActivitySubSectorId = sectorId.ToInt32();
dtActivity = wbs.SelectActivityOutputBySector(objActivityDetailBo);
if (dtActivity != null && dtActivity.Rows.Count > 0)
{
objList.Add(new Combo {
ComboId = 0, Name = "छान्नुहोस"
});
foreach (DataRow dr in dtActivity.Rows)
{
objList.Add(new Combo {
ComboId = dr["activity_output_id"].ToInt32(), Name = dr["activity_output_name"].ToString()
});
}
}
return(objList);
}
/// <summary>
/// Populates the role by id.
/// </summary>
/// <param name="activityDetailId">The activity detail id.</param>
private void PopulateActivityDetailById(int activityDetailId)
{
objActivityBo = new ActivityDetailBO();
objActivityBo.Lang = Session["LanguageSetting"].ToString();
objActivityBo.ActivityDetailId = activityDetailId;
DataTable dt = new DataTable();
wbs = new ActivityManagementService();
wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity();
dt = wbs.SelectActivityDetailById(objActivityBo);
//Session["vdcList"] = dtvm;
if (dt != null && dt.Rows.Count > 0)
{
txtActivityDetailNepName.Text = dt.Rows[0]["activity_detail_nep_name"].ToString();
txtActivityDetailEngName.Text = dt.Rows[0]["activity_detail_eng_name"].ToString();
txtActivityDetailId.Text = dt.Rows[0]["activity_detail_id"].ToString();
if (dt.Rows[0]["isenable"].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();
}
ClientScript.RegisterStartupScript(this.GetType(), "name1", "<script> "
+ " $('#modal-form').modal();" + " </script>");
}
public DataTable SelectActivityUnit(ActivityDetailBO objActivity)
{
DbCommand cmd = db.GetStoredProcCommand("PKG_ACTIVITY.PR_SELECT_ACTIVITY_UNIT", objActivity.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);
}
public DataTable SelectActivityOutputBySector(ActivityDetailBO objActivity)
{
DbCommand cmd = db.GetStoredProcCommand("PKG_ACTIVITY.PR_SELECT_OUTPUT_BY_SECTOR", objActivity.Lang, objActivity.ActivitySubSectorId, 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);
}
private void BindUnit()
{
ActivityDetailBO objAdb = new ActivityDetailBO();
objAdb.Lang = Session["LanguageSetting"].ToString();
objAms.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity();
DataTable dtUnit = objAms.SelectActivityUnit(objAdb);
ddlJaggaPraptiUnit.DataSource = dtUnit;
ddlJaggaPraptiUnit.DataTextField = "UNIT_NAME";
ddlJaggaPraptiUnit.DataValueField = "UNIT_ID";
ddlJaggaPraptiUnit.DataBind();
//ddlJaggaPraptiUnit.Items.Insert(0, "--छान्नुहोस्--");
}
/// <summary>
/// Loads all Activity.
/// </summary>
private void LoadAllActivityDetail()
{
objActivityBo = new ActivityDetailBO();
objActivityBo.Lang = Session["LanguageSetting"].ToString();
DataTable dt = new DataTable();
wbs = new ActivityManagementService();
wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity();
dt = wbs.PopulateActivityDetail(objActivityBo);
//Session["vdcList"] = dtvm;
if (dt != null && dt.Rows.Count > 0)
{
lvRoles.DataSource = dt;
lvRoles.DataBind();
}
}
private void PopulateActivityDetail()
{
objActivityBo = new ActivityDetailBO();
objActivityBo.Lang = Session["LanguageSetting"].ToString();
DataTable dt = new DataTable();
wbs = new ActivityManagementService();
wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity();
dt = wbs.PopulateActivityDetail(objActivityBo);
if (dt != null && dt.Rows.Count > 0)
{
ddlActivityDetail.DataSource = dt;
ddlActivityDetail.DataTextField = "activity_detail_name";
ddlActivityDetail.DataValueField = "activity_detail_id";
ddlActivityDetail.DataBind();
}
}
private void populateActivityUnit()
{
wbs = new ActivityManagementService();
DataTable dtUnit = null;
objActivityBo = new ActivityDetailBO();
objActivityBo.Lang = Session["languageSetting"].ToString();
wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity();
dtUnit = wbs.SelectActivityUnit(objActivityBo);
if (dtUnit != null && dtUnit.Rows.Count > 0)
{
ddlUnit.DataSource = dtUnit;
ddlUnit.DataTextField = "unit_name";
ddlUnit.DataValueField = "unit_id";
ddlUnit.DataBind();
ddlUnit.Items.Insert(0, "-- छान्नुहोस्--");
}
}
/// <summary>
/// Adds the roles.
/// </summary>
/// <param name="objActivity">The obj activity.</param>
/// <returns></returns>
public int ActivityDetail(ActivityDetailBO objActivity)
{
int i = 0;
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("PKG_ACTIVITY.PR_ACTIVITY_DETAIL");
db.AddInParameter(cmd, "V_MODE", DbType.String, objActivity.Mode);
db.AddInParameter(cmd, "V_ACTIVITY_DETAIL_ID", DbType.Decimal, objActivity.ActivityDetailId);
db.AddInParameter(cmd, "V_ACTIVITY_DETAIL_ENG_NAME", DbType.String, objActivity.ActivityDetailEngName);
db.AddInParameter(cmd, "V_ACTIVITY_DETAIL_NEP_NAME", DbType.String, objActivity.ActivityDetailNepName);
db.AddInParameter(cmd, "V_ACTIVITY_UNIT_ID", DbType.Decimal, objActivity.ActivityUnitId);
db.AddInParameter(cmd, "V_ISENABLE", DbType.Int16, objActivity.Isenable);
db.AddInParameter(cmd, "V_ISLOCKED", DbType.Int16, objActivity.Islocked);
db.AddInParameter(cmd, "V_ACTIVITY_SUB_SECTOR_ID", DbType.Decimal, objActivity.ActivitySubSectorId);
i = db.ExecuteNonQuery(cmd);
return(i);
}
protected void btnAddRoles_Click(object sender, EventArgs e)
{
wbs = new ActivityManagementService();
wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity();
objActivityBo = new ActivityDetailBO();
if (hidActivityDetailId.Value.ToInt32() > 0)
{
objActivityBo.Mode = "U";
objActivityBo.ActivityDetailId = hidActivityDetailId.Value.ToInt32();
}
else
{
objActivityBo.Mode = "I";
}
objActivityBo.ActivityDetailEngName = txtActivityDetailEngName.Text;
objActivityBo.ActivityDetailNepName = txtActivityDetailNepName.Text;
objActivityBo.Isenable = IsActive.Checked == true ? 1 : 0;
objActivityBo.ActivityUnitId = ddlUnit.SelectedValue.ToInt32();
objActivityBo.ActivitySubSectorId = ddlSubSector.SelectedValue.ToInt32();
wbs.ActivityDetail(objActivityBo);
Response.Redirect(Constants.ConstantAppPath + "/Modules/ActivityManagement/AddActivityDetail.aspx");
}
protected void rptOutput_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
ActivityManagementService objAms = new ActivityManagementService();
DropDownList ddlUnit = (DropDownList)e.Item.FindControl("ddlUnit");
ActivityDetailBO objAdb = new ActivityDetailBO();
objAdb.Lang = Session["LanguageSetting"].ToString();
objAms.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationActivity();
DataTable dtUnit = objAms.SelectActivityUnit(objAdb);
if (dtUnit != null && dtUnit.Rows.Count > 0)
{
ddlUnit.DataSource = dtUnit;
ddlUnit.DataTextField = "UNIT_NAME";
ddlUnit.DataValueField = "UNIT_ID";
ddlUnit.DataBind();
ddlUnit.Items.Insert(0, "--छान्नुहोस्--");
}
DropDownList ddlPlanUnit = new DropDownList();
ddlPlanUnit = (DropDownList)e.Item.FindControl("ddlUnit");
ddlPlanUnit.SelectedValue = dtA.Rows[e.Item.ItemIndex]["UNIT_ID"].ToString();
}
}
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/AddActivityDetail.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();
objActivityBo = new ActivityDetailBO();
objActivityBo.ActivityDetailId = roleId;
objActivityBo.Mode = "D";
i = wbs.ActivityDetail(objActivityBo);
//wbs.deleteDonar(donarId);
if (i > 0)
{
Response.Redirect(Constants.ConstantAppPath + "/Modules/ActivityManagement/AddActivityDetail.aspx");
}
else
{
Response.Write("<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();
objActivityBo = new ActivityDetailBO();
objActivityBo.ActivityDetailId = roleId;
objActivityBo.Mode = "L";
i = wbs.ActivityDetail(objActivityBo);
if (i > 0)
{
Response.Redirect(Constants.ConstantAppPath + "/Modules/ActivityManagement/AddActivityDetail.aspx");
}
else
{
Response.Write("<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());
objActivityBo = new ActivityDetailBO();
objActivityBo.ActivityDetailId = roleId;
objActivityBo.Mode = "L";
i = wbs.ActivityDetail(objActivityBo);
if (i > 0)
{
Response.Redirect(Constants.ConstantAppPath + "/Modules/ActivityManagement/AddActivityDetail.aspx");
}
else
{
Response.Write("<script>alert('Delete failed')</script>");
}
}
}
public DataTable SelectActivityOutputBySector(ActivityDetailBO objActivityDetail)
{
Authentication();
return(objActivity.SelectActivityOutputBySector(objActivityDetail));
}
public DataTable SelectActivityUnit(ActivityDetailBO objActivityDetail)
{
Authentication();
return(objActivity.SelectActivityUnit(objActivityDetail));
}
public int ActivityDetail(ActivityDetailBO objActivityDetail)
{
Authentication();
return(objActivity.ActivityDetail(objActivityDetail));
}
public DataTable PopulateActivityDetail(ActivityDetailBO objActivityDetail)
{
Authentication();
return(objActivity.SelectActivityDetail(objActivityDetail));
}
