Exemple #1
0
        // GET: Exam/Edit/5
        public ActionResult Edit()
        {
            Exam.Models.Exam ex  = new Models.Exam();
            SqlConnection    con = new SqlConnection();

            con.ConnectionString = @"Data Source=(localdb)\MsSqlLocalDb;Initial Catalog=Exam;Integrated Security=True;Pooling=False";
            con.Open();
            SqlCommand cmd = new SqlCommand();

            cmd.Connection  = con;
            cmd.CommandType = System.Data.CommandType.Text;
            cmd.CommandText = "select * from Exam where UserName=@UserName";

            cmd.Parameters.AddWithValue("@UserName", Session["UserName"]);

            SqlDataReader dr = cmd.ExecuteReader();

            if (dr.Read())
            {
                ex.UserName = (string)dr["UserName"];
                ex.Password = (string)dr["PassWord"];
            }

            return(View(ex));
        }
        private SelectList GetAllExams(string AYID = "", string SchoolId = "", string ClassID = "", string AssessmentType = "")
        {
            Models.Exam obj = new Models.Exam();
            obj.AYID = AYID;
            obj.SchoolID = SchoolId;
            obj.ExamType = "UnitTest";
            obj.AssessmentType = AssessmentType;
            obj.ClassID = ClassID;

            SelectList retList = null;
            List<Models.Exam> ObjList = _ExamService.GetAllForLookup(obj).ToList();

            if (retList == null)
                retList = new SelectList(ObjList, ExamMst_Constant.EXAM_ID, ExamMst_Constant.EXAM_NAME);

            return retList;
        }