public static int Add(StudentDocuments studentDocuments)
{
int retvalue = -1;
try
{
studentDocuments.DocumentUrls_Id = DocumentUrls.Add(studentDocuments.DocumentUrls);
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.CommandText = "procStudentDocuments_AddStudentDocuments";
db.cmd.Parameters.AddWithValue("@Student_ID", studentDocuments.StudentsId);
db.cmd.Parameters.AddWithValue("@DocumentUrl_ID", studentDocuments.DocumentUrls_Id);
db.cmd.Parameters.Add("@id", SqlDbType.Int);
db.cmd.Parameters["@id"].Direction = ParameterDirection.Output;
db.con.Open();
db.cmd.ExecuteNonQuery();
retvalue = Convert.ToInt32(db.cmd.Parameters["@id"].Value);
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.CloseDb(db.con, db.cmd);
}
return(retvalue);
}
public static void Update(int id, StudentDocuments studoc)
{
try
{
db.cmd.CommandText = @" update tblStudentDocuments set Student_ID = @studentid,
DocumentUrl_ID=@docurlid
where Id=@id;";
db.cmd.Parameters.AddWithValue("@studentid", studoc.StudentsId);
db.cmd.Parameters.AddWithValue("@docurlid", studoc.DocumentUrls_Id);
db.cmd.Parameters.AddWithValue("@id", id);
db.con.Open();
db.cmd.ExecuteNonQuery();
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.CloseDb(db.con, db.cmd);
}
}
public static int Add(StudentDocuments studentDocuments, DocumentUrls documentsUrl)
{
int retvalue = -1;
studentDocuments.DocumentUrls_Id = DocumentUrls.Add(documentsUrl);
retvalue = StudentDocuments.Add(studentDocuments);
return(retvalue);
}
private static List <StudentDocuments> _GetStudentDocuments()
{
List <StudentDocuments> StudentDocuments = new List <StudentDocuments>();
try
{
Command = "select * from tblStudentDocuments";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
StudentDocuments singleStudentDocuments = new StudentDocuments();
singleStudentDocuments.Id = (int)rdr[0];
singleStudentDocuments.StudentsId = (int)rdr[1];
singleStudentDocuments.DocumentUrls_Id = (int)rdr[2];
singleStudentDocuments.Students = Students.
ListOfStudents.
SingleOrDefault(s => s.Id == singleStudentDocuments.StudentsId);
singleStudentDocuments.DocumentUrls = DocumentUrls.
ListOfDocumentUrls.
SingleOrDefault(u => u.Id == singleStudentDocuments.DocumentUrls_Id);
StudentDocuments.Add(singleStudentDocuments);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(StudentDocuments);
}
