public Message EngClassRegister(Training_Attendee objUI)
{
Message msg = null;
try
{
if (!isDublicateEmpId(objUI))
{
objUI.CreateDate = DateTime.Now;
objUI.UpdateDate = DateTime.Now;
objUI.DeleteFlag = false;
objUI.StatusId = Constants.TRAINING_REGISTRATION_STATUS_NEW;
objUI.SubmittingDate = DateTime.Now;
dbContext.Training_Attendees.InsertOnSubmit(objUI);
dbContext.SubmitChanges();
// Show success message
msg = new Message(MessageConstants.I0001, MessageType.Info, "Registration for this class ", "added");
}
else
{
msg = new Message(MessageConstants.E0020, MessageType.Error, "Your name is ", "in this class");
}
}
catch (Exception ex)
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
throw ex;
}
return msg;
}
public Message ApproveAttendee(Training_Attendee objUI)
{
Message msg = null;
try
{
if (objUI != null)
{
// Get current group in dbContext
Training_Attendee objDb = GetAttendeeByClassId(objUI.ClassId);
if (objDb != null)
{
// Update info by objUI
objDb.StatusId = Constants.TRAINING_REGISTRATION_STATUS_APPROVED;
objDb.UpdateDate = DateTime.Now;
objDb.UpdatedBy = objUI.UpdatedBy;
// Submit changes to dbContext
dbContext.SubmitChanges();
// Show success message
msg = new Message(MessageConstants.I0001, MessageType.Info, "Attendee '" + objDb.ClassId + "'", "approved");
}
}
}
catch
{
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public void Delete(Training_Attendee attendee)
{
try
{
var objDb = GetById(attendee.Id);
objDb.DeleteFlag = true;
objDb.Remark = attendee.Remark;
objDb.Result = attendee.Result;
objDb.Priority = attendee.Priority;
objDb.UpdateDate = DateTime.Now;
objDb.UpdatedBy = HttpContext.Current.User.Identity.Name;
dbContext.SubmitChanges();
}
catch
{
return;
}
}
private bool isDublicateEmpId(Training_Attendee objUI)
{
bool isDublicateName = true;
Training_Attendee dublicateName = dbContext.Training_Attendees.Where(a => a.ClassId.Equals(objUI.ClassId) && a.DeleteFlag == false && a.EmpId == objUI.EmpId).FirstOrDefault<Training_Attendee>();
if (dublicateName == null || dublicateName.EmpId != objUI.EmpId)
{
isDublicateName = false;
}
return isDublicateName;
}
public Message Update(Training_Attendee attendee)
{
try
{
var objDb = GetById(attendee.Id);
objDb.UpdatedBy = HttpContext.Current.User.Identity.Name;
objDb.UpdateDate = DateTime.Now;
objDb.EmpId = attendee.EmpId;
objDb.ManagerId = attendee.ManagerId;
objDb.Remark = attendee.Remark;
objDb.Result = attendee.Result;
objDb.Priority = attendee.Priority;
objDb.StatusId = attendee.StatusId;
dbContext.SubmitChanges();
return new Message(MessageConstants.I0001, MessageType.Info, "Attendee " + emp.FullName(attendee.EmpId, Constants.FullNameFormat.FirstMiddleLast), "updated");
}
catch
{
return new Message(MessageConstants.E0007, MessageType.Error);
}
}
public Message Insert(Training_Attendee attendee)
{
try
{
attendee.CreatedBy = attendee.UpdatedBy = HttpContext.Current.User.Identity.Name;
attendee.CreateDate = attendee.UpdateDate = attendee.SubmittingDate= DateTime.Now;
dbContext.Training_Attendees.InsertOnSubmit(attendee);
dbContext.SubmitChanges();
return new Message(MessageConstants.I0001, MessageType.Info, "Attendee " + attendee.EmpId, "added");
}
catch
{
return new Message(MessageConstants.E0007, MessageType.Error);
}
}
