public static mdatesheet[] select()
{
using (var data = new instDataContext())
{
return(data.mdatesheets.ToArray());
}
}
public static mcourse[] select()
{
using (var data = new instDataContext())
{
return data.mcourses.ToArray();
}
}
public static mstaff[] select()
{
using (var data = new instDataContext())
{
return(data.mstaffs.ToArray());
}
}
public static transport[] select()
{
using (var data = new instDataContext())
{
return(data.transports.ToArray());
}
}
public static administration[] select()
{
using (var data = new instDataContext())
{
return(data.administrations.ToArray());
}
}
public static tsalarypaid[] select()
{
using (var data=new instDataContext())
{
return data.tsalarypaids.ToArray();
}
}
public static bill[] select()
{
using (var data = new instDataContext())
{
return(data.bills.ToArray());
}
}
public static tattendance_stu[] select()
{
using (var data = new instDataContext())
{
return(data.tattendance_stus.ToArray());
}
}
public static marksint[] selectStudentResult(string enrollmentNo)
{
using (var data = new instDataContext())
{
return(data.marksints.Where(x => x.rollno == enrollmentNo).ToArray());
}
}
public static malumni[] select()
{
using (var data = new instDataContext())
{
return(data.malumnis.ToArray());
}
}
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();
}
}
public static feedback[] select()
{
using (var data = new instDataContext())
{
return data.feedbacks.ToArray();
}
}
public static tsalarypaid[] select()
{
using (var data = new instDataContext())
{
return(data.tsalarypaids.ToArray());
}
}
public static feedback[] select()
{
using (var data = new instDataContext())
{
return(data.feedbacks.ToArray());
}
}
public static administration[] select()
{
using (var data=new instDataContext())
{
return data.administrations.ToArray();
}
}
public static transport[] select()
{
using (var data=new instDataContext())
{
return data.transports.ToArray();
}
}
public static mcourse[] selectCourse(string courseId)
{
using (var data = new instDataContext())
{
return(data.mcourses.Where(s => s.course_id == courseId).ToArray());
}
}
public static mresult[] select()
{
using (var data = new instDataContext())
{
return data.mresults.ToArray();
}
}
public static mdatesheet[] select()
{
using (var data = new instDataContext())
{
return data.mdatesheets.ToArray();
}
}
public static charge[] select()
{
using (var data = new instDataContext())
{
return data.charges.ToArray();
}
}
public static mstudent[] selectStudent(string enrollmentNo)
{
using (var data = new instDataContext())
{
return(data.mstudents.Where(s => s.enrolmentno == enrollmentNo).ToArray());
}
}
public static bill[] select()
{
using (var data = new instDataContext())
{
return data.bills.ToArray();
}
}
public static malumni[] select()
{
using (var data = new instDataContext())
{
return data.malumnis.ToArray();
}
}
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();
}
}
public static mresult[] select()
{
using (var data = new instDataContext())
{
return(data.mresults.ToArray());
}
}
public static image[] select()
{
using (var data = new instDataContext())
{
return(data.images.ToArray());
}
}
public static mpassword[] select()
{
using (var data = new instDataContext())
{
return data.mpasswords.ToArray();
}
}
public static mcourse[] select()
{
using (var data = new instDataContext())
{
return(data.mcourses.ToArray());
}
}
public static mpassword[] select()
{
using (var data = new instDataContext())
{
return(data.mpasswords.ToArray());
}
}
public static mstaff[] select()
{
using (var data = new instDataContext())
{
return data.mstaffs.ToArray();
}
}
public static void insert(image r)
{
using (var data = new instDataContext())
{
data.images.InsertOnSubmit(r);
data.SubmitChanges();
}
}
public static void insert(charge m)
{
using (var data = new instDataContext())
{
data.charges.InsertOnSubmit(m);
data.SubmitChanges();
}
}
public static void insert(malumni m)
{
using (var data = new instDataContext())
{
data.malumnis.InsertOnSubmit(m);
data.SubmitChanges();
}
}
public static void insert(mresult r)
{
using (var data = new instDataContext())
{
data.mresults.InsertOnSubmit(r);
data.SubmitChanges();
}
}
public static void insert(mresult r)
{
using (var data = new instDataContext())
{
data.mresults.InsertOnSubmit(r);
data.SubmitChanges();
}
}
public static void insert(mcourse s)
{
using (var data = new instDataContext())
{
data.mcourses.InsertOnSubmit(s);
data.SubmitChanges();
}
}
public static void insert(mcourse s)
{
using (var data = new instDataContext())
{
data.mcourses.InsertOnSubmit(s);
data.SubmitChanges();
}
}
public static void insert(mstaff f)
{
using (var data = new instDataContext())
{
data.mstaffs.InsertOnSubmit(f);
data.SubmitChanges();
}
}
public static void insert(administration a)
{
using (var data = new instDataContext())
{
data.administrations.InsertOnSubmit(a);
data.SubmitChanges();
}
}
public static void insert(feedback m)
{
using (var data = new instDataContext())
{
data.feedbacks.InsertOnSubmit(m);
data.SubmitChanges();
}
}
public static void insert(charge m)
{
using (var data = new instDataContext())
{
data.charges.InsertOnSubmit(m);
data.SubmitChanges();
}
}
public static tattendance_stu[] select()
{
using (var data=new instDataContext())
{
return data.tattendance_stus.ToArray();
}
}
public static void insert(transport t)
{
using (var data = new instDataContext())
{
data.transports.InsertOnSubmit(t);
data.SubmitChanges();
}
}
public static void insert(malumni m)
{
using (var data = new instDataContext())
{
data.malumnis.InsertOnSubmit(m);
data.SubmitChanges();
}
}
public static void insert(feedback m)
{
using (var data = new instDataContext())
{
data.feedbacks.InsertOnSubmit(m);
data.SubmitChanges();
}
}
public static void insert(tsalarypaid t)
{
using (var data = new instDataContext())
{
data.tsalarypaids.InsertOnSubmit(t);
data.SubmitChanges();
}
}
public static void insert(tsalarypaid t)
{
using (var data = new instDataContext())
{
data.tsalarypaids.InsertOnSubmit(t);
data.SubmitChanges();
}
}
public static void insert(transport t)
{
using (var data = new instDataContext())
{
data.transports.InsertOnSubmit(t);
data.SubmitChanges();
}
}
public static void insert(mpassword p)
{
using (var data = new instDataContext())
{
data.mpasswords.InsertOnSubmit(p);
data.SubmitChanges();
}
}
public static void insert(mfee k)
{
using (var data = new instDataContext())
{
data.mfees.InsertOnSubmit(k);
data.SubmitChanges();
}
}
public static void insert(administration a)
{
using (var data = new instDataContext())
{
data.administrations.InsertOnSubmit(a);
data.SubmitChanges();
}
}
public static void insert(mfee k)
{
using (var data = new instDataContext())
{
data.mfees.InsertOnSubmit(k);
data.SubmitChanges();
}
}
public static void insert(tattendance_stu t)
{
using (var data = new instDataContext())
{
data.tattendance_stus.InsertOnSubmit(t);
data.SubmitChanges();
}
}
public static void insert(mstudent m)
{
using (var data = new instDataContext())
{
data.mstudents.InsertOnSubmit(m);
data.SubmitChanges();
}
}
public static void insert(image r)
{
using (var data = new instDataContext())
{
data.images.InsertOnSubmit(r);
data.SubmitChanges();
}
}
public static void insert(mpassword p)
{
using (var data = new instDataContext())
{
data.mpasswords.InsertOnSubmit(p);
data.SubmitChanges();
}
}
public static void insert(mdatesheet t)
{
using (var data = new instDataContext())
{
data.mdatesheets.InsertOnSubmit(t);
data.SubmitChanges();
}
}
public static void delete(mstaff f)
{
using (var data = new instDataContext())
{
var obj = data.mstaffs.Single(j => j.staffid == f.staffid);
data.mstaffs.DeleteOnSubmit(obj);
data.SubmitChanges();
}
}
public static void delete(transport t)
{
using (var data = new instDataContext())
{
var obj = data.transports.Single(j => j.busno==t.busno);
data.transports.DeleteOnSubmit(obj);
data.SubmitChanges();
}
}
public static void delete(mcourse s)
{
using (var data = new instDataContext())
{
var obj = data.mcourses.Single(j => j.course_id == s.course_id);
data.mcourses.DeleteOnSubmit(obj);
data.SubmitChanges();
}
}
