public ActionResult Edit([Bind(Include = "LeaveRequestID,EmployeeID,RequestTime,StartTime,EndTime,LeaveType,LeaveReason,ReviewStatusID,ReviewTime,Attachment")] LeaveRequests leaveRequests) { if (ModelState.IsValid) { if (Request.Files["LeaveFile"].ContentLength != 0) { byte[] data = null; using (BinaryReader br = new BinaryReader( Request.Files["LeaveFile"].InputStream)) { data = br.ReadBytes(Request.Files["LeaveFile"].ContentLength); } leaveRequests.Attachment = data; } else { LeaveRequests L = db.LeaveRequests.Find(leaveRequests.LeaveRequestID); L.EmployeeID = leaveRequests.EmployeeID; L.RequestTime = leaveRequests.RequestTime; L.StartTime = leaveRequests.StartTime; L.EndTime = leaveRequests.StartTime; L.LeaveType = leaveRequests.LeaveType; L.LeaveReason = leaveRequests.LeaveReason; L.LeaveRequestID = leaveRequests.LeaveRequestID; L.RequestTime = leaveRequests.RequestTime; leaveRequests = L; } db.Entry(leaveRequests).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(leaveRequests)); }
public LeaveRequestViewModels(LeaveRequests leaveRequest) { StartDate = Utility.DateToString(leaveRequest.StartDate); EndDate = Utility.DateToString(leaveRequest.EndDate); LeaveType = _leaveTypes.GetLeaveTypeName(leaveRequest.LeaveTypeId); NumberOfDay = Utility.GetNumberOfDay(leaveRequest.StartDate, leaveRequest.EndDate); LeaveTypeId = leaveRequest.LeaveTypeId; }
public ActionResult DeleteConfirmed(string id) { LeaveRequests leaveRequests = db.LeaveRequests.Find(id); db.LeaveRequests.Remove(leaveRequests); db.SaveChanges(); return(RedirectToAction("Index")); }
public int UpdateLeaveRequest(LeaveRequests leaveRequest) { try { _db.Entry(leaveRequest).State = EntityState.Modified; _db.SaveChanges(); return(200); } catch { throw; } }
// GET: LeaveRequests/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LeaveRequests leaveRequests = db.LeaveRequests.Find(id); if (leaveRequests == null) { return(HttpNotFound()); } return(View(leaveRequests)); }
public void UpdateApprovedLeave(Entity target) { try { var entityobj = organizationService.Retrieve("new_leaverequests", target.Id, new ColumnSet(true)); var leaverequest = new LeaveRequests(entityobj); EntityCollection results = null; if (leaverequest.LeaveStatus == eLeaveRequests_LeaveStatus.Approved) { QueryExpression _LeaveBalanceQuery = new QueryExpression { EntityName = "new_leavebalance", ColumnSet = new ColumnSet("new_leavebalance"), Criteria = new FilterExpression { Conditions = { new ConditionExpression { AttributeName = "new_employeeid", Operator = ConditionOperator.Equal, Values = { leaverequest.CreatedBy.Id } }, new ConditionExpression { AttributeName = "new_leavetype", Operator = ConditionOperator.Equal, Values = { leaverequest.LeaveType_OptionSetValue.Value } } } } }; results = organizationService.RetrieveMultiple(_LeaveBalanceQuery); if (results.Entities.Count == 1) { var leavebalance = new LeaveBalance(results.Entities[0]); leavebalance.LeaveBalanceAttribute = leavebalance.LeaveBalanceAttribute - leaverequest.NumberOfDays; leavebalance.Update(organizationService); } } } catch (Exception ex) { throw ex; } }
public ActionResult Create([Bind(Include = "LeaveRequestID,EmployeeID,RequestTime,StartTime,EndTime,LeaveType,LeaveReason,ReviewStatusID,ReviewTime,Attachment")] LeaveRequests leaveRequests) { if (ModelState.IsValid) { if (Request.Files["LeaveFile"].ContentLength != 0) { byte[] data = null; using (BinaryReader br = new BinaryReader( Request.Files["LeaveFile"].InputStream)) { data = br.ReadBytes(Request.Files["LeaveFile"].ContentLength); } leaveRequests.Attachment = data; } db.LeaveRequests.Add(leaveRequests); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(leaveRequests)); }