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 Fill()
{
int ID = int.Parse(Request.QueryString["ID_Student"]);
DataTable dt = new tbl_StudentInformationTableAdapter().GetDataByStudent_ID(ID);
if (dt.Rows.Count > 0)
{
TextName = dt.Rows[0]["SI_Name"].ToString();
TextFatherName = dt.Rows[0]["SI_FatherName"].ToString();
TextAddress = dt.Rows[0]["SI_Address"].ToString();
TextTell = dt.Rows[0]["SI_Tell"].ToString();
TextPostalCode = dt.Rows[0]["SI_PostalCode"].ToString();
TextExportPlace = dt.Rows[0]["SI_ExportPlace"].ToString();
TextBirthDate = dt.Rows[0]["SI_BirthDate"].ToString();
TextAdminCode = dt.Rows[0]["SI_StudentCode"].ToString();
TextUserName = dt.Rows[0]["SI_UserName"].ToString();
TextEndTime = dt.Rows[0]["SI_Stu_End_Time"].ToString();
TextStartTime = dt.Rows[0]["SI_Stu_Start_Time"].ToString();
TextFatherMobile = dt.Rows[0]["SI_FatherMobile"].ToString();
TextFatherJob = dt.Rows[0]["SI_FatherJob"].ToString();
TextMotherMobile = dt.Rows[0]["SI_MotherMobile"].ToString();
TextMotherName = dt.Rows[0]["SI_MotherName"].ToString();
TextMotherJob = dt.Rows[0]["SI_MotherJob"].ToString();
Image1.ImageUrl = dt.Rows[0]["SI_Picture"].ToString();
if (System.IO.File.Exists(Server.MapPath(Image1.ImageUrl)))
{
}
else
{
Image1.ImageUrl = "~//Image_User//default_pic.png";
}
FillPath("Student", dt.Rows[0]["Student_ID"].ToString(), dt.Rows[0]["SI_ID_Category"].ToString());
}
}
private void FillGrid()
{
DataTable dt = new tbl_StudentInformationTableAdapter().GetDataByStudent_ID(int.Parse(Request.Cookies["ID_Role"].Value));
int ID_Category =int.Parse( dt.Rows[0]["SI_ID_Category"].ToString());
GridView1.SelectedIndex = -1;
GridView1.DataSource = new tbl_StudentInformationTableAdapter().GetDataByCategory_ID(ID_Category);
GridView1.DataBind();
FillPath(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("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 FillDr()
{
DataTable dt = new tbl_StudentInformationTableAdapter().GetDataByStudent_ID(int.Parse(Request.Cookies["ID_Role"].Value));
int ID_Category = int.Parse(dt.Rows[0]["SI_ID_Category"].ToString());
DropDownList1.Items.Clear();
DropDownList1.DataValueField = "Lesson_ID";
DropDownList1.DataTextField = "Les_Name";
DropDownList1.DataSource = new tbl_LessonTableAdapter().GetDataByCategory_ID(ID_Category);
DropDownList1.DataBind();
DropDownList1.Visible = true;
}
private void FillPath(string Type, string ID, string ID_Category)
{
string title = "";
string name = "";
DataTable 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 + " >> " + FillPath2(ID_Category) +
"<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>";
}
private void FillChild(string Type,string ID)
{
string name = "";
DataTable 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();
}
if (Request.Cookies["Type_Role"].Value != "Parent")
{
ChildName = "<a href='./index.aspx?Type=" + Type + "Detail&" +
"ID_" + Type + "=" + ID + "'>" +
name + "</a>";
}
else
{
ChildName = name;
}
}
private void FillGrid()
{
int ID_Category = -10;
string cat_path = "";
if (Request.Cookies["Type_Role"].Value.ToString() == "Parent")
{
int ID_Role = int.Parse(Request.Cookies["ID_Role"].Value.ToString());
DataTable dt = new tbl_ParentInformationTableAdapter().GetDataByParentInformationCategoryStudentInformationPersonParent(ID_Role);
cat_path = dt.Rows[0]["Cat_Path"].ToString();
ID_Category = int.Parse(dt.Rows[0]["Category_ID"].ToString());
}
else if (Request.Cookies["Type_Role"].Value.ToString() == "Student")
{
int ID_Role = int.Parse(Request.Cookies["ID_Role"].Value.ToString());
DataTable dt = new tbl_StudentInformationTableAdapter().GetDataByStudentInformationCategoryWhereID_Student(ID_Role);
cat_path = dt.Rows[0]["Cat_Path"].ToString();
ID_Category = int.Parse(dt.Rows[0]["SI_ID_Category"].ToString());
}
GridView1.DataSource = new tbl_GallerySubjectTableAdapter().GetDataByPerson(ID_Category, cat_path);
GridView1.DataBind();
}
private void FillPath(string Type, string ID)
{
string title = "";
string name = "";
DataTable 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 + "<a href='./index.aspx?Type=StudentInformationManage'>" +
title + "</a>" + " >> " +
"<a href='./index.aspx?Type=AdminEditStudent&Student_ID=" + ID + "'>" +
name + "</a>";
}
private void FillTest()
{
int ID_Student = int.Parse(Request.QueryString["ID_Student"]);
int ID_Test = int.Parse(Request.QueryString["ID_Test"]);
DataTable dt = new tbl_TestTableAdapter().GetDataByTest_ID(ID_Test);
lblTestTitle=dt.Rows[0]["t_title"].ToString();
DataTable dt2= new tbl_TestResultTableAdapter().GetDataByScoreStudent(ID_Test,ID_Student);
if (dt2.Rows.Count > 0)
{
txtScoreAllTest.Text = dt2.Rows[0]["tr_Score"].ToString();
}
DataTable dt3 = new tbl_StudentInformationTableAdapter().GetDataByStudent_ID(ID_Student);
lblName.Text = dt3.Rows[0]["SI_Name"].ToString();
if (lblName.Text.Length == 0)
{
lblName.Text = dt3.Rows[0]["SI_UserName"].ToString();
}
lblName.Text = "<a href='index.aspx?Type=StudentDetail&ID_Student=" + dt3.Rows[0]["Student_ID"].ToString() +
"'>" + lblName.Text + "</a>";
}
protected void Button1_Click(object sender, EventArgs e)
{
string Folder1 = "~\\Image_User\\Image_Parent\\";
string File_Name1 = FileUpload1.FileName.ToString().Trim();
string Address_Full1 = check_name_File(Folder1, File_Name1);
////////////////////////////////////////////////////////////////////////
string Code = TextCode.Text;
string StudentCode = TextStudentCode.Text;
DataTable dt = new tbl_StudentInformationTableAdapter().GetDataByUserNameAndStudentCode(Code, StudentCode);
if (dt.Rows.Count > 0)
{
int id_Student = int.Parse(dt.Rows[0]["Student_ID"].ToString());
DataTable dt5 = new tbl_ParentInformationTableAdapter().GetDataByPA_ID_Student(id_Student);
if (dt5.Rows.Count == 0)
{
if (new tbl_ParentInformationTableAdapter().GetDataByUsername(TextUserName.Text).Rows.Count == 0)
{
int ID_Stdent = int.Parse(dt.Rows[0]["Student_ID"].ToString());
if (FileUpload1.HasFile)
{
if (FileUpload1.PostedFile.ContentLength < 5120000)
{
string pic = Address_Full1;
new tbl_ParentInformationTableAdapter().Insert1(
TextName.Text,
TextMobile.Text,
TextUserName.Text,
new main_class().Encode(TextPassword.Text),
ID_Stdent,
TextJob.Text,
TextTell.Text,
TextAddress.Text,
pic, new main_class().GetDate(), "");
/////////////////////////////////////////
if (FileUpload1.HasFile)
{
Save_File(FileUpload1, Address_Full1);
}
}
else
{
Response.Write("<script>alert('حجم باید کمتر از 5000 کیلو بایت باشد')</script>");
}
}
else
{
string pic1 = "";
new tbl_ParentInformationTableAdapter().Insert1(
TextName.Text,
TextMobile.Text,
TextUserName.Text,
new main_class().Encode(TextPassword.Text),
ID_Stdent,
TextJob.Text,
TextTell.Text,
TextAddress.Text,
pic1, new main_class().GetDate(), "");
/////////////////////////////////////////
if (FileUpload1.HasFile)
{
Save_File(FileUpload1, Address_Full1);
}
}
lblError.Text = "ثبت نام به درستی انجام شد";
lblError.Visible = true;
}
else
{
lblError.Text = "نام کاربری وارد شده تکراری میباشد";
lblError.Visible = true;
}
}
else
{
lblError.Text = "برای این دانش آموز قبلا اولیایی به ثبت رسیده است";
lblError.Visible = true;
}
}
else
{
lblError.Text = "دانش آموزی با این مشخصات یافت نشد";
lblError.Visible = true;
}
//////////// //////////////////////// //////////////////////// //////////////////////// ////////////
}
private void FillGrid()
{
if (Request.Cookies["Type_Role"].Value.ToString() == "Parent")
{
int ID_Role = int.Parse(Request.Cookies["ID_Role"].Value.ToString());
DataTable dt = new tbl_ParentInformationTableAdapter().GetDataByParentInformationCategoryStudentInformationPersonParent(ID_Role);
string cat_path = dt.Rows[0]["Cat_Path"].ToString();
//Label4.Text = dt.Rows[0]["Cat_Path"].ToString();
//TextBox1.Text = dt.Rows[0]["Cat_Path"].ToString();
int ID_Category = int.Parse(dt.Rows[0]["Category_ID"].ToString());
// Label4.Text = dt.Rows[0]["SI_ID_Category"].ToString();
GridView1.DataSource = new tbl_ContentTableAdapter().GetDataByPersonCategory(ID_Category, "Library", cat_path);
GridView1.DataBind();
}
else
{
int ID_Role = int.Parse(Request.Cookies["ID_Role"].Value.ToString());
DataTable dt = new tbl_StudentInformationTableAdapter().GetDataByStudentInformationCategoryWhereID_Student(ID_Role);
string cat_path = dt.Rows[0]["Cat_Path"].ToString();
//Label4.Text = dt.Rows[0]["Cat_Path"].ToString();
//TextBox1.Text = dt.Rows[0]["Cat_Path"].ToString();
int ID_Category = int.Parse(dt.Rows[0]["SI_ID_Category"].ToString());
// Label4.Text = dt.Rows[0]["SI_ID_Category"].ToString();
GridView1.DataSource = new tbl_ContentTableAdapter().GetDataByPersonCategory(ID_Category, "Library", cat_path);
GridView1.DataBind();
}
}
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
{
}
}
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>";
}
}
private void Fill()
{
int ID = int.Parse(Request.QueryString["Student_ID"].ToString());
DataTable dt = new tbl_StudentInformationTableAdapter().GetDataByStudent_ID(ID);
if (dt.Rows.Count > 0)
{
LblHidden.ToolTip = Request.QueryString["Student_ID"].ToString();
TextName.Text = dt.Rows[0]["SI_Name"].ToString();
TextFatherMobile.Text = dt.Rows[0]["SI_FatherMobile"].ToString();
TextFatherName.Text = dt.Rows[0]["SI_FatherName"].ToString();
TextFatherJob.Text = dt.Rows[0]["SI_FatherJob"].ToString();
TextMotherMobile.Text = dt.Rows[0]["SI_MotherMobile"].ToString();
TextMotherName.Text = dt.Rows[0]["SI_MotherName"].ToString();
TextMotherJob.Text = dt.Rows[0]["SI_MotherJob"].ToString();
TextAddress.Text = dt.Rows[0]["SI_Address"].ToString();
TextTell.Text = dt.Rows[0]["SI_Tell"].ToString();
TextPostalCode.Text = dt.Rows[0]["SI_PostalCode"].ToString();
TextExportPlace.Text = dt.Rows[0]["SI_ExportPlace"].ToString();
TextBirthDate.Text = dt.Rows[0]["SI_BirthDate"].ToString();
TextAdminCode.Text = dt.Rows[0]["SI_StudentCode"].ToString();
TextUserName.Text = dt.Rows[0]["SI_UserName"].ToString();
HiddenField2.Value = dt.Rows[0]["SI_UserName"].ToString();
HiddenField1.Value = new main_class().Decode(dt.Rows[0]["SI_Password"].ToString());
Image1.Visible = true;
Image1.ImageUrl = dt.Rows[0]["SI_Picture"].ToString();
if (System.IO.File.Exists(Server.MapPath(Image1.ImageUrl)))
{
Image1.Visible = true;
}
else
{
Image1.Visible = true;
Image1.ImageUrl = "~//Image_User//default_pic.png";
}
}
FillDr(-1, DropDownList1);
DataTable dt2 = new tbl_CategoryTableAdapter().GetDataByID(int.Parse(dt.Rows[0]["SI_ID_Category"].ToString()));
if (dt2.Rows.Count > 0)
{
string delimitedInfo = dt2.Rows[0]["Cat_Path"].ToString();
string[] discreteInfo = delimitedInfo.Split(new char[] { ',' });
int i = 1;
foreach (string Data in discreteInfo)
{
if (Data == "-1")
{
FillDr(int.Parse(Data), (DropDownList)FindControl("DropDownList" + i.ToString()));
}
else
{
((DropDownList)(FindControl("DropDownList" + (i - 1).ToString()))).Items.FindByValue(Data).Selected = true;
FillDr(int.Parse(Data), (DropDownList)FindControl("DropDownList" + i.ToString()));
}
i++;
}
((DropDownList)(FindControl("DropDownList" + (i - 1).ToString()))).Items.FindByValue(dt.Rows[0]["SI_ID_Category"].ToString()).Selected = true;
if (i != 6)
{
FillDr(int.Parse(dt.Rows[0]["SI_ID_Category"].ToString()), (DropDownList)FindControl("DropDownList" + (i + 1).ToString()));
}
}
Panel1.Visible = true;
FillPath("Student", dt.Rows[0]["Student_ID"].ToString());
}
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_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();
}
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'");
}
}
}
