public static void Save(HandmadeData Data) { DKMHEntities db = new DKMHEntities(); var ClassList = ""; foreach (String cl in Data.Class) { ClassList += (ClassList.Length > 0 ? ", " : "") + "'" + cl + "'"; } String IgnoreStudents = InputHelper.IgnoreStudents.ContainsKey(Data.SubjectData) ? JsonConvert.SerializeObject(InputHelper.IgnoreStudents[Data.SubjectData]) : "[]"; IgnoreStudents = IgnoreStudents.Substring(1, IgnoreStudents.Length - 2).Replace("\"", "'"); var StudentList = db.Database.SqlQuery <StudentInfo>("select pdkmh.MaSinhVien, pdkmh.Nhom from pdkmh, sinhvien " + "where pdkmh.MaSinhVien = sinhvien.MaSinhVien and MaMonHoc = '" + Data.SubjectData + "' and Nhom in (" + ClassList + ") " + (IgnoreStudents.Length > 0 ? "and not(sinhvien.MaSinhVien in (" + IgnoreStudents + ")) " : "") + "order by (sinhvien.Ten + sinhvien.ho)").ToList(); DateTime FirstShiftTime = InputHelper.Options.StartDate.AddHours(InputHelper.Options.Times[0].Hour) .AddMinutes(InputHelper.Options.Times[0].Minute); String ShiftID = "";//InputHelper.Options.StartDate.Year + "" + InputHelper.Options.StartDate.Month + "" + InputHelper.Options.StartDate.Day; ShiftID += RoomArrangement.CalcShift(FirstShiftTime, Data.Date).ToString(); if ((from ct in db.CaThis where ct.MaCa == ShiftID select ct).Count() == 0) { var pa = new SqlParameter[] { new SqlParameter("@MaCa", SqlDbType.NVarChar) { Value = ShiftID }, new SqlParameter("@GioThi", SqlDbType.DateTime) { Value = Data.Date }, }; db.Database.ExecuteSqlCommand("INSERT INTO CaThi (MaCa, GioThi) VALUES (@MaCa, @GioThi)", pa); } Thi aRecord = new Thi(); aRecord.MaMonHoc = Data.SubjectData; aRecord.MaCa = ShiftID; var ClassGroup = Data.SubjectData; foreach (var cl in Data.Class) { ClassGroup += "_" + cl; } aRecord.Nhom = ClassGroup; String SQLQuery = ""; int StudentIndex = 0; for (int Index = 0; Index < Data.Room.Count; Index++) { aRecord.MaPhong = Data.Room[Index]; for (int i = 0; i < Data.Num[Index]; i++) { aRecord.MaSinhVien = StudentList[StudentIndex].MaSinhVien; SQLQuery += String.Format("INSERT INTO Thi (MaCa, MaMonHoc, Nhom, MaPhong, MaSinhVien) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')\r\n", aRecord.MaCa, aRecord.MaMonHoc, aRecord.Nhom, aRecord.MaPhong, aRecord.MaSinhVien ); StudentIndex++; } } db.Database.ExecuteSqlCommand(SQLQuery); }