protected void LoadMain()
{
if (Request.QueryString["tourid"] != null)
{
int tourid = Int32.Parse(Request.QueryString["tourid"]);
var result = (from t in data.Tour where (int)t.TourID == tourid select t).Single();
{
txtId.Text = result.TourID.ToString();
txtNm.Text = result.TourNm;
txtDescRev.Text = result.DescReview;
CKEditor1.Text = result.TourReview;
CKEditor2.Text = result.Description;
ddGroup1.SelectedValue = result.TourGroup.ToString();
cbPromotion.Checked = (bool)result.IsPromotion;
cbProminent.Checked = (bool)result.IsProminent;
}
//fill listbox Role
var result1 = from t in data.TourTourKind where t.TourID == tourid select t;
DataTable dtresult1 = Linqtodataset.LINQToDataTable(result1);
for (int i = 0; i < dtresult1.Rows.Count; i++)
{
if (lbKind.Items.FindByValue(dtresult1.Rows[i]["TourKindId"].ToString()) != null) // must have
{
lbKind.Items.FindByValue(dtresult1.Rows[i]["TourKindId"].ToString()).Selected = true;
}
}
}
}
protected void GetTronGoi()
{
DataTable dtTronGoi;
if (Request.QueryString["TourKindId"] != null)
{
int TourKindId = Int32.Parse(Request.QueryString["TourKindId"]);
var result = from t in data.Tour
join l in data.TourTourKind
on(int) t.TourID equals l.TourID
where l.TourKindID == TourKindId && t.IsActived == true && t.TourGroup == 1
select t;
dtTronGoi = Linqtodataset.LINQToDataTable(result);
}
else
{
var result = from t in data.Tour where t.IsActived == true && t.TourGroup == 1 select t;
dtTronGoi = Linqtodataset.LINQToDataTable(result);
}
CollectionPager1.PageSize = 4;
CollectionPager1.DataSource = dtTronGoi.DefaultView;
CollectionPager1.BindToControl = RepTronGoi;
RepTronGoi.DataSource = CollectionPager1.DataSourcePaged;
}
protected void GetEvent()
{
DataTable dtMain;
var result = from t in data.Event
join l in data.Location
on t.LocaID equals(int) l.LocaID
where t.IsActived == true
orderby t.FromDate descending
select new
{
t.EventID,
t.EventNm,
t.Description,
t.FromDate,
t.ToDate,
t.LocaID,
l.LocaNm
};
dtMain = Linqtodataset.LINQToDataTable(result);
CollectionPager1.PageSize = 4;
CollectionPager1.DataSource = dtMain.DefaultView;
CollectionPager1.BindToControl = repMain;
repMain.DataSource = CollectionPager1.DataSourcePaged;
}
protected void SetGridMain()
{
DataTable dtMain;
var result = from t in data.Role orderby t.RoleID descending select t;
dtMain = Linqtodataset.LINQToDataTable(result);
gridMain.DataSource = dtMain;
gridMain.DataBind();
}
protected void SetGridMain()
{
DataTable dtMain;
var result = from t in data.Location where t.CountryID == Int32.Parse(ddCountry.SelectedValue) orderby t.LocaID descending select t;
dtMain = Linqtodataset.LINQToDataTable(result);
gridMain.DataSource = dtMain;
gridMain.DataBind();
}
protected void GetProminent()
{
DataTable dtProminent;
var result = from t in data.Tour where t.IsActived == true && t.IsProminent == true orderby t.TourID descending select t;
dtProminent = Linqtodataset.LINQToDataTable(result);
CollectionPager2.PageSize = 4;
CollectionPager2.DataSource = dtProminent.DefaultView;
CollectionPager2.BindToControl = dlProminent;
dlProminent.DataSource = CollectionPager2.DataSourcePaged;
}
protected void SetGridMain()
{
DataTable dtMain;
var result = from t in data.Tour
where t.TourGroup == Int32.Parse(ddGroup.SelectedValue)
orderby t.TourID descending
select t;
dtMain = Linqtodataset.LINQToDataTable(result);
gridMain.DataSource = dtMain;
gridMain.DataBind();
}
protected void SetGridMain()
{
DataTable dtMain;
var result = from t in data.Users
join l in data.UserRole
on(int) t.UserID equals l.UserID
where l.RoleID == Int32.Parse(ddRole.SelectedValue)
orderby t.UserID descending
select t;
dtMain = Linqtodataset.LINQToDataTable(result);
gridMain.DataSource = dtMain;
gridMain.DataBind();
}
protected void LoadGridMain(string id, string kind)
{
DataTable dtMain;
if (id != "")
{
var result = from t in data.Pictures where t.PicKind == kind && t.ItemsID == Int32.Parse(id) select t;
dtMain = Linqtodataset.LINQToDataTable(result);
}
else
{
var result = from t in data.Pictures where t.PicKind == kind select t;
dtMain = Linqtodataset.LINQToDataTable(result);
}
gridMain.DataSource = dtMain;
gridMain.DataBind();
}
protected void GetHotel()
{
DataTable dtHotel;
if (Request.QueryString["LocaId"] != null)
{
int LocaId = Int32.Parse(Request.QueryString["LocaId"]);
var result = from t in data.Hotel where t.LocaID == LocaId && t.IsActived == true select t;
dtHotel = Linqtodataset.LINQToDataTable(result);
//RepHotel.DataSource = result;
//RepHotel.DataBind();
}
else
{
var result = from t in data.Hotel where t.IsActived == true select t;
dtHotel = Linqtodataset.LINQToDataTable(result);
//RepHotel.DataSource = result;
//RepHotel.DataBind();
}
CollectionPager1.PageSize = 4;
CollectionPager1.DataSource = dtHotel.DefaultView;
CollectionPager1.BindToControl = RepHotel;
RepHotel.DataSource = CollectionPager1.DataSourcePaged;
}
protected void LoadUser()
{
if (Request.QueryString["userid"] != null)
{
int userid = Int32.Parse(Request.QueryString["userid"]);
var result = (from t in data.Users where (int)t.UserID == userid select t).Single();
{
txtId.Text = result.UserID.ToString();
txtUserName.Text = result.UserNm;
txtFullNm.Text = result.FullNm;
txtAddress.Text = result.Address1;
txtEmail.Text = result.Email;
ckActived.Checked = (bool)result.IsActived;
if ((int)result.UserID == 1)
{
ckActived.Enabled = false;
}
else
{
ckActived.Enabled = true;
}
txtUN.Text = result.UserNm;
}
//fill listbox Role
var result1 = from t in data.UserRole where t.UserID == userid select t;
DataTable dtresult1 = Linqtodataset.LINQToDataTable(result1);
for (int i = 0; i < dtresult1.Rows.Count; i++)
{
if (lbRole.Items.FindByValue(dtresult1.Rows[i]["RoleId"].ToString()) != null) // must have
{
lbRole.Items.FindByValue(dtresult1.Rows[i]["RoleId"].ToString()).Selected = true;
}
}
}
}
