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();
}
}
}