public static string Save(StudentDataModel data, string action, RequestProfile requestProfile)
{
var sql = "EXEC ";
switch (action)
{
case "Create":
sql += "dbo.StudentInsert " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
break;
case "Update":
sql += "dbo.StudentUpdate " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
break;
default:
break;
}
sql = sql + ", " + ToSQLParameter(data, StudentDataModel.DataColumns.StudentId);
sql = sql + ", " + ToSQLParameter(data, StudentDataModel.DataColumns.Name);
sql = sql + ", " + ToSQLParameter(data, StudentDataModel.DataColumns.Description);
sql = sql + ", " + ToSQLParameter(data, StudentDataModel.DataColumns.SortOrder);
return(sql);
}
public static int Create(StudentDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, "Create", requestProfile);
var newId = DBDML.RunScalarSQL("Student.Insert", sql, DataStoreKey);
return(Convert.ToInt32(newId));
}
public void Edit(StudentDataModel studentDataModel)
{
var editStudent = Mapper.Map <StudentDataModel, Student>(studentDataModel);
UnitOfWork.Students.Update(editStudent);
UnitOfWork.Save();
}
public ActionResult Details(int id)
{
StudentDataModel currentStudent = SessionCurrentStudent();
var postDataModel = postService.Get(id);
return(View(postDataModel));
}
public void Delete(string value)
{
var dataQuery = new StudentDataModel();
dataQuery.StudentId = int.Parse(value);
StudentDataManager.Delete(dataQuery, SessionVariables.RequestProfile);
}
public JObject Put(int id, [FromBody] StudentDataModel value)
{
var json = System.IO.File.ReadAllText(jsonFile);
var flag = 0;
HttpContext.Response.Headers.Add("Access-Control-Allow-Origin", "*");
try
{
var jObject = JObject.Parse(json);
if (jObject != null)
{
JArray students = (JArray)jObject["students"];
if (id > 0)
{
var name = value.name;
var age = value.age;
var subject = value.subject;
var percentage = value.percentage;
foreach (var student in students.Where(obj => obj["id"].Value <int>() == id))
{
flag = 1;
student["name"] = !string.IsNullOrEmpty(name) ? name : "";
student["age"] = age;
student["subject"] = !string.IsNullOrEmpty(subject) ? subject : "";
student["percentage"] = percentage;
}
jObject["students"] = students;
string output = Newtonsoft.Json.JsonConvert.SerializeObject(jObject, Newtonsoft.Json.Formatting.Indented);
System.IO.File.WriteAllText(jsonFile, output);
if (flag == 1)
{
return(new JObject());
}
else
{
return(new JObject());
}
}
else
{
Console.Write("Invalid Company ID, Try Again!");
return(new JObject());
}
}
else
{
Console.WriteLine("jObject is null");
// return "NULL";
return(new JObject());
}
}
catch (Exception e)
{
Console.WriteLine(e);
return(new JObject());
}
}
public ActionResult Edit(CreatePostDataModel createPostDataModel)
{
StudentDataModel currentStudent = SessionCurrentStudent();
postService.Edit(createPostDataModel);
return(RedirectToAction("Index", "Posts"));
}
private Student ToStudent(StudentDataModel studentDataModel)
{
return(new Student(
Guid.Parse(studentDataModel.Guid),
studentDataModel.Name,
int.Parse(studentDataModel.Age)));
}
public JObject Post([FromBody] StudentDataModel value)
{
var json = System.IO.File.ReadAllText(jsonFile);
HttpContext.Response.Headers.Add("Access-Control-Allow-Origin", "*");
try
{
var jObject = JObject.Parse(json);
if (jObject != null)
{
JArray students = (JArray)jObject["students"];
var newStudentData = "{ 'id': " + (students.Count + 1) + ", 'name': '" + value.name + "', 'age': " + value.age + ", 'subject': '" + value.subject + "', 'percentage': " + value.percentage + "}";
var newStudent = JObject.Parse(newStudentData);
students.Add(newStudent);
jObject["students"] = students;
string newJsonResult = Newtonsoft.Json.JsonConvert.SerializeObject(jObject, Newtonsoft.Json.Formatting.Indented);
System.IO.File.WriteAllText(jsonFile, newJsonResult);
return(newStudent);
// return students[index].ToString();
}
else
{
Console.WriteLine("jObject is null");
// return "NULL";
return(new JObject());
}
}
catch (Exception e)
{
Console.WriteLine(e);
return(new JObject());
}
}
public override async Task <string> Save(Student student)
{
StudentDataModel studentDataModel = null;
if (!string.IsNullOrWhiteSpace(student.Id))
{
studentDataModel = await GetBaseQuery().SingleOrDefaultAsync(x => x.Id == student.Id);
}
if (studentDataModel == null)
{
studentDataModel = new StudentDataModel()
{
Name = student.Name
};
}
studentDataModel.SubjectLinks = student.SubjectEnrolments.Select(s => new SubjectStudentLink()
{
StudentId = student.Id,
SubjectId = s.SubjectId
}).ToList();
_dbContext.Update(studentDataModel);
await _dbContext.SaveChangesAsync();
await DispatchEvents(student);
return(studentDataModel.Id);
}
public ActionResult Index(int?id)
{
StudentDataModel currentStudent = SessionCurrentStudent();
var modelTuple = new Tuple <StudentDataModel, IEnumerable <PostDataModel> >(currentStudent, postService.GetAllPosts());
return(View(modelTuple));
}
public ActionResult Edit(int id)
{
StudentDataModel currentStudent = SessionCurrentStudent();
var postDataModel = postService.Get(id);
var createPostDataModel = postService.Get(postDataModel);
return(View(createPostDataModel));
}
public int Create(StudentDataModel studentDataModel)
{
var newStudent = Mapper.Map <StudentDataModel, Student>(studentDataModel);
UnitOfWork.Students.Create(newStudent);
UnitOfWork.Save();
return(newStudent.Id);
}
public ActionResult Create(CreatePostDataModel createPostDataMode)
{
StudentDataModel currentStudent = SessionCurrentStudent();
createPostDataMode.AuthorId = currentStudent.Id;
postService.Create(createPostDataMode);
return(RedirectToAction("Index", "Posts", currentStudent));
}
public async Task <StudentDataModel> GetStudent(int studentId)
{
Student entity = await _context.Students.Include(o => o.StudentsInGroups).AsNoTracking().FirstOrDefaultAsync(e => e.Id == studentId);
StudentDataModel student = entity is null ? new StudentDataModel() : new StudentDataModel(entity);
return(student);
}
public static string ToSQLParameter(StudentDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case StudentDataModel.DataColumns.StudentId:
if (data.StudentId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, StudentDataModel.DataColumns.StudentId, data.StudentId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, StudentDataModel.DataColumns.StudentId);
}
break;
case StudentDataModel.DataColumns.Name:
if (!string.IsNullOrEmpty(data.Name))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, StudentDataModel.DataColumns.Name, data.Name);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, StudentDataModel.DataColumns.Name);
}
break;
case StudentDataModel.DataColumns.Description:
if (!string.IsNullOrEmpty(data.Description))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, StudentDataModel.DataColumns.Description, data.Description);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, StudentDataModel.DataColumns.Description);
}
break;
case StudentDataModel.DataColumns.SortOrder:
if (data.SortOrder != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, StudentDataModel.DataColumns.SortOrder, data.SortOrder);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, StudentDataModel.DataColumns.SortOrder);
}
break;
default:
returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public StudentDataModel GetById(string value)
{
var dataQuery = new StudentDataModel();
dataQuery.StudentId = int.Parse(value);
var result = StudentDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile, 1);
return(result[0]);
}
public void RemoveStudent(StudentDataModel student)
{
if (student is null)
{
throw new ArgumentNullException("student", "Student cannot be null.");
}
_students?.Remove(student);
}
public ActionResult Create(int id)
{
StudentDataModel currentStudent = SessionCurrentStudent();
var commentDataModel = new CommentDataModel();
commentDataModel.AuthorId = currentStudent.Id;
commentDataModel.PostId = id;
return(View(commentDataModel));
}
public ActionResult Delete(int id)
{
if (id != null && id != 0)
{
StudentDataModel currentStudent = SessionCurrentStudent();
var postDataModel = postService.Get(id);
return(View(postDataModel));
}
return(View());
}
public static bool DoesExist(StudentDataModel data, RequestProfile requestProfile)
{
var doesExistRequest = new StudentDataModel();
doesExistRequest.ApplicationId = data.ApplicationId;
doesExistRequest.Name = data.Name;
var list = GetEntityDetails(doesExistRequest, requestProfile, 0);
return(list.Count > 0);
}
public StudentViewModel(StudentDataModel studentDataModel)
{
this.Id = studentDataModel.Id;
this.Gender = EnumHelper <Gender> .GetDisplayValue(studentDataModel.Gender);
this.GenderId = (int)studentDataModel.Gender;
this.Surname = studentDataModel.Surname;
this.Name = studentDataModel.Name;
this.MiddleName = studentDataModel.MiddleName;
this.UniqueName = studentDataModel.UniqueName;
this.FullName = studentDataModel.FullName;
}
public StudentDataModel Get(StudentDataModel studentDataModel)
{
var currentStudent = UnitOfWork.Students
.Find(s => s.FirstName == studentDataModel.FirstName && s.LastName == studentDataModel.LastName)
.FirstOrDefault();
if (currentStudent != null)
{
return(Get(currentStudent.Id));
}
return(null);
}
public StudentViewModel(StudentDataModel studentDataModel, IEnumerable <GroupDataModel> groups)
{
this.Id = studentDataModel.Id;
this.Gender = EnumHelper <Gender> .GetDisplayValue(studentDataModel.Gender);
this.GenderId = (int)studentDataModel.Gender;
this.Surname = studentDataModel.Surname;
this.Name = studentDataModel.Name;
this.MiddleName = studentDataModel.MiddleName;
this.UniqueName = studentDataModel.UniqueName;
this.FullName = studentDataModel.FullName;
this.GroupList = groups.ToList();
}
public async Task <IActionResult> Create(StudentDataModel student)
{
try
{
await _studentService.AddStudent(student);
}
catch
{
return(BadRequest());
}
return(Ok());
}
public IHttpActionResult Post([FromBody] StudentDataModel studentModel)
{
if (!ModelState.IsValid)
{
return(this.BadRequest(ModelState));
}
var student = StudentDataModel.FromModelToData(studentModel);
this.Data.Students.Add(student);
this.Data.SaveChanges();
return(this.Created(this.Url.ToString(), student));
}
public async Task AddStudent(StudentDataModel student)
{
Student entity = student.FillToEntity();
_context.Students.Add(entity);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
throw new Exception("Ошибка добавления в базу данных.");
}
}
public static void Delete(StudentDataModel data, RequestProfile requestProfile)
{
const string sql = @"dbo.StudentDelete ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, StudentId = data.StudentId
};
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure);
}
}
public JsonResult JsonDepartmentAdd([FromBody] StudentDataModel model)
{
if (model != null && model.DepartmentUID != null && model.DepartmentUID != Convert.ToString(Guid.Empty))
{
foreach (var item in model.Dizi)
{
_departmentPersonsService.Add(new DepartmentPerson()
{
Uid = Guid.NewGuid(),
DepartmentUid = Guid.Parse(model.DepartmentUID),
PersonUid = Guid.Parse(item)
});
}
}
return(Json(new { Success = true, Message = "" }));
}
public static Student ToStudentAggregate(this StudentDataModel studentDataModel)
{
if (studentDataModel == null)
{
return(null);
}
var subjectEnrolments =
studentDataModel.SubjectLinks.Select(x =>
new SubjectEnrolment(x.SubjectId, x.Subject.Name,
x.Subject.Lectures.Sum(l => l.LectureTheatreLink.EndHour - l.LectureTheatreLink.StartHour))
).ToList();
var student = new Student(studentDataModel.Id, studentDataModel.Name, subjectEnrolments);
return(student);
}