/// <summary>
/// Deletes the room.
/// </summary>
/// <param name="id">The room identifier.</param>
/// <param name="accountId">The account identifier.</param>
/// <returns>The result.</returns>
public ResultDto DeleteRoom(Guid id, Guid accountId)
{
ResultDto result = new ResultDto();
using (BzsEntityContainer ctx = this.CreateContainer())
{
RoomEntity entity = ctx.RoomSet.FirstOrDefault(f => f.Id == id);
if (entity == null)
{
result.Error = "ERR-ROOM-NOT-EXISTS";
return result;
}
if (entity.AccountId == null)
{
result.Error = "ERR-ROOM-ACCOUNT-INDEPENDENT";
return result;
}
if (entity.AccountId != accountId)
{
result.Error = "ERR-ROOM-ACCOUNT-INVALID";
return result;
}
if (entity.LessonNavProp.Any())
{
result.Error = "ERR-ROOM-USED";
return result;
}
ctx.RoomSet.Remove(entity);
ctx.SaveChanges();
result.Success = true;
return result;
}
}
/// <summary>
/// Deletes a lesson.
/// </summary>
/// <param name="id">The lesson identifier.</param>
/// <param name="accountId">The account identifier.</param>
/// <returns>The result.</returns>
public ResultDto DeleteLesson(Guid id, Guid accountId)
{
ResultDto result = new ResultDto();
using (BzsEntityContainer ctx = this.CreateContainer())
{
LessonEntity entity = ctx.LessonSet.FirstOrDefault(f => f.Id == id);
if (entity == null)
{
result.Error = "ERR-LESSON-NOT-EXISTS";
return result;
}
if (entity.AccountId != accountId)
{
result.Error = "ERR-LESSON-ACCOUNT-INVALID";
return result;
}
ctx.LessonSet.Remove(entity);
ctx.SaveChanges();
result.Success = true;
return result;
}
}
/// <summary>
/// Inserts a room.
/// </summary>
/// <param name="itemToSave">The item to save.</param>
/// <param name="accountId">The account identifier.</param>
/// <returns>The result.</returns>
public ResultDto InsertRoom(RoomEditDto itemToSave, Guid? accountId)
{
ResultDto result = new ResultDto();
using (BzsEntityContainer ctx = this.CreateContainer())
{
RoomEntity entity = ctx.RoomSet.FirstOrDefault(f => f.Id == itemToSave.Id);
if (entity != null)
{
result.Error = "ERR-ROOM-ALREADY-EXISTS";
return result;
}
entity = new RoomEntity();
entity.Id = itemToSave.Id;
entity.AccountId = accountId;
entity.Code = itemToSave.Code.Length > 10 ? itemToSave.Code.Substring(0, 9) : itemToSave.Code;
entity.Caption = itemToSave.Caption.Length > 50 ? itemToSave.Caption.Substring(0, 49) : itemToSave.Caption;
entity.ModDate = DateTime.Now;
entity.ModUser = Environment.UserName;
ctx.RoomSet.Add(entity);
ctx.SaveChanges();
result.Success = true;
}
return result;
}
/// <summary>
/// Updates a lesson.
/// </summary>
/// <param name="itemToSave">The item to save.</param>
/// <param name="accountId">The account identifier.</param>
/// <returns>The result.</returns>
public ResultDto UpdateLesson(LessonEditDto itemToSave, Guid accountId)
{
ResultDto result = new ResultDto();
using (BzsEntityContainer ctx = this.CreateContainer())
{
LessonEntity entity = ctx.LessonSet.FirstOrDefault(f => f.Id == itemToSave.Id);
if (entity == null)
{
result.Error = "ERR-LESSON-NOT-EXISTS";
return result;
}
if (entity.AccountId != accountId)
{
result.Error = "ERR-LESSON-ACCOUNT-INVALID";
return result;
}
entity.DayId = itemToSave.DayId;
entity.FromDate = DateTimeHelper.StringToDateTime(itemToSave.FromDate);
entity.ToDate = DateTimeHelper.StringToDateTime(itemToSave.ToDate);
entity.SubjectId = itemToSave.SubjectId;
entity.TeacherId = itemToSave.TeacherId;
entity.RoomId = itemToSave.RoomId;
entity.Remark = itemToSave.Remark;
entity.ModDate = DateTime.Now;
entity.ModUser = Environment.UserName;
ctx.SaveChanges();
result.Success = true;
return result;
}
}
/// <summary>
/// Inserts or updates a lesson.
/// </summary>
/// <param name="itemToSave">The item to save.</param>
/// <param name="accountId">The account identifier.</param>
/// <returns>The result.</returns>
public ResultDto InsertUpdateLesson(LessonEditDto itemToSave, Guid accountId)
{
ResultDto result = new ResultDto();
using (BzsEntityContainer ctx = this.CreateContainer())
{
LessonEntity entity = ctx.LessonSet.FirstOrDefault(f => f.Id == itemToSave.Id);
if (entity != null)
{
result.Error = "ERR-LESSON-ALREADY-EXISTS";
return result;
}
if (!new DayServerService().DayExists(itemToSave.DayId, ctx))
{
result.Error = "ERR-LESSON-DAY-NOT-EXISTS";
return result;
}
if (!new SubjectServerService().SubjectExists(itemToSave.SubjectId, ctx))
{
result.Error = "ERR-LESSON-SUBJECT-NOT-EXISTS";
return result;
}
if (itemToSave.TeacherId.HasValue && !new TeacherServerService().TeacherExists(itemToSave.TeacherId.Value, ctx))
{
result.Error = "ERR-LESSON-TEACHER-NOT-EXISTS";
return result;
}
if (itemToSave.RoomId.HasValue && !new RoomServerService().RoomExists(itemToSave.RoomId.Value, ctx))
{
result.Error = "ERR-LESSON-ROOM-NOT-EXISTS";
return result;
}
entity = new LessonEntity();
entity.Id = itemToSave.Id;
entity.AccountId = accountId;
entity.DayId = itemToSave.DayId;
entity.FromDate = DateTimeHelper.StringToDateTime(itemToSave.FromDate);
entity.ToDate = DateTimeHelper.StringToDateTime(itemToSave.ToDate);
entity.SubjectId = itemToSave.SubjectId;
entity.TeacherId = itemToSave.TeacherId;
entity.RoomId = itemToSave.RoomId;
entity.Remark = itemToSave.Remark;
entity.ModDate = DateTime.Now;
entity.ModUser = Environment.UserName;
ctx.LessonSet.Add(entity);
ctx.SaveChanges();
result.Success = true;
return result;
}
}
/// <summary>
/// Updates a teacher.
/// </summary>
/// <param name="itemToSave">The item to save.</param>
/// <param name="accountId">The account identifier.</param>
/// <returns>The result.</returns>
public ResultDto UpdateTeacher(TeacherEditDto itemToSave, Guid? accountId)
{
ResultDto result = new ResultDto();
using (BzsEntityContainer ctx = this.CreateContainer())
{
TeacherEntity entity = ctx.TeacherSet.FirstOrDefault(f => f.Id == itemToSave.Id);
if (entity == null)
{
result.Error = "ERR-TEACHER-NOT-EXISTS";
return result;
}
if (entity.AccountId == null || entity.AccountId != accountId)
{
result.Error = "ERR-TEACHER-ACCOUNT-INVALID";
return result;
}
entity.Code = itemToSave.Code.Length > 10 ? itemToSave.Code.Substring(0, 9) : itemToSave.Code;
entity.Caption = itemToSave.Caption.Length > 50 ? itemToSave.Caption.Substring(0, 49) : itemToSave.Caption;
entity.ModDate = DateTime.Now;
entity.ModUser = Environment.UserName;
ctx.SaveChanges();
result.Success = true;
}
return result;
}
