public async Task <IActionResult> GetBySecretKey(string key)
{
var subject = await _baseRepository.GetContext()
.Subject.Include(x => x.Document)
.FirstOrDefaultAsync(x => x.SecretKey == key);
if (subject == null)
{
return(UnprocessableEntity());
}
var dto = new SubjectDto
{
Id = subject.Id,
UserId = subject.UserId,
Name = subject.Name,
FileName = subject.Document.OriginalName,
Logo = await ConvertToBase64(subject.Document.Path + subject.Document.FileName),
SecretKey = subject.SecretKey
};
return(Ok(dto));
}
// GET: Subject/Create
public async Task <ActionResult> Create(int groupId)
{
try
{
var subject = new SubjectDto
{
GroupId = groupId
};
var subjects = await _subjectInfoService.GetSubjectInfosAsync(groupId);
ViewBag.Subjects = new SelectList(subjects, "Id", "Title");
return(View(subject));
}
catch (SPCException ex)
{
return(View("ErrorView", new ErrorDto(ex.Message, ex.StatusCode)));
}
catch
{
return(View("Error"));
}
}
public async Task <IActionResult> CreateCustomer([FromBody] SubjectDto subjectDto, Owner.Type ownerType)
{
var customer = Mapper.Map <SubjectDto, DicCustomer>(subjectDto);
//var isCustomerExistsByXin = string.IsNullOrEmpty(customer.Xin) == false && Executor.GetQuery<IsCustomerAlreadyExistsByXinQuery>().Process(q => q.Execute(customer.Xin));
//if (isCustomerExistsByXin)
//{
// throw new ValidationException($"Customer with XIN {customer.Xin} already exists");
//}
await Executor.GetCommand <CreateDicCustomerCommand>().Process(c => c.ExecuteAsync(customer));
var newSubject = Mapper.Map <SubjectDto>(customer);
if (ownerType != Owner.Type.None)
{
newSubject.OwnerId = subjectDto.OwnerId;
newSubject.Id = subjectDto.Id;
newSubject.RoleId = subjectDto.RoleId;
newSubject = await AttachCustomerPrivate(newSubject, ownerType);
}
return(Ok(newSubject));
}
public async Task <ApiResponse <Subject> > CreateSubject(SubjectDto subjectDto)
{
var response = new ApiResponse <Subject>();
try
{
//check subject Exists
var isExistSubject = await _subjectRepository.CountAsync(i => i.Name == subjectDto.Name);
if (isExistSubject != 0)
{
response.Success = false;
response.Errors.Add("Subject Already Exists");
return(response);
}
var id = Guid.NewGuid();
//create new subject
var subject = Mapper.Map <Subject>(subjectDto);
subject.Id = id;
//subject.CreatedBy = subject.Id;
subject.CreatedDate = DateTime.Now;
//subject.Roles = subjectRoles;
subject.IsActive = true;
await _subjectRepository.AddAsyn(subject);
response.Success = true;
}
catch (Exception ex)
{
response.Success = false;
response.Errors.Add(ex.Message);
}
return(response);
}
private void btnAddRow_Down_Click(object sender, EventArgs e)
{
if (CommonHandler.GetComboBoxSelectedValue(cboLink) == null || string.IsNullOrEmpty(CommonHandler.GetComboBoxSelectedValue(cboLink).ToString()))
{
CommonHandler.ShowMessage(MessageType.Information, "请先选择环节");
return;
}
SubjectDto subject = new SubjectDto();
subject.LinkCode = CommonHandler.GetComboBoxSelectedValue(cboLink).ToString();
subject.ProjectCode = project.ProjectCode;
subject.FullScore = 2;
subject.ScoreCheck = true;
if (cboExamType.SelectedIndex == 0)
{
subject.SubjectTypeCodeExam = "C";
}
else
{
subject.SubjectTypeCodeExam = CommonHandler.GetComboBoxSelectedValue(cboExamType).ToString();
}
dataHandlerSubject.AddRow(subject);
}
private void btnSearch_Click(object sender, EventArgs e)
{
string projectCode = CommonHandler.GetComboBoxSelectedValue(cboProject).ToString();
string linkCode = CommonHandler.GetComboBoxSelectedValue(cboLink).ToString();
List <SubjectDto> sourceSubjectList = new List <SubjectDto>();
DataSet ds = service.SearchSubject(projectCode, "", linkCode, "");
if (ds.Tables.Count > 0)
{
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
SubjectDto subject = new SubjectDto();
subject.LinkCode = Convert.ToString(ds.Tables[0].Rows[j]["LinkCode"]);
subject.LinkName = Convert.ToString(ds.Tables[0].Rows[j]["LinkName"]);
subject.SubjectCode = Convert.ToString(ds.Tables[0].Rows[j]["SubjectCode"]);
subject.CheckPoint = Convert.ToString(ds.Tables[0].Rows[j]["CheckPoint"]);
subject.ChapterName = Convert.ToString(ds.Tables[0].Rows[j]["CharterName"]);
sourceSubjectList.Add(subject);
}
}
grcSubject.DataSource = sourceSubjectList;
}
public ActionResult UpdateSubject(int subjectId, SubjectDto subject)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var subjectfromRepo = _subjectOrderRepository.GetSubject(subjectId);
if (subjectfromRepo == null)
{
return(NotFound());
}
subjectfromRepo.FirstName = subject.firstName;
subjectfromRepo.LastName = subject.lastName;
subjectfromRepo.DateOfBirth = subject.dateOfBirth;
subjectfromRepo.TitleId = subject.titleId;
_subjectOrderRepository.UpdateSubject(subjectfromRepo);
_subjectOrderRepository.Save();
return(NoContent());
}
public SubjectDto GetSubject(string subjectType)
{
SubjectDto subject = SubjectList[subjectType];
//if (WebContext.Current.ApplicationOption.IsMultiLanguageSupported && languageId != null)
//{
// // Implement multi-language for Subject
// if (subject.SubjectLanguagesDic.ContainsKey(languageId))
// {
// SubjectLanguageDto subjectLanguage = subject.SubjectLanguagesDic[languageId];
// subject.SubjectLabel = subjectLanguage.SubjectLabel;
// }
// foreach (SubjectFieldDto subjectField in subject.SubjectFields)
// {
// // Implement multi-language for Subject Field
// if (subjectField.SubjectFieldLanguagesDic.ContainsKey(languageId))
// {
// SubjectFieldLanguageDto subjectFieldLanguage = subjectField.SubjectFieldLanguagesDic[languageId];
// subjectField.FieldLabel = subjectFieldLanguage.FieldLabel;
// subjectField.HelpText = subjectFieldLanguage.HelpText;
// }
// }
// foreach (SubjectChildListDto childList in subject.SubjectChildLists)
// {
// // Implement multi-language for Subject ChildList
// if (childList.SubjectChildListLanguagesDic.ContainsKey(languageId))
// {
// SubjectChildListLanguageDto childListLanguage = childList.SubjectChildListLanguagesDic[languageId];
// childList.Title = childListLanguage.Title;
// }
// }
//}
return(subject);
}
private async Task GetData()
{
SubjectData = await SubjectService.Get(Id);
StateHasChanged();
}
public override Task <bool> StoreAttendenceAsync(StudentDto studentDto, SubjectDto subjectDto)
{
throw new NotImplementedException();
}
public ActionResult UpdateSubject([FromBody] SubjectDto subject)
{
this.subjectService.UpdateSubject(subject);
return(this.Ok());
}
public void UpdateSubject(SubjectDto Subject) => this.Subjects.Update(this.mapper.Map <Subject>(Subject));
public async Task <IActionResult> Edit([FromBody] SubjectDto subjectDto)
{
return(await HandleRequestAsync(async() => await _subjectService.EditSubjectAsync(subjectDto)));
}
public static TimeTable ReadTimeTable(string filePath)
{
FileInfo fileInfo = new FileInfo(filePath);
TimeTable timeTable = new TimeTable();
using (ExcelPackage package = new ExcelPackage(fileInfo))
{
ExcelWorksheet excelWorksheet = package.Workbook.Worksheets.First();
if (excelWorksheet == null)
{
return(null);
}
#region Groups
List <GroupDto> tempGroupDtos = excelWorksheet.Extract <GroupDto>().WithProperty(p => p.Name, "C").GetData(8, 300).Where(p => p.Name != null).ToList();
int id = 1;
tempGroupDtos.ForEach(groupDto => groupDto.Id = id++);
List <GroupDto> groupDtos = new List <GroupDto>();
tempGroupDtos.ForEach(group =>
{
if (group.Name == "Grupa")
{
return;
}
groupDtos.Add(group);
/*GroupDto groupB = new GroupDto(group.Id,group.Name);
* groupDtos.Add(groupB);*/
});
#endregion
excelWorksheet.Cells[8, 5, 300, 50].ToList().ForEach(cell =>
{
//if (cell.GetValue<string>() != null) return;
if (!cell.Merge && string.IsNullOrEmpty(cell.Text))
{
return;
}
string value = GoUp(excelWorksheet, cell.Start.Row, cell.Start.Column);
cell.Value = value;
if (value.Split(",".ToCharArray()).Length > 2)
{
if (value.Substring(value.Length - 7).Equals(",Impara"))
{
value = value.Substring(0, value.Length - 7);
}
else if (value.Substring(value.Length - 5).Equals(",Para"))
{
value = value.Substring(0, value.Length - 5);
}
}
if (cell.Start.Row % 2 == 0)
{
cell.Value = value + "," + "Impara";
}
else
{
cell.Value = value + "," + "Para";
}
});
excelWorksheet.Cells[6, 5, 6, 50].ToList().ForEach(cell =>
{
//if (!string.IsNullOrEmpty(cell.Text)) return;
if (!cell.Merge)
{
return;
}
string value = GoLeft(excelWorksheet, cell.Start.Row, cell.Start.Column);
cell.Value = value;
excelWorksheet.Cells[cell.Start.Row + 1, cell.Start.Column].Value = cell.Text + "|" + excelWorksheet.Cells[cell.Start.Row + 1, cell.Start.Column].Text;
});
List <RowAppointments> rowAppointmentses = excelWorksheet.Extract <RowAppointments>().WithProperty(p => p.Group, "C",
setPropertyValueCallback: (context, value) =>
{
if (value != null)
{
return;
}
if (!excelWorksheet.Cells[context.CellAddress.Row, 3].Merge)
{
return;
}
value = GoUp(excelWorksheet, context.CellAddress.Row, 3);
excelWorksheet.Cells[context.CellAddress.Row, 3].Value = value;
}
).WithProperty(p => p.SemiGroup, "D",
setPropertyValueCallback: (context, value) =>
{
if (value != null)
{
return;
}
if (!excelWorksheet.Cells[context.CellAddress.Row, 4].Merge)
{
return;
}
value = GoUp(excelWorksheet, context.CellAddress.Row, 4);
excelWorksheet.Cells[context.CellAddress.Row, 4].Value = value;
}
)
.WithCollectionProperty(p => p.AppointmentExcelReads, item => item.AppointmentDate, 7,
item => item.AppointmentString, "E", "AK").GetData(8, 300).ToList();
timeTable.Groups = groupDtos;
rowAppointmentses.ForEach(rowAppointment =>
{
GroupDto groupDto = groupDtos.Find(group =>
group.Name.Equals(rowAppointment.Group));
rowAppointment.AppointmentExcelReads.Where(ap => ap.AppointmentString != null).ToList().ForEach(appointment =>
{
string[] date = appointment.AppointmentDate.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
string[] split = appointment.AppointmentString.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (split.Length != 5)
{
return;
}
SubjectDto subjectDto = timeTable.Subjects.FirstOrDefault(subj => subj.Name.Equals(split[0]));
ClassDto classDto = null;
if (subjectDto == null)
{
subjectDto = new SubjectDto(timeTable.Subjects.Count, split[0]);
timeTable.Subjects.Add(subjectDto);
}
else
{
classDto = timeTable.Classes.FirstOrDefault(classTemp => classTemp.Subject.Name.Equals(split[0]) && classTemp.ClassType.ToString().Equals(split[1]));
}
if (classDto == null)
{
classDto = new ClassDto(timeTable.Classes.Count, subjectDto, ClassTypeEnumExtension.StringToEnum(split[1]));
timeTable.Classes.Add(classDto);
}
string ClassRoom = split[2];
date[0] = date[0] + " " + split[4];
TeacherDto teacherDto = timeTable.Teachers.FirstOrDefault(teacher => teacher.Name.Equals(split[3].Replace(" ", "")));
if (teacherDto == null)
{
teacherDto = new TeacherDto(timeTable.Teachers.Count, split[3].Replace(" ", ""));
timeTable.Teachers.Add(teacherDto);
}
AppointmentDto appointmentDTO = new AppointmentDto(timeTable.Appointments.Count, classDto, teacherDto, date[0], date[1], "p", ClassRoom, groupDto);
timeTable.Appointments.Add(appointmentDTO);
});
});
}
return(timeTable);
}
public static int newDtoSubject(SubjectDto subjectDto)
{
return(SubjectManager.NewSubject(subjectDto));
}
public void Put([FromBody] SubjectDto subjectDto)
{
SubjectDtoManager.editDtoSubject(subjectDto);
}
public int Post([FromBody] SubjectDto subjectDto)
{
return(SubjectDtoManager.newDtoSubject(subjectDto));
}
public void SaveSubject(SubjectDto model)
{
model.Scores = model.Score1.ToString() + "," + model.Score2.ToString() + "," + model.Score3.ToString() +
"," + model.Score4.ToString() + "," + model.Score5.ToString();
this._physiqueSubjectRepository.InsertOrUpdate(Mapper.Map <Physique_Subject>(model));
}
public async Task Add(SubjectDto subjectDto)
{
Subject subject = _mapper.Map <Subject>(subjectDto);
await _subjecttRepository.Add(subject);
}
public async Task <IActionResult> Put(int id, Owner.Type ownerType, [FromBody] SubjectDto subjectDto)
{
var result = await _mediator.Send(new Update.Command(id, subjectDto, ownerType));
return(Ok(result));
}
public async Task <IActionResult> AttachCustomer([FromBody] SubjectDto subjectDto, Owner.Type ownerType)
{
var result = await _mediator.Send(new AttachToOwner.Command(subjectDto, ownerType));
return(Ok(result));
}
public static void editDtoSubject(SubjectDto subjectDto)
{
SubjectManager.editSubject(subjectDto);
}
public async Task <IActionResult> Create([FromBody] SubjectDto subject)
{
return(await HandleRequestAsync(async() => await _subjectService.CreateSubjectAsync(subject)));
}
public override Task <bool> StoreAttendenceAsync(StudentDto studentDto, SubjectDto subjectDto)
{
throw new StateManagerException($"The student {studentDto.ApplicationUser.FullName} is not enrolled in {subjectDto.Name} yet.");
}
private void SearchSubject()
{
string projectCode = CommonHandler.GetComboBoxSelectedValue(cboProjectForSubject).ToString();
string chapterCode = CommonHandler.GetComboBoxSelectedValue(cboChapterForSubject).ToString();
string linkCode = CommonHandler.GetComboBoxSelectedValue(cboLink).ToString();
string examTypeCode = CommonHandler.GetComboBoxSelectedValue(cboExamType).ToString();
List <SubjectDto> subjectList = new List <SubjectDto>();
DataSet ds = webService.SearchSubject(projectCode, chapterCode, linkCode, examTypeCode);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
SubjectDto subject = new SubjectDto();
subject.SubjectCode = Convert.ToString(ds.Tables[0].Rows[i]["SubjectCode"]);
subject.Implementation = Convert.ToString(ds.Tables[0].Rows[i]["Implementation"]);
subject.InspectionDesc = Convert.ToString(ds.Tables[0].Rows[i]["InspectionDesc"]);
subject.Desc = Convert.ToString(ds.Tables[0].Rows[i]["Desc"]);
subject.InspectionNeedFile = Convert.ToString(ds.Tables[0].Rows[i]["InspectionNeedFile"]);
subject.AdditionalDesc = Convert.ToString(ds.Tables[0].Rows[i]["AdditionalDesc"]);
subject.CheckPoint = Convert.ToString(ds.Tables[0].Rows[i]["CheckPoint"]);
subject.DelChk = Convert.ToBoolean(ds.Tables[0].Rows[i]["DelChk"]);
subject.ProjectCode = Convert.ToString(ds.Tables[0].Rows[i]["ProjectCode"]);
subject.OrderNO = Convert.ToInt32(ds.Tables[0].Rows[i]["OrderNO"]);
subject.Remark = Convert.ToString(ds.Tables[0].Rows[i]["Remark"]);
subject.ScoreCheck = Convert.ToBoolean(ds.Tables[0].Rows[i]["ScoreCheck"]);
subject.LinkCode = Convert.ToString(ds.Tables[0].Rows[i]["LinkCode"]);
subject.MemberType = Convert.ToString(ds.Tables[0].Rows[i]["MemberType"]);
if (ds.Tables[0].Rows[i]["FullScore"] != DBNull.Value)
{
subject.FullScore = Convert.ToDecimal(ds.Tables[0].Rows[i]["FullScore"]);
}
else
{
subject.FullScore = null;
}
if (ds.Tables[0].Rows[i]["LowestScore"] != DBNull.Value)
{
subject.LowestScore = Convert.ToDecimal(ds.Tables[0].Rows[i]["LowestScore"]);
}
else
{
subject.LowestScore = null;
}
if (ds.Tables[0].Rows[i]["PhotoLowestScore"] != DBNull.Value)
{
subject.PhotoLowestScore = Convert.ToDecimal(ds.Tables[0].Rows[i]["PhotoLowestScore"]);
}
else
{
subject.PhotoLowestScore = null;
}
if (ds.Tables[0].Rows[i]["PhotoFullScore"] != DBNull.Value)
{
subject.PhotoFullScore = Convert.ToDecimal(ds.Tables[0].Rows[i]["PhotoFullScore"]);
}
else
{
subject.PhotoFullScore = null;
}
subject.SubjectTypeCode = Convert.ToString(ds.Tables[0].Rows[i]["SubjectTypeCode"]);
subject.SubjectTypeCodeExam = Convert.ToString(ds.Tables[0].Rows[i]["SubjectTypeCodeExam"]);
if (ds.Tables[0].Rows[i]["SubjectDelChk"] != DBNull.Value)
{
subject.SubjectDelChk = Convert.ToBoolean(ds.Tables[0].Rows[i]["SubjectDelChk"]);
}
if (ds.Tables[0].Rows[i]["AddErrorChk"] != DBNull.Value)
{
subject.AddErrorChk = Convert.ToBoolean(ds.Tables[0].Rows[i]["AddErrorChk"]);
}
subjectList.Add(subject);
}
grcSubject.DataSource = subjectList;
}
else
{
CommonHandler.ShowMessage(MessageType.Information, "没有数据");
grcSubject.DataSource = null;
}
}
public override Task <bool> EnrollStudentAsync(StudentDto studentDto, SubjectDto subjectDto)
{
throw new StateManagerException($"The student {studentDto.ApplicationUser.FullName} is already enrolled in {subjectDto.Name}.");
}
public abstract Task <bool> EnrollStudentAsync(StudentDto studentDto, SubjectDto subjectDto);
public async Task <ActionResult <IEnumerable <CategoryDto> > > GetCategoriesForSubject(SubjectDto subject)
{
var categories = await _categoryRepository.GetCategoryDtosForSubjectAsync(subject.Name);
return(Ok(categories));
}
public static void newDtoSubject(int idExpertise, SubjectDto subjectDto)
{
EwithSManager.NewEwithS(idExpertise, subjectDto);
}
public abstract Task <bool> StoreAttendenceAsync(StudentDto studentDto, SubjectDto subjectDto);
