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