//insert assignment
public int insertAssignment(Assignments assignment, DateTime startdate, int schoolid, int id)
{
open();
SqlCommand cmd = new SqlCommand("IDU_Assignment", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "INSERT");
cmd.Parameters.AddWithValue("@name", assignment.name);
cmd.Parameters.AddWithValue("@resources", assignment.resources);
cmd.Parameters.AddWithValue("@description", assignment.description);
cmd.Parameters.AddWithValue("@startdate", startdate);
cmd.Parameters.AddWithValue("@enddate", assignment.enddate);
cmd.Parameters.AddWithValue("@schoolid", schoolid);
cmd.Parameters.AddWithValue("@teacherid", id);
if (assignment.Question1 == null)
{
assignment.Question1 = "None";
}
if (assignment.Question2 == null)
{
assignment.Question2 = "None";
}
if (assignment.Question3 == null)
{
assignment.Question3 = "None";
}
if (assignment.Question4 == null)
{
assignment.Question4 = "None";
}
if (assignment.Question5 == null)
{
assignment.Question5 = "None";
}
cmd.Parameters.AddWithValue("@question1", assignment.Question1);
cmd.Parameters.AddWithValue("@question2", assignment.Question2);
cmd.Parameters.AddWithValue("@question3", assignment.Question3);
cmd.Parameters.AddWithValue("@question4", assignment.Question4);
cmd.Parameters.AddWithValue("@question5", assignment.Question5);
int res = 0;
res = cmd.ExecuteNonQuery();
return(res);
close();
}
// all assign assignment
public IEnumerable <Assignments> Displayassignment(int schoolid, int userid)
{
open();
string query = "select assignment.*,assignmentStd.* from assignments AS assignment inner join assignmentsStudentList as assignmentStd on assignment.id = assignmentStd.assignmentid where assignmentStd.studentid=" + userid;
List <Assignments> assignments = new List <Assignments>();
SqlCommand cmd = new SqlCommand(query, con);
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var assignment = new Assignments {
id = dr.GetInt32(0), name = dr.GetString(1), startdate = dr.GetDateTime(2), enddate = dr.GetDateTime(3), resources = dr.GetString(8), description = dr.GetString(6), Question1 = dr.GetString(9), Question2 = dr.GetString(10), Question3 = dr.GetString(11), Question4 = dr.GetString(12), Question5 = dr.GetString(13)
};
assignments.Add(assignment);
}
}
return(assignments);
close();
}
//get assignmnet
public IEnumerable <Assignments> displayassignment(int schoolid, int id)
{
open();
string query;
query = "select * from assignments where schoolid=" + schoolid + " and teacherid=" + id;
List <Assignments> lstassignment = new List <Assignments>();
SqlCommand cmd = new SqlCommand(query, con);
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var assignment = new Assignments {
id = dr.GetInt32(0), name = dr.GetString(1), startdate = dr.GetDateTime(2), enddate = dr.GetDateTime(3), Question1 = dr.GetString(9), Question2 = dr.GetString(10), Question3 = dr.GetString(11), Question4 = dr.GetString(12), Question5 = dr.GetString(13)
};
lstassignment.Add(assignment);
}
}
return(lstassignment);
close();
}