public Leave AddLeave(LeaveTypeEnum leavesType, DateTimeOffset startDate, DateTimeOffset endDate, string purpose, string delegation, DateTimeOffset createDate)
{
TimeSpan span = endDate.Subtract(startDate);
double duration = span.TotalDays + 1;
double remaining = 12 - duration;
//if leave not null then remaining equal to latest remaining minus duration
if (Leaves.Count > 0)
{
remaining = Leaves.Select(o => o.Remaining).Max();
remaining = remaining - duration;
}
//no idea
bool status = false;
var leave = new Leave(Guid.NewGuid(), this.Identity, leavesType, startDate, endDate, purpose, delegation, duration, remaining, status, createDate);
if (Leaves == null)
{
Leaves = new List <Leave>().AsReadOnly();
}
var list = Leaves.ToList();
list.Add(leave);
ReadModel.Leaves.Add(new LeaveReadModel(leave));
Leaves = list.AsReadOnly();
return(leave);
}
private void GetLeaveApplications_ByApproverId(int statusId)
{
LeaveTypeEnum leaveType = LeaveTypeEnum.None;
DateTime fromApplicationDate = DateTime.MinValue;
DateTime toApplicationDate = DateTime.MinValue;
DataTable dtLeaveApplicationMaster =
new Business.LeaveManagement.LeaveApprovalDetails()
.GetLeaveApplications_ByApproverId(Convert.ToInt32(HttpContext.Current.User.Identity.Name), statusId, leaveType, fromApplicationDate, toApplicationDate);
gvLeavePending.DataSource = dtLeaveApplicationMaster;
gvLeavePending.DataBind();
}
private void GetLeaveApplications_ByApproverId(int statusId)
{
LeaveTypeEnum leaveType = (LeaveTypeEnum)Enum.Parse(typeof(LeaveTypeEnum), ddlLeaveType.SelectedValue);
DateTime fromApplicationDate = string.IsNullOrEmpty(txtFromLeaveDate.Text.Trim()) ? DateTime.MinValue : Convert.ToDateTime(txtFromLeaveDate.Text.Trim());
DateTime toApplicationDate = string.IsNullOrEmpty(txtToLeaveDate.Text.Trim()) ? DateTime.MinValue : Convert.ToDateTime(txtToLeaveDate.Text.Trim());
DataTable dtLeaveApplicationMaster =
new Business.LeaveManagement.LeaveApprovalDetails()
.GetLeaveApplications_ByApproverId(Convert.ToInt32(HttpContext.Current.User.Identity.Name), statusId, leaveType, fromApplicationDate, toApplicationDate);
gvLeaveApprovalList.DataSource = dtLeaveApplicationMaster;
gvLeaveApprovalList.DataBind();
}
public Leave(Guid id, Guid employeeId, LeaveTypeEnum leaveType, DateTimeOffset startDate, DateTimeOffset endDate, string purpose, string delegation, double duration, double remaining, bool status, DateTimeOffset createDate)
{
Identity = id;
EmployeeId = employeeId;
LeaveType = leaveType;
StartDate = startDate;
EndDate = endDate;
Purpose = purpose;
Delegation = delegation;
Duration = duration;
Remaining = remaining;
Status = status;
CreateDate = createDate;
this.AddDomainEvent(new LeaveCreated(this));
}
public Leave(DateTime startingDate, int duration, LeaveTypeEnum leaveType)
{
this.startingDate = startingDate;
this.duration = duration;
this.leaveType = leaveType;
}
public DataTable GetLeaveApplications_ByApproverId(int approverId, int statusId, LeaveTypeEnum leaveType, DateTime fromApplicationDate, DateTime toApplicationDate)
{
return(DataAccess.LeaveManagement.LeaveApprovalDetails.GetLeaveApplications_ByApproverId(approverId, statusId, leaveType, fromApplicationDate, toApplicationDate));
}
public static DataTable GetLeaveApplications_ByApproverId(int approverId, int statusId, LeaveTypeEnum leaveType, DateTime fromApplicationDate, DateTime toApplicationDate)
{
using (DataTable dt = new DataTable())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_GetLeaveApplications_ByApproverId";
cmd.Parameters.AddWithValue("@ApproverId", approverId);
if (statusId == 0)
{
cmd.Parameters.AddWithValue("@Status", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Status", statusId);
}
if (leaveType == LeaveTypeEnum.None)
{
cmd.Parameters.AddWithValue("@LeaveTypeId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@LeaveTypeId", (int)leaveType);
}
if (fromApplicationDate == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@FromLeaveApplicationDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@FromLeaveApplicationDate", fromApplicationDate);
}
if (toApplicationDate == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@ToLeaveApplicationDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ToLeaveApplicationDate", toApplicationDate);
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
