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 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(); } }
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);