public static void DelSubject(List<Priority> SP, List<String> SubjectID)
{
List<String> SB = new List<String>();
if (SubjectID != null)
{
foreach (var r in SP)
if (!SubjectID.Contains(r.SubjectID.ToString()))
SB.Add(r.SubjectID);
}
else
{
foreach (var r in SP)
SB.Add(r.SubjectID);
}
for (int i = 0; i < SB.Count(); i++)
{
var a = SB[i];
var nhom = (from m in InputHelper.db.nhoms
where m.MaMonHoc.Equals(a)
select m.Nhom1).ToList();
foreach (var r in nhom)
{
byte aByte = Convert.ToByte(r);
InputHelper.Groups.FirstOrDefault(m => m.Value.MaMonHoc == SB[i] && m.Value.Nhom == aByte).Value.IsIgnored = false;
}
OutputHelper.SaveOBJ("Groups", InputHelper.Groups);
}
}
public String SelectSuccess(List<String> SubjectID, List<long> Date, List<long> Time)
{
string paramInfo = "";
if (InputHelper.SubjectPriority.Count() != 0)
{
DelSubject(InputHelper.SubjectPriority, SubjectID);
}
InputHelper.SubjectPriority = new List<Priority>();
List<String> SB = new List<String>();
List<String> aClass = new List<String>();
List<String> Check = new List<String>();
if (SubjectID != null)
for (int i = 0; i < SubjectID.Count(); i++)
{
DateTime dt = (new DateTime(1970, 1, 1, 0, 0, 0, 0)).AddMilliseconds(Date[i]).Date;
InputHelper.SubjectPriority.Add(new Priority
{
SubjectID = SubjectID[i],
Date = dt,
Time = dt.AddMilliseconds(Time[i])
});
var a = SubjectID[i];
var nhom = (from m in InputHelper.db.nhoms
where m.MaMonHoc.Equals(a)
select m.Nhom1).ToList();
foreach (var r in nhom)
{
SB.Add(SubjectID[i]);
aClass.Add(r.ToString());
// Check.Add("undefined");
Check.Add("checked");
}
paramInfo += "MH:" + SubjectID[i] + " Ngay:" + Date[i] + "Gio:" + Time[i] + "<br /><br />";
}
OutputHelper.SaveOBJ("SubjectPriority", InputHelper.SubjectPriority);
string st = OutputHelper.SaveIgnoreGroups(SB, aClass, Check, true);
return paramInfo;
}
public String SelectSuccess(List<String> StudentID, List<String> SubjectID)
{
InputHelper.IgnoreStudents = new Dictionary<String,List<String>>();
string paramInfo = "";
if (StudentID != null)
{
for (int i = 0; i < StudentID.Count(); i++)
{
if (InputHelper.IgnoreStudents.ContainsKey(SubjectID[i]))
{
InputHelper.IgnoreStudents[SubjectID[i]].Add(StudentID[i]);
}
else
{
InputHelper.IgnoreStudents.Add(SubjectID[i], new List<String> { StudentID[i] });
}
paramInfo += "MH:" + SubjectID[i] + " SV: " + StudentID[i] + "<br /><br />";
}
}
OutputHelper.SaveOBJ("IgnoreStudents", InputHelper.IgnoreStudents);
return paramInfo;
}
//
// По аналогии с TreeList, Spreadsheet также должен находиться
// на в частичном представлении, которое включается в это представление.
//
public ActionResult ExampleTablesAfterParsing(long emailId)
{
List<Model.ParsedCells> workSheetCellsList = new List<Model.ParsedCells>();
List<List<Model.ParsedCells>> tableCellsList = new List<List<Model.ParsedCells>>();
List<List<List<Model.ParsedCells>>> cellsList = new List<List<List<Model.ParsedCells>>>();
Model.ParsedCells cellsWSC = new Model.ParsedCells();
if (emailId != 0)
{
var userId = UserHelper.GetUserByEmail(User.Identity.Name).Id;
if (IsUsersEmail(userId, emailId))
{
var cells = parsedCellsRepository.FindAll(w => w.EmailId_Id == emailId);
var distCellsByTable = cells.GroupBy(a => a.TableId_Id).Select(g => g.First()).OrderBy(i => i.TableId_Id).ToList();
foreach (var table in distCellsByTable)
{
var distCellsByWorkcheet = cells.Where(t => t.TableId_Id == table.TableId_Id)
.GroupBy(a => a.Worksheet).Select(g => g.First()).OrderBy(i => i.Worksheet).ToList();
foreach (var cell in distCellsByWorkcheet)
{
tableCellsList = new List<List<Model.ParsedCells>>();
workSheetCellsList = new List<Model.ParsedCells>();
var Cells = cells.Where(c => c.TableId_Id == table.TableId_Id && c.Worksheet == cell.Worksheet).OrderBy(i => i.Column).ToList();
foreach (var c in Cells)
{
c.ColumnName = GetColumnName(c.Column);
workSheetCellsList.Add(c);
}
tableCellsList.Add(workSheetCellsList);
cellsList.Add(tableCellsList);
}
}
}
}
if (cellsList.Count() != 0)
return View(cellsList);
else
return View("ExampleTablesAfterParsingNoData");
}
public JsonResult DataTable_IgnoreGroups(jQueryDataTableParamModel param, List<String> SubjectID = null, List<String> Class = null, List<String> Check = null, String Search = null, String ShowIgnore = null, String ShowNotIgnore = null)
{
if (SubjectID != null && Class != null && Check != null)
{
OutputHelper.SaveIgnoreGroups(SubjectID, Class, Check, false);
}
Dictionary<String, Group> dbGroups = Clone.Dictionary<String, Group>((Dictionary<String, Group>)(CurrentSession.Get("IgnoreGroups") ?? InputHelper.Groups));
//Dictionary<String, Group> dbGroups = InputHelper.Groups;
var Groups = from m in dbGroups.Values select m;
var total = Groups.Count();
if (!string.IsNullOrEmpty(Search))
{
Groups = Groups.Where(m => m.MaMonHoc.ToLower().Contains(Search.ToLower()) || m.TenMonHoc.ToLower().Contains(Search.ToLower()));
}
if (ShowIgnore != null && ShowNotIgnore != null)
{
if (ShowIgnore == "checked" && ShowNotIgnore != "checked")
{
Groups = Groups.Where(m => m.IsIgnored == true);
}
if (ShowIgnore != "checked" && ShowNotIgnore == "checked")
{
Groups = Groups.Where(m => m.IsIgnored == false);
}
if (ShowIgnore != "checked" && ShowNotIgnore != "checked")
{
Groups = Groups.Where(m => false);
}
}
var Result = new List<string[]>();
var MH = (from m in InputHelper.db.This
select new
{
MaMonHoc = m.MaMonHoc,
Nhom = m.Nhom,
}).Distinct();
Dictionary<String, List<String>> CheckMH = new Dictionary<string, List<string>>();
foreach (var m in MH)
{
if (CheckMH.ContainsKey(m.MaMonHoc))
CheckMH[m.MaMonHoc].Add(m.Nhom);
else
CheckMH.Add(m.MaMonHoc, new List<String> { m.Nhom });
}
foreach (var su in Groups.OrderBy(m => m.TenMonHoc))
{
if (CheckMH.ContainsKey(su.MaMonHoc))
{
if (!CheckGroup(CheckMH[su.MaMonHoc], su.Nhom.ToString()))
{
Result.Add(new string[] {
su.MaMonHoc,
su.TenMonHoc,
su.TenBoMon,
su.TenKhoa,
su.Nhom.ToString(),
su.SoLuongDK.ToString(),
su.IsIgnored ? "checked" : "",
}
);
}
}
else
{
Result.Add(new string[] {
su.MaMonHoc,
su.TenMonHoc,
su.TenBoMon,
su.TenKhoa,
su.Nhom.ToString(),
su.SoLuongDK.ToString(),
su.IsIgnored ? "checked" : "",
}
);
}
}
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = Result.Count(),
iTotalDisplayRecords = Result.Count(),
//iTotalDisplayedRecords = Subjects.Count(),
aaData = Result.Skip(param.iDisplayStart).Take(param.iDisplayLength)
},
JsonRequestBehavior.AllowGet
);
}
public IList<Model.DJ_Workers> GetTourGroupByTeId(int id)
{
var listTg = Idjtourgroup.GetTourGroupByTEId(id).ToList();
var listGw = new List<Model.DJ_Group_Worker>();
var listGw2 = new List<Model.DJ_Group_Worker>();
List<DJ_Workers> Listdw = new List<DJ_Workers>();
foreach (var tg in listTg)
{
listGw.AddRange(tg.Workers.Where(x => x.DJ_Workers.WorkerType == Model.DJ_GroupWorkerType.导游).ToList<Model.DJ_Group_Worker>());
}
foreach (var item in listGw)
{
if (listGw2.Count(x => x.DJ_Workers.IDCard == item.DJ_Workers.IDCard) == 0)
{
listGw2.Add(item);
}
}
foreach (var item in listGw2)
{
Listdw.Add(item.DJ_Workers);
}
return Listdw;
}
