Exemple #1
0
        public void StudentChangeClassDivision(StudentClassChange entity, int schoolId)
        {
            try
            {
                Hashtable parameterlist = new Hashtable();
                parameterlist.Add("@SchoolId", schoolId);
                parameterlist.Add("@PreviousClassDivisionId", entity.PreviousClassDivisionId);
                parameterlist.Add("@CurrentClassDivisionId", entity.CurrentClassDivisionId);
                parameterlist.Add("@Status", 1);
                parameterlist.Add("@CreatedBy", 0);
                parameterlist.Add("@CreatedDate", DateTime.Today.Date);

                DataTable dt = new DataTable();
                dt.Columns.Add("StudentId", typeof(int));
                dt.Columns.Add("Remark", typeof(string));
                for (int i = 0; i < entity.SelectedStudent.Length; i++)
                {
                    DataRow dr = dt.NewRow();
                    dr["StudentId"] = entity.SelectedStudent[i];
                    dr["Remark"]    = entity.Remark;
                    dt.Rows.Add(dr);
                }
                parameterlist.Add("@ClassChangeDataType", dt);


                int effetedRows = CommanMethodsForSQL.StudentChangeClassDivision("sp_StudentChangeClassDivision", parameterlist);

                if (effetedRows > 0)
                {
                }
            }
            catch (Exception ex)
            {
                throw;
            }
        }