protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DDLHelper.BindDDL(ref drpCategories, BINROTA.BUS.PageCategories.GetPageCategoriesAll(), "PageCategoryName", "PageCategoryID", "", "Tüm Kategoriler", "0"); } }
private void SelectDrpValues(string ParentSubjectID) { DataTable dtSubject; if (drpRegion.Visible == true) { drpRegion.SelectedValue = ParentSubjectID; dtSubject = BINROTA.BUS.Subjects.GetSubject(int.Parse(ParentSubjectID));//region drpCountry.SelectedValue = dtSubject.Rows[0]["ParentSubjectID"].ToString(); DDLHelper.BindDDL(ref drpRegion, BINROTA.BUS.Subjects.GetSubjectBySubjectID(int.Parse(dtSubject.Rows[0]["ParentSubjectID"].ToString()), (int)Enumerations.SubjectType.Bolge), "Name", "SubjectID", ""); dtSubject = BINROTA.BUS.Subjects.GetSubject(int.Parse(dtSubject.Rows[0]["ParentSubjectID"].ToString()));//country drpContinents.SelectedValue = dtSubject.Rows[0]["ParentSubjectID"].ToString(); DDLHelper.BindDDL(ref drpCountry, BINROTA.BUS.Subjects.GetSubjectByParentSubjectID(int.Parse(drpContinents.SelectedValue)), "Name", "SubjectID", ""); } else { drpCountry.SelectedValue = ParentSubjectID; dtSubject = BINROTA.BUS.Subjects.GetSubject(int.Parse(ParentSubjectID));//country drpContinents.SelectedValue = dtSubject.Rows[0]["ParentSubjectID"].ToString(); DDLHelper.BindDDL(ref drpCountry, BINROTA.BUS.Subjects.GetSubjectByParentSubjectID(int.Parse(drpContinents.SelectedValue)), "Name", "SubjectID", ""); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = new DataTable(); dt.Columns.Add("Name"); dt.Columns.Add("CategoryID"); DataTable dtCategories = BINROTA.BUS.Categories.GetCategories(); DataRow dr = dt.NewRow(); dr["Name"] = "Ana Yazý"; dr["CategoryID"] = "0"; dt.Rows.Add(dr); foreach (DataRow drCategories in dtCategories.Rows) { dr = dt.NewRow(); dr["Name"] = drCategories["Name"]; dr["CategoryID"] = drCategories["CategoryID"]; dt.Rows.Add(dr); } DDLHelper.BindDDL(ref drpCategories, dt, "Name", "CategoryID", ""); } }
private void ArrangeDropDowns(int ParentSubjectID, Enumerations.SubjectType SubjectTypeID) { switch (SubjectTypeID) { case Enumerations.SubjectType.Kita: drpContinents.Visible = false; drpCountries.Visible = false; break; case Enumerations.SubjectType.Ulke: drpContinents.SelectedValue = ParentSubjectID.ToString(); drpContinents.Visible = true; break; case Enumerations.SubjectType.Sehir: DataTable dt = BINROTA.BUS.Subjects.GetParentSubjectBySubjectID(ParentSubjectID); if (dt.Rows.Count > 0) { drpContinents.SelectedValue = dt.Rows[0]["SubjectID"].ToString(); } DDLHelper.BindDDL(ref drpCountries, BINROTA.BUS.Subjects.GetSubjectByParentSubjectID(Convert.ToInt32(dt.Rows[0]["SubjectID"])), "Name", "SubjectID", ""); drpCountries.SelectedValue = ParentSubjectID.ToString(); drpContinents.Visible = true; drpCountries.Visible = true; break; } }
private void BindDateDDL() { DataTable dt = new DataTable(); dt.Columns.Add("Date"); dt.Columns.Add("Value"); for (int i = 2007; i <= 2008; i++) { for (int j = 1; j <= 12; j++) { if ((i == 2008) || (j > 10 && i == 2007)) { DataRow dr = dt.NewRow(); DateTime date = new DateTime(i, j, 1); dr["Date"] = string.Format("{0:Y}", date); dr["Value"] = date.Month.ToString() + date.Year.ToString(); dt.Rows.Add(dr); } } } DDLHelper.BindDDL(ref ddlDate, dt, "Date", "Value", "", "", ""); ddlDate.SelectedValue = ActivityDate.Month.ToString() + ActivityDate.Year.ToString(); }
public void ExecuteCreateScriptTest() { CreateDatabaseTest(); DDLHelper target = new DDLHelper(db); db.ChangeDatabase("information_schema"); DataSet ds = db.ExecuteQuery("SELECT * FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='" + schema_name + "'"); DataTable dt = ds.Tables[0]; if (dt.Rows.Count != 1) { Assert.Inconclusive("database does not exist"); return; } db.ChangeDatabase(schema_name); // todo could be a DE string file = @"..\..\..\GUI\bin\Debug\sql\create.sql"; // needs to be realtive target.ExecuteCreateScript(file); db.ChangeDatabase("information_schema"); ds = db.ExecuteQuery("SELECT * FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='" + schema_name + "'"); dt = ds.Tables[0]; Assert.IsTrue(dt.Rows.Count > 0); }
private void LoadMemberItem() { using (TheFacade facade = new TheFacade()) { List <Ins_MemberItem> memberItems = facade.InsentiveFacade.GetMemberItemByMemberID(MemberID); DDLHelper.Bind <Ins_MemberItem>(ddlItem, memberItems, "Name", "IID", EnumCollection.ListItemType.Select, true); } }
private void BindItemDropdownListForUpdate(long categoryId, long itemID) { using (TheFacade facade = new TheFacade()) { List <Ins_Item> itemList = facade.InsentiveFacade.GetItemListForMemberItemUpdateByCategoryID(categoryId, MemberID, itemID); DDLHelper.Bind <Ins_Item>(ddlItem, itemList, "Name", "IID", EnumCollection.ListItemType.ItemName, true); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DDLHelper.BindDDL(ref drpContinents, BINROTA.BUS.Subjects.GetSubjectForDDL(1), "Name", "SubjectID", ""); ModeControl(); } }
private void LoadMember() { using (TheFacade facade = new TheFacade()) { List <Member> members = facade.InsentiveFacade.GetMemberAll(); DDLHelper.Bind <Member>(ddlMember, members, "Name", "ID", EnumCollection.ListItemType.Select, true); } }
private void LoadCurrencyType() { using (TheFacade facade = new TheFacade()) { List <Currency> currencyTypeList = facade.MemberFacade.GetAllCurrency(); DDLHelper.Bind <Currency>(ddlCurrencyType, currencyTypeList, "CurrencyCode", "IID", EnumCollection.ListItemType.Currency, true); } }
private void LoadBusniessType() { using (TheFacade facade = new TheFacade()) { List <BusinessType> businessTypeList = facade.MemberFacade.GetBusinessTypeInfoAll(); DDLHelper.Bind <BusinessType>(ddlBusniessTypes, businessTypeList, "Name", "ID", EnumCollection.ListItemType.BusinessTypeList, true); } }
private void LoadData() { using (TheFacade facade = new TheFacade()) { List <Member> memberItems = facade.MemberFacade.GetApprovedMember(); DDLHelper.Bind <Member>(ddlMember, memberItems, "Name", "ID", EnumCollection.ListItemType.Select, true); } LoadListViews(); }
public static List <SelectListItem> ToSelectListItems(this IEnumerable <string> values, string selectedValue = null, bool addDefault = false) { Check.Null(values, "values"); var query = string.IsNullOrWhiteSpace(selectedValue) ? values.Select(x => DDLHelper.GetSelectListItem(x)) : values.Select(x => DDLHelper.GetMarkedSelectListItem(x, selectedValue)); return(addDefault ? query.ToDefaultPrependedList() : query.AsList()); }
private void LoadCompanyCategory() { using (TheFacade facade = new TheFacade()) { List <CompanyCategory> companyCategoryList = facade.MemberFacade.GetCompanyCategoryInfoAll(); DDLHelper.Bind <CompanyCategory>(ddlCompanyCategory, companyCategoryList, "Name", "ID", EnumCollection.ListItemType.CompanyCategory, true); } }
public static List <SelectListItem> ToSelectListItems(this IEnumerable <string> values, List <string> selectedValues = null, bool addDefault = false) { Check.Null(values, "values"); var query = selectedValues == null || !selectedValues.Any() ? values.Select(x => DDLHelper.GetSelectListItem(x)) : values.Select(x => DDLHelper.GetMarkedSelectListItem(x, selectedValues)); return(addDefault ? query.ToDefaultPrependedList() : query.AsList()); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DDLHelper.BindDDL(ref drpContinents, BINROTA.BUS.Subjects.GetSubjectForDDL((int)Enumerations.SubjectType.Kita), "Name", "SubjectID", ""); DDLHelper.BindDDL(ref drpCountry, BINROTA.BUS.Subjects.GetSubjectForDDL((int)Enumerations.SubjectType.Ulke), "Name", "SubjectID", ""); ModeControl(); } }
private void LoadInvoice() { using (TheFacade facade = new TheFacade()) { List <Inv_Master> invoiceList = facade.MemberFacade.GetInvoiceByMemberIDForChaForm(MemberID); DDLHelper.Bind <Inv_Master>(ddlInvoiceList, invoiceList, "Number", "IID", EnumCollection.ListItemType.Invoice, true); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DDLHelper.LoadNumberDDL(ref drpDay, 31, 1, 1); DDLHelper.LoadNumberDDL(ref drpMonth, 12, 1, 1); DDLHelper.LoadNumberDDL(ref drpYear, 2010, 1, 2000); DDLHelper.BindDDL(ref drpPageCategory, BINROTA.BUS.PageCategories.GetPageCategoriesAll(), "PageCategoryName", "PageCategoryID", ""); } }
private string GetFileConfigAlterDDL() { StringBuilder result = new StringBuilder(); foreach (var item in this.ToFileFieldList()) { result.AppendLine(DDLHelper.GetFileFieldDDL(item)); } return(result.ToString()); }
private void FillDropDowns() { DDLHelper.BindDDL(ref drpCountry, BINROTA.BUS.Subjects.GetSubjectForDDL((int)Enumerations.SubjectType.Ulke), "Name", "SubjectID", "", "Bir Ülke Seçiniz", "0"); drpCountry.SelectedValue = "4658"; DDLHelper.BindDDL(ref drpCity, BINROTA.BUS.Subjects.GetSubjectBySubjectID(int.Parse(drpCountry.SelectedValue), (int)Enumerations.SubjectType.Sehir), "Name", "SubjectID", "", "Bir Þehir Seçiniz", ""); DDLHelper.BindDDL(ref drpJob, BINROTA.BUS.Jobs.GetJobs(), "Job", "JobID", "", "Bir Meslek Seçiniz", ""); DDLHelper.LoadNumberDDL(ref drpDay, 31); DDLHelper.LoadNumberDDL(ref drpMonth, 12); DDLHelper.LoadNumberDDL(ref drpYear, DateTime.Today.Year, 1, 1920); }
private void BindDDL() { DataTable dt = BINROTA.BUS.Members.PhotoAlbum.GetAlbums(this.MemberID); if (dt.Rows.Count > 0) { DDLHelper.BindDDL(ref ddlAlbumList, BINROTA.BUS.Members.PhotoAlbum.GetAlbums(this.MemberID), "PhotoName", "MemberPhotoID", ""); DDLHelper.BindDDL(ref ddlAlbumList2, BINROTA.BUS.Members.PhotoAlbum.GetAlbums(this.MemberID), "PhotoName", "MemberPhotoID", ""); } }
public string FileConfigDDL() { string tbName = "S_FileInfo"; StringBuilder sql = new StringBuilder(); sql.AppendLine(" if not exists (select * from dbo.sysobjects " + "where id = object_id(N'[dbo].[" + tbName + "]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) "); StringBuilder CreateTbSql = new StringBuilder(); StringBuilder UpdateTbSql = new StringBuilder(); CreateTbSql.AppendLine(" CREATE TABLE [dbo].[" + tbName + "] ( "); CreateTbSql.AppendLine(" [ID] [varchar](50) NOT NULL,"); CreateTbSql.AppendLine(" [DocIndexID] [int] IDENTITY(1,1) NOT NULL,"); CreateTbSql.AppendLine(" [Name] [nvarchar](500) NOT NULL, "); CreateTbSql.AppendLine(" [NodeID] [varchar](50) NOT NULL, "); CreateTbSql.AppendLine(" [SpaceID] [varchar](50) NOT NULL, "); CreateTbSql.AppendLine(" [ConfigID] [varchar](50) NOT NULL, "); CreateTbSql.AppendLine(" [RelateID] [varchar](500) NULL, "); CreateTbSql.AppendLine(" [FullNodeID] [varchar](500) NOT NULL, "); CreateTbSql.AppendLine(" [ContentText] [text] NULL, "); CreateTbSql.AppendLine(" [CreateTime] [datetime] NULL, "); CreateTbSql.AppendLine(" [State] [nvarchar](50) NOT NULL, "); CreateTbSql.AppendLine(" [BorrowState] [nvarchar](50) NULL, "); CreateTbSql.AppendLine(" [BorrowUserID] [nvarchar](50) NULL, "); CreateTbSql.AppendLine(" [BorrowUserName] [nvarchar](50) NULL, "); var list = this.ToFileFieldList(); foreach (var item in list) { if (!FIleDefaultField.Contains(item.FieldName)) { CreateTbSql.AppendLine(" [" + item.FieldName + "] " + DDLHelper.GetFieldDataTypeDDL(item.DataType) + " NULL, "); } } UpdateTbSql.AppendLine(GetFileConfigAlterDDL()); CreateTbSql.AppendLine(@" CONSTRAINT [PK_S_FileInfo] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] "); CreateTbSql.AppendLine(@" ALTER TABLE [dbo].[S_FileInfo] WITH CHECK ADD CONSTRAINT [FK_S_FileInfo_S_NodeInfo] FOREIGN KEY([NodeID]) REFERENCES [dbo].[S_NodeInfo] ([ID]) ALTER TABLE [dbo].[S_FileInfo] CHECK CONSTRAINT [FK_S_FileInfo_S_NodeInfo]"); if (String.IsNullOrEmpty(UpdateTbSql.ToString().Trim())) { sql.Append(" begin " + CreateTbSql.ToString() + " end "); } else { sql.Append(" begin " + CreateTbSql.ToString() + " end else "); sql.Append(" begin " + UpdateTbSql.ToString() + " end "); } return(sql.ToString()); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DDLHelper.BindDDL(ref drpContinents, BINROTA.BUS.Subjects.GetSubjectForDDL((int)Enumerations.SubjectType.Kita), "Name", "SubjectID", ""); imgSubjectPhoto.Attributes.Add("onerror", "this.src='Images/NoPictureForSubject.png';"); UctrlImageUpload1.UploadType = Enumerations.FileUploadType.SubjectImages; ((Button)UctrlImageUpload1.FindControl("btnSend")).Visible = false; FillSubjectTree(); } }
public void CreateDatabaseTest() { DDLHelper target = new DDLHelper(db); target.CreateDatabase(schema_name); db.ChangeDatabase("information_schema"); DataSet ds = db.ExecuteQuery("SELECT * FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='music_test'"); DataTable dt = ds.Tables[0]; Assert.IsTrue(dt.Rows.Count > 0); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DDLHelper.LoadNumberDDL(ref drpDay, 31); DDLHelper.LoadNumberDDL(ref drpMonth, 12); DDLHelper.LoadNumberDDL(ref drpYear, DateTime.Today.Year, 1, 1920); UserControl(); lnbDeletePortrait.Attributes.Add("onclick", "return confirm('Resmi silmek istediðinizden emin misiniz?');"); imgMemberPortrait.Attributes.Add("onerror", "this.src='Images/Design/NoPicture.jpg';"); } }
/// <summary> /// Returns a new list which will contain the default item and the items of the current list /// </summary> public static List <SelectListItem> ToDefaultPrependedList(this IEnumerable <SelectListItem> list, string defaultText = null) { Check.Null(list, "list"); var currentList = list.AsList(); var newList = new List <SelectListItem>(currentList.Count + 1) { DDLHelper.GetDefaultSelectListItem(defaultText) }; newList.AddRange(currentList); return(newList); }
private void FillMemberDetailsForMember(DataTable dt) { if (dt.Rows.Count > 0) { txtFirstName.Text = dt.Rows[0]["FirstName"].ToString(); hplAllPages.NavigateUrl = "~/PagesView.aspx?MemberID=" + dt.Rows[0]["MemberID"].ToString(); txtLastName.Text = dt.Rows[0]["LastName"].ToString(); DateTime BirthDate = Convert.ToDateTime(dt.Rows[0]["BirthDay"]); drpDay.SelectedValue = BirthDate.Day.ToString(); drpMonth.SelectedValue = BirthDate.Month.ToString(); drpYear.SelectedValue = BirthDate.Year.ToString(); DDLHelper.BindDDL(ref drpCountry, BINROTA.BUS.Subjects.GetSubjectForDDL((int)Enumerations.SubjectType.Ulke), "Name", "SubjectID", ""); DataTable dtLivingPlace = BINROTA.BUS.Subjects.GetParentSubjectBySubjectID(int.Parse(dt.Rows[0]["LivingPlace"].ToString())); if (dtLivingPlace.Rows.Count > 0) { drpCountry.SelectedValue = dtLivingPlace.Rows[0]["SubjectID"].ToString(); DDLHelper.BindDDL(ref drpCity, BINROTA.BUS.Subjects.GetSubjectBySubjectID(int.Parse(drpCountry.SelectedValue), (int)Enumerations.SubjectType.Sehir), "Name", "SubjectID", ""); drpCity.SelectedValue = dt.Rows[0]["LivingPlace"].ToString(); } DDLHelper.BindDDL(ref drpJob, BINROTA.BUS.Jobs.GetJobs(), "Job", "JobID", ""); drpJob.SelectedValue = dt.Rows[0]["JobID"].ToString(); txtInterests.Text = dt.Rows[0]["Interests"].ToString(); txtVisitedPlaces.Text = dt.Rows[0]["VisitedPlaces"].ToString(); txtMotto.Text = dt.Rows[0]["Motto"].ToString(); lbNickName.Text = dt.Rows[0]["NickName"].ToString(); lbEmail.Text = dt.Rows[0]["Email"].ToString(); //TODO: Oray && System.IO.File.Exists(Common.ReturnImagePath(dt.Rows[0]["PhotoPath"].ToString(), ConfigurationManager.AppSettings["MemberImagesUrl"].ToString())) eklenecek if (dt.Rows[0]["PhotoPath"].ToString() != "") { imgMemberPortrait.ImageUrl = Common.ReturnImagePath(dt.Rows[0]["PhotoPath"].ToString(), ConfigurationManager.AppSettings["MemberImagesUrl"].ToString()); } else { imgMemberPortrait.ImageUrl = "~/Images/Design/NoPicture.jpg"; } dt = BINROTA.BUS.Pages.GetUserPages(SessRoot.UserID, (int)Enumerations.PageType.HomePage); if (dt.Rows.Count > 0) { ltrMemberContentPage.Text = dt.Rows[0]["PageContent"].ToString(); } } else { Common.GotoDefaultPage(this.Response); } }
private void BindDDL() { DDLHelper.BindDDL(ref drpPageCategory, BINROTA.BUS.PageCategories.GetPageCategoriesAll(), "PageCategoryName", "PageCategoryID", ""); DDLHelper.BindDDL(ref drpContinent, BINROTA.BUS.Subjects.GetSubjectByParentSubjectID(0), "Name", "SubjectID", ""); if (this.SubjectID != 0) { BindDLLBySubjectID(this.SubjectID); } else { DDLHelper.BindDDL(ref drpCountry, BINROTA.BUS.Subjects.GetSubjectByParentSubjectID(int.Parse(drpContinent.SelectedValue)), "Name", "SubjectID", ""); DDLHelper.BindDDL(ref drpCity, BINROTA.BUS.Subjects.GetSubjectByParentSubjectID(int.Parse(drpCountry.SelectedValue)), "Name", "SubjectID", "", "Ülke Genel", "0"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { FillSubjectTree(); DDLHelper.BindDDL(ref drpCategories, BINROTA.BUS.Categories.GetCategories(), "Name", "CategoryID", ""); } catch (Exception) { throw; } } }