public string WithJSON(string LastLogin) /// get list of notes { JavaScriptSerializer ser = new JavaScriptSerializer(); DBConnection DBop = new DBConnection(); DataTable dataTable = new DataTable(); string[] myname =null; string[] datesin=null; int HasNewNews = 0; dataTable = DBop.NewConectionDLL.SelectDataSet("News", "top 10 NewsTitle,NewsDate ", "NewsDate>= '" + LastLogin + "'", " NewsDate DESC").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { myname = new string[dataTable.Rows.Count]; datesin = new string[dataTable.Rows.Count]; HasNewNews = 1; for (int i = 0; i < dataTable.Rows.Count; i++) { datesin[i]=Convert.ToString (dataTable.Rows[i]["NewsTitle"]); myname[i] = Convert.ToString(dataTable.Rows[i]["NewsDate"]); } } var jsonData = new { NewNews = HasNewNews, name = myname , DateUp=datesin }; return ser.Serialize(jsonData); //products.ToString(); }
public ErrorTrack ReturnLastLocation(string PhoneMac) { DBConnection DBop = new DBConnection(); ErrorTrack error = new ErrorTrack(); /// check if this account avilable DataTable dataTable = new DataTable(); dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "PhoneMac like '" + PhoneMac + "'").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { int PhoneID = (int)dataTable.Rows[0]["PhoneID"]; dataTable = DBop.NewConectionDLL.SelectDataSet("Tracking", " * ", "PhoneID=" + PhoneID + " and DateRecord=( select max(DateRecord) from Tracking where PhoneID=" + PhoneID + ")").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { TrackingTable[] mytrack1 = new TrackingTable[dataTable.Rows.Count]; for (int i = 0; i < dataTable.Rows.Count; i++) { mytrack1[i] = new TrackingTable(); mytrack1[i].Latitude = (Double)dataTable.Rows[i]["Latitude"]; mytrack1[i].longitude = (Double)dataTable.Rows[i]["longitude"]; mytrack1[i].DateRecord = (DateTime)dataTable.Rows[i]["DateRecord"]; } error.myTrack = mytrack1; error.ErrorID = 2; error.ErrorMessage = "Greate you find record"; return error; } else { error.ErrorID = 1; error.ErrorMessage = "Error , cannot Find Records in this date Range"; return error; } } else { error.ErrorID = 1; error.ErrorMessage = "Error , this phone isnot register in your database"; return error; } }
public ErrorTrack ReturnTrackRange(string PhoneMac, string FromDate,string Todate) { DBConnection DBop = new DBConnection(); ErrorTrack error = new ErrorTrack(); /// check if this account avilable DataTable dataTable = new DataTable(); dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "PhoneMac like '" + PhoneMac + "'").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { int PhoneID = (int)dataTable.Rows[0]["PhoneID"]; dataTable = DBop.NewConectionDLL.SelectDataSet("Tracking", " * ", "DateRecord Between '" + FromDate + "' AND '" + Todate + "' and PhoneID="+ PhoneID +" order by DateRecord DESC").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { TrackingTable[] mytrack1 = new TrackingTable[dataTable.Rows.Count ]; for (int i = 0; i < dataTable.Rows.Count;i++ ) { mytrack1[i] = new TrackingTable(); mytrack1[i].Latitude = (Double)dataTable.Rows[i]["Latitude"]; mytrack1[i].longitude = (Double)dataTable.Rows[i]["longitude"]; mytrack1[i].DateRecord = (DateTime)dataTable.Rows[i]["DateRecord"]; } error.myTrack = mytrack1; error.ErrorID = 2; error.ErrorMessage = "Greate you insert new record"; return error; } else { error.ErrorID = 1; error.ErrorMessage = "Error , cannot Find Records in this date Range"; return error; } } else { error.ErrorID = 1; error.ErrorMessage = "Error , this phone isnot register in your database"; return error; } }
public ErrorAdminPhones ReturnAdminPhones(int UserID) { DBConnection DBop = new DBConnection(); ErrorAdminPhones error = new ErrorAdminPhones(); DataTable dataTable = new DataTable(); dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "UserID=" + UserID).Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { AdminPhonesTable[] mytrack1 = new AdminPhonesTable[dataTable.Rows.Count]; for (int i = 0; i < dataTable.Rows.Count; i++) { mytrack1[i] = new AdminPhonesTable(); mytrack1[i].PhoneMac = (string)dataTable.Rows[i]["PhoneMac"]; mytrack1[i].PhoneName = (string)dataTable.Rows[i]["PhoneName"]; } error.myphones= mytrack1; error.ErrorID = 2; error.ErrorMessage = "Greate you insert new record"; return error; } else { error.ErrorID = 1; error.ErrorMessage = "Error , cannot Find Records in this date Range"; return error; } }
public ReturnError InsertTrackR(string PhoneMac, string Latitude, string longitude) { DBConnection DBop = new DBConnection(); ReturnError error = new ReturnError(); /// check if this account avilable DataTable dataTable = new DataTable(); dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "PhoneMac like '" + PhoneMac + "'").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { int PhoneID = (int)dataTable.Rows[0]["PhoneID"]; ColoumnParam[] Coloumns = new ColoumnParam[4]; Coloumns[0] = new ColoumnParam("Latitude", ColoumnType.Float, Latitude); Coloumns[1] = new ColoumnParam("longitude", ColoumnType.Float, longitude); Coloumns[2] = new ColoumnParam("PhoneID", ColoumnType.Int, PhoneID); Coloumns[3] = new ColoumnParam("DateRecord", ColoumnType.DateTime, DateTime.Now); if (DBop.NewConectionDLL.InsertRow("Tracking", Coloumns)) { error.ErrorID = 2; error.ErrorMessage = "Greate you insert new record"; return error; } else { error.ErrorID = 1; error.ErrorMessage = "Error , cannot insert this record in the Database"; return error; } } else { error.ErrorID = 1; error.ErrorMessage = "Error , this phone isnot register in your database"; return error; } }
public ReturnError OpenAccount(string FullName, string UserName, String Password, Boolean AccountType,string EmailAdrress) { DBConnection DBop = new DBConnection(); ReturnError error = new ReturnError(); /// check if empty data if (( FullName.Length==0)||( UserName.Length==0)||(Password.Length==0)||( EmailAdrress.Length==0)) { error.ErrorID = 1; error.ErrorMessage = "please fill all your information"; return error; } /// check if this account avilable DataTable dataTable = new DataTable(); dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * ", "UserName like '" + UserName + "' or EmailAdrress like '" + EmailAdrress + "'").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { error.ErrorID = 1; error.ErrorMessage = "the user name or email address already used by other account try with different email or user name"; return error; } /// save new account /// ColoumnParam[] Coloumns = new ColoumnParam[6]; Coloumns[0] = new ColoumnParam("FullName", ColoumnType.varchar50, FullName); Coloumns[1] = new ColoumnParam("UserName", ColoumnType.varchar50, UserName); Coloumns[2] = new ColoumnParam("Password", ColoumnType.varchar50, Password); Coloumns[3] = new ColoumnParam("AccountType", ColoumnType.Bit, AccountType); Coloumns[4] = new ColoumnParam("DateRegister", ColoumnType.DateTime, DateTime.Now); Coloumns[5] = new ColoumnParam("EmailAdrress", ColoumnType.varchar50, EmailAdrress); if (DBop.NewConectionDLL.InsertRow("Admins", Coloumns)) { dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * ", "UserName like '" + UserName + "'").Tables[0]; /////send email to new account========================================================= // System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage(); // mail.To.Add(EmailAdrress); // mail.From = new MailAddress( "*****@*****.**" , "Email head", System.Text.Encoding.UTF8); // mail.Subject = "Complete your final steps with my phone locations"; //mail.SubjectEncoding = System.Text.Encoding.UTF8; //mail.Body = "Thank you for using my phone locations system" + Environment.NewLine + "Your account now ready to be used. please setup this app from google play on your phone" + Environment.NewLine + "https://play.google.com/store/apps/details?id=phonelocation.example.asuss550c.phonelocation" + Environment.NewLine + "Then from setting login with your user name and password." + Environment.NewLine + "And enjoy." + Environment.NewLine + "Best regards,"; //mail.BodyEncoding = System.Text.Encoding.UTF8; //mail.IsBodyHtml = true; //mail.Priority = MailPriority.High; //SmtpClient client = new SmtpClient(); //client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "abc3551356"); //client.Port = 25; //client.Host = "mail.alrubaye.com"; //client.EnableSsl = true; //try //{ // client.Send(mail); // // Page.RegisterStartupScript("UserMsg", "<script>alert('Successfully Send...');if(alert){ window.location='SendMail.aspx';}</script>"); //} //catch (Exception ex) //{ // Exception ex2 = ex; // string errorMessage = string.Empty; // while (ex2 != null) // { // errorMessage += ex2.ToString(); // ex2 = ex2.InnerException; // } // // Page.RegisterStartupScript("UserMsg", "<script>alert('Sending Failed...');if(alert){ window.location='SendMail.aspx';}</script>"); //} error.ErrorID = 2; error.AdminID = (int)dataTable.Rows[0]["UserID"]; error.ErrorMessage = "Greate you insert new record"; return error; } else { error.ErrorID = 1; error.ErrorMessage = "Error , cannot insert this record in the Database"; return error; } }
public ReturnError IsExisitAccount(string UserName, string Password) { DBConnection DBop = new DBConnection(); ReturnError error = new ReturnError(); /// check if this account avilable DataTable dataTable = new DataTable(); dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * ", "UserName like '" + UserName + "' AND Password like '" + Password + "'").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { error.ErrorID = 2; error.AdminID = (int)dataTable.Rows[0]["UserID"]; error.ErrorMessage = "Greate we find record"; return error; } else { error.ErrorID = 1; error.ErrorMessage = "Error , cannot find this record in the Database"; return error; } }
public ReturnError InsertPhoneInfo(int UserID, string PhoneMac, string PhoneName) { DBConnection DBop = new DBConnection(); ReturnError error = new ReturnError(); /// check if this account avilable DataTable dataTable = new DataTable(); dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * ", "UserID=" + UserID).Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { Boolean isnulti = (Boolean)dataTable.Rows[0]["AccountType"]; dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "PhoneMac like '" + PhoneMac + "'").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { error.ErrorID = 1; error.ErrorMessage = "this phone is already registered in database"; return error; } // check if this phone is not comercial if (isnulti == false) { dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "UserID=" + UserID ).Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { error.ErrorID = 1; error.ErrorMessage = "this type of account is for one device only"; return error; } } ColoumnParam[] Coloumns = new ColoumnParam[4]; Coloumns[0] = new ColoumnParam("UserID", ColoumnType.Int, UserID); Coloumns[1] = new ColoumnParam("PhoneMac", ColoumnType.varchar50, PhoneMac); Coloumns[2] = new ColoumnParam("DateRegister", ColoumnType.DateTime, DateTime.Now); Coloumns[3] = new ColoumnParam("PhoneName", ColoumnType.varchar50, PhoneName); if (DBop.NewConectionDLL.InsertRow("AdminPhones", Coloumns)) { error.ErrorID = 2; error.ErrorMessage = "Greate you insert new record"; return error; } else { error.ErrorID = 1; error.ErrorMessage = "Error , cannot insert this record in the Database"; return error; } } else { error.ErrorID = 1; error.ErrorMessage = "Error , cannot find this record in the Database"; return error; } }
public ReturnError ReturnLastLocationPN(string PhoneNumber) { DBConnection DBop = new DBConnection(); ReturnError error = new ReturnError(); string[] Phones = PhoneNumber.Split(':'); for (int k = 0; k < Phones.Length - 1; k++) { /// check if this account avilable DataTable dataTable = new DataTable(); dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "PhoneNumber like '%" + Phones[k] + "' and IsVisabale=1").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { int PhoneID = (int)dataTable.Rows[0]["PhoneID"]; dataTable = DBop.NewConectionDLL.SelectDataSet("Tracking", " * ", "PhoneID=" + PhoneID + " and DateRecord=( select max(DateRecord) from Tracking where PhoneID=" + PhoneID + ")").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { error.ErrorMessage = error.ErrorMessage + ":" + Phones[k]; } } } // for for if (error.ErrorMessage != null) { // error.myTrack = mytrack1; error.ErrorID = 2; // error.ErrorMessage = "Greate you find record"; return error; } else { error.ErrorID = 1; error.ErrorMessage = "Error ,we cannot find any friend for this phone"; return error; } }
public ReturnError ReturnLastLocationPNOne(string PhoneNumber) { DBConnection DBop = new DBConnection(); ReturnError error = new ReturnError(); /// check if this account avilable DataTable dataTable = new DataTable(); dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "PhoneNumber like '%" + PhoneNumber + "' and IsVisabale=1").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { int PhoneID = (int)dataTable.Rows[0]["PhoneID"]; dataTable = DBop.NewConectionDLL.SelectDataSet("Tracking", " * ", "PhoneID=" + PhoneID + " and DateRecord=( select max(DateRecord) from Tracking where PhoneID=" + PhoneID + ")").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { error.ErrorMessage = dataTable.Rows[0]["Latitude"].ToString() + ":" + dataTable.Rows[0]["longitude"].ToString() + ":" + dataTable.Rows[0]["DateRecord"].ToString(); error.ErrorID = 2; // error.ErrorMessage = "Greate you find record"; return error; } else { error.ErrorID = 1; error.ErrorMessage = "Error , cannot Find Records in this date Range"; return error; } } else { error.ErrorID = 1; error.ErrorMessage = "You Cannot access to this person location. may be he dont allow you to see his location or he didnot install (my phone locations)"; return error; } }
public ReturnError InsertPhoneNumberPrivicy( string PhoneMac, string PhoneNumber, Boolean IsVisabale) { DBConnection DBop = new DBConnection(); ReturnError error = new ReturnError(); /// check if this account avilable DataTable dataTable = new DataTable(); dataTable = DBop.NewConectionDLL.SelectDataSet("AdminPhones", " * ", "PhoneMac like '" + PhoneMac + "' and PhoneNumber like '" + PhoneNumber +"'").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { ColoumnParam[] Coloumns = new ColoumnParam[1]; Coloumns[0] = new ColoumnParam("IsVisabale", ColoumnType.Bit, IsVisabale); if (DBop.NewConectionDLL.UpdateRow("AdminPhones", Coloumns, "PhoneMac like '" + PhoneMac + "' and PhoneNumber like '" + PhoneNumber + "'")) { error.ErrorID = 2; error.ErrorMessage = "Greate you update the record"; return error; } else { error.ErrorID = 1; error.ErrorMessage = "Error , cannot insert this record in the Database"; return error; } } else { error.ErrorID = 1; error.ErrorMessage = "Error , this phone is not registared in database"; return error; } }
public ReturnError OpenAccount(string FullName, string UserName, String Password, Boolean AccountType, string EmailAdrress) { DBConnection DBop = new DBConnection(); ReturnError error = new ReturnError(); /// check if empty data if ((FullName.Length == 0) || (UserName.Length == 0) || (Password.Length == 0) || (EmailAdrress.Length == 0)) { error.ErrorID = 1; error.ErrorMessage = "please fill all your information"; return error; } /// check if this account avilable DataTable dataTable = new DataTable(); dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * ", "UserName like '" + UserName + "' or EmailAdrress like '" + EmailAdrress + "'").Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { error.ErrorID = 1; error.ErrorMessage = "the user name or email address already used by other account try with different email or user name"; return error; } /// save new account /// ColoumnParam[] Coloumns = new ColoumnParam[6]; Coloumns[0] = new ColoumnParam("FullName", ColoumnType.varchar50, FullName); Coloumns[1] = new ColoumnParam("UserName", ColoumnType.varchar50, UserName); Coloumns[2] = new ColoumnParam("Password", ColoumnType.varchar50, Password); Coloumns[3] = new ColoumnParam("AccountType", ColoumnType.Bit, AccountType); Coloumns[4] = new ColoumnParam("DateRegister", ColoumnType.DateTime, DateTime.Now); Coloumns[5] = new ColoumnParam("EmailAdrress", ColoumnType.varchar50, EmailAdrress); if (DBop.NewConectionDLL.InsertRow("Admins", Coloumns)) { dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * ", "UserName like '" + UserName + "'").Tables[0]; // dataTable = DBop.NewConectionDLL.SelectDataSet("Admins", " * " ).Tables[0]; /////send email to new account========================================================= // System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage(); // mail.To.Add(EmailAdrress); // mail.From = new MailAddress( "*****@*****.**" , "Email head", System.Text.Encoding.UTF8); // mail.Subject = "Complete your final steps with my phone locations"; //mail.SubjectEncoding = System.Text.Encoding.UTF8; // for (int i = 0; i < dataTable.Rows.Count; i++) { try { string smtpAddress = "mail.alrubaye.com"; int portNumber = 25; bool enableSSL = false; string emailFrom = "*****@*****.**"; string password = "******"; string emailTo = EmailAdrress; string subject = "Welcome in my phone location system"; string body = "Thank you for using my phone locations system \n" + " \n Your account now ready to be used. please setup this app from google play on your phone \n" + "https://play.google.com/store/apps/details?id=phonelocation.example.asuss550c.phonelocation" + "\nThen from setting login with your user name and password." + "And enjoy." + "Best regards,"; using (MailMessage mail = new MailMessage()) { mail.From = new MailAddress(emailFrom); mail.To.Add(emailTo); mail.Subject = subject; mail.Body = body; mail.IsBodyHtml = true; // Can set to false, if you are sending pure text. // mail.Attachments.Add(new Attachment("C:\\SomeFile.txt")); // mail.Attachments.Add(new Attachment("C:\\SomeZip.zip")); using (SmtpClient smtp = new SmtpClient(smtpAddress, portNumber)) { smtp.Credentials = new NetworkCredential(emailFrom, password); smtp.EnableSsl = enableSSL; smtp.Send(mail); } } } catch (Exception ex) { } //} // for loop error.ErrorID = 2; error.AdminID = (int)dataTable.Rows[0]["UserID"]; error.ErrorMessage = "Greate you insert new record"; return error; } else { error.ErrorID = 1; error.ErrorMessage = "Error , cannot insert this record in the Database"; return error; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["adminID"] == null) Response.Redirect("AdminLogin.aspx"); if (!Page.IsPostBack) { ///Images/StylesImage/business_user.png ///Images/AdminImage/20%&6292015124826.jpg DBConnection DBop = new DBConnection(); DataTable dataTable = new DataTable(); dataTable = DBop.NewConectionDLL.SelectDataSet("MyStudents", "AccountTypeID,StudentFirstName", "StudentID=" + Session["adminID"]).Tables[0]; if ((dataTable != null) && (dataTable.Rows.Count > 0)) { // LaPathImage.Text = Convert.ToString(dataTable.Rows[0]["ImagePath"]); // string Name = Convert.ToString(dataTable.Rows[0]["StudentFirstName"]); int AccounType = Convert.ToInt32(dataTable.Rows[0]["AccountTypeID"]); DataTable TBUse = new DataTable("tblUserSystemViewGrid"); // add tabel coloumns DataColumn keyField1 = new DataColumn("ViewUserID", typeof(int)); TBUse.Columns.Add(keyField1); DataColumn keyField2 = new DataColumn("NameView", typeof(string)); TBUse.Columns.Add(keyField2); DataColumn keyField3 = new DataColumn("ImageView", typeof(string)); TBUse.Columns.Add(keyField3); DataColumn keyField4 = new DataColumn("LinkPageView", typeof(string)); TBUse.Columns.Add(keyField4); DataColumn keyField5 = new DataColumn("ViewUserLevel", typeof(string)); TBUse.Columns.Add(keyField5); // add tabel contain DataRow oneRow; // 1 oneRow = TBUse.NewRow(); oneRow["ViewUserID"] = 1; oneRow["NameView"] = "التنبيهات"; oneRow["ImageView"] = "~/Images/StylesImage/image.png"; oneRow["LinkPageView"] = "MyDashoard.aspx"; oneRow["ViewUserLevel"] = "1,2,3 "; TBUse.Rows.Add(oneRow); oneRow = TBUse.NewRow(); oneRow["ViewUserID"] = 2; oneRow["NameView"] = "الجدول"; oneRow["ImageView"] = "~/Images/StylesImage/calendar.png"; oneRow["LinkPageView"] = "TutorialSchedule.aspx"; oneRow["ViewUserLevel"] = "1,2,3"; ; TBUse.Rows.Add(oneRow); oneRow = TBUse.NewRow(); oneRow["ViewUserID"] =3; oneRow["NameView"] = "واجباتي"; oneRow["ImageView"] = "~/Images/StylesImage/business_user_edit.png"; oneRow["LinkPageView"] = "MyHomeWorks.aspx"; oneRow["ViewUserLevel"] = "1,2,3"; TBUse.Rows.Add(oneRow); // 2 oneRow = TBUse.NewRow(); oneRow["ViewUserID"] = 4; oneRow["NameView"] = "الحضور"; oneRow["ImageView"] = "~/Images/StylesImage/user-info-icon.png"; oneRow["LinkPageView"] = "StudentAttendance.aspx"; // "NewActivity.aspx?ID=C5AC851D-91C1-4A48-858A-2FAE20738FDC"; // oneRow["ViewUserLevel"] = "1,2,3"; TBUse.Rows.Add(oneRow); // 2 // 2 oneRow = TBUse.NewRow(); oneRow["ViewUserID"] = 5; oneRow["NameView"] = "ادارةالطلاب"; oneRow["ImageView"] = "~/Images/StylesImage/user_add.png"; oneRow["LinkPageView"] = "ManageStudent.aspx"; //"~/NewActivity.aspx?ID=C5AC851D-91C1-4A48-858A-2FAE20738FDC" oneRow["ViewUserLevel"] = "1,2"; TBUse.Rows.Add(oneRow); //oneRow = TBUse.NewRow(); //oneRow["ViewUserID"] = 6; //oneRow["NameView"] = "الدورات "; //oneRow["ImageView"] = "~/Images/StylesImage/application_edit.png"; //oneRow["LinkPageView"] = "ManagedAccounts.aspx"; //oneRow["ViewUserLevel"] = "1"; //TBUse.Rows.Add(oneRow); //peopleaccount oneRow = TBUse.NewRow(); oneRow["ViewUserID"] = 7; oneRow["NameView"] = "المراسلات"; oneRow["ImageView"] = "~/Images/StylesImage/messages.png"; oneRow["LinkPageView"] = "AddNews.aspx"; oneRow["ViewUserLevel"] = "2,1"; TBUse.Rows.Add(oneRow); //Enrollnto.aspx oneRow = TBUse.NewRow(); oneRow["ViewUserID"] = 8; oneRow["NameView"] = "الدورات"; oneRow["ImageView"] = "~/Images/StylesImage/application_edit.png"; oneRow["LinkPageView"] = "Enrollnto.aspx"; oneRow["ViewUserLevel"] = "2,1,3"; TBUse.Rows.Add(oneRow); //ManageMetrics oneRow = TBUse.NewRow(); oneRow["ViewUserID"] = 9 ; oneRow["NameView"] = "كلمة المرور"; oneRow["ImageView"] = "~/Images/StylesImage/Password.gif"; oneRow["LinkPageView"] = "ChangePssword.aspx"; oneRow["ViewUserLevel"] = "2,1,3"; TBUse.Rows.Add(oneRow); ////EmployeesPerformance oneRow = TBUse.NewRow(); oneRow["ViewUserID"] = 10; oneRow["NameView"] = "خروج"; oneRow["ImageView"] = "~/Images/StylesImage/logtout.png"; oneRow["LinkPageView"] = "AdminLogin.aspx"; oneRow["ViewUserLevel"] = "2,1,3"; TBUse.Rows.Add(oneRow); ////PeopleTracking ////EmployeesPerformance //oneRow = TBUse.NewRow(); //oneRow["ViewUserID"] = 7; //oneRow["NameView"] = "Tracking"; //oneRow["ImageView"] = "~/Images/StylesImage/peopleTracking.png"; //oneRow["LinkPageView"] = "PeopleTracking.aspx"; //oneRow["ViewUserLevel"] = "2,1,3"; //TBUse.Rows.Add(oneRow); ////EmployeesPerformance //oneRow = TBUse.NewRow(); //oneRow["ViewUserID"] = 7; //oneRow["NameView"] = "Project"; //oneRow["ImageView"] = "~/Images/StylesImage/project.png"; //oneRow["LinkPageView"] = "ManageProject.aspx"; //oneRow["ViewUserLevel"] = "2,1,3"; // TBUse.Rows.Add(oneRow); try { DataRow[] matchingRows = TBUse.Select(" ViewUserLevel LIKE '%" + AccounType + "%'", " ViewUserID"); DataTable FoundRow = TBUse.Clone(); foreach (DataRow dtRow in matchingRows) { FoundRow.ImportRow(dtRow); // DataGridView1.DataSource = FoundRows } DataList1.DataSource = FoundRow; DataList1.DataBind(); } catch (Exception ex) { // MsgBox(ex.Message); } // set admin pic } } }