public long AcceptEvent(UserEventAdminListViewModel userEventModel) { var result = 0; try { if (userEventModel.UeCount == 2) { using (TransactionScope scope = new TransactionScope()) { result = db.Database.ExecuteSqlCommand("exec proc_as_AcceptNghiPhep @UserID, @UeID", new SqlParameter("@UserID", userEventModel.UserID), new SqlParameter("@UeID", userEventModel.UeID)); scope.Complete(); } } else { using (TransactionScope scope = new TransactionScope()) { result = db.Database.ExecuteSqlCommand("exec proc_as_AcceptUpdateAttanceDanceForUser @UserID, @UeType, @UeID", new SqlParameter("@UserID", userEventModel.UserID), new SqlParameter("@UeType", userEventModel.UeCount), new SqlParameter("@UeID", userEventModel.UeID)); scope.Complete(); } } } catch (Exception ex) { throw ex; } return(result); }
public IEnumerable <UserEventAdminListViewModel> UeListAllForAdmin() { UsersDAL userModel = new UsersDAL(); var model = db.tbl_UserEvent.ToList(); List <UserEventAdminListViewModel> liHomeView = new List <UserEventAdminListViewModel>(); foreach (var item in model) { UserEventAdminListViewModel ueModel = new UserEventAdminListViewModel(); ueModel.UserID = item.UserID; ueModel.UserFullName = userModel.GetUser(item.UserID).UserFullName; ueModel.UserPhone = userModel.GetUser(item.UserID).UserPhone; ueModel.UeDateExpires = item.UeDateExpires; ueModel.UeWillExpires = item.UeWillExpires; ueModel.UeNote = item.UeNote; ueModel.Loai = item.UeCount == (int)Enums.EventType.CongTac ? "Công Tác" : "Nghỉ Phép"; ueModel.Color = item.UeCount == 1 ? item.UeOk == true? "success": "default" : item.UeOk == true ? "success" : "danger"; ueModel.UeOk = item.UeOk; ueModel.UeID = item.UeID; ueModel.UeCount = item.UeCount; liHomeView.Add(ueModel); //Edit 0608 } return(liHomeView); }
public ActionResult Accept(UserEventAdminListViewModel model) { try { if (!ModelState.IsValid) { return(View()); } userDAL.AcceptEvent(model); return(RedirectToAction("Index", "Home")); } catch (Exception ex) { ModelState.AddModelError("", ex.Message); return(View(model)); } }