private void Fill() { int ID = int.Parse(Request.QueryString["ID_Teacher"]); DataTable dt = new tbl_TeacherInformationTableAdapter().GetDataByID(ID); if (dt.Rows.Count > 0) { TextName = dt.Rows[0]["TI_Name"].ToString(); TextFatherName = dt.Rows[0]["TI_FatherName"].ToString(); TextAddress = dt.Rows[0]["TI_Address"].ToString(); TextTell = dt.Rows[0]["TI_Tell"].ToString(); TextPostalCode = dt.Rows[0]["TI_PostalCode"].ToString(); TextExportPlace = dt.Rows[0]["TI_ExportPlace"].ToString(); TextBirthDate = dt.Rows[0]["TI_BirthDate"].ToString(); TextAdminCode = dt.Rows[0]["TI_TeacherCode"].ToString(); TextUserName = dt.Rows[0]["TI_UserName"].ToString(); TextEndTime = dt.Rows[0]["TI_Teacher_End_Time"].ToString(); TextStartTime = dt.Rows[0]["TI_Teacher_Start_Time"].ToString(); Image1.ImageUrl = dt.Rows[0]["TI_Picutre"].ToString(); if (System.IO.File.Exists(Server.MapPath(Image1.ImageUrl))) { Image1.Visible = true; } else { Image1.Visible = true; Image1.ImageUrl = "~//Image_User//default_pic.png"; } FillPath("Teacher", dt.Rows[0]["Teacher_ID"].ToString()); } }
private void FillGrid() { GridView1.SelectedIndex = -1; int ID_Admin = 0; if (Request.Cookies["Type_Role"].Value.ToString() == "Teacher") { DataTable dt = new tbl_TeacherInformationTableAdapter().GetDataByID(int.Parse(Request.Cookies["ID_Role"].Value.ToString())); ID_Admin=int.Parse(dt.Rows[0]["TI_ID_Admin"].ToString()); } else if (Request.Cookies["Type_Role"].Value.ToString() == "Parent") { DataTable dt2 = new tbl_ParentInformationTableAdapter().GetDataByID(int.Parse(Request.Cookies["ID_Role"].Value.ToString())); DataTable dt = new tbl_StudentInformationTableAdapter().GetDataByStudent_ID(int.Parse(dt2.Rows[0]["PA_ID_Student"].ToString())); ID_Admin = int.Parse(dt.Rows[0]["SI_ID_Admin"].ToString()); } else if (Request.Cookies["Type_Role"].Value.ToString() == "Student") { DataTable dt = new tbl_StudentInformationTableAdapter().GetDataByStudent_ID(int.Parse(Request.Cookies["ID_Role"].Value.ToString())); ID_Admin= int.Parse(dt.Rows[0]["SI_ID_Admin"].ToString()); } GridView1.DataSource = new tbl_AdminInformationTableAdapter().GetDataByAdminListTeacher(ID_Admin); GridView1.DataBind(); }
private void FillGrid() { GridView1.SelectedIndex = -1; DataTable dt = new tbl_TeacherInformationTableAdapter().GetDataByID(int.Parse(Request.Cookies["ID_Role"].Value.ToString())); GridView1.DataSource = new tbl_TeacherInformationTableAdapter().GetDataByTeacherTeacher(int.Parse(dt.Rows[0]["TI_ID_Admin"].ToString())); GridView1.DataBind(); }
private void FillPath() { string title = ""; string name = ""; string Type = Request.QueryString["Type_Role_Getter"]; string ID = Request.QueryString["ID_Role_Getter"]; DataTable dt; if (Type == "Admin") { dt = new tbl_AdminInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["AI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["AI_username"].ToString(); } title = " مدیران"; } else if (Type == "Teacher") { dt = new tbl_TeacherInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["TI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["TI_username"].ToString(); } title = " معلم ها"; } else if (Type == "Parent") { dt = new tbl_ParentInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["PA_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["PA_username"].ToString(); } title = " اولیاء"; } else if (Type == "Student") { dt = new tbl_StudentInformationTableAdapter().GetDataByStudent_ID(int.Parse(ID)); name = dt.Rows[0]["SI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["SI_username"].ToString(); } title = " دانش آموزان"; } lblPath.Text = lblPath.Text+ "ارسال پیام برای >> " + title + " >> " + "<a href='./index.aspx?Type=" + Type + "Detail&" + "ID_"+Type +"=" + ID + "'>" + name + "</a>"; }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowIndex != -1) { string title = ""; string name = ""; string Type = ((Label)(e.Row.FindControl("lblTypeGetter"))).Text; string ID = ((Label)(e.Row.FindControl("lblIDGetter"))).Text; DataTable dt; if (Type == "Admin") { dt = new tbl_AdminInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["AI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["AI_username"].ToString(); } title = "مدیر"; } else if (Type == "Teacher") { dt = new tbl_TeacherInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["TI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["TI_username"].ToString(); } title = "معلم"; } else if (Type == "Parent") { dt = new tbl_ParentInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["PA_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["PA_username"].ToString(); } title = "اولیاء"; } else if (Type == "Student") { dt = new tbl_StudentInformationTableAdapter().GetDataByStudent_ID(int.Parse(ID)); name = dt.Rows[0]["SI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["SI_username"].ToString(); } title = "دانش آموز"; } ((Label)(e.Row.FindControl("lblName"))).Text = name + " ( " + title + " ) "; } }
private void FillPath(string Type, string ID) { string title = ""; string name = ""; DataTable dt= new tbl_TeacherInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["TI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["TI_username"].ToString(); } title = " معلم ها"; lblPath.Text = lblPath.Text + title + " >> " + "<a href='./index.aspx?Type=" + Type + "Detail&" + "ID_" + Type + "=" + ID + "'>" + name + "</a>"; Message = "<a href='index.aspx?Type=PersonalMessageInsert&Type_Role_Getter=" + Type + "&ID_Role_Getter=" + ID + "'>ارسال پیام شخصی</a>"; }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowIndex != -1) { int ID_Role = int.Parse(((Label)(e.Row.FindControl("ID_Role"))).Text.ToString()); if (((Label)(e.Row.FindControl("Type_Role"))).Text == "Admin") { DataTable dt = new tbl_AdminInformationTableAdapter().GetDataByID(ID_Role); if (dt.Rows.Count > 0) { if (dt.Rows[0]["AI_Name"].ToString().Length > 0) { ((Label)(e.Row.FindControl("lblName"))).Text = "توسط : " + dt.Rows[0]["AI_Name"].ToString(); } else { ((Label)(e.Row.FindControl("lblName"))).Text = "توسط : " + dt.Rows[0]["AI_UserName"].ToString(); } } } else { DataTable dt = new tbl_TeacherInformationTableAdapter().GetDataByID(ID_Role); if (dt.Rows.Count > 0) { if (dt.Rows[0]["TI_Name"].ToString().Length > 0) { ((Label)(e.Row.FindControl("lblName"))).Text = "توسط : " + dt.Rows[0]["TI_Name"].ToString(); } else { ((Label)(e.Row.FindControl("lblName"))).Text = "توسط : " + dt.Rows[0]["TI_UserName"].ToString(); } } } } }
private void FillPath(string Type, string ID) { string title = ""; string name = ""; DataTable dt; if (Type == "Admin") { dt = new tbl_AdminInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["AI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["AI_username"].ToString(); } title = "مدیر"; } else if (Type == "Teacher") { dt = new tbl_TeacherInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["TI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["TI_username"].ToString(); } title = " معلم "; } AuthorContent = " <a href='./index.aspx?Type=" + Type + "Detail&" + "ID_" + Type + "=" + ID + "'>" + name + " ( "+ title+ " )</a>"; }
private void FillDr(int ID_Category,DropDownList Dr) { int ID = 0; if (Request.Cookies["Type_Role"].Value == "Admin") { ID = int.Parse(Request.Cookies["ID_Role"].Value); } else if (Request.Cookies["Type_Role"].Value == "Teacher") { DataTable dt3 = new tbl_TeacherInformationTableAdapter().GetDataByID(int.Parse(Request.Cookies["ID_Role"].Value)); ID = int.Parse(dt3.Rows[0]["TI_ID_Admin"].ToString()); } DataTable dt = new tbl_AdminPermissionCategoryTableAdapter().GetDataByAPC_ID_Admin(ID); string DR_ID = Dr.ID.Substring(Dr.ID.Length - 1, 1); if (dt.Rows.Count > 0) { string APC_Cat_Patch = dt.Rows[0]["APC_Cat_Patch"].ToString(); string[] discreteInfo = APC_Cat_Patch.Split(new char[] { ',' }); int i = 0; foreach (string Data in discreteInfo) { i++; } Dr.Items.Clear(); Dr.DataValueField = "Category_ID"; Dr.DataTextField = "Cat_Title"; if (i >= int.Parse(DR_ID) && APC_Cat_Patch.Trim() != "-1") { Dr.DataSource = new tbl_CategoryTableAdapter().GetDataByIDRootPermissionAdmin(ID_Category, APC_Cat_Patch); Dr.DataBind(); Dr.Visible = true; } else { if (DR_ID != "1") { Dr.Items.Add("همه"); Dr.Items[0].Value = "0"; } Dr.DataSource = new tbl_CategoryTableAdapter().GetDataByID_Root(ID_Category); Dr.DataBind(); Dr.Visible = true; } } else { if (DR_ID != "1") { Dr.Items.Add("هیچکدام"); Dr.Items[0].Value = "-2"; Dr.DataBind(); Dr.Visible = true; } } if (DR_ID == "1") { Dr.Items.Insert(0, "عمومی"); Dr.Items[0].Value = "-10"; Dr.Visible = true; } }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowIndex != -1) { int ID_Role = int.Parse(((Label)(e.Row.FindControl("ID_Role"))).Text); if (((Label)(e.Row.FindControl("Type_Role"))).Text == "Admin") { DataTable dt = new tbl_AdminInformationTableAdapter().GetDataByID(ID_Role); if (dt.Rows.Count > 0) { if (dt.Rows[0]["AI_Name"].ToString().Length > 0) { ((Label)(e.Row.FindControl("lblName"))).Text = dt.Rows[0]["AI_Name"].ToString(); } else { ((Label)(e.Row.FindControl("lblName"))).Text = dt.Rows[0]["AI_UserName"].ToString(); } ((Label)(e.Row.FindControl("lblName"))).Text = "<a href='index.aspx?Type=AdminDetail&ID_Admin=" + ID_Role.ToString() + "'>" + ((Label)(e.Row.FindControl("lblName"))).Text + " ( مدیر ) " + "</a>"; } } else if(((Label)(e.Row.FindControl("Type_Role"))).Text == "Teacher") { DataTable dt = new tbl_TeacherInformationTableAdapter().GetDataByID(ID_Role); if (dt.Rows.Count > 0) { if (dt.Rows[0]["TI_Name"].ToString().Length > 0) { ((Label)(e.Row.FindControl("lblName"))).Text = dt.Rows[0]["TI_Name"].ToString(); } else { ((Label)(e.Row.FindControl("lblName"))).Text = dt.Rows[0]["TI_UserName"].ToString(); } ((Label)(e.Row.FindControl("lblName"))).Text = "<a href='index.aspx?Type=TeacherDetail&ID_Teacher=" + ID_Role.ToString() + "'>" + ((Label)(e.Row.FindControl("lblName"))).Text + " ( معلم ) " + "</a>"; } } } }
protected void Button1_Click(object sender, EventArgs e) { // Response.Redirect("~//index.aspx?Type=IndexAdmin"); if (RadioButtonList1.SelectedValue == "Parent") { DataTable dt = new tbl_ParentInformationTableAdapter().GetByUserNameAndPassword(TextBox1.Text, new main_class().Encode(TextBox2.Text)); if (dt.Rows.Count > 0) { // Response.Cookies.Add(new HttpCookie("username", TextBox1.Text)); // Response.Cookies.Add(new HttpCookie("password", new main_class().Encode(TextBox2.Text))); Response.Cookies.Add(new HttpCookie("ID_Role", dt.Rows[0]["Parent_ID"].ToString())); Response.Cookies.Add(new HttpCookie("Type_Role", RadioButtonList1.SelectedValue)); Response.Redirect("~//index.aspx?Type=IndexParent"); } else { lblEror.Visible = true; } } else if (RadioButtonList1.SelectedValue == "Student") { DataTable dt = new tbl_StudentInformationTableAdapter().GetDataByUserNameAndPassword(TextBox1.Text, new main_class().Encode(TextBox2.Text)); if (dt.Rows.Count > 0) { // Response.Cookies.Add(new HttpCookie("username", TextBox1.Text)); // Response.Cookies.Add(new HttpCookie("password", new main_class().Encode(TextBox2.Text))); Response.Cookies.Add(new HttpCookie("ID_Role", dt.Rows[0]["Student_ID"].ToString())); Response.Cookies.Add(new HttpCookie("Type_Role", RadioButtonList1.SelectedValue)); Response.Redirect("~//index.aspx?Type=IndexStudent"); } else { lblEror.Visible = true; } } else if (RadioButtonList1.SelectedValue == "Teacher") { DataTable dt = new tbl_TeacherInformationTableAdapter().GetDataByUserNameAndPassword(TextBox1.Text, new main_class().Encode(TextBox2.Text)); if (dt.Rows.Count > 0) { // Response.Cookies.Add(new HttpCookie("username", TextBox1.Text)); // Response.Cookies.Add(new HttpCookie("password", new main_class().Encode(TextBox2.Text))); Response.Cookies.Add(new HttpCookie("ID_Role", dt.Rows[0]["Teacher_ID"].ToString())); Response.Cookies.Add(new HttpCookie("Type_Role", RadioButtonList1.SelectedValue)); Response.Redirect("~//index.aspx?Type=IndexTeacher"); } else { lblEror.Visible = true; } } else if (RadioButtonList1.SelectedValue == "Admin") { DataTable dt = new tbl_AdminInformationTableAdapter().GetByUserNameAndPassword(TextBox1.Text, new main_class().Encode(TextBox2.Text)); if (dt.Rows.Count > 0) { // Response.Cookies.Add(new HttpCookie("username", TextBox1.Text)); // Response.Cookies.Add(new HttpCookie("password", new main_class().Encode(TextBox2.Text))); Response.Cookies.Add(new HttpCookie("ID_Role", dt.Rows[0]["Admin_ID"].ToString())); Response.Cookies.Add(new HttpCookie("Type_Role", RadioButtonList1.SelectedValue)); Response.Redirect("~//index.aspx?Type=IndexAdmin"); } else { lblEror.Visible = true; } } else { } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { int ID = int.Parse(((Label)(GridView1.Rows[e.RowIndex].FindControl("lblID"))).Text); int i = 0; // Delete Teacher DataTable dt20 = new tbl_TeacherInformationTableAdapter().GetDataByAdmin(ID); for (int h = 0; h < dt20.Rows.Count; h++) { new tbl_LinkTableAdapter().DeletePerson(int.Parse(dt20.Rows[i]["Teacher_ID"].ToString()),"Teacher"); new tbl_ContentTableAdapter().DeletePerson("Teacher",int.Parse(dt20.Rows[i]["Teacher_ID"].ToString())); new tbl_PersonalMessageTableAdapter().DeleteUserMessage("Teacher", int.Parse(dt20.Rows[i]["Teacher_ID"].ToString())); // Delete Lesson DataTable dt3 = new tbl_LessonTableAdapter().GetDataByAllTeacher(int.Parse(dt20.Rows[i]["Teacher_ID"].ToString())); for (i = 0; i < dt3.Rows.Count; i++) { DataTable dt4 = new tbl_ScoreTitleTableAdapter().GetDataByID_Lesson(int.Parse(dt3.Rows[i]["Lesson_ID"].ToString())); for (int j = 0; j < dt4.Rows.Count; j++) { new tbl_ScoreTableAdapter().DeleteTitle(int.Parse(dt4.Rows[j]["ScoreTitle_ID"].ToString())); } new tbl_ScoreTitleTableAdapter().DeleteLesson(int.Parse(dt3.Rows[i]["Lesson_ID"].ToString())); // Delete Test DataTable dt6 = new tbl_TestTableAdapter().GetDataByt_id_lesson(int.Parse(dt3.Rows[i]["Lesson_ID"].ToString())); for (int k = 0; k < dt4.Rows.Count; k++) { DataTable dt7 = new tbl_TestQuestionTableAdapter().GetDataByDetailStudent(int.Parse(dt6.Rows[k]["ID_Test"].ToString())); for (int f = 0; f < dt7.Rows.Count; f++) { new tbl_TestResultDetailTableAdapter().DeleteQuestion(int.Parse(dt7.Rows[f]["TestQuestion_ID"].ToString())); } new tbl_TestQuestionTableAdapter().DeleteTest(int.Parse(dt6.Rows[k]["ID_Test"].ToString())); new tbl_TestResultTableAdapter().DeleteTest(int.Parse(dt6.Rows[k]["ID_Test"].ToString())); } new tbl_TestTableAdapter().DeleteLesson(int.Parse(dt3.Rows[i]["Lesson_ID"].ToString())); } new tbl_LessonTableAdapter().DeleteTeacher(int.Parse(dt20.Rows[i]["Teacher_ID"].ToString())); } new tbl_TeacherInformationTableAdapter().DeleteAdmin(ID); // Delete Student Parent DataTable dt = new tbl_StudentInformationTableAdapter().GetDataByAdmin(ID); for (i = 0; i < dt.Rows.Count; i++) { new tbl_PersonalMessageTableAdapter().DeleteUserMessage("Student", int.Parse(dt.Rows[i]["Student_ID"].ToString())); new tbl_ScoreTableAdapter().DeleteStudent(int.Parse(dt.Rows[i]["Student_ID"].ToString())); DataTable dt10 = new tbl_ParentInformationTableAdapter().GetDataByPA_ID_Student(int.Parse(dt.Rows[i]["Student_ID"].ToString())); for (int f = 0; f < dt10.Rows.Count; f++) { new tbl_PersonalMessageTableAdapter().DeleteUserMessage("Parent", int.Parse(dt10.Rows[f]["Parent_ID"].ToString())); } new tbl_ParentInformationTableAdapter().DeleteStudent(int.Parse(dt.Rows[i]["Student_ID"].ToString())); } new tbl_StudentInformationTableAdapter().DeleteAdmin(ID); // Delete Gallery DataTable dt5 = new tbl_GallerySubjectTableAdapter().GetDataByAdmin(ID); for (i = 0; i < dt5.Rows.Count; i++) { new tbl_GalleryPictureTableAdapter().Deletegp_ID_GallerySubject(int.Parse(dt5.Rows[i]["GallerySubjet_ID"].ToString())); } new tbl_GallerySubjectTableAdapter().DeleteAdmin(ID); new tbl_AdminSecurityTableAdapter().DeleteAS_ID_Admin(ID); new tbl_AdminPermissionCategoryTableAdapter().DeleteAPC_ID_Admin(ID); new tbl_ContentTableAdapter().DeletePerson("Admin", ID); new tbl_LinkTableAdapter().DeletePerson(ID, "Admin"); new tbl_PersonalMessageTableAdapter().DeleteUserMessage("Admin", ID); new tbl_AdminInformationTableAdapter().DeleteAdmin(ID); FillGrid(); Cancel(); }
private void Fill() { int ID_Content = int.Parse(Request.QueryString["ID_Content"]); DataTable dt = new tbl_ContentTableAdapter().GetDataByContent_ID(ID_Content); TitleContent = dt.Rows[0]["con_title"].ToString(); DateContent = dt.Rows[0]["Con_Date"].ToString(); BazdidContent = dt.Rows[0]["Con_Bazdid"].ToString(); Label1.Text = dt.Rows[0]["con_text"].ToString(); // موضوع if (dt.Rows[0]["Con_Type"].ToString() == "News") { Label2.Text = "موضوع : <b>اخبار و اطلاعیه ها</b>"; } else if (dt.Rows[0]["Con_Type"].ToString() == "Break") { Label2.Text = "موضوع : <b>زنگ تفریح</b>"; } else if (dt.Rows[0]["Con_Type"].ToString() == "Library") { Label2.Text = "موضوع : <b>کتابخانه</b>"; } // نویسنده مطلب DataTable dt2; string Con_ID_Role = "0"; if (dt.Rows[0]["Con_Type_Role"].ToString() == "Teacher") { dt2 = new tbl_TeacherInformationTableAdapter().GetDataByID(int.Parse(dt.Rows[0]["Con_ID_Role"].ToString())); AuthorContent = dt2.Rows[0]["TI_Name"].ToString(); if (AuthorContent.Trim().Length == 0) { AuthorContent = dt2.Rows[0]["TI_UserName"].ToString(); } Con_ID_Role = dt2.Rows[0]["Teacher_ID"].ToString(); } else if (dt.Rows[0]["Con_Type_Role"].ToString() == "Admin") { dt2 = new tbl_AdminInformationTableAdapter().GetDataByID(int.Parse(dt.Rows[0]["Con_ID_Role"].ToString())); AuthorContent = dt2.Rows[0]["AI_Name"].ToString(); if (AuthorContent.Trim().Length == 0) { AuthorContent = dt2.Rows[0]["AI_UserName"].ToString(); } Con_ID_Role = dt2.Rows[0]["Admin_ID"].ToString(); } AuthorContent = "<a href='./index.aspx?Type=" + dt.Rows[0]["Con_Type_Role"].ToString() + "Detail&" + "ID_" + dt.Rows[0]["Con_Type_Role"].ToString() + "=" + Con_ID_Role + "'>" + AuthorContent + "</a>"; // فایل پیوست if (System.IO.File.Exists(Server.MapPath(dt.Rows[0]["Con_Attach"].ToString()))) { HyperLink1.NavigateUrl = dt.Rows[0]["Con_Attach"].ToString(); System.IO.FileStream f = new System.IO.FileStream(Server.MapPath(dt.Rows[0]["Con_Attach"].ToString()), System.IO.FileMode.Open); double a = f.Length; double b = 1024; double size = a / b; Label3.Text = size.ToString(); Label3.Text = Label3.Text.Substring(0, 6); f.Close(); } else { HyperLink1.NavigateUrl = ""; Panel1.Visible = false; } // مسیر قرارگیری مطلب FillPath(dt.Rows[0]["con_id_category"].ToString()); }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowIndex != -1) { string title = ""; string name = "توسط : "; string Type = ((Label)(e.Row.FindControl("lblTypeSender"))).Text; string ID = ((Label)(e.Row.FindControl("lblIDSender"))).Text; DataTable dt; if (Type == "Admin") { dt = new tbl_AdminInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["AI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["AI_username"].ToString(); } title = "مدیر"; } else if (Type == "Teacher") { dt = new tbl_TeacherInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["TI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["TI_username"].ToString(); } title = "معلم"; } else if (Type == "Parent") { dt = new tbl_ParentInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["PA_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["PA_username"].ToString(); } title = "اولیاء"; } else if (Type == "Student") { dt = new tbl_StudentInformationTableAdapter().GetDataByStudent_ID(int.Parse(ID)); name = dt.Rows[0]["SI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["SI_username"].ToString(); } title = "دانش آموز"; } name = "توسط : " + name; ((Label)(e.Row.FindControl("lblName"))).Text = name + " ( " + title + " ) "; if (bool.Parse(((Label)(e.Row.FindControl("lblVision"))).Text)) { e.Row.Attributes.Add("onMouseOver", "this.style.background='#eeff00'"); e.Row.Attributes.Add("onMouseOut", "this.style.background='#EFF3FB'"); e.Row.BackColor = System.Drawing.Color.FromName("#EFF3FB"); } else { e.Row.BackColor = System.Drawing.Color.White; e.Row.Attributes.Add("onMouseOver", "this.style.background='#eeff00'"); e.Row.Attributes.Add("onMouseOut", "this.style.background='White'"); } } }
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { int ID = int.Parse(((Label)(GridView1.Rows[e.NewEditIndex].FindControl("lblID"))).Text); DataTable dt = new tbl_TeacherInformationTableAdapter().GetDataByID(ID); if (dt.Rows.Count > 0) { TextName.Text = dt.Rows[0]["TI_Name"].ToString(); TextFatherName.Text = dt.Rows[0]["TI_FatherName"].ToString(); TextAddress.Text = dt.Rows[0]["TI_Address"].ToString(); TextTell.Text = dt.Rows[0]["TI_Tell"].ToString(); TextPostalCode.Text = dt.Rows[0]["TI_PostalCode"].ToString(); TextExportPlace.Text = dt.Rows[0]["TI_ExportPlace"].ToString(); TextBirthDate.Text = dt.Rows[0]["TI_BirthDate"].ToString(); TextAdminCode.Text = dt.Rows[0]["TI_TeacherCode"].ToString(); TextUserName.Text = dt.Rows[0]["TI_UserName"].ToString(); HiddenField2.Value = dt.Rows[0]["TI_UserName"].ToString(); HiddenField1.Value = new main_class().Decode(dt.Rows[0]["TI_Password"].ToString()); FileUpload1.ToolTip = dt.Rows[0]["TI_Picutre"].ToString(); Image1.ImageUrl = dt.Rows[0]["TI_Picutre"].ToString(); if (System.IO.File.Exists(Server.MapPath(Image1.ImageUrl))) { Image1.Visible = true; } else { Image1.Visible = true; Image1.ImageUrl = "~//Image_User//default_pic.png"; } } LblHidden.ToolTip = ID.ToString(); GridView1.SelectedIndex = e.NewEditIndex; Button3.Visible = true; Button1.Visible = false; }
private void FillPath(string Type,string ID) { string title = ""; string name = ""; DataTable dt; if (Type == "Admin") { dt = new tbl_AdminInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["AI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["AI_username"].ToString(); } title = " مدیران"; } else if (Type == "Teacher") { dt = new tbl_TeacherInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["TI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["TI_username"].ToString(); } title = " معلم ها"; } else if (Type == "Parent") { dt = new tbl_ParentInformationTableAdapter().GetDataByID(int.Parse(ID)); name = dt.Rows[0]["PA_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["PA_username"].ToString(); } title = " اولیاء"; } else if (Type == "Student") { dt = new tbl_StudentInformationTableAdapter().GetDataByStudent_ID(int.Parse(ID)); name = dt.Rows[0]["SI_name"].ToString(); if (name.Trim().Length == 0) { name = dt.Rows[0]["SI_username"].ToString(); } title = " دانش آموزان"; } if (Request.QueryString["Kind"] == "Inbox") { lblPath.Text = lblPath.Text + "<a href='index.aspx?Type=PersonalMessageInbox'> پیام های دریافتی </a> >> " + title + " >> " + "<a href='./index.aspx?Type=" + Type + "Detail&" + "ID_" + Type + "=" + ID + "'>" + name + "</a>"; } else if (Request.QueryString["Kind"] == "Outbox") { lblPath.Text = lblPath.Text + "<a href='index.aspx?Type=PersonalMessageOutbox'> پیام های فرستاده شده </a> >> "+ title + " >> " + "<a href='./index.aspx?Type=" + Type + "Detail&" + "ID_" + Type + "=" + ID + "'>" + name + "</a>"; } if (Request.QueryString["Kind"] == "Inbox") { AuthorContent = "<a href='index.aspx?Type=PersonalMessageInsert&Type_Role_Getter=" + Type + "&ID_Role_Getter=" + ID + "'>پاسخ به " + name + "</a>"; } else if (Request.QueryString["Kind"] == "Outbox") { AuthorContent = "<a href='index.aspx?Type=PersonalMessageInsert&Type_Role_Getter=" + Type + "&ID_Role_Getter=" + ID + "'>ارسالی دیگر به " + name + "</a>"; } }