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); } }