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