public void getdatauseraccount() { DataTable dt = new DataTable(); dt.Columns.Add("Id"); dt.Columns.Add("FirstName"); dt.Columns.Add("LastName"); dt.Columns.Add("Email"); dt.Columns.Add("Password"); dt.Columns.Add("MobilePhone"); dt.Columns.Add("UserGroup"); dt.Columns.Add("Urlimage"); string urlImage = "Image/innofood.jpg"; CommonClassLibrary.CommonDataSet.UserAccountDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.UserAccountTableAdapter().GetDataByStatus100(); foreach (CommonClassLibrary.CommonDataSet.UserAccountRow item in collection) { CommonClassLibrary.CommonDataSet.AccountGroupDataTable collection2 = new CommonClassLibrary.CommonDataSetTableAdapters.AccountGroupTableAdapter().GetDataByUserAccount(item.Id); if (collection2.Rows.Count > 1) { string usergroup = ""; foreach (CommonClassLibrary.CommonDataSet.AccountGroupRow item2 in collection2) { CommonClassLibrary.CommonDataSet.UserGroupDataTable collection3 = new CommonClassLibrary.CommonDataSetTableAdapters.UserGroupTableAdapter().GetDataByID(item2.UserGroup); foreach (CommonClassLibrary.CommonDataSet.UserGroupRow item3 in collection3) { usergroup += item3.Name + ", "; if (item.ImageUrl != null) { urlImage = "Image/" + item.ImageUrl; } } } usergroup = usergroup.Trim(); if (usergroup.EndsWith(",")) { usergroup = usergroup.Substring(0, usergroup.Length - 1); } dt.Rows.Add(item.Id, item.FirstName, item.LastName, item.Email, item.Password, item.MobilePhoneNumber, usergroup, urlImage); } else { foreach (CommonClassLibrary.CommonDataSet.AccountGroupRow item2 in collection2) { CommonClassLibrary.CommonDataSet.UserGroupDataTable collection3 = new CommonClassLibrary.CommonDataSetTableAdapters.UserGroupTableAdapter().GetDataByID(item2.UserGroup); foreach (CommonClassLibrary.CommonDataSet.UserGroupRow item3 in collection3) { if (item.ImageUrl != null) { urlImage = "Image/" + item.ImageUrl; } dt.Rows.Add(item.Id, item.FirstName, item.LastName, item.Email, item.Password, item.MobilePhoneNumber, item3.Name, urlImage); } } } } this.UserAccountRepeater.DataSource = dt; this.UserAccountRepeater.DataBind(); }
public void getdatauseraccount() { DataTable dt = new DataTable(); dt.Columns.Add("Id"); dt.Columns.Add("FirstName"); dt.Columns.Add("LastName"); dt.Columns.Add("Email"); dt.Columns.Add("Password"); dt.Columns.Add("MobilePhone"); dt.Columns.Add("Name"); dt.Columns.Add("Address"); string commentuser = ""; CommonClassLibrary.CommonDataSet.UserAccountDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.UserAccountTableAdapter().GetData(); foreach (CommonClassLibrary.CommonDataSet.UserAccountRow item in collection) { if (inno.Comments.Where(x => x.Create_By == item.Id).Count() > 0) { commentuser = inno.Comments.Where(x => x.Create_By == item.Id).OrderByDescending(u => u.Id).FirstOrDefault().Comment1; } else { commentuser = ""; } CommonClassLibrary.CommonDataSet.AccountGroupDataTable collection2 = new CommonClassLibrary.CommonDataSetTableAdapters.AccountGroupTableAdapter().GetDataByUserAccount(item.Id); if (collection2.Rows.Count > 1) { string usergroup = ""; foreach (CommonClassLibrary.CommonDataSet.AccountGroupRow item2 in collection2) { CommonClassLibrary.CommonDataSet.UserGroupDataTable collection3 = new CommonClassLibrary.CommonDataSetTableAdapters.UserGroupTableAdapter().GetDataByID(item2.UserGroup); foreach (CommonClassLibrary.CommonDataSet.UserGroupRow item3 in collection3) { usergroup += item3.Name + ", "; } } usergroup = usergroup.Trim(); if (usergroup.EndsWith(",")) { usergroup = usergroup.Substring(0, usergroup.Length - 1); } dt.Rows.Add(item.Id, item.FirstName, item.LastName, item.Email, item.Password, item.MobilePhoneNumber, usergroup, commentuser); } else { foreach (CommonClassLibrary.CommonDataSet.AccountGroupRow item2 in collection2) { CommonClassLibrary.CommonDataSet.UserGroupDataTable collection3 = new CommonClassLibrary.CommonDataSetTableAdapters.UserGroupTableAdapter().GetDataByID(item2.UserGroup); foreach (CommonClassLibrary.CommonDataSet.UserGroupRow item3 in collection3) { dt.Rows.Add(item.Id, item.FirstName, item.LastName, item.Email, item.Password, item.MobilePhoneNumber, item3.Name, commentuser); } } } } this.UserAccountRepeater.DataSource = dt; this.UserAccountRepeater.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { System.Web.UI.HtmlControls.HtmlGenericControl Usermanagement = (System.Web.UI.HtmlControls.HtmlGenericControl)Master.FindControl("Li7"); Usermanagement.Attributes.Add("class", "active"); System.Web.UI.HtmlControls.HtmlGenericControl Usergroup = (System.Web.UI.HtmlControls.HtmlGenericControl)Master.FindControl("Li8"); Usergroup.Attributes.Add("class", "active"); int ID = int.Parse(Request.QueryString["Id"]); CommonClassLibrary.CommonDataSet.UserGroupDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.UserGroupTableAdapter().GetDataByID(ID); if (collection.Rows.Count > 0) { foreach (CommonClassLibrary.CommonDataSet.UserGroupRow item in collection) { this.NameEditUserGroup_TextBox.Text = item.Name; } } } }