public LeaveDays SetLeaveDays(int CasualLeave, int SickLeave, int WorkingHours, string SessionId, string SessionValue) { var leaveDays = new LeaveDays {StatusText = "Session out, please login again"}; CasualLeave = (CasualLeave == null) ? 0 : CasualLeave; SickLeave = (SickLeave == null) ? 0 : SickLeave; WorkingHours = (WorkingHours == null) ? 0 : WorkingHours; SessionId = LeaveRegisterUtils.DecryptPassword(SessionId); SessionValue = LeaveRegisterUtils.DecryptPassword(SessionValue); if (!DataBaseUtils.IsEmployeeLoggedIn(ConnectionString, SessionId, SessionValue)) { return leaveDays; } var employeeid = DataBaseUtils.GetEmployeeId(ConnectionString, SessionId); if (!DataBaseUtils.IsAdminEmployee(ConnectionString, employeeid)) { leaveDays.StatusText = "Leave configuration can be set only <b>Admin</b> employee"; return leaveDays; } if ( DataBaseUtils.SetLeaveConfigurationInformations(ConnectionString, SickLeave, CasualLeave, WorkingHours) != "Success") { leaveDays.StatusText = "Some problem occure during setting the configuration, please try lator"; return leaveDays; } return DataBaseUtils.GetLeaveConfigurationDetailes(ConnectionString); }
/// <summary> /// Get leave configuration informations like casual, sick leaves and total working hours /// </summary> public static LeaveDays GetLeaveConfigurationDetailes(string ConnectionString) { var leavDays = new LeaveDays { StatusText = "Failed" }; var con = new SqlConnection(ConnectionString); try { using (var cmd = new SqlCommand(StoreProcedureGetLeavesAndWorkingHours, con)) { cmd.CommandType = CommandType.StoredProcedure; con.Open(); var dr = cmd.ExecuteReader(); while (dr.Read()) { leavDays.CasualLeave = (int)dr["TotalCasualLeave"]; leavDays.SickLeave = (int)dr["ToatlSickLeave"]; leavDays.TotalWorkingHours = (int)dr["TotalWorkingHours"]; leavDays.StatusText = "Success"; } con.Close(); } return leavDays; } catch (Exception) { return leavDays; } }
public LeaveDays GetLeaveDays(string SessionKey, string SessionValue) { var leaveDays = new LeaveDays {StatusText = "Session out, please login again"}; SessionKey = LeaveRegisterUtils.DecryptPassword(SessionKey); SessionValue = LeaveRegisterUtils.DecryptPassword(SessionValue); if (!DataBaseUtils.IsEmployeeLoggedIn(ConnectionString, SessionKey, SessionValue)) { return leaveDays; } var employeeId = DataBaseUtils.GetEmployeeId(ConnectionString, SessionKey); if (!DataBaseUtils.IsAdminEmployee(ConnectionString, employeeId)) { leaveDays.StatusText = "Leave configuration data can be see only <b>Admin</b> employee"; return leaveDays; } return DataBaseUtils.GetLeaveConfigurationDetailes(ConnectionString); }