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