public async Task <IActionResult> PutSubjects([FromRoute] int id, [FromBody] SubjectsDTO subject)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != subject.Id)
{
return(BadRequest());
}
_context.Entry(Mapper.Map <Subjects>(subject)).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SubjectsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
// GET: Subjects
public ActionResult Index()
{
SubjectsDTO subjectDTO;
if (System.Web.HttpContext.Current.User.Identity.IsAuthenticated)
{
username = System.Web.HttpContext.Current.User.Identity.Name;
}
specificUser = db.Users.Where(u => u.Email == username).FirstOrDefault();
foreach (var subject in db.subjects.ToList())
{
subjectDTO = new SubjectsDTO();
subjectDTO.subject = subject;
if (specificUser.Subjects.Contains(subject))
{
subjectDTO.isSelected = true;
}
else
{
subjectDTO.isSelected = false;
}
subjects.Add(subjectDTO);
}
return(View(subjects));
}
public static long CreateUpdateSubjects(SubjectsDTO subjects)
{
try
{
using (var ctx = new DAL.tutorDBEntities())
{
var dbSubject = ctx.Subjects.FirstOrDefault(x => x.id == subjects.id) ?? ctx.Subjects.Add(new DAL.Subjects());
if (ctx.Subjects.Any(x => x.name == subjects.name && x.id != dbSubject.id))
{
throw new Exception($"Предмет: {subjects.name} уже существует");
}
dbSubject.name = subjects.name;
dbSubject.subjectTypeId = subjects.subjectTypeId;
ctx.SaveChanges();
return(dbSubject.id);
}
}
catch (Exception ex)
{
throw;
//return -1;
}
}
public static SubjectsDTO GetSubject(long?id = null, string name = null)
{
if (!id.HasValue && string.IsNullOrEmpty(name))
{
return(null);
}
try
{
using (var ctx = new DAL.tutorDBEntities())
{
var dbSubject = ctx.Subjects.FirstOrDefault(x => x.id == id || x.name == name);
if (dbSubject != null)
{
var subject = new SubjectsDTO
{
id = dbSubject.id,
name = dbSubject.name,
subjectTypeId = dbSubject.subjectTypeId
};
return(subject);
}
throw new Exception($"Предмет: {name} не найден");
}
}
catch (Exception ex)
{
return(null);
}
}
public async Task <IActionResult> PostSubjects([FromBody] SubjectsDTO subject)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.Subjects.Add(Mapper.Map <Subjects>(subject));
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSubjects", new { id = subject.Id }, subject));
}
public IActionResult Update(string id, [FromBody] SubjectsDTO dto)
{
try
{
var isExist = repository.GetById(id);
if (isExist != null)
{
mapper.Map(dto, isExist);
repository.Update(isExist);
var result = repository.SaveChanges();
if (result)
{
return(Ok());
}
}
return(NotFound());
}
catch (System.Exception msg)
{
return(NotFound(msg));
}
}
public IActionResult Insert([FromBody] SubjectsDTO dto)
{
try
{
var model = mapper.Map <Subjects>(dto);
if (model != null)
{
model.DateCreate = DateTime.Now;
repository.Insert(model);
var result = repository.SaveChanges();
if (result)
{
return(Ok());
}
}
return(NotFound());
}
catch (System.Exception msg)
{
return(NotFound(msg));
}
}