internal bool HasCourse(CourseRow courseRow, MarkingPeriod mp)
{
if (courseRow == null)
{
return(true);
}
return(GetGradeRows().Any(c => c.CourseRow.CourseKey == courseRow.CourseKey));
}
public Courses()
{
InitializeComponent();
foreach (Course c in Storage.Courses)
{
CourseRow row = new CourseRow(c, false);
Table.Children.Add(row);
}
Loaded += AnimatingControl_Loaded;
}
public ExcelImportResponse TeacherExcelImport(IUnitOfWork uow, ExcelImportRequest request)
{
request.CheckNotNull();
Check.NotNullOrWhiteSpace(request.FileName, "filename");
UploadHelper.CheckFileNameSecurity(request.FileName);
if (!request.FileName.StartsWith("temporary/"))
{
throw new ArgumentOutOfRangeException("filename");
}
ExcelPackage ep = new ExcelPackage();
using (var fs = new FileStream(UploadHelper.DbFilePath(request.FileName), FileMode.Open, FileAccess.Read))
ep.Load(fs);
var t = MyRow.Fields;
var b = TextbookRow.Fields;
var c = CourseRow.Fields;
var response = new ExcelImportResponse();
response.ErrorList = new List <string>();
var worksheet = ep.Workbook.Worksheets[1];
for (var row = 2; row <= worksheet.Dimension.End.Row; row++)
{
try
{
//TeacherWholeData
var batchId = Convert.ToString(worksheet.Cells[row, 3].Value ?? "");
if (batchId.IsTrimmedEmpty())
{
continue;
}
var declaration = uow.Connection.TryFirst <MyRow>(q1 => q1
.Select(t.DeclarationId)
.Where(t.DeclarationId == -1));
if (declaration == null)
{
declaration = new MyRow
{
BatchId = batchId
};
}
else
{
declaration.TrackWithChecks = false;
}
//Textbook
var textbookID = Convert.ToString(worksheet.Cells[row, 12].Value ?? "");
if (textbookID.IsTrimmedEmpty())
{
continue;
}
var textbook = uow.Connection.TryFirst <TextbookRow>(q => q
.Select(b.TextbookNum2)
.Where(b.TextbookId == textbookID));
if (textbook == null)
{
textbook = new TextbookRow
{
TextbookId = textbookID
};
}
else
{
textbook.TrackWithChecks = false;
}
textbook.TextbookName = Convert.ToString(worksheet.Cells[row, 13].Value ?? "");
textbook.Author = Convert.ToString(worksheet.Cells[row, 14].Value ?? "");
textbook.Isbn = Convert.ToString(worksheet.Cells[row, 15].Value ?? "");
textbook.Press = Convert.ToString(worksheet.Cells[row, 16].Value ?? "");
textbook.Edition = Convert.ToString(worksheet.Cells[row, 17].Value ?? "");
textbook.PrintingCount = Convert.ToString(worksheet.Cells[row, 18].Value ?? "");
textbook.TextbookType = Convert.ToString(worksheet.Cells[row, 19].Value ?? "");
textbook.Price = Convert.ToString(worksheet.Cells[row, 20].Value ?? "");
textbook.IsSelfCompile = Convert.ToString("0");
if (textbook.TextbookNum2 == null)
{
new TextbookRepository().Create(uow, new SaveRequest <TextbookRow>
{
Entity = textbook
});
}
else
{
new TextbookRepository().Update(uow, new SaveRequest <TextbookRow>
{
Entity = textbook,
EntityId = textbook.TextbookNum2.Value
});
}
//Course
var courseId = Convert.ToString(worksheet.Cells[row, 8].Value ?? "");
if (courseId.IsTrimmedEmpty())
{
continue;
}
var course = uow.Connection.TryFirst <CourseRow>(q => q
.Select(c.CourseNum)
.Where(c.CourseId == courseId));
if (course == null)
{
course = new CourseRow
{
CourseId = courseId
};
}
else
{
course.TrackWithChecks = false;
}
course.CourseCode = Convert.ToString(worksheet.Cells[row, 10].Value ?? "空");
course.CourseName = Convert.ToString(worksheet.Cells[row, 11].Value ?? "");
if (course.CourseNum == null)
{
new CourseRepository().Create(uow, new SaveRequest <CourseRow>
{
Entity = course
});
}
else
{
new CourseRepository().Update(uow, new SaveRequest <CourseRow>
{
Entity = course,
EntityId = course.CourseNum.Value
});
}
declaration.TermCode = Convert.ToString(worksheet.Cells[row, 1].Value ?? "");
declaration.TermName = Convert.ToString(worksheet.Cells[row, 2].Value ?? "");
declaration.SchoolId = Convert.ToString(worksheet.Cells[row, 4].Value ?? "");
declaration.SchoolName = Convert.ToString(worksheet.Cells[row, 5].Value ?? "");
declaration.DepartmentId = Convert.ToString(worksheet.Cells[row, 6].Value ?? "");
declaration.DepartmentName = Convert.ToString(worksheet.Cells[row, 7].Value ?? "");
declaration.EducationalType = Convert.ToString(worksheet.Cells[row, 9].Value ?? "");
declaration.ApprovedAmount = Convert.ToInt32(worksheet.Cells[row, 21].Value ?? 0);
declaration.Priority = Convert.ToString(worksheet.Cells[row, 22].Value ?? "");
declaration.Phone = Convert.ToString(worksheet.Cells[row, 23].Value ?? "");
declaration.Remarks = Convert.ToString(worksheet.Cells[row, 24].Value ?? "");
declaration.CheckState = Convert.ToString(worksheet.Cells[row, 25].Value ?? "");
declaration.DataSign = Convert.ToString(worksheet.Cells[row, 26].Value ?? "");
declaration.CourseNum = course.CourseNum.Value;
declaration.TextbookNum2 = textbook.TextbookNum2.Value;
if (declaration.DeclarationId == null)
{
new TeacherWholeDataRepository().Create(uow, new SaveRequest <MyRow>
{
Entity = declaration
});
response.Inserted = response.Inserted + 1;
}
else
{
new TeacherWholeDataRepository().Update(uow, new SaveRequest <MyRow>
{
Entity = declaration,
EntityId = declaration.DeclarationId.Value
});
response.Updated = response.Updated + 1;
}
}
catch (Exception ex)
{
response.ErrorList.Add("Exception on Row " + row + ": " + ex.Message);
}
}
return(response);
}
public CourseRowChangeEvent(CourseRow row, global::System.Data.DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public void RemoveCourseRow(CourseRow row) {
this.Rows.Remove(row);
}
public void AddCourseRow(CourseRow row) {
this.Rows.Add(row);
}
public CourseRowChangeEvent(CourseRow row, global::System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
internal bool HasCourse(CourseRow courseRow, MarkingPeriod mp)
{
if (courseRow == null)
return true;
return GetGradeRows().Any(c => c.CourseRow.CourseKey == courseRow.CourseKey);
}
