protected void Button1_Click(object sender, EventArgs e)
{
string cvPath = "~/attachments/" + fu_cv.FileName;
fu_cv.SaveAs(Server.MapPath(cvPath));
string imgPath = "~/attachments/" + fu_photo.FileName;
fu_photo.SaveAs(Server.MapPath(imgPath));
Instructor I = new Instructor
{
Id = 0,
name = txt_name.Text,
email = txt_email.Text,
password = txt_pass.Text,
cv = cvPath,
photo = imgPath,
age = int.Parse(txt_age.Text),
dept_Id = int.Parse(ddl_Department.SelectedValue),
};
InstructorDBContext db = new InstructorDBContext();
var flag = db.Instructors.Add(I);
db.SaveChanges();
if (flag != null)
{
txt_age.Text = txt_email.Text = txt_name.Text
= txt_age.Text = "";
lbl_warning.Visible = true;
lbl_warning.Text = "A new Instructor has been added successfully";
}
else
{
lbl_warning.Text = "Please fill all fields";
}
}
public void ddlFill()
{
InstructorDBContext db = new InstructorDBContext();
var dept = db.Departments.ToList();
ddl_Department.DataSource = dept;
ddl_Department.DataTextField = "Dept_Name";
ddl_Department.DataValueField = "Dept_Id";
ddl_Department.DataBind();
}
protected void ddl_dept_SelectedIndexChanged1(object sender, EventArgs e)
{
InstructorDBContext db = new InstructorDBContext();
int y = int.Parse(ddl_dept.SelectedValue);
var Inst = db.Instructors.Where(n => n.dept_Id == y)
.Select(n => new { name = n.name, age = n.age, email = n.email, department = n.Department.Dept_Name }).ToList();
gv_InsData.DataSource = Inst;
gv_InsData.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlFill();
InstructorDBContext db = new InstructorDBContext();
int y = int.Parse(ddl_dept.SelectedValue);
var Inst = db.Instructors.Where(n => n.dept_Id == y)
.Select(n => new { name = n.name, age = n.age, email = n.email, department = n.Department.Dept_Name }).ToList();
gv_InsData.DataSource = Inst;
gv_InsData.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
InstructorDBContext db = new InstructorDBContext();
int id = int.Parse(Session["current_user"].ToString());
var I2 = db.Instructors.Where(I => I.Id == id).FirstOrDefault();
if (I2 != null)
{
lbl_name.Text = I2.name.ToString();
lbl_age.Text = I2.age.ToString();
lbl_email.Text = I2.email.ToString();
img.ImageUrl = I2.photo.ToString();
hl_cv.NavigateUrl = I2.cv.ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
InstructorDBContext db = new InstructorDBContext();
int id = int.Parse(Session["current_user"].ToString());
Instructor Ins = db.Instructors.Where(n => n.Id == id).FirstOrDefault();
if (Ins != null)
{
Ins.name = txt_name.Text;
Ins.email = txt_email.Text;
Ins.age = int.Parse(txt_age.Text);
Ins.dept_Id = int.Parse(ddl_Department.SelectedValue);
}
db.SaveChanges();
Response.Redirect("~/login page.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
InstructorDBContext db = new InstructorDBContext();
var I = db.Instructors.Where(n => n.name == txt_name.Text && n.password == txt_pass.Text).SingleOrDefault();
if (I != null)
{
Session.Add("current_user", I.Id);
Response.Redirect("~/profile page.aspx");
}
else
{
lbl_warning.Visible = true;
lbl_warning.Text = "Failed";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlFill();
int x = int.Parse(Session["current_user"].ToString());
InstructorDBContext db = new InstructorDBContext();
var Ins = db.Instructors.Where(n => n.Id == x).FirstOrDefault();
if (Ins != null)
{
ddl_Department.SelectedValue = Ins.dept_Id.ToString();
txt_name.Text = Ins.name.ToString();
txt_email.Text = Ins.email.ToString();
txt_age.Text = Ins.age.ToString();
}
}
}
