private void populateSubSector(int i)
{
objWebService = new SectorService();
objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationSector();
ComSubSector objComSubSector = new ComSubSector();
objComSubSector.SubSectorId = i;
DataTable dtPopulateSubSector = objWebService.PopulateAllSubSectors(objComSubSector);
Session["dtPopulateSubSector"] = dtPopulateSubSector;
if (dtPopulateSubSector != null && dtPopulateSubSector.Rows.Count > 0)
{
txtSubSectorEngName.Text = dtPopulateSubSector.Rows[0]["activity_sub_sector_eng_name"].ToString();
txtSubSectorNepName.Text = dtPopulateSubSector.Rows[0]["activity_sub_sector_nep_name"].ToString();
txtSubSectorCode.Text = dtPopulateSubSector.Rows[0]["activity_sub_sector_code"].ToString();
ddlSector.SelectedValue = dtPopulateSubSector.Rows[0]["activity_sector_id"].ToString();
if (Convert.ToInt16(dtPopulateSubSector.Rows[0]["ISENABLE"]) == 1)
{
chkIsEnable.Checked = true;
}
else
{
chkIsEnable.Checked = false;
}
}
}
protected void BtnEdit_Command(object sender, CommandEventArgs e)
{
int subSectorId = 0;
if (e.CommandName == "edit")
{
subSectorId = int.Parse(e.CommandArgument.ToString());
SecureQueryString str = new SecureQueryString();
str["id"] = e.CommandArgument.ToString();
Response.Redirect(Constants.ConstantAppPath + "/Modules/SectorManagement/AddEditSubSector.aspx" + str.EncryptedString, false);
}
else if (e.CommandName == "delete")
{
objComSubSector = new ComSubSector();
objComSubSector.SubSectorId = int.Parse(e.CommandArgument.ToString());
objComSubSector.Mode = "D";
objWebService = new SectorService();
objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationSector();
objWebService.AddSubSector(objComSubSector);
Response.Redirect(Constants.ConstantAppPath + "/Modules/SectorManagement/ListSubSector.aspx");
}
else if (e.CommandName == "lock")
{
int i = 0;
objComSubSector = new ComSubSector();
objComSubSector.SubSectorId = int.Parse(e.CommandArgument.ToString());
objComSubSector.Mode = "L";
objWebService = new SectorService();
objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationSector();
i = objWebService.AddSubSector(objComSubSector);
if (i > 0)
{
Response.Redirect(Constants.ConstantAppPath + "/Modules/SectorManagement/ListSubSector.aspx");
}
else
{
Response.Write("<script>alert('Lock failed')</script>");
}
}
else
{
int i = 0;
objComSubSector = new ComSubSector();
objComSubSector.SubSectorId = int.Parse(e.CommandArgument.ToString());
objComSubSector.Mode = "L";
objWebService = new SectorService();
objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationSector();
i = objWebService.AddSubSector(objComSubSector);
if (i > 0)
{
Response.Redirect(Constants.ConstantAppPath + "/Modules/SectorManagement/ListSubSector.aspx");
}
else
{
Response.Write("<script>alert('Unlock failed')</script>");
}
}
}
protected void ddlSector_SelectedIndexChanged(object sender, EventArgs e)
{
objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationSector();
objComSubSector.SectorId = ddlSector.SelectedValue.ToInt32();
objComSubSector.Lang = Session["LanguageSetting"].ToString();
dtPopulateSubSector = objWebService.PopulateSubSectorsBySectorId(objComSubSector);
if (dtPopulateSubSector != null && dtPopulateSubSector.Rows.Count > 0)
{
ddlSubSector.DataSource = dtPopulateSubSector;
ddlSubSector.DataValueField = "ACTIVITY_SUB_SECTOR_ID";
ddlSubSector.DataTextField = "SUB_SECTOR_NAME";
ddlSubSector.DataBind();
ddlSubSector.Items.Insert(0, "--छान्नुहोस्--");
}
}
private void BindListView()
{
objWebService = new SectorService();
objComSubSector = new ComSubSector();
objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationSector();
objComSubSector.Lang = Session["LanguageSetting"].ToString();
dtListView = objWebService.PopulateAllSubSectors(objComSubSector);
if (dtListView != null && dtListView.Rows.Count > 0)
{
lvSubSector.DataSource = dtListView;
lvSubSector.DataBind();
}
else
{
}
}
private void PopulateSector()
{
ComSubSector objComSubSector = new ComSubSector();
SectorService objWebService = new SectorService();
DataTable dtPopulateSector = null;
objComSubSector.Lang = Session["LanguageSetting"].ToString();
objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationSector();
dtPopulateSector = objWebService.PopulateAllSectors(objComSubSector);
if (dtPopulateSector != null && dtPopulateSector.Rows.Count > 0)
{
ddlSector.DataSource = dtPopulateSector;
ddlSector.DataValueField = "SECTOR_ID";
ddlSector.DataTextField = "SECTOR_NAME";
ddlSector.DataBind();
ddlSector.Items.Insert(0, "--छान्नुहोस्--");
}
}
protected void btnAddSubSector_Click(object sender, EventArgs e)
{
int i = 0;
objComSubSector = new ComSubSector();
objComSubSector.SubSectorEngName = txtSubSectorEngName.Text;
objComSubSector.SubSectorNepName = txtSubSectorNepName.Text;
objComSubSector.SubSectorCode = txtSubSectorCode.Text;
objComSubSector.SectorId = ddlSector.SelectedValue.ToInt32();
objComSubSector.SubSectorId = Session["subSectorId"].ToInt32();
objComSubSector.Islocked = 0;
if (chkIsEnable.Checked == true)
{
objComSubSector.Isenable = 1;
}
else
{
objComSubSector.Isenable = 0;
}
objComSubSector.Lang = Session["LanguageSetting"].ToString();
if (Session["subSectorId"].ToInt32() == 0)
{
objComSubSector.Mode = "I";
}
else
{
objComSubSector.Mode = "U";
}
objWebService = new SectorService();
objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationSector();
i = objWebService.AddSubSector(objComSubSector);
if (i > 0)
{
Response.Write("<script>alert('Sub Sector added successfully!')</script>");
Response.Redirect(Constants.ConstantAppPath + "/Modules/SectorManagement/ListSubSector.aspx");
}
else
{
Response.Write("<script>alert('Sub Sector addition failed!')</script>");
}
}
private void populateSubSector()
{
SectorService objWebService = new SectorService();
objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationSector();
DataTable dtPopulateSubSector = null;
string selectedDataText = string.Empty;
ComSubSector objComSubSector = new ComSubSector();
dtPopulateSubSector = objWebService.PopulateAllSubSectors(objComSubSector);
if (dtPopulateSubSector != null && dtPopulateSubSector.Rows.Count > 0)
{
selectedDataText = Session["LanguageSetting"].ToString() == "Nepali" ? "activity_sub_sector_nep_name" : "activity_sub_sector_eng_name";
ddlSubSector.DataSource = dtPopulateSubSector;
ddlSubSector.DataTextField = selectedDataText;
ddlSubSector.DataValueField = "activity_sub_sector_id";
ddlSubSector.DataBind();
ddlSubSector.Items.Insert(0, "-- छान्नुहोस्--");
}
}
private void PopulateProjectDetails(int projectId)
{
DataTable dtProjectSansodhan = null;
ComProjectBO obj = new ComProjectBO();
DataTable dtPopulateProjectDetails = null;
obj.ProjectId = projectId;
wbs = new ProjectService();
wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject();
dtPopulateProjectDetails = wbs.PopulateProjectDetails(obj);
if (dtPopulateProjectDetails != null && dtPopulateProjectDetails.Rows.Count > 0)
{
ddlBudgetHead.SelectedValue = dtPopulateProjectDetails.Rows[0]["BUDGET_HEAD_ID"].ToString();
txtAyojanaNepName.Text = dtPopulateProjectDetails.Rows[0]["PROJECT_NEP_NAME"].ToString();
txtAyojanaEngName.Text = dtPopulateProjectDetails.Rows[0]["PROJECT_ENG_NAME"].ToString();
txtAyojanaLakshya.Text = dtPopulateProjectDetails.Rows[0]["PROJECT_LAKSHYA"].ToString();
txtAyojanaUdeshya.Text = dtPopulateProjectDetails.Rows[0]["PROJECT_UDESHYA"].ToString();
txtAyojanaPratifal.Text = dtPopulateProjectDetails.Rows[0]["PROJECT_PRATIFAL"].ToString();
txtAyojanaKriyakalap.Text = dtPopulateProjectDetails.Rows[0]["PROJECT_MAIN_ACTIVITY"].ToString();
rblKaryakramPrakar.SelectedValue = dtPopulateProjectDetails.Rows[0]["PROJECT_PROGRAM_TYPE"].ToString();
txtSuruMiti.Text = dtPopulateProjectDetails.Rows[0]["SURU_MITI"].ToString();
txtAyojanaSampannaMiti.Text = dtPopulateProjectDetails.Rows[0]["SAMPAANA_MITI"].ToString();
rbdJalBayuSanket.SelectedValue = dtPopulateProjectDetails.Rows[0]["JALVAYU_SANKET"].ToString();
rbdYojanaRananiti.SelectedValue = dtPopulateProjectDetails.Rows[0]["YOJANA_RANANITI_NO"].ToString();
lblModification.Text = dtPopulateProjectDetails.Rows[0]["MODIFIED_DATE"].ToDateTime().ToString("D");
lblModifiedBy.Text = dtPopulateProjectDetails.Rows[0]["MODIFIED_BY"].ToString();
/* txtAyojanaSampannaMitiPratham.Text =dtPopulateProjectDetails.Rows[0]["SAMPAANA_MITI1"].ToString();
* txtAyojanaSampannaMitiDoshro.Text =dtPopulateProjectDetails.Rows[0]["SAMPAANA_MITI2"].ToString();
* txtAyojanaSampannaMitiTeshro.Text =dtPopulateProjectDetails.Rows[0]["SAMPAANA_MITI3"].ToString();*/
ddlSector.SelectedValue = dtPopulateProjectDetails.Rows[0]["SECTOR_ID"].ToString();
Session["project_ministry_id"] = dtPopulateProjectDetails.Rows[0]["MINISTRY_ID"].ToInt32();
SectorService objWebService = new SectorService();
ComSubSector objComSubSector = new ComSubSector();
DataTable dtPopulateSubSector = null;
objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationSector();
objComSubSector.SectorId = dtPopulateProjectDetails.Rows[0]["SECTOR_ID"].ToInt32();
objComSubSector.Lang = Session["LanguageSetting"].ToString();
dtPopulateSubSector = objWebService.PopulateSubSectorsBySectorId(objComSubSector);
if (dtPopulateSubSector != null && dtPopulateSubSector.Rows.Count > 0)
{
ddlSubSector.DataSource = dtPopulateSubSector;
ddlSubSector.DataTextField = "SUB_SECTOR_NAME";
ddlSubSector.DataValueField = "ACTIVITY_SUB_SECTOR_ID";
ddlSubSector.DataBind();
ddlSubSector.Items.Insert(0, "छान्नुहोस्");
}
hidSubSector.Value = ddlSubSector.SelectedValue = dtPopulateProjectDetails.Rows[0]["SUB_SECTOR_ID"].ToString();
ProjectService objPs = new ProjectService();
EntitySubSector objCss = new EntitySubSector();
DataTable dtPopulateRananiti = null;
objPs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject();
objCss.SubSectorId = ddlSubSector.SelectedValue.ToInt32();
objCss.Lang = Session["LanguageSetting"].ToString();
dtPopulateRananiti = objPs.PopulateRananitiBySubSectorId(objCss);
if (dtPopulateRananiti != null && dtPopulateRananiti.Rows.Count > 0)
{
ddlRananiti.DataSource = dtPopulateRananiti;
ddlRananiti.DataTextField = "RANANITI_NAME";
ddlRananiti.DataValueField = "RANANITI_ID";
ddlRananiti.DataBind();
ddlRananiti.Items.Insert(0, "छान्नुहोस्");
}
hidRananiti.Value = ddlRananiti.SelectedValue = dtPopulateProjectDetails.Rows[0]["RANANITI_ID"].ToString();
objPs = new ProjectService();
ComProjectBO objComProjectBO = new ComProjectBO();
DataTable dtPopulateKaryaniti = new DataTable();
objPs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject();
objComProjectBO.Rananiti = ddlRananiti.SelectedValue.ToInt32();
objComProjectBO.Lang = Session["LanguageSetting"].ToString();
dtPopulateKaryaniti = objPs.PopulateKaryanitiByRananitiId(objComProjectBO);
if (dtPopulateKaryaniti != null && dtPopulateKaryaniti.Rows.Count > 0)
{
ddlKaryaniti1.DataSource = dtPopulateKaryaniti;
ddlKaryaniti1.DataTextField = "KARYANITI_NAME";
ddlKaryaniti1.DataValueField = "KARYANITI_ID";
ddlKaryaniti1.DataBind();
ddlKaryaniti1.Items.Insert(0, "छान्नुहोस्");
ddlKaryaniti2.DataSource = dtPopulateKaryaniti;
ddlKaryaniti2.DataTextField = "KARYANITI_NAME";
ddlKaryaniti2.DataValueField = "KARYANITI_ID";
ddlKaryaniti2.DataBind();
ddlKaryaniti2.Items.Insert(0, "छान्नुहोस्");
ddlKaryaniti3.DataSource = dtPopulateKaryaniti;
ddlKaryaniti3.DataTextField = "KARYANITI_NAME";
ddlKaryaniti3.DataValueField = "KARYANITI_ID";
ddlKaryaniti3.DataBind();
ddlKaryaniti3.Items.Insert(0, "छान्नुहोस्");
}
hidKaryaniti1.Value = ddlKaryaniti1.SelectedValue = dtPopulateProjectDetails.Rows[0]["KARYANITI_ID1"].ToString();
hidKaryaniti2.Value = ddlKaryaniti2.SelectedValue = dtPopulateProjectDetails.Rows[0]["KARYANITI_ID2"].ToString();
hidKaryaniti3.Value = ddlKaryaniti3.SelectedValue = dtPopulateProjectDetails.Rows[0]["KARYANITI_ID3"].ToString();
//added later
if (dtPopulateProjectDetails.Rows[0]["SAHASRABDI_OR_DIGO"].ToInt32() == 1)
{
rbdSahaSrabdiDigo.SelectedValue = "1";
/*sahaSrabdi1.Visible = true;
* sahaSrabdi2.Visible = true;
* sahaSrabdi3.Visible = true;
* digo1.Visible = false;
* digo2.Visible = false;
* digo3.Visible = false;*/
}
else
{
rbdSahaSrabdiDigo.SelectedValue = "2";
/*sahaSrabdi1.Visible = false;
* sahaSrabdi2.Visible = false;
* sahaSrabdi3.Visible = false;
* digo1.Visible = true;
* digo2.Visible = true;
* digo3.Visible = true;*/
}
ddlSahasabdiBikashLakshya.SelectedValue =
dtPopulateProjectDetails.Rows[0]["SAHA_BIKASH_LAKSHYA"].ToString();
ddlDigoBikashLakshya.SelectedValue = dtPopulateProjectDetails.Rows[0]["DIGO_BIKASH_LAKSHYA"].ToString();
if (dtPopulateProjectDetails.Rows[0]["SAHASRABDI_OR_DIGO"].ToInt32() == 1)
{
PopulateSahashrabdiBikashGantabya();
}
else
{
PopulateDigoBikashGantabya();
}
/* objPs = new ProjectService();
* objComProjectBO = new ComProjectBO();
* DataTable dtPopulateGantabya = new DataTable();
* DataTable dtPopulateDigoGantabya = new DataTable();
*
* objPs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject();
* objComProjectBO.SahasabdiBikashLakshya = ddlSahasabdiBikashLakshya.SelectedValue.ToInt32();
* objComProjectBO.Lang = Session["LanguageSetting"].ToString();
* objComProjectBO.DigoBikashLakshya = ddlDigoBikashLakshya.SelectedValue.ToInt32();
* dtPopulateGantabya = objPs.PopulateSahashrabdiBikashGantabya(objComProjectBO);
* dtPopulateDigoGantabya = objPs.PopulateDigoBikashGantabya(objComProjectBO);
*
* if (dtPopulateGantabya != null && dtPopulateGantabya.Rows.Count > 0)
* {
* ddlSahasabdiBikashGantabya.DataSource = dtPopulateGantabya;
* ddlSahasabdiBikashGantabya.DataTextField = "GANTABYA_NAME";
* ddlSahasabdiBikashGantabya.DataValueField = "GANTABYA_ID";
* ddlSahasabdiBikashGantabya.DataBind();
* ddlSahasabdiBikashGantabya.Items.Insert(0, "छान्नुहोस्");
*
* }*/
hidSahasabdiBikashGantabya.Value = ddlSahasabdiBikashGantabya.SelectedValue =
dtPopulateProjectDetails.Rows[0]["SAHA_BIKASH_GANTABYA"].ToString();
/*if (dtPopulateDigoGantabya != null && dtPopulateDigoGantabya.Rows.Count > 0)
* {
* ddlDigoBikashGantabya.DataSource = dtPopulateDigoGantabya;
* ddlDigoBikashGantabya.DataTextField = "DIGO_GANTABYA_NAME";
* ddlDigoBikashGantabya.DataValueField = "DIGO_GANTABYA_ID";
* ddlDigoBikashGantabya.DataBind();
* ddlDigoBikashGantabya.Items.Insert(0, "छान्नुहोस्");
* }*/
hidDigoBikashGantavya.Value = ddlDigoBikashGantabya.SelectedValue =
dtPopulateProjectDetails.Rows[0]["DIGO_BIKASH_GANTABYA"].ToString();
if (dtPopulateProjectDetails.Rows[0]["SAHASRABDI_OR_DIGO"].ToInt32() == 1)
{
PopulateSahashrabdiBikashSuchak();
}
else
{
PopulateDigoBikashSuchak();
}
/*objPs = new ProjectService();
* objComProjectBO = new ComProjectBO();
* DataTable dtPopulateSuchak = new DataTable();
* DataTable dtPopulateDigoSuchak = new DataTable();
* objPs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject();
* objComProjectBO.SahasabdiBikashGantabya = ddlSahasabdiBikashGantabya.SelectedValue.ToInt32();
* objComProjectBO.Lang = Session["LanguageSetting"].ToString();
* objComProjectBO.DigoBikashGantabya = ddlDigoBikashGantabya.SelectedValue.ToInt32();
* dtPopulateSuchak = objPs.PopulateSahashrabdiBikashSuchak(objComProjectBO);
* dtPopulateDigoSuchak = objPs.PopulateDigoBikashSuchak(objComProjectBO);
* if (dtPopulateSuchak != null && dtPopulateSuchak.Rows.Count > 0)
* {
* ddlSahasabdiBikashSuchak.DataSource = dtPopulateSuchak;
* ddlSahasabdiBikashSuchak.DataTextField = "SUCHAK_NAME";
* ddlSahasabdiBikashSuchak.DataValueField = "SUCHAK_ID";
* ddlSahasabdiBikashSuchak.DataBind();
* ddlSahasabdiBikashSuchak.Items.Insert(0, "छान्नुहोस्");
* }
*
* if (dtPopulateDigoSuchak != null && dtPopulateDigoSuchak.Rows.Count > 0)
* {
* ddlDigoBikashSuchak.DataSource = dtPopulateDigoSuchak;
* ddlDigoBikashSuchak.DataTextField = "DIGO_SUCHAK_NAME";
* ddlDigoBikashSuchak.DataValueField = "DIGO_SUCHAK_ID";
* ddlDigoBikashSuchak.DataBind();
* ddlDigoBikashSuchak.Items.Insert(0, "छान्नुहोस्");
* }*/
hidSahasabdiBikashSuchak.Value = ddlSahasabdiBikashSuchak.SelectedValue =
dtPopulateProjectDetails.Rows[0]["SAHA_BIKASH_SUCHAK"].ToString();
hidDigoBikashSuchak.Value =
ddlDigoBikashSuchak.SelectedValue =
dtPopulateProjectDetails.Rows[0]["DIGO_BIKASH_SUCHAK"].ToString();
rbdGaribiSankhet.SelectedValue = dtPopulateProjectDetails.Rows[0]["GARIBI_SANKET"].ToString();
rbdLaingikSankhet.SelectedValue = dtPopulateProjectDetails.Rows[0]["LAINGIK_SANKET"].ToString();
string AayojanaKisim = dtPopulateProjectDetails.Rows[0]["AAYOJANA_KISIM"].ToString();
List <string> AayojanaType = AayojanaKisim.Split(new char[] { ',' }).ToList <string>();
for (int i = 0; i < chkAyojanaKisim.Items.Count; i++)
{
for (int j = 0; j < AayojanaType.Count; j++)
{
if (chkAyojanaKisim.Items[i].Value == AayojanaType[j])
{
chkAyojanaKisim.Items[i].Selected = true;
break;
}
}
}
rbdMadhyaKharchaYojana.SelectedValue = dtPopulateProjectDetails.Rows[0]["PRIORITY"].ToString();
txtKaryanayanNikaya.Text = dtPopulateProjectDetails.Rows[0]["NIKAAYA"].ToString();
txtAyojanaLagat.Text = dtPopulateProjectDetails.Rows[0]["KUL_LAAGAT"].ToString();
if (dtPopulateProjectDetails.Rows[0]["IS_ENABLE"].ToInt32() == 1)
{
chkEnable.Checked = true;
}
else
{
chkEnable.Checked = false;
}
obj = new ComProjectBO();
obj.ProjectId = projectId;
wbs = new ProjectService();
wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationProject();
dtProjectSansodhan = wbs.PopulateProjectSansodhan(obj);
dtA = dtProjectSansodhan;
if (dtProjectSansodhan != null && dtProjectSansodhan.Rows.Count > 0)
{
rptSansodhan.DataSource = dtProjectSansodhan;
rptSansodhan.DataBind();
foreach (RepeaterItem rptItem in rptSansodhan.Items)
{
TextBox txtSansodhanDate = new TextBox();
txtSansodhanDate = (TextBox)rptItem.FindControl("txtSansodhanDate");
}
}
else
{
dtA.Clear();
DataRow drB = dtA.NewRow();
drB["SANSODHAN_DATE"] = "";
dtA.Rows.Add(drB);
rptSansodhan.DataSource = dtA;
rptSansodhan.DataBind();
}
}
}