protected void Button1_Click(object sender, EventArgs e)
{
SMSentities dbcontex=new SMSentities();
var studinfor = from dd in dbcontex.studinfoes select dd;
//var stumarks=from xx in dbcontex.studinfoes
DataTable dt = new DataTable();
dt.Columns.Add("id");
dt.Columns.Add("stuname");
dt.Columns.Add("fathername");
dt.Columns.Add("mothername");
dt.Columns.Add("address");
dt.Columns.Add("contactno");
dt.Columns.Add("email");
dt.Columns.Add("department");
foreach (var studd in studinfor)
{
DataRow r = dt.NewRow();
r[0] = studd.Id;
r[1] = studd.stuname;
r[2] = studd.fathername;
r[3] = studd.mothername;
r[4] = studd.address;
r[5] = studd.contactNo;
r[6] = studd.email;
r[7] = studd.DepartMent;
dt.Rows.Add(r);
}
showGridView.DataSource = dt;
showGridView.DataBind();
}
protected void Button1_Click1(object sender, EventArgs e)
{
SMSentities dbcontext=new SMSentities();
int id1 = int.Parse(IdTextBox.Text);
var studobj = from xx in dbcontext.studinfoes where xx.Id == id1 select xx;
bool flag = false;
foreach (var stdin in studobj)
{
NameTextBox.Text = stdin.stuname;
FatherTextBox.Text = stdin.fathername;
MotherTextBox.Text = stdin.mothername;
AddressTextBox.Text = stdin.address;
contTextBox.Text = stdin.contactNo.ToString();
emailTextBox.Text = stdin.email;
deptTextBox.Text = stdin.DepartMent;
flag = true;
}
if (flag == false)
{
msgLabel.Text = "not found";
}
else
{
msgLabel.Text = "found";
}
}
protected void addButton_Click(object sender, EventArgs e)
{
SMSentities dbcontext = new SMSentities();
studinfo stdobj = new studinfo();
stdobj.Id = int.Parse(IdTextBox.Text);
stdobj.stuname = NameTextBox.Text;
stdobj.fathername = FatherTextBox.Text;
stdobj.mothername = MotherTextBox.Text;
stdobj.address = AddressTextBox.Text;
stdobj.contactNo = int.Parse(contTextBox.Text);
stdobj.email = emailTextBox.Text;
stdobj.DepartMent = deptTextBox.Text;
dbcontext.studinfoes.Add(stdobj);
dbcontext.SaveChanges();
msgLabel.Text = "added successfully";
//SMSentities dbcontext=new SMSentities();
//studinfo obj =new studinfo();
//obj.Id = int.Parse(IdTextBox.Text);
//obj.stuname = NameTextBox.Text;
//obj.fathername = FatherTextBox.Text;
//obj.mothername = MotherTextBox.Text;
//obj.address = AddressTextBox.Text;
//obj.contactNo = int.Parse(contTextBox.Text);
//obj.email = emailTextBox.Text;
//obj.DepartMent = deptTextBox.Text;
//dbcontext.studinfoes.Add(obj);
//dbcontext.SaveChanges();
}
protected void updateButton_Click(object sender, EventArgs e)
{
SMSentities dbcontex=new SMSentities();
StudentManagementSystem.studinfo objStudinfo=new studinfo();
//try
{
int id1 = int.Parse(IdTextBox.Text);
objStudinfo = dbcontex.studinfoes.FirstOrDefault(xx => xx.Id==id1);
objStudinfo.DepartMent = deptTextBox.Text;
objStudinfo.address = AddressTextBox.Text;
dbcontex.SaveChanges();
msgLabel.Text = "update successfully";
}
//catch (Exception e1)
{
msgLabel.Text = "not found id";
//throw;
}
}
protected void showResultButton_Click(object sender, EventArgs e)
{
SMSentities dbcontext=new SMSentities();
var stumarks = from xx in dbcontext.stdmarksDetails select xx;
DataTable dt=new DataTable();
dt.Columns.Add("idnumber");
dt.Columns.Add("name");
dt.Columns.Add("deppartment");
dt.Columns.Add("email");
dt.Columns.Add("grade");
dt.Columns.Add("cgpa");
dt.Columns.Add("courses");
dt.Columns.Add("semester");
foreach (var stdma in stumarks)
{
DataRow dr = dt.NewRow();
dr[0] = stdma.idNumber;
dr[1] = stdma.name;
dr[2] = stdma.DeppartMent;
dr[3] = stdma.Email;
dr[4] = stdma.grade;
dr[5] = stdma.cgpa;
dr[6] = stdma.courses;
dr[7] = stdma.semester;
dt.Rows.Add(dr);
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void searchbydeptButton_Click(object sender, EventArgs e)
{
string dept = searchTextBox.Text;
SMSentities dbcontex = new SMSentities();
var studinfor = from xx in dbcontex.studinfoes where xx.DepartMent == dept select xx;
DataTable dt = new DataTable();
dt.Columns.Add("id");
dt.Columns.Add("stuname");
dt.Columns.Add("fathername");
dt.Columns.Add("mothername");
dt.Columns.Add("address");
dt.Columns.Add("contactno");
dt.Columns.Add("email");
dt.Columns.Add("department");
foreach (var studentin in studinfor)
{
DataRow r = dt.NewRow();
r[0] = studentin.Id;
r[1] = studentin.stuname;
r[2] = studentin.fathername;
r[3] = studentin.mothername;
r[4] = studentin.address;
r[5] = studentin.contactNo;
r[6] = studentin.email;
r[7] = studentin.DepartMent;
dt.Rows.Add(r);
}
showGridView.DataSource = dt;
showGridView.DataBind();
}
protected void delateButton_Click(object sender, EventArgs e)
{
SMSentities dbcontext=new SMSentities();
StudentManagementSystem.studinfo sobject = new studinfo();
// try
{
int id1 = int.Parse(IdTextBox.Text);
var sobj = dbcontext.studinfoes.FirstOrDefault(xx => xx.Id == id1);
dbcontext.studinfoes.Remove(sobj);
dbcontext.SaveChanges();
msgLabel.Text = "successfully delated";
}
// catch (Exception e1)
{
msgLabel.Text = "not found";
}
{
}
}