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; } } }
/// <summary> /// Populate Sector by Id /// </summary> /// <param name="search"></param> public TSMSector GetSectorByID(Guid id) { TSMSector objSector = new TSMSector(); try { objSector = SectorService.GetSector(id); if (objSector != null) { this.ParentNomenclature = new List <TSMSector>(); this.ChildNomenclature = new List <TSMSector>(); this.ID = objSector.ID; this.Nomenclaturetype = objSector.NomenclatureType; this.Sectortype = objSector.Type; this.ParentCode = objSector.ParentID.ToString(); this.SectorName = objSector.Name; this.NomenclatureCode = objSector.Code; this.IsActive = objSector.IsActive; } } catch (Exception ex) { ErrorLog.WriteLog("ManageUserModel", "Populate", ex, ""); } return(objSector); }
public List <Combo> FindSubSectorBySectorId(string sectorId) { SectorService objWebService = new SectorService(); ComSubSector objComSubSector = new ComSubSector(); DataTable dtPopulateSubSector = null; List <Combo> objList = new List <Combo>(); objWebService.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationSector(); objComSubSector.SectorId = sectorId.ToDecimal(); objComSubSector.Lang = Session["LanguageSetting"].ToString(); dtPopulateSubSector = objWebService.PopulateSubSectorsBySectorId(objComSubSector); if (dtPopulateSubSector != null && dtPopulateSubSector.Rows.Count > 0) { objList.Add(new Combo { ComboId = 0, Name = "छान्नुहोस" }); foreach (DataRow dr in dtPopulateSubSector.Rows) { objList.Add(new Combo { ComboId = dr["ACTIVITY_SUB_SECTOR_ID"].ToInt32(), Name = dr["SUB_SECTOR_NAME"].ToString() }); } } return(objList); }
/// <summary> /// Get Parent By Child /// </summary> /// <param name="ChildCode"></param> /// <returns></returns> public string GetParentByChild(string ChildCode) { string id = string.Empty; id = SectorService.GetParentByChild(ChildCode); return(id); }
/// <summary> /// Get Parent ID For Nomenclature /// </summary> public List <TSMSector> GetParentID(string nomenclatureCode, string Sectortype) { List <TSMSector> lstTSMSector = new List <TSMSector>(); lstTSMSector = SectorService.GetParentID(nomenclatureCode, Sectortype); this.ParentNomenclature = lstTSMSector; return(lstTSMSector); }
/// <summary> /// Get Child ID For Nomenclature /// </summary> public List <TSMSector> GetChildID(string ParentCode) { List <TSMSector> lstTSMSector = new List <TSMSector>(); lstTSMSector = SectorService.GetChildID(ParentCode); this.ParentNomenclature = lstTSMSector; return(lstTSMSector); }
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>"); } } }
/// <summary> /// Save /// </summary> public TSMSector Save() { TSMSector tsmSector = new TSMSector(); try { if (this.ID != Guid.Empty) { tsmSector = SectorService.GetSector(this.ID); tsmSector.ID = this.ID; tsmSector.LastModifiedBy = TSM.Model.TSMContext.CurrentUser.ID; tsmSector.LastModifiedDate = DateTime.UtcNow; } else { tsmSector = new TSMSector(); tsmSector.CreatedBy = TSM.Model.TSMContext.CurrentUser.ID; tsmSector.CreatedDate = DateTime.UtcNow; } tsmSector.LanguageID = TSMContext.CurrentLanguageID; tsmSector.Code = this.NomenclatureCode; tsmSector.IsActive = this.IsActive; tsmSector.IsDeleted = false; tsmSector.Name = this.SectorName; tsmSector.NomenclatureType = this.Nomenclaturetype; Guid newGuid = new Guid(); try { var childcode = this.ChildCode; var parentCode = this.ParentCode; if (childcode != null) { newGuid = Guid.Parse(childcode); tsmSector.ParentID = newGuid; } else if (parentCode != null) { newGuid = Guid.Parse(parentCode); tsmSector.ParentID = newGuid; } } catch { tsmSector.ParentID = null; } tsmSector.Type = this.Sectortype; SectorService.Save(tsmSector); } catch (Exception ex) { ErrorLog.WriteLog("ManageUserModel", "Save", ex, ""); } return(tsmSector); }
/// <summary> /// Get All Sectors /// </summary> /// <returns></returns> public void GetAllSector(SearchAttributes searchParam) { try { this.lstSector = new List <TSMSector>(); this.SearchParam = searchParam; this.lstSector = SectorService.GetSectors(searchParam, TSMContext.CurrentLanguageID); } catch (Exception ex) { ErrorLog.WriteLog("ManageUserModel", "Populate", ex, ""); } }
/// <summary> /// Delete Sector /// </summary> /// <param name="id"></param> /// <param name="Model"></param> public void Delete(Guid id) { TSMSector tsmSector = SectorService.GetSector(id); if (tsmSector != null) { tsmSector.IsActive = false; tsmSector.IsDeleted = true; tsmSector.LastModifiedBy = TSMContext.CurrentUser.ID; tsmSector.LastModifiedDate = DateTime.UtcNow; SectorService.Delete(tsmSector); } }
/// <summary> /// Populate Sector /// </summary> /// <param name="search"></param> public TSMSector GetSector(Guid id) { TSMSector objSector = new TSMSector(); try { objSector = SectorService.GetSector(id); } catch (Exception ex) { ErrorLog.WriteLog("ManageUserModel", "Populate", ex, ""); } return(objSector); }
protected override void Initialize(RequestContext requestContext) { if (exploitationService == null) { exploitationService = new ExploitationService(); } if (parcelleService == null) { parcelleService = new ParcelleService(); } if (secteurService == null) { secteurService = new SectorService(); } if (nodeService == null) { nodeService = new NodeService(); } if (climatNodeService == null) { climatNodeService = new NodeClimatService(); } if (mesuresClimatService == null) { mesuresClimatService = new MesuresClimatService(); } if (et0Service == null) { et0Service = new EToService(); } if (mesuresIrrigationService == null) { mesuresIrrigationService = new MesuresIrrigationService(); } if (electrovanneService == null) { electrovanneService = new VanneService(); } if (notificationService == null) { notificationService = new NotificationService(); } if (noeudfictifService == null) { noeudfictifService = new NodeFictifService(); } base.Initialize(requestContext); }
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 InitialData() { Session["lstOrderDetail"] = null; var cmdStore = new StoreService(); //DataSouce = cmdStore.GetALL(); DataSouce = new List <STORE>(); USER user = Session["user"] as USER; if (user == null) { Response.Redirect("MainAdmin.aspx"); } var cmdZone = new ZoneDetailService(); foreach (ZONE_DETAIL zoneId in cmdZone.GetALLByUser(user.EMPLOYEE_ID)) { List <STORE> tmp = cmdStore.GetALL().Where(x => x.ZONE_ID == zoneId.ZONE_ID).ToList(); DataSouce.AddRange(tmp); } var cmd = new SectorService(); var list = cmd.GetALL(); foreach (var item in list) { ddlSector.Items.Add(new ListItem(item.SECTOR_NAME, item.SECTOR_ID.ToString())); } var cmdPro = new ProvinceService(); ViewState["listProvince"] = cmdPro.GetALL(); foreach (var item in (List <PROVINCE>)ViewState["listProvince"]) { ddlProvince.Items.Add(new ListItem(item.PROVINCE_NAME, item.PROVINCE_ID.ToString())); } var cmdRoad = new RoadService(); ViewState["listRoad"] = cmdRoad.GetALL(); foreach (var item in (List <ROAD>)ViewState["listRoad"]) { ddlRoad.Items.Add(new ListItem(item.ROAD_NAME, item.ROAD_ID.ToString())); } gridStore.DataSource = null; gridStore.DataBind(); }
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, "-- छान्नुहोस्--"); } }
/// <summary> /// Populate Data /// </summary> public void Populate() { Guid langaugeID = TSMContext.CurrentSiteLanguageID; this.Data = new List <KeyValue>(); var cacheProvider = CacheFactory.Get(); if (!cacheProvider.Exists(CacheKeys.CACHE_TSM_INT_SECTORS_DROPDOWN)) { var internationalSectors = SectorService.GetTSMSectors(langaugeID, Entity.NomenclatureType.International); var parentSectors = internationalSectors.Where(ts => ts.ParentID == null).OrderBy(ts => ts.Type).ThenBy(ts => ts.Name).ToList(); //First Level Loop foreach (var parentSector in parentSectors) { KeyValue keyValue = new KeyValue { Key = parentSector.ID.ToString(), Value = parentSector.Name, ClassName = "first-level", Level = "1" }; this.Data.Add(keyValue); var sectors = internationalSectors.Where(ts => ts.ParentID == parentSector.ID).OrderBy(ts => ts.Name).ToList(); //Second Level Loop foreach (var sector in sectors) { KeyValue keyValueSector = new KeyValue { Key = sector.ID.ToString(), Value = sector.Name, ClassName = "second-level", Level = "2" }; this.Data.Add(keyValueSector); var childSectors = internationalSectors.Where(ts => ts.ParentID == sector.ID).OrderBy(ts => ts.Name).ToList(); if (childSectors.Count == 0) { keyValueSector.ClassName = "second-level-last"; } //Third Level loop foreach (var childSector in childSectors) { KeyValue keyValueChildSector = new KeyValue { Key = childSector.ID.ToString(), Value = childSector.Name, ClassName = "third-level", Level = "3" }; this.Data.Add(keyValueChildSector); } } } //Add in Cache cacheProvider.Add <List <KeyValue> >(this.Data, CacheKeys.CACHE_TSM_INT_SECTORS_DROPDOWN, SiteConstants.CacheDuration); } else { this.Data = cacheProvider.Get <List <KeyValue> >(CacheKeys.CACHE_TSM_INT_SECTORS_DROPDOWN); } }
private void InitialDataPopup() { var cmd = new SectorService(); var list = cmd.GetALL(); foreach (var item in list) { ddlSector.Items.Add(new ListItem(item.SECTOR_NAME, item.SECTOR_ID.ToString())); } var cmdPro = new ProvinceService(); ViewState["listProvince"] = cmdPro.GetALL(); foreach (var item in (List<PROVINCE>)ViewState["listProvince"]) { ddlProvince.Items.Add(new ListItem(item.PROVINCE_NAME, item.PROVINCE_ID.ToString())); } var cmdRoad = new RoadService(); ViewState["listRoad"] = cmdRoad.GetALL(); foreach (var item in (List<ROAD>)ViewState["listRoad"]) { ddlRoad.Items.Add(new ListItem(item.ROAD_NAME, item.ROAD_ID.ToString())); } var cmdZone = new ZoneService(); var listZone = cmdZone.GetALL(); foreach (var item in listZone) { ddlZone.Items.Add(new ListItem(item.ZONE_NAME, item.ZONE_ID.ToString())); } if (ViewState["stoId"] != null) { var cmdStore = new StoreService(); _store = cmdStore.Select(Convert.ToInt32(ViewState["stoId"].ToString())); if (_store != null) { txtAddress.Text = _store.STORE_ADDR1; txtAmpur.Text = _store.STORE_DISTRICT; txtFax.Text = _store.STORE_FAX; txtMobli.Text = _store.STORE_MOBILE; txtPostCode.Text = _store.STORE_POSTCODE; popTxtStoreCode.Text = _store.STORE_CODE; poptxtStoreName.Text = _store.STORE_NAME; txtTel1.Text = _store.STORE_TEL1; txtTel2.Text = _store.STORE_TEL2; txtTumbon.Text = _store.STORE_SUBDISTRICT; ddlSector.SelectedValue = _store.SECTOR_ID.ToString(); ddlProvince.SelectedValue = _store.PROVINCE_ID.ToString(); ddlProvince.Enabled = true; ddlZone.SelectedValue = _store.ZONE_ID.ToString(); //if (ddlProvince.SelectedItem.Text.Equals("กรุงเทพมหานคร")) //{ ddlRoad.Visible = true; ddlRoad.SelectedValue = _store.ROAD_ID.ToString(); txtRoad.Visible = false; //} //else //{ // txtRoad.Text = _store.STORE_STREET; // ddlRoad.Visible = false; //} flag.Text = "Edit"; } } }
public SectorsController() { sectorService = new SectorService(); _logService = new LogService(); }
/// <summary> /// Populate /// </summary> /// <param name="id"></param> /// <returns></returns> public bool Populate(Guid id, string urlPath) { bool isExists = false; var languageID = TSMContext.CurrentSiteLanguageID; this.ThematicFocus = new List <string>(); this.DesignProcess = new List <string>(); try { this.RecordLanguage = RecordService.GetRecordLanguage(id, languageID); if (this.RecordLanguage != null) { isExists = true; this.Name = RecordLanguage.Name; this.ID = id.ToString(); //Document Type var documentType = RecordLanguage.Record.Variables.Where(v => v.VariableID == AppSettingsUtility.GetGuid(AppSettingsKeys.DocumentTypeVariableID) && v.LanguageID == languageID).FirstOrDefault(); if (documentType != null) { this.DocumentType = documentType.Value; } //Description var description = RecordLanguage.Record.Variables.Where(v => v.VariableID == AppSettingsUtility.GetGuid(AppSettingsKeys.DescriptionVariableID) && v.LanguageID == languageID).FirstOrDefault(); if (description != null) { this.Description = description.Value; } this.Region = GetRegionName(RecordLanguage, languageID); this.Countries = GetCountryNames(RecordLanguage, languageID); // Year var year = RecordLanguage.Record.Variables.Where(v => v.VariableID == AppSettingsUtility.GetGuid(AppSettingsKeys.YearVariableID) && v.LanguageID == languageID).FirstOrDefault(); if (year != null) { this.Year = year.Value; } //last updated var lastUpdated = RecordLanguage.Record.Variables.Where(v => v.VariableID == AppSettingsUtility.GetGuid(AppSettingsKeys.LastUpdatedVariableID) && v.LanguageID == languageID).FirstOrDefault(); if (lastUpdated != null) { this.LastUpdated = GetLastUpdatedValue(lastUpdated.Value); } //Implementation Period var startYear = RecordLanguage.Record.Variables.Where(v => v.VariableID == AppSettingsUtility.GetGuid(AppSettingsKeys.StartYearVariableID) && v.LanguageID == languageID).FirstOrDefault(); var endYear = RecordLanguage.Record.Variables.Where(v => v.VariableID == AppSettingsUtility.GetGuid(AppSettingsKeys.EndYearVariableID) && v.LanguageID == languageID).FirstOrDefault(); if (startYear != null) { this.ImplementationPeriod = startYear.Value; } if (endYear != null) { this.ImplementationPeriod += "/" + endYear.Value; } var variableLanguages = VariableService.GetVariables(languageID); //Thematic focus var thematicVariables = variableLanguages.Where(vl => vl.Variable.VariableCategory == VariableCategory.ThematicFocus && CompareVariableValue(RecordLanguage.Record.Variables, vl, "true")).ToList(); foreach (var variableLanguage in thematicVariables) { this.ThematicFocus.Add(variableLanguage.DisplayName); } this.ThematicFocus = this.ThematicFocus.OrderBy(tf => tf).ToList(); //design process focus var designProcessVariables = variableLanguages.Where(vl => vl.Variable.VariableCategory == VariableCategory.DesignProcess && CompareVariableValue(RecordLanguage.Record.Variables, vl, "true")).ToList(); foreach (var variableLanguage in designProcessVariables) { this.DesignProcess.Add(variableLanguage.DisplayName); } this.DesignProcess = this.DesignProcess.OrderBy(dp => dp).ToList(); //Populate Sectors var sectorLanguages = PrioritySectorService.GetSectors(languageID); var tsmSectors = SectorService.GetTSMSectors(languageID); List <Guid> sectorIds = this.RecordLanguage.Record.Sectors.Select(s => s.ID).ToList(); this.ServiceSectors = PopulateSectors(sectorIds, sectorLanguages, tsmSectors, SectorType.Service); this.ProductSectors = PopulateSectors(sectorIds, sectorLanguages, tsmSectors, SectorType.Product); //Populate Files this.Files = new List <Document>(); if (RecordLanguage.Record.Documents != null) { this.Files = RecordLanguage.Record.Documents; } //Get Public var isPub = RecordLanguage.Record.Variables.Where(v => v.VariableID == AppSettingsUtility.GetGuid(AppSettingsKeys.isDownload) && v.LanguageID == languageID).FirstOrDefault(); if (isPub != null) { if (isPub.Value == "true") { this.isPublic = "ITCdownload"; } else { this.isPublic = "Regulardownload"; } } else { this.isPublic = "Regulardownload"; } //Link Record var linkRecord = RecordLanguage.Record.Variables.Where(v => v.VariableID == AppSettingsUtility.GetGuid(AppSettingsKeys.RecordLink) && v.LanguageID == languageID).FirstOrDefault(); if (linkRecord != null) { this.recordLink = linkRecord.Value; } this.ZipFilePath = ""; this.LoginStat = ""; this.urlPathForDoc = urlPath.ToString(); } } catch (Exception ex) { ErrorLog.WriteLog("DocumentDetailModel", "Populate", ex, ""); } return(isExists); }
/// <summary> /// Check Sector Exist /// </summary> /// <returns></returns> public bool CheckSector() { bool exist = SectorService.CheckSector(TSM.Model.TSMContext.CurrentLanguageID, this.SectorName, this.NomenclatureCode); return(exist); }
private void InitialData() { Session["lstOrderDetail"] = null; var cmdStore = new StoreService(); //DataSouce = cmdStore.GetALL(); DataSouce = new List<STORE>(); USER user = Session["user"] as USER; if (user == null) Response.Redirect("MainAdmin.aspx"); var cmdZone = new ZoneDetailService(); foreach (ZONE_DETAIL zoneId in cmdZone.GetALLByUser(user.EMPLOYEE_ID)) { List<STORE> tmp = cmdStore.GetALL().Where(x => x.ZONE_ID == zoneId.ZONE_ID).ToList(); DataSouce.AddRange(tmp); } var cmd = new SectorService(); var list = cmd.GetALL(); foreach (var item in list) { ddlSector.Items.Add(new ListItem(item.SECTOR_NAME, item.SECTOR_ID.ToString())); } var cmdPro = new ProvinceService(); ViewState["listProvince"] = cmdPro.GetALL(); foreach (var item in (List<PROVINCE>)ViewState["listProvince"]) { ddlProvince.Items.Add(new ListItem(item.PROVINCE_NAME, item.PROVINCE_ID.ToString())); } var cmdRoad = new RoadService(); ViewState["listRoad"] = cmdRoad.GetALL(); foreach (var item in (List<ROAD>)ViewState["listRoad"]) { ddlRoad.Items.Add(new ListItem(item.ROAD_NAME, item.ROAD_ID.ToString())); } gridStore.DataSource = null; gridStore.DataBind(); }
private void InitialDataPopup() { var cmd = new SectorService(); var list = cmd.GetALL(); foreach (var item in list) { ddlSector.Items.Add(new ListItem(item.SECTOR_NAME, item.SECTOR_ID.ToString())); } var cmdPro = new ProvinceService(); ViewState["listProvince"] = cmdPro.GetALL(); foreach (var item in (List <PROVINCE>)ViewState["listProvince"]) { ddlProvince.Items.Add(new ListItem(item.PROVINCE_NAME, item.PROVINCE_ID.ToString())); } var cmdRoad = new RoadService(); ViewState["listRoad"] = cmdRoad.GetALL(); foreach (var item in (List <ROAD>)ViewState["listRoad"]) { ddlRoad.Items.Add(new ListItem(item.ROAD_NAME, item.ROAD_ID.ToString())); } var cmdZone = new ZoneService(); var listZone = cmdZone.GetALL(); foreach (var item in listZone) { ddlZone.Items.Add(new ListItem(item.ZONE_NAME, item.ZONE_ID.ToString())); } if (ViewState["stoId"] != null) { var cmdStore = new StoreService(); _store = cmdStore.Select(Convert.ToInt32(ViewState["stoId"].ToString())); if (_store != null) { txtAddress.Text = _store.STORE_ADDR1; txtAmpur.Text = _store.STORE_DISTRICT; txtFax.Text = _store.STORE_FAX; txtMobli.Text = _store.STORE_MOBILE; txtPostCode.Text = _store.STORE_POSTCODE; popTxtStoreCode.Text = _store.STORE_CODE; poptxtStoreName.Text = _store.STORE_NAME; txtTel1.Text = _store.STORE_TEL1; txtTel2.Text = _store.STORE_TEL2; txtTumbon.Text = _store.STORE_SUBDISTRICT; ddlSector.SelectedValue = _store.SECTOR_ID.ToString(); ddlProvince.SelectedValue = _store.PROVINCE_ID.ToString(); ddlProvince.Enabled = true; ddlZone.SelectedValue = _store.ZONE_ID.ToString(); //if (ddlProvince.SelectedItem.Text.Equals("กรุงเทพมหานคร")) //{ ddlRoad.Visible = true; ddlRoad.SelectedValue = _store.ROAD_ID.ToString(); txtRoad.Visible = false; //} //else //{ // txtRoad.Text = _store.STORE_STREET; // ddlRoad.Visible = false; //} flag.Text = "Edit"; } } }
/// <summary> /// Populate Nomenclature Sectors /// </summary> /// <param name="nomenclatureType"></param> /// <param name="type"></param> public void Populate(NomenclatureType nomenclatureType, SectorType type) { Guid langaugeID = TSMContext.CurrentSiteLanguageID; this.Data = new List <KeyValue>(); var tsmSectors = SectorService.GetTSMSectors(langaugeID, nomenclatureType); //filter by type var parentSectors = tsmSectors.Where(ts => ts.ParentID == null && ts.Type == type).OrderBy(ts => ts.Type).ThenBy(ts => ts.Name).ToList(); //First Level Loop foreach (var parentSector in parentSectors) { KeyValue keyValue = new KeyValue { Key = parentSector.ID.ToString(), Value = parentSector.Name, ClassName = "first-level", Level = "1" }; this.Data.Add(keyValue); var sectors = tsmSectors.Where(ts => ts.ParentID == parentSector.ID).OrderBy(ts => ts.Name).ToList(); //Second Level Loop foreach (var sector in sectors) { KeyValue keyValueSector = new KeyValue { Key = sector.ID.ToString(), Value = sector.Name, ClassName = "second-level", Level = "2" }; this.Data.Add(keyValueSector); var childSectors = tsmSectors.Where(ts => ts.ParentID == sector.ID).OrderBy(ts => ts.Name).ToList(); if (childSectors.Count == 0) { keyValueSector.ClassName = "second-level-last"; } //Third Level loop foreach (var childSector in childSectors) { KeyValue keyValueChildSector = new KeyValue { Key = childSector.ID.ToString(), Value = childSector.Name, ClassName = "third-level", Level = "3" }; this.Data.Add(keyValueChildSector); } } } }
/// <summary> /// Initializes a new instance of the <see cref="SectorServiceTest"/> class. /// </summary> public SectorServiceTest() { DbContext = new Mock <IDbContext>(); SectorService = new SectorService(DbContext.Object); }
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(); } } }