public Boolean Insert(LeaveENT entLeave, SqlInt32 UserID)
{
LeaveDAL dalLeave = new LeaveDAL();
if (dalLeave.Insert(entLeave, UserID))
{
return(true);
}
else
{
Message = dalLeave.Message;
return(false);
}
}
public Boolean UpdateLeaveStatusInLeave(LeaveENT entLeave, SqlInt32 LeaveID)
{
LeaveDAL dalLeave = new LeaveDAL();
if (dalLeave.UpdateLeaveStatusInLeave(entLeave, LeaveID))
{
return(true);
}
else
{
Message = dalLeave.Message;
return(false);
}
}
public static List <LeaveEntity> GetAllReasons()
{
List <LeaveEntity> reasons = null;
try
{
reasons = LeaveDAL.GetAllReasons();
}
catch (LeaveException)
{
throw;
}
return(reasons);
}
public Boolean DeleteAll(SqlInt32 UserID)
{
LeaveDAL dalLeave = new LeaveDAL();
if (dalLeave.DeleteAll(UserID))
{
return(true);
}
else
{
Message = dalLeave.Message;
return(false);
}
}
public static bool LoginUser(LoginEntity login)
{
bool success = false;
try
{
success = LeaveDAL.LoginUser(login);
}
catch (LeaveException)
{
throw;
}
return(true);
}
public static bool AddLeave(LeaveEntity leave)
{
bool added = false;
try
{
added = LeaveDAL.AddLeave(leave);
}
catch (LeaveException)
{
throw;
}
return(added);
}
public DataTable SelectAllByUserID(SqlInt32 UserID)
{
LeaveDAL dalLeave = new LeaveDAL();
DataTable dt = new DataTable();
dt = dalLeave.SelectAllByUserID(UserID);
if (dt == null)
{
Message = dalLeave.Message;
return(null);
}
else
{
return(dt);
}
}
public void Update_Leave(Leave l_id)
{
LeaveDAL DDAL = new LeaveDAL();
try
{
DDAL.Update_Leave(l_id);
}
catch (Exception)
{
throw;
}
finally
{
DDAL = null;
}
}
public int Insert(Leave leave)
{
LeaveDAL ADAL = new LeaveDAL();
try
{
return(ADAL.Insert(leave));
}
catch (Exception)
{
throw;
}
finally
{
leave = null;
}
}
public int Delete_leave(Leave leave)
{
LeaveDAL ADAL = new LeaveDAL();
try
{
return(ADAL.Delete_Leave(leave));
}
catch (Exception)
{
throw;
}
finally
{
leave = null;
}
}
internal static GetWorkingDaysResponse getWorkingDays(GetWorkingDaysRequest getLeaveDaysRequest, HttpRequestMessage request)
{
GetWorkingDaysResponse response = new GetWorkingDaysResponse();
try
{
LeaveDAL leaveDAL = new LeaveDAL();
var sessionDetails = AuthDAL.getSession(getLeaveDaysRequest.Fb_id);
var leaveDaysDataSet = leaveDAL.Employee_GetLeaveDay(
getLeaveDaysRequest.From_Date,
getLeaveDaysRequest.To_Date,
getLeaveDaysRequest.From_Time,
getLeaveDaysRequest.To_Time,
sessionDetails["UserGUID"] as string,
sessionDetails["CompanyGUID"] as string
);
// ToDo: Calculate the current balance and check if the required leaves is within the range
//leaveDAL.Get_CurrentBalance(
// sessionDetails["UserGUID"] as string,
// getLeaveDaysRequest.LeaveTypeId,
// new DateTime().Year,
// );
response.Success = true;
response.Days = leaveDaysDataSet.Tables[0].Rows[0]["LeaveDays"] as int?;
return(response);
}
catch (Exception ex)
{
response.Success = false;
response.Error = new Error
{
Id = ErrorCode.INTERNAL_ERROR,
Message = ex.Message
};
throw new HttpResponseException(request.CreateResponse(HttpStatusCode.InternalServerError, response));
}
}
public static DataSet GetLeaveList(string where)
{
return(LeaveDAL.GetLeaveList(where));
}
public static DataSet GetLeaveByID(string id)
{
return(LeaveDAL.GetLeaveList("ID=" + id));
}
public LeaveENT SelectTotalDaysByLeaveTypeIDUserID(SqlInt32 LeaveTypeID, SqlInt32 UserID)
{
LeaveDAL dalLeave = new LeaveDAL();
return(dalLeave.SelectTotalDaysByLeaveTypeIDUserID(LeaveTypeID, UserID));
}
public LeaveENT SelectLeaveStatusByPK(SqlInt32 LeaveID)
{
LeaveDAL dalLeave = new LeaveDAL();
return(dalLeave.SelectLeaveStatusByPK(LeaveID));
}
public static void UpdateLeave(int ID, DateTime punchIn, DateTime punchOut)
{
LeaveDAL.UpdateLeave(punchIn, punchOut, ID);
}
public static void InsertLeave(int UserID, string userName, DateTime punchIn)
{
LeaveDAL.InsertLeave(UserID, userName, punchIn);
}
public static void UpdateLeave(int UserID, DateTime punchOut)
{
LeaveDAL.UpdateLeave(punchOut, UserID);
}
public DataTable SelectForDropDownList()
{
LeaveDAL dalLeave = new LeaveDAL();
return(dalLeave.SelectForDropDownList());
}
public static void DeleteLeave(string IDs)
{
LeaveDAL.DeleteLeave(IDs);
}
public LeaveENT SelectByPK(SqlInt32 LeaveID, SqlInt32 UserID)
{
LeaveDAL dalLeave = new LeaveDAL();
return(dalLeave.SelectByPK(LeaveID, UserID));
}
