public static void update(mstudent m)
{
using (var data = new instDataContext())
{
var obj = data.mstudents.Single(j => j.enrolmentno == m.enrolmentno);
obj.firstname = m.firstname;
obj.lastname = m.lastname;
obj.courseid = m.courseid;
obj.referenceno = m.referenceno;
obj.address1 = m.address1;
obj.address2 = m.address2;
obj.address3 = m.address3;
obj.city = m.city;
obj.pin = m.pin;
obj.phone = m.phone;
obj.state = m.state;
obj.email = m.email;
obj.dob = m.dob;
obj.fathername = m.fathername;
obj.mothername = m.mothername;
obj.category = m.category;
obj.gender = m.gender;
obj.phone = m.phone;
data.SubmitChanges();
}
}
protected void btnEnroll_Click(object sender, EventArgs e)
{
mstudent s = mstudent.selectStudent(ddlStudents.SelectedValue).FirstOrDefault();
s.courseid = ddlCourses.SelectedValue;
mstudent.update(s);
}
protected void Button1_Click(object sender, EventArgs e)
{
mstudent m = new mstudent();
m.enrolmentno = TextBox1.Text;
m.firstname = TextBox2.Text;
m.lastname = TextBox3.Text;
m.courseid = TextBox4.Text;
m.referenceno = TextBox5.Text;
m.address1 = TextBox6.Text;
m.address2 = TextBox7.Text;
m.address3 = TextBox11.Text;
m.city = TextBox8.Text;
m.pin = TextBox12.Text;
m.state = TextBox13.Text;
m.email = TextBox9.Text;
m.dob = TextBox14.Text;
m.fathername = TextBox15.Text;
m.mothername = TextBox16.Text;
m.category = TextBox17.Text;
m.gender = TextBox18.Text;
m.phone = TextBox19.Text;
mstudent.insert(m);
mpassword k = new mpassword();
k.username = TextBox1.Text;
k.password = TextBox2.Text;
k.usertype = "student";
mpassword.insert(k);
}
public static void update(mstudent m)
{
using (var data = new instDataContext())
{
var obj = data.mstudents.Single(j => j.enrolmentno == m.enrolmentno);
obj.firstname = m.firstname;
obj.lastname = m.lastname;
obj.courseid = m.courseid;
obj.referenceno = m.referenceno;
obj.address1 = m.address1;
obj.address2 = m.address2;
obj.address3 = m.address3;
obj.city = m.city;
obj.pin = m.pin;
obj.phone = m.phone;
obj.state = m.state;
obj.email = m.email;
obj.dob = m.dob;
obj.fathername = m.fathername;
obj.mothername = m.mothername;
obj.category = m.category;
obj.gender = m.gender;
obj.phone = m.phone;
data.SubmitChanges();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
mstudent m = new mstudent();
m.enrolmentno = TextBox1.Text;
m.firstname = TextBox2.Text;
m.lastname = TextBox3.Text;
m.courseid = TextBox4.Text;
m.referenceno = TextBox5.Text;
m.address1 = TextBox6.Text;
m.address2 = TextBox7.Text;
m.address3 = TextBox11.Text;
m.city = TextBox8.Text;
m.pin = TextBox12.Text;
m.state = TextBox13.Text;
m.email = TextBox9.Text;
m.dob = TextBox14.Text;
m.fathername = TextBox15.Text;
m.mothername = TextBox16.Text;
m.category = TextBox17.Text;
m.gender = TextBox18.Text;
m.phone = TextBox19.Text;
mstudent.insert(m);
mpassword k = new mpassword();
k.username = TextBox1.Text;
k.password = TextBox2.Text;
k.usertype = "student";
mpassword.insert(k);
}
public static void insert(mstudent m)
{
using (var data = new instDataContext())
{
data.mstudents.InsertOnSubmit(m);
data.SubmitChanges();
}
}
public static void insert(mstudent m)
{
using (var data = new instDataContext())
{
data.mstudents.InsertOnSubmit(m);
data.SubmitChanges();
}
}
public static void delete(mstudent m)
{
using (var data = new instDataContext())
{
var obj = data.mstudents.Single(j => j.enrolmentno == m.enrolmentno);
data.mstudents.DeleteOnSubmit(obj);
data.SubmitChanges();
}
}
public static void delete(mstudent m)
{
using (var data = new instDataContext())
{
var obj = data.mstudents.Single(j => j.enrolmentno == m.enrolmentno);
data.mstudents.DeleteOnSubmit(obj);
data.SubmitChanges();
}
}
private void BindCourses(SqlConnection con)
{
mstudent s = mstudent.selectStudent(ddlStudentId.SelectedValue).FirstOrDefault();
string com = "Select * from mcourses where course_id=" + "'" + s.courseid + "'";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
ddlCourses.DataSource = dt;
ddlCourses.DataBind();
ddlCourses.DataTextField = "course_name";
ddlCourses.DataValueField = "course_id";
ddlCourses.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
mstudent s = mstudent.selectStudent(Session["user"].ToString()).FirstOrDefault();
Session["course"] = s.courseid;
}
protected void Button1_Click(object sender, EventArgs e)
{
int value;
decimal comtact;
if (TextBox1.Text.Length == 7 && int.TryParse(TextBox1.Text, out value))
{
if (TextBox19.Text.Length == 10 && decimal.TryParse(TextBox19.Text, out comtact))
{
mstudent m = new mstudent();
m.enrolmentno = TextBox1.Text;
m.firstname = TextBox2.Text;
m.lastname = TextBox3.Text;
m.courseid = "";
m.referenceno = "";
m.address1 = "";
m.address2 = "";
m.address3 = "";
m.city = "";
m.pin = "";
m.state = "";
m.email = "";
m.dob = "";
m.fathername = "";
m.mothername = "";
m.category = "";
m.gender = "";
m.phone = TextBox19.Text;
mstudent.insert(m);
//mpassword k = new mpassword();
//k.username = TextBox1.Text;
//k.password = TextBox2.Text;
//k.usertype = "student";
//mpassword.insert(k);
string query = @"INSERT INTO [dbo].[mpasswords]
([usertype]
,[username]
,[password]
,[enrollmentno])
VALUES
(@usertype
,@username
,@password
,@enrollmentno)";
SqlConnection con = new SqlConnection(@"Data Source=HYRDCND5340CD1\SQL2014;Initial Catalog=inst_mgmt_sys;User ID=HRnet;Password=pword;Pooling=true;Min Pool Size=10;Max Pool Size=1000");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = query;
cmd.Connection = con;
string guid1 = Guid.NewGuid().ToString();
cmd.Parameters.AddWithValue("@usertype", ddlUsertype.SelectedValue);
cmd.Parameters.AddWithValue("@username", TextBox1.Text);
cmd.Parameters.AddWithValue("@password", TextBox4.Text);
cmd.Parameters.AddWithValue("@enrollmentno", TextBox1.Text);
con.Open();
int s1 = cmd.ExecuteNonQuery();
con.Close();
if (s1 > 0)
{
lblNotify.Text = "User Registered successfully.";
lblNotify.Visible = true;
TextBox1.Text = "";
TextBox19.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
}
}
else
{
lblNotify.Text = "Please enter 10 digit contact number.";
lblNotify.Visible = true;
}
}
else
{
lblNotify.Text = "Please enter 7 digit student id number.";
lblNotify.Visible = true;
}
}
partial void Deletemstudent(mstudent instance);
partial void Updatemstudent(mstudent instance);
partial void Insertmstudent(mstudent instance);
