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