protected void ddlTheme_SelectedIndexChanged(object sender, EventArgs e)
{
Configuration config = WebConfigurationManager.OpenWebConfiguration("~/");
PagesSection pages = (PagesSection)config.GetSection("system.web/pages");
pages.Theme = ddlTheme.SelectedItem.Text.ToString();
if (!pages.SectionInformation.IsLocked)
{
config.Save();
Response.Redirect("dashboard.aspx");
}
else
{
Response.Write("<script>alert('Could not save configuration')</script>");
}
using (var db = new LogUserDataContext())
{
LogUser lu = new LogUser()
{
Theme = pages.Theme.ToString(),
Language = DropDownList1.SelectedValue.ToString()
};
db.SubmitChanges();
}
}
protected void BtnLogin_Click(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
// Field values
var User = TextBoxUser.Text;
var Pass = TextBoxPass.Text;
// stored procedure for login
var s = from d in db.LoginVerify(User, Pass)
select d;
//var q = from p in db.LogUsers
// where p.Username == User
// && p.Password == Pass
// select p;
if (s.Any())
{
// do something (correct password)
Session["id"] = TextBoxUser.Text;
Response.Redirect("dashboard.aspx?id" + User);
Session.RemoveAll();
}
else
{
// something else (incorrect password)
LblMsg.Text = " Username and Password is incorrect";
}
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
LogUser lu = new LogUser()
{
Language = DropDownList1.SelectedValue.ToString()
};
db.SubmitChanges();
}
}
private void UpdateGrid()
{
using (var db = new LogUserDataContext())
{
var st = from s in db.catgs
select s;
ListBox1.DataSource = st;
ListBox1.DataTextField = "cat_name";
ListBox1.DataValueField = "cat_id";
ListBox1.DataBind();
}
}
protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
int selectedid = Convert.ToInt32(ListBox1.SelectedValue);
//var st = from s in db.Students
// where s.Id == selectedid
// select s;
catg st = db.catgs.First(s => s.cat_id == selectedid);
StudName.Text = st.cat_name;
StudAttend.Text = st.s_attend.ToString();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
int selectedid = Convert.ToInt32(ListBox1.SelectedValue);
catg st = db.catgs.First(s => s.cat_id == selectedid);
st.cat_name = StudName.Text;
st.s_attend = Convert.ToInt32(StudAttend.Text);
db.SubmitChanges();
}
StudName.Text = StudAttend.Text = "";
UpdateGrid();
}
protected void btnDel_Click(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
int selectedid = Convert.ToInt32(ListBox1.SelectedValue);
teacher st = db.teachers.First(s => s.cat_id == selectedid);
db.teachers.DeleteOnSubmit(st);
db.SubmitChanges();
}
TeachName.Text = TeachEmail.Text = TeachDOB.Text = TeachAddress.Text = TeachGender.Text = TeachSalary.Text = "";
UpdateGrid();
btnAdd.Visible = true;
btnUp.Visible = false;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
catg cg = new catg()
{
cat_name = StudName.Text,
s_address = StudAddress.Text,
s_dob = StudDOB.Text,
s_gender = StudGender.Text,
s_email = StudEmail.Text,
s_sem = Convert.ToInt32(StudSem.Text)
};
db.catgs.InsertOnSubmit(cg);
db.SubmitChanges();
}
StudEmail.Text = StudAddress.Text = StudName.Text = StudGender.Text = StudSem.Text = StudDOB.Text = "";
UpdateGrid();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
teacher tc = new teacher()
{
cat_name = TeachName.Text,
t_email = TeachEmail.Text,
t_address = TeachAddress.Text,
t_gender = TeachGender.Text,
t_dob = TeachDOB.Text,
t_salary = Convert.ToInt32(TeachSalary.Text)
};
db.teachers.InsertOnSubmit(tc);
db.SubmitChanges();
}
TeachName.Text = TeachEmail.Text = TeachDOB.Text = TeachAddress.Text = TeachGender.Text = TeachSalary.Text = "";
UpdateGrid();
}
protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
int selectedid = Convert.ToInt32(ListBox1.SelectedValue);
//var st = from s in db.Students
// where s.Id == selectedid
// select s;
teacher st = db.teachers.First(s => s.cat_id == selectedid);
TeachName.Text = st.cat_name;
TeachAddress.Text = st.t_address;
TeachDOB.Text = st.t_dob;
TeachEmail.Text = st.t_email;
TeachGender.Text = st.t_gender;
TeachSalary.Text = st.t_salary.ToString();
btnAdd.Visible = false;
btnUp.Visible = true;
}
}
protected void btnUp_Click(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
int selectedid = Convert.ToInt32(ListBox1.SelectedValue);
catg st = db.catgs.First(s => s.cat_id == selectedid);
st.cat_name = StudName.Text;
st.s_email = StudEmail.Text;
st.s_address = StudAddress.Text;
st.s_gender = StudGender.Text;
st.s_dob = StudDOB.Text;
st.s_sem = Convert.ToInt32(StudSem.Text);
db.SubmitChanges();
}
StudName.Text = StudEmail.Text = StudDOB.Text = StudAddress.Text = StudGender.Text = StudSem.Text = "";
UpdateGrid();
btnAdd.Visible = true;
btnUp.Visible = false;
}
protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
int selectedid = Convert.ToInt32(ListBox1.SelectedValue);
//var st = from s in db.Students
// where s.Id == selectedid
// select s;
catg st = db.catgs.First(s => s.cat_id == selectedid);
StudName.Text = st.cat_name;
StudAddress.Text = st.s_address;
StudDOB.Text = st.s_dob;
StudEmail.Text = st.s_email;
StudGender.Text = st.s_gender;
StudSem.Text = st.s_sem.ToString();
btnAdd.Visible = false;
btnUp.Visible = true;
}
}
