Exemplo n.º 1
0
        public void insertTest(Entities.personalInfo t1)
        {
            using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[insertPersonalInfo]"))
            {
                s1.AddParameter("@pKId", System.Data.SqlDbType.NVarChar, t1.pKId);
                s1.AddParameter("@firstName", System.Data.SqlDbType.NVarChar, t1.firstName);
                s1.AddParameter("@middleName", System.Data.SqlDbType.NVarChar, t1.middleName);
                s1.AddParameter("@lastName", System.Data.SqlDbType.NVarChar, t1.lastName);
                s1.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, t1.iAm);
                s1.AddParameter("@phone", System.Data.SqlDbType.NVarChar, t1.phone);
                s1.AddParameter("@emergencyContact", System.Data.SqlDbType.NVarChar, t1.emergencyContact);
                s1.AddParameter("@cellNo", System.Data.SqlDbType.NVarChar, t1.cellNo);
                s1.AddParameter("@email", System.Data.SqlDbType.NVarChar, t1.eMail);
                s1.AddParameter("@dOB", System.Data.SqlDbType.Date, t1.dOB);
                s1.AddParameter("@enrollmentdate", System.Data.SqlDbType.Date, t1.enrollmentDate);
                s1.AddParameter("@gender", System.Data.SqlDbType.Int, t1.gender);
                s1.AddParameter("@userType", System.Data.SqlDbType.NVarChar, t1.userType);
                s1.AddParameter("@isActive", System.Data.SqlDbType.Bit, t1.isActive);
                s1.AddParameter("@isNew", System.Data.SqlDbType.Bit, t1.isNew);
                s1.AddParameter("@passCode", System.Data.SqlDbType.NVarChar, t1.passCode);
                s1.AddParameter("@address1", System.Data.SqlDbType.NVarChar, t1.address1);
                s1.AddParameter("@address2", System.Data.SqlDbType.NVarChar, t1.address2);
                s1.AddParameter("@address3", System.Data.SqlDbType.NVarChar, t1.address3);
                s1.AddParameter("@fileName", System.Data.SqlDbType.NVarChar, t1.fileName);
                s1.AddParameter("@recordFile", System.Data.SqlDbType.VarBinary, t1.recordFile);

                s1.Execute();
            }
        }
Exemplo n.º 2
0
 public void InsertSection(Entities.Section c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertSectionName]"))
     {
         s1.AddParameter("@sectionName ", System.Data.SqlDbType.NVarChar, c1.sectionName);
         s1.Execute();
     }
 }
Exemplo n.º 3
0
 public void AddCourse(Entities.Subjects c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAddSubject]"))
     {
         s1.AddParameter("@subjectId", System.Data.SqlDbType.NVarChar, c1.subjectId);
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, c1.subjectName);
         s1.Execute();
     }
 }
 public void AddExamypes(Entities.ExamType e1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertExamType]"))
     {
         s1.AddParameter("@examTypeId", System.Data.SqlDbType.NVarChar, e1.examTypeId);
         s1.AddParameter("@examType", System.Data.SqlDbType.NVarChar, e1.examType);
         s1.Execute();
     }
 }
Exemplo n.º 5
0
 public void InsertNote(Entities.Announcement c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertAnnouncement]"))
     {
         s1.AddParameter("@iam", System.Data.SqlDbType.NVarChar, c1.createdBy);
         s1.AddParameter("@note", System.Data.SqlDbType.NVarChar, c1.note);
         s1.Execute();
     }
 }
Exemplo n.º 6
0
 public void AddExamypes(Entities.ExamType e1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertExamType]"))
     {
         s1.AddParameter("@examTypeId", System.Data.SqlDbType.NVarChar, e1.examTypeId);
         s1.AddParameter("@examType", System.Data.SqlDbType.NVarChar, e1.examType);
         s1.Execute();
     }
 }
Exemplo n.º 7
0
 public void InsertClass(Entities.Class c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertClass]"))
     {
         s1.AddParameter("@classId", System.Data.SqlDbType.NVarChar, c1.classId);
         s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c1.className);
         s1.Execute();
     }
 }
 public void AddCourse(Entities.Subjects c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAddSubject]"))
     {
         s1.AddParameter("@subjectId", System.Data.SqlDbType.NVarChar, c1.subjectId);
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, c1.subjectName);
         s1.Execute();
     }
 }
Exemplo n.º 9
0
 public void GenerateSurvey(Entities.SurveyQuestion c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAddSurveyQuestions]"))
     {
         s1.AddParameter("@surveyId", System.Data.SqlDbType.Int, c1.surveyId);
         s1.AddParameter("@questionId", System.Data.SqlDbType.Int, c1.questionId);
         s1.AddParameter("@question", System.Data.SqlDbType.NVarChar, c1.question);
         s1.Execute();
     }
 }
Exemplo n.º 10
0
 public void InsertStudentGrade(Entities.StudentSubject c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertGrade]"))
     {
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, c1.subjectName);
         s1.AddParameter("@student", System.Data.SqlDbType.NVarChar, c1.pKId);
         s1.AddParameter("@grade", System.Data.SqlDbType.NVarChar, c1.grade);
         s1.Execute();
     }
 }
Exemplo n.º 11
0
 public void InsertCampusClassSection(Entities.CampusClassSection c1, Entities.personalInfo p1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertSectionClass]"))
     {
         s1.AddParameter("@pkid", System.Data.SqlDbType.NVarChar, p1.pKId);
         s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c1.className);
         s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, c1.sectionName);
         s1.Execute();
     }
 }
Exemplo n.º 12
0
 public void InsertTeacherAttendance(Entities.TAttendance c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertTeacherAttendance]"))
     {
         s1.AddParameter("@pKId", System.Data.SqlDbType.NVarChar, c1.pKId);
         s1.AddParameter("@date", System.Data.SqlDbType.Date, c1.date);
         s1.AddParameter("@attendance ", System.Data.SqlDbType.Bit, c1.attendance);
         s1.Execute();
     }
 }
Exemplo n.º 13
0
 public void InsertSurveyResponse(Entities.SurveyReply c1, Entities.Survey c2)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertSurveyResponse]"))
     {
         s1.AddParameter("@surveyId", System.Data.SqlDbType.Int, c1.surveyId);
         s1.AddParameter("@repliedBy", System.Data.SqlDbType.NVarChar, c1.repliedBy);
         s1.AddParameter("@replyDate", System.Data.SqlDbType.Date, c2.surveyDate);
         s1.Execute();
     }
 }
Exemplo n.º 14
0
 public void SurveyReply(Entities.SurveyReply c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spSurveyReply]"))
     {
         s1.AddParameter("@survey", System.Data.SqlDbType.Int, c1.surveyId);
         s1.AddParameter("@questionId", System.Data.SqlDbType.Int, c1.questionId);
         s1.AddParameter("@answer", System.Data.SqlDbType.Int, c1.answer);
         s1.AddParameter("@repliedBy", System.Data.SqlDbType.NVarChar, c1.repliedBy);
         s1.Execute();
     }
 }
Exemplo n.º 15
0
        public DataSet ShowSurvey(Entities.SurveyQuestion q1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spShowQuestions]"))
            {
                dbCom.AddParameter("@surveyId", System.Data.SqlDbType.Int, q1.surveyId);
                ds = new DataSet();
                ds = dbCom.Execute();
            }
            return(ds);
        }
Exemplo n.º 16
0
 public void AssignCourses(Entities.Section s3, Entities.personalInfo p1, Entities.personalInfo p2, Entities.Class c1, Entities.Subjects s2)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAssignTeacher]"))
     {
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, s2.subjectName);
         s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, s3.sectionName);
         s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c1.className);
         s1.AddParameter("@iAm ", System.Data.SqlDbType.NVarChar, p1.pKId);
         s1.AddParameter("@pKId", System.Data.SqlDbType.NVarChar, p2.pKId);
         s1.Execute();
     }
 }
Exemplo n.º 17
0
 public void AddStudentExam(Entities.StudentExam c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAddStudentMarks]"))
     {
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, c1.subjectName);
         s1.AddParameter("@examDate", System.Data.SqlDbType.Date, c1.examDate);
         s1.AddParameter("@obtainedMarks", System.Data.SqlDbType.Real, c1.obtainedMarks);
         s1.AddParameter("@ispresent", System.Data.SqlDbType.Bit, c1.isPresent);
         s1.AddParameter("@pkid", System.Data.SqlDbType.NVarChar, c1.pKId);
         s1.Execute();
     }
 }
Exemplo n.º 18
0
 public void InsertStudentAttendance(Entities.SAttendance a1, Entities.Subjects c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertStudentAttendance]"))
     {
         s1.AddParameter("@pkid", System.Data.SqlDbType.NVarChar, a1.pKId);
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, c1.subjectName);
         s1.AddParameter("@Sdate", System.Data.SqlDbType.Date, a1.Sdate);
         s1.AddParameter("@attendance", System.Data.SqlDbType.Bit, a1.attendance);
         s1.AddParameter("@smilies", System.Data.SqlDbType.Bit, a1.smilies);
         s1.Execute();
     }
 }
Exemplo n.º 19
0
        public DataSet ShowStudentClass(Entities.personalInfo p1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spSelectStudent]"))
            {
                dbCom.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, p1.pKId);
                ds = new DataSet();
                ds = dbCom.Execute();
            }
            return(ds);
        }
Exemplo n.º 20
0
 public void AssignStudentClass(Entities.personalInfo p1, Entities.StudentSubject p2, Entities.Class c1, Entities.Section ss1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAssignClassSection]"))
     {
         s1.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, p1.pKId);
         s1.AddParameter("@studentId", System.Data.SqlDbType.NVarChar, p2.pKId);
         s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c1.className);
         s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, ss1.sectionName);
         s1.AddParameter("@year", System.Data.SqlDbType.NVarChar, p2.year);
         s1.Execute();
     }
 }
Exemplo n.º 21
0
        public DataSet CountSmiles(Entities.personalInfo p1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spShowCMAttandus]"))
            {
                dbCom.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, p1.pKId);
                ds = new DataSet();
                ds = dbCom.Execute();
            }
            return(ds);
        }
Exemplo n.º 22
0
        public DataSet CheckUserType(Entities.tblSchoolId p1, Entities.Campus c1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spSelectUserType]"))
            {
                dbCom.AddParameter("@ID", System.Data.SqlDbType.NVarChar, p1.schoolId);
                dbCom.AddParameter("@campus", System.Data.SqlDbType.NVarChar, c1.campusName);
                ds = new DataSet();
                ds = dbCom.Execute();
            }
            return(ds);
        }
Exemplo n.º 23
0
 public void AddEvaluation(Entities.Recommendations r1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertEvaluation]"))
     {
         s1.AddParameter("@studentId", System.Data.SqlDbType.NVarChar, r1.studentId);
         s1.AddParameter("@teacher", System.Data.SqlDbType.NVarChar, r1.teacher);
         s1.AddParameter("@Adate", System.Data.SqlDbType.Date, r1.Adate);
         s1.AddParameter("@appitude", System.Data.SqlDbType.NVarChar, r1.appitude);
         s1.AddParameter("@attitude", System.Data.SqlDbType.NVarChar, r1.attitude);
         s1.AddParameter("@recommendation", System.Data.SqlDbType.NVarChar, r1.recommendation);
         s1.Execute();
     }
 }
Exemplo n.º 24
0
        public DataSet SelectTicket(Entities.Tickets c1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spSelectIssue]"))
            {
                dbCom.AddParameter("@issueId", SqlDbType.Int, c1.issueId);

                ds = new DataSet();
                ds = dbCom.Execute();
            }
            return(ds);
        }
Exemplo n.º 25
0
 public void AddTicket(Entities.Tickets c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertNewIssue]"))
     {
         s1.AddParameter("@generatedBy", System.Data.SqlDbType.NVarChar, c1.generatedBy);
         s1.AddParameter("@generatedFor", System.Data.SqlDbType.NVarChar, c1.generatedFor);
         s1.AddParameter("@issue", System.Data.SqlDbType.NVarChar, c1.issue);
         s1.AddParameter("@linkedWith", System.Data.SqlDbType.Int, c1.linkedWith);
         s1.AddParameter("@issueDate", System.Data.SqlDbType.Date, c1.issueDate);
         s1.AddParameter("@isNew", System.Data.SqlDbType.Bit, c1.isNew);
         s1.Execute();
     }
 }
 public void AddEvaluation(Entities.Recommendations r1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertEvaluation]"))
     {
         s1.AddParameter("@studentId", System.Data.SqlDbType.NVarChar, r1.studentId);
         s1.AddParameter("@teacher", System.Data.SqlDbType.NVarChar, r1.teacher);
         s1.AddParameter("@Adate", System.Data.SqlDbType.Date, r1.Adate);
         s1.AddParameter("@appitude", System.Data.SqlDbType.NVarChar, r1.appitude);
         s1.AddParameter("@attitude", System.Data.SqlDbType.NVarChar, r1.attitude);
         s1.AddParameter("@recommendation", System.Data.SqlDbType.NVarChar, r1.recommendation);
         s1.Execute();
     }
 }
Exemplo n.º 27
0
 public void AddExamDate(Entities.ExamDate c1, Entities.Subjects s2, Entities.Section s3, Entities.Class c2, Entities.personalInfo p1, Entities.ExamType e1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertExamDate]"))
     {
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, s2.subjectName);
         s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, s3.sectionName);
         s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c2.className);
         s1.AddParameter("@examTypeId", System.Data.SqlDbType.NVarChar, e1.examTypeId);
         s1.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, p1.pKId);
         s1.AddParameter("@examDate", System.Data.SqlDbType.Date, c1.examDate);
         s1.AddParameter("@totalMarks", System.Data.SqlDbType.Int, c1.totalMarks);
         s1.Execute();
     }
 }
Exemplo n.º 28
0
 public void CoursePlan(Entities.CoursePlan c1, Entities.Subjects s2, Entities.Section s3, Entities.Class c2, Entities.personalInfo p1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertCourseProgress]"))
     {
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, s2.subjectName);
         s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, s3.sectionName);
         s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c2.className);
         s1.AddParameter("@pKId", System.Data.SqlDbType.NVarChar, p1.pKId);
         s1.AddParameter("@progressId", System.Data.SqlDbType.Int, c1.progressId);
         s1.AddParameter("@year", System.Data.SqlDbType.NVarChar, c1.year);
         s1.AddParameter("@goal", System.Data.SqlDbType.NVarChar, c1.Goal);
         s1.Execute();
     }
 }
 public void AddExamDate(Entities.ExamDate c1, Entities.Subjects s2, Entities.Section s3, Entities.Class c2, Entities.personalInfo p1,Entities.ExamType e1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertExamDate]"))
     {
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, s2.subjectName);
         s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, s3.sectionName);
         s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c2.className);
         s1.AddParameter("@examTypeId", System.Data.SqlDbType.NVarChar, e1.examTypeId);
         s1.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, p1.pKId);
         s1.AddParameter("@examDate", System.Data.SqlDbType.Date, c1.examDate);
         s1.AddParameter("@totalMarks", System.Data.SqlDbType.Int, c1.totalMarks);
         s1.Execute();
     }
 }
Exemplo n.º 30
0
        public DataSet Graph(Entities.StudentExam c1, Entities.Class c2, Entities.ExamType e1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spSelectStudentMarks]"))
            {
                dbCom.AddParameter("@studentId", SqlDbType.NVarChar, c1.pKId);
                dbCom.AddParameter("@className", SqlDbType.NVarChar, c2.className);
                dbCom.AddParameter("@examType", SqlDbType.NVarChar, e1.examType);

                ds = new DataSet();
                ds = dbCom.Execute();
            }
            return(ds);
        }
Exemplo n.º 31
0
        public DataSet SelectClassSection(Entities.CampusClassSection c1, Entities.personalInfo p1)
        {
            DataSet ds;

            using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spSelectCampusDetails]"))
            {
                s1.AddParameter("@pKId", System.Data.SqlDbType.NVarChar, p1.pKId);
                s1.AddParameter("@campusId", System.Data.SqlDbType.Int, c1.campusId);
                s1.AddParameter("@sectionId", System.Data.SqlDbType.Int, c1.sectionName);
                s1.AddParameter("@classId", System.Data.SqlDbType.NVarChar, c1.className);
                ds = new DataSet();
                ds = s1.Execute();
            }
            return(ds);
        }
 public void AddNotes(Entities.Notes c1, Entities.Subjects s2, Entities.Section s3, Entities.Class c2)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAddNotes]"))
     {
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, s2.subjectName);
         s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, s3.sectionName);
         s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c2.className);
         s1.AddParameter("@teacher", System.Data.SqlDbType.NVarChar, c1.teacher);
         s1.AddParameter("@noteType", System.Data.SqlDbType.NVarChar, c1.noteType);
         s1.AddParameter("@assignDate", System.Data.SqlDbType.Date, c1.date);
         s1.AddParameter("@fileName", System.Data.SqlDbType.NVarChar, c1.fileName);
         s1.AddParameter("@dataFile", System.Data.SqlDbType.VarBinary, c1.dataFile);
         s1.AddParameter("@description", System.Data.SqlDbType.NVarChar, c1.description);
         s1.Execute();
     }
 }
Exemplo n.º 33
0
 public void AddNotes(Entities.Notes c1, Entities.Subjects s2, Entities.Section s3, Entities.Class c2)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAddNotes]"))
     {
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, s2.subjectName);
         s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, s3.sectionName);
         s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c2.className);
         s1.AddParameter("@teacher", System.Data.SqlDbType.NVarChar, c1.teacher);
         s1.AddParameter("@noteType", System.Data.SqlDbType.NVarChar, c1.noteType);
         s1.AddParameter("@assignDate", System.Data.SqlDbType.Date, c1.date);
         s1.AddParameter("@fileName", System.Data.SqlDbType.NVarChar, c1.fileName);
         s1.AddParameter("@dataFile", System.Data.SqlDbType.VarBinary, c1.dataFile);
         s1.AddParameter("@description", System.Data.SqlDbType.NVarChar, c1.description);
         s1.Execute();
     }
 }
Exemplo n.º 34
0
        public DataSet ShowSubNotes(Entities.Notes q1, Entities.personalInfo p1, Entities.Class c1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spShowSubNotes]"))
            {
                dbCom.AddParameter("@iam", System.Data.SqlDbType.NVarChar, p1.pKId);
                dbCom.AddParameter("@className", System.Data.SqlDbType.NVarChar, c1.className);
                dbCom.AddParameter("@noteType", System.Data.SqlDbType.NVarChar, q1.noteType);
                dbCom.AddParameter("@minDate", System.Data.SqlDbType.Date, q1.date);
                dbCom.AddParameter("@maxDate", System.Data.SqlDbType.Date, q1.date);
                ds = new DataSet();
                ds = dbCom.Execute();
            }
            return(ds);
        }
Exemplo n.º 35
0
 public void InsertBranch(Entities.Campus c1, Entities.ZipCodes z1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertBranch]"))
     {
         s1.AddParameter("@campusName", System.Data.SqlDbType.NVarChar, c1.campusName);
         s1.AddParameter("@address", System.Data.SqlDbType.NVarChar, c1.address);
         s1.AddParameter("@zipCode", System.Data.SqlDbType.Int, c1.zipCode);
         s1.AddParameter("@phone1", System.Data.SqlDbType.NVarChar, c1.phone1);
         s1.AddParameter("@phone2", System.Data.SqlDbType.NVarChar, c1.phone2);
         s1.AddParameter("@phone3", System.Data.SqlDbType.NVarChar, c1.phone3);
         s1.AddParameter("@principal", System.Data.SqlDbType.NVarChar, c1.principal);
         s1.AddParameter("@cityName", System.Data.SqlDbType.NVarChar, z1.cityName);
         s1.AddParameter("@email", System.Data.SqlDbType.NVarChar, c1.email);
         s1.AddParameter("@isActive", System.Data.SqlDbType.Bit, c1.isActive);
         s1.Execute();
     }
 }
 public DataSet SelectClassSection(Entities.CampusClassSection c1, Entities.personalInfo p1)
 {
     DataSet ds;
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spSelectCampusDetails]"))
     {
         s1.AddParameter("@pKId", System.Data.SqlDbType.NVarChar, p1.pKId);
         s1.AddParameter("@campusId", System.Data.SqlDbType.Int, c1.campusId);
         s1.AddParameter("@sectionId", System.Data.SqlDbType.Int, c1.sectionName);
         s1.AddParameter("@classId", System.Data.SqlDbType.NVarChar, c1.className);
         ds = new DataSet();
         ds = s1.Execute();
     }
         return ds;
 }
 public void InsertStudentAttendance(Entities.SAttendance a1, Entities.Subjects c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertStudentAttendance]"))
     {
         s1.AddParameter("@pkid", System.Data.SqlDbType.NVarChar, a1.pKId);
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, c1.subjectName);
         s1.AddParameter("@Sdate", System.Data.SqlDbType.Date, a1.Sdate);
         s1.AddParameter("@attendance", System.Data.SqlDbType.Bit, a1.attendance);
         s1.AddParameter("@smilies", System.Data.SqlDbType.Bit, a1.smilies);
         s1.Execute();
     }
 }
 public void InsertTeacherAttendance(Entities.TAttendance c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertTeacherAttendance]"))
     {
         s1.AddParameter("@pKId", System.Data.SqlDbType.NVarChar, c1.pKId);
         s1.AddParameter("@date", System.Data.SqlDbType.Date, c1.date);
         s1.AddParameter("@attendance ", System.Data.SqlDbType.Bit, c1.attendance);
         s1.Execute();
     }
 }
        public void insertTest(Entities.personalInfo t1)
        {
            using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[insertPersonalInfo]"))
             {
             s1.AddParameter("@pKId", System.Data.SqlDbType.NVarChar, t1.pKId);
             s1.AddParameter("@firstName", System.Data.SqlDbType.NVarChar, t1.firstName);
             s1.AddParameter("@middleName", System.Data.SqlDbType.NVarChar, t1.middleName);
             s1.AddParameter("@lastName", System.Data.SqlDbType.NVarChar, t1.lastName);
             s1.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, t1.iAm);
             s1.AddParameter("@phone", System.Data.SqlDbType.NVarChar, t1.phone);
             s1.AddParameter("@emergencyContact", System.Data.SqlDbType.NVarChar, t1.emergencyContact);
             s1.AddParameter("@cellNo", System.Data.SqlDbType.NVarChar, t1.cellNo);
             s1.AddParameter("@email", System.Data.SqlDbType.NVarChar, t1.eMail);
             s1.AddParameter("@dOB", System.Data.SqlDbType.Date, t1.dOB);
             s1.AddParameter("@enrollmentdate", System.Data.SqlDbType.Date, t1.enrollmentDate);
             s1.AddParameter("@gender", System.Data.SqlDbType.Int, t1.gender);
             s1.AddParameter("@userType", System.Data.SqlDbType.NVarChar, t1.userType);
             s1.AddParameter("@isActive", System.Data.SqlDbType.Bit, t1.isActive);
             s1.AddParameter("@isNew", System.Data.SqlDbType.Bit, t1.isNew);
             s1.AddParameter("@passCode", System.Data.SqlDbType.NVarChar, t1.passCode);
             s1.AddParameter("@address1", System.Data.SqlDbType.NVarChar, t1.address1);
             s1.AddParameter("@address2", System.Data.SqlDbType.NVarChar, t1.address2);
             s1.AddParameter("@address3", System.Data.SqlDbType.NVarChar, t1.address3);
             s1.AddParameter("@fileName", System.Data.SqlDbType.NVarChar, t1.fileName);
             s1.AddParameter("@recordFile", System.Data.SqlDbType.VarBinary, t1.recordFile);

             s1.Execute();

            }
        }
        public DataSet CountSmiles(Entities.personalInfo p1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spShowCMAttandus]"))
            {
                dbCom.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, p1.pKId);
                ds = new DataSet();
                ds = dbCom.Execute();

            }
            return ds;
        }
        public void InsertSurveyResponse(Entities.SurveyReply c1 ,Entities.Survey c2)
        {
            using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertSurveyResponse]"))
            {

                s1.AddParameter("@surveyId", System.Data.SqlDbType.Int, c1.surveyId);
                s1.AddParameter("@repliedBy", System.Data.SqlDbType.NVarChar, c1.repliedBy);
                s1.AddParameter("@replyDate", System.Data.SqlDbType.Date, c2.surveyDate);
                s1.Execute();
            }
        }
        public DataSet ShowStudentClass(Entities.personalInfo p1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spSelectStudent]"))
            {
                dbCom.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, p1.pKId);
                ds = new DataSet();
                ds = dbCom.Execute();

            }
            return ds;
        }
        public void GenerateSurvey(Entities.SurveyQuestion c1)
        {
            using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAddSurveyQuestions]"))
            {

                s1.AddParameter("@surveyId", System.Data.SqlDbType.Int, c1.surveyId);
                s1.AddParameter("@questionId", System.Data.SqlDbType.Int, c1.questionId);
                s1.AddParameter("@question", System.Data.SqlDbType.NVarChar, c1.question);
                s1.Execute();
            }
        }
        public void InsertSection(Entities.Section c1)
        {
            using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertSectionName]"))
            {
                s1.AddParameter("@sectionName ", System.Data.SqlDbType.NVarChar, c1.sectionName);
                s1.Execute();

            }
        }
        public DataSet SelectTicket(Entities.Tickets c1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spSelectIssue]"))
            {
                dbCom.AddParameter("@issueId", SqlDbType.Int, c1.issueId);

                ds = new DataSet();
                ds = dbCom.Execute();
            }
            return ds;
        }
        public void InsertNote(Entities.Announcement c1)
        {
            using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertAnnouncement]"))
            {

                s1.AddParameter("@iam", System.Data.SqlDbType.NVarChar, c1.createdBy);
                s1.AddParameter("@note", System.Data.SqlDbType.NVarChar, c1.note);
                s1.Execute();
            }
        }
        public void InsertClass(Entities.Class c1)
        {
            using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertClass]"))
            {

                s1.AddParameter("@classId", System.Data.SqlDbType.NVarChar, c1.classId);
                s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c1.className);
                s1.Execute();

            }
        }
        public void InsertCampusClassSection(Entities.CampusClassSection c1,Entities.personalInfo p1)
        {
            using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertSectionClass]"))
            {
                s1.AddParameter("@pkid", System.Data.SqlDbType.NVarChar, p1.pKId);
                s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c1.className);
                s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, c1.sectionName);
                s1.Execute();

            }
        }
        public void InsertBranch(Entities.Campus c1,Entities.ZipCodes z1)
        {
            using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertBranch]"))
            {

                s1.AddParameter("@campusName", System.Data.SqlDbType.NVarChar, c1.campusName);
                s1.AddParameter("@address", System.Data.SqlDbType.NVarChar, c1.address);
                s1.AddParameter("@zipCode", System.Data.SqlDbType.Int, c1.zipCode);
                s1.AddParameter("@phone1", System.Data.SqlDbType.NVarChar, c1.phone1);
                s1.AddParameter("@phone2", System.Data.SqlDbType.NVarChar, c1.phone2);
                s1.AddParameter("@phone3", System.Data.SqlDbType.NVarChar, c1.phone3);
                s1.AddParameter("@principal", System.Data.SqlDbType.NVarChar, c1.principal);
                s1.AddParameter("@cityName", System.Data.SqlDbType.NVarChar, z1.cityName);
                s1.AddParameter("@email", System.Data.SqlDbType.NVarChar, c1.email);
                s1.AddParameter("@isActive", System.Data.SqlDbType.Bit, c1.isActive);
                s1.Execute();

            }
        }
        public DataSet Graph(Entities.StudentExam c1,Entities.Class c2,Entities.ExamType e1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spSelectStudentMarks]"))
            {
                dbCom.AddParameter("@studentId", SqlDbType.NVarChar, c1.pKId);
                dbCom.AddParameter("@className", SqlDbType.NVarChar, c2.className);
                dbCom.AddParameter("@examType", SqlDbType.NVarChar, e1.examType);

                ds = new DataSet();
                ds = dbCom.Execute();
            }
            return ds;
        }
        public DataSet ShowStudentAttendacne(Entities.personalInfo p1, Entities.SAttendance s1, Entities.Subjects s2)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spShowAttandus]"))
            {
                dbCom.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, p1.pKId);
                dbCom.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, s2.subjectName);
                dbCom.AddParameter("@month", System.Data.SqlDbType.NVarChar, s1.Sdate);
                dbCom.AddOutputParameter("@smilies", System.Data.SqlDbType.Int);
                dbCom.AddOutputParameter("@sad", System.Data.SqlDbType.Int);
                dbCom.AddOutputParameter("@presents", System.Data.SqlDbType.Int);
                dbCom.AddOutputParameter("@absents", System.Data.SqlDbType.Int);
                ds = new DataSet();
                ds = dbCom.Execute();

            }
            return ds;
        }
        public DataSet ShowSurvey(Entities.SurveyQuestion q1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spShowQuestions]"))
            {
                dbCom.AddParameter("@surveyId", System.Data.SqlDbType.Int, q1.surveyId);
                ds = new DataSet();
                ds = dbCom.Execute();

            }
            return ds;
        }
        public DataSet ShowSubNotes(Entities.Notes q1,Entities.personalInfo p1,Entities.Class c1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spShowSubNotes]"))
            {
                dbCom.AddParameter("@iam", System.Data.SqlDbType.NVarChar, p1.pKId);
                dbCom.AddParameter("@className", System.Data.SqlDbType.NVarChar, c1.className);
                dbCom.AddParameter("@noteType", System.Data.SqlDbType.NVarChar, q1.noteType);
                dbCom.AddParameter("@minDate", System.Data.SqlDbType.Date, q1.date);
                dbCom.AddParameter("@maxDate", System.Data.SqlDbType.Date, q1.date);
                ds = new DataSet();
                ds = dbCom.Execute();

            }
            return ds;
        }
 public void CoursePlan(Entities.CoursePlan c1, Entities.Subjects s2, Entities.Section s3, Entities.Class c2, Entities.personalInfo p1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertCourseProgress]"))
     {
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, s2.subjectName);
         s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, s3.sectionName);
         s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c2.className);
         s1.AddParameter("@pKId", System.Data.SqlDbType.NVarChar, p1.pKId);
         s1.AddParameter("@progressId", System.Data.SqlDbType.Int, c1.progressId);
         s1.AddParameter("@year", System.Data.SqlDbType.NVarChar, c1.year);
         s1.AddParameter("@goal", System.Data.SqlDbType.NVarChar, c1.Goal);
         s1.Execute();
     }
 }
        public void SurveyReply(Entities.SurveyReply c1)
        {
            using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spSurveyReply]"))
            {

                s1.AddParameter("@survey", System.Data.SqlDbType.Int, c1.surveyId);
                s1.AddParameter("@questionId", System.Data.SqlDbType.Int, c1.questionId);
                s1.AddParameter("@answer", System.Data.SqlDbType.Int, c1.answer);
                s1.AddParameter("@repliedBy", System.Data.SqlDbType.NVarChar, c1.repliedBy);
                s1.Execute();
            }
        }
        public void InsertStudentGrade(Entities.StudentSubject c1)
        {
            using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertGrade]"))
            {

                s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, c1.subjectName);
                s1.AddParameter("@student", System.Data.SqlDbType.NVarChar, c1.pKId);
                s1.AddParameter("@grade", System.Data.SqlDbType.NVarChar, c1.grade);
                s1.Execute();
            }
        }
        public DataSet CheckUserType(Entities.tblSchoolId p1, Entities.Campus c1)
        {
            DataSet ds;

            using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spSelectUserType]"))
            {
                dbCom.AddParameter("@ID", System.Data.SqlDbType.NVarChar, p1.schoolId);
                dbCom.AddParameter("@campus", System.Data.SqlDbType.NVarChar, c1.campusName);
                ds = new DataSet();
                ds = dbCom.Execute();

            }
            return ds;
        }
        public int InsertSurvey(Entities.Survey c1)
        {
            int temp1;
            using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAddSurvey]"))
            {

                SqlParameter temp = s1.AddOutputParameter("@surveyId", System.Data.SqlDbType.Int);
                s1.AddParameter("@surveyName", System.Data.SqlDbType.NVarChar, c1.surveyName);
                s1.AddParameter("@surveyDate", System.Data.SqlDbType.Date, c1.surveyDate);
                s1.AddParameter("@generatedBy", System.Data.SqlDbType.NVarChar, c1.surveyGeneratedBy);
                s1.AddParameter("@generatedFor", System.Data.SqlDbType.NVarChar, c1.surveyGeneratedFor);
                s1.AddParameter("@type", System.Data.SqlDbType.Int, c1.type);
                s1.AddParameter("@isActive", System.Data.SqlDbType.Bit, c1.isActive);
                s1.Execute();
                temp1=int.Parse(temp.Value.ToString());
            }

            return temp1;
        }
 public void AddStudentExam(Entities.StudentExam c1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAddStudentMarks]"))
     {
         s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, c1.subjectName);
         s1.AddParameter("@examDate", System.Data.SqlDbType.Date, c1.examDate);
         s1.AddParameter("@obtainedMarks", System.Data.SqlDbType.Real, c1.obtainedMarks);
         s1.AddParameter("@ispresent", System.Data.SqlDbType.Bit, c1.isPresent);
         s1.AddParameter("@pkid", System.Data.SqlDbType.NVarChar, c1.pKId);
         s1.Execute();
     }
 }
 public void AssignStudentClass(Entities.personalInfo p1, Entities.StudentSubject p2, Entities.Class c1, Entities.Section ss1)
 {
     using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAssignClassSection]"))
     {
         s1.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, p1.pKId);
         s1.AddParameter("@studentId", System.Data.SqlDbType.NVarChar, p2.pKId);
         s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c1.className);
         s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, ss1.sectionName);
         s1.AddParameter("@year", System.Data.SqlDbType.NVarChar, p2.year);
         s1.Execute();
     }
 }