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