public string insert(AssignmentUpload up) { try { string Date = DateTime.Now.ToShortDateString(); con.Open(); string q = "insert into UploadAssignment (T_id,ClassID,LessonNo,AssignmentName,AssignmentFile,DateOfSubmission,DatabaseName) values (@T_id, @ClassID,@LessonNo,@assName,@AssignmentFile, @Date,@DatabaseName)"; SqlCommand cmd = new SqlCommand(q, con); cmd.Parameters.AddWithValue("@T_id", up.T_id); cmd.Parameters.AddWithValue("@ClassID", up.ClassID); cmd.Parameters.AddWithValue("@LessonNo", up.LessonNo); cmd.Parameters.AddWithValue("@assName", up.AssignmentName); cmd.Parameters.AddWithValue("@AssignmentFile", up.AssignmentFile); cmd.Parameters.AddWithValue("@Date", Date); cmd.Parameters.AddWithValue("@DatabaseName", up.DatabaseName); cmd.ExecuteNonQuery(); con.Close(); return("succesfull "); } catch (Exception ex) { return(ex.ToString()); } }
public List <AssignmentUpload> getListOfstudents(int lessonNo) { con.Open(); List <AssignmentUpload> stList = new List <AssignmentUpload>(); try { SqlCommand cmd = new SqlCommand("select DISTINCT UserName,LessonNo,DatabaseName from StudentAssignment where LessonNo =" + lessonNo + "", con); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { AssignmentUpload up = new AssignmentUpload(); up.UserName = sdr["UserName"].ToString(); up.LessonNo = int.Parse(sdr["LessonNo"].ToString()); up.DatabaseName = sdr["DatabaseName"].ToString(); stList.Add(up); } con.Close(); return(stList); } catch (Exception ex) { return(null); } }
public bool TeacherLogin(AssignmentUpload c) { con.Open(); string q = "select * from[fyp].[dbo].[Teacher] where T_id ='" + c.T_id + "' and U_Password='******'"; string p = q; SqlCommand cmd = new SqlCommand(q, con); SqlDataReader sdr = cmd.ExecuteReader(); if (sdr.Read()) { return(true); } else { return(false); } }
public AssignmentUpload gets(int AssignmentNO) { try { con.Open(); AssignmentUpload up = new AssignmentUpload(); SqlCommand cmd = new SqlCommand("select * from UploadAssignment where LessonNO=" + AssignmentNO + "", con); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { up.AssignmentName = sdr["AssignmentName"].ToString(); up.AssignmentFile = (byte[])sdr["AssignmentFile"]; up.ss = Convert.ToBase64String(up.AssignmentFile); up.LessonNo = int.Parse(sdr["LessonNO"].ToString()); up.AssignmentID = int.Parse(sdr["AssignmentID"].ToString()); } con.Close(); return(up); }catch (Exception ex) { return(null); } }