public static List <EmployeeLeaveDays> GetEmployeeLeaveDaysList(int employeeId, int financialPeriodId) { List <EmployeeLeaveDays> list = new List <EmployeeLeaveDays>(); Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetEmployeeLeaveDaysList"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@EmployeeId", DbType.Int32, employeeId); db.AddInParameter(dbCommand, "@FinancialPeriodId", DbType.Int32, financialPeriodId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { EmployeeLeaveDays employeeLeaveDays = new EmployeeLeaveDays(); employeeLeaveDays.EmployeeId = employeeId; employeeLeaveDays.FinancialPeriodId = financialPeriodId; employeeLeaveDays.EmployeeLeaveDaysId = Convert.ToInt32(dataReader["EmployeeLeaveDaysId"]); employeeLeaveDays.EmployeeLeaveId = Convert.ToInt32(dataReader["EmployeeLeaveId"]); employeeLeaveDays.StartDate = Convert.ToDateTime(dataReader["StartDate"]); employeeLeaveDays.EndDate = Convert.ToDateTime(dataReader["EndDate"]); employeeLeaveDays.Days = Convert.ToDecimal(dataReader["Days"]); employeeLeaveDays.Comment = dataReader["Comment"].ToString(); employeeLeaveDays.LeaveTypeId = Convert.ToInt32(dataReader["LeaveTypeId"]); employeeLeaveDays.LeaveType = dataReader["LeaveType"].ToString(); employeeLeaveDays.isApproved = Convert.ToInt32(dataReader["isApproved"]); employeeLeaveDays.Attachment = dataReader["Attachment"].ToString(); list.Add(employeeLeaveDays); } } return(list); }
public static EmployeeLeaveDays GetEmployeeLeaveDaysByEmployeeIdFinancialPeriodId(int employeeId, int financialPeriodId) { Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetEmployeeLeaveDaysByEmployeeIdFinancialPeriodId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@EmployeeId", DbType.Int32, employeeId); db.AddInParameter(dbCommand, "@FinancialPeriodId", DbType.Int32, financialPeriodId); db.AddOutParameter(dbCommand, "@EmployeeLeaveDaysId", DbType.Int32, 4); db.AddOutParameter(dbCommand, "@StartDate", DbType.DateTime, 8); db.AddOutParameter(dbCommand, "@EndDate", DbType.DateTime, 8); db.AddOutParameter(dbCommand, "@Days", DbType.Decimal, 8); db.AddOutParameter(dbCommand, "@Comment", DbType.String, 500); db.AddOutParameter(dbCommand, "@LeaveTypeId", DbType.Int32, 4); db.ExecuteNonQuery(dbCommand); EmployeeLeaveDays employeeLeaveDays = new EmployeeLeaveDays(); employeeLeaveDays.EmployeeId = employeeId; employeeLeaveDays.FinancialPeriodId = financialPeriodId; employeeLeaveDays.EmployeeLeaveDaysId = Convert.ToInt32(db.GetParameterValue(dbCommand, "EmployeeLeaveDaysId")); employeeLeaveDays.StartDate = Convert.ToDateTime(db.GetParameterValue(dbCommand, "StartDate")); employeeLeaveDays.EndDate = Convert.ToDateTime(db.GetParameterValue(dbCommand, "EndDate")); employeeLeaveDays.Days = Convert.ToDecimal(db.GetParameterValue(dbCommand, "Days")); employeeLeaveDays.Comment = db.GetParameterValue(dbCommand, "Comment").ToString(); employeeLeaveDays.LeaveTypeId = Convert.ToInt32(db.GetParameterValue(dbCommand, "LeaveTypeId")); return(employeeLeaveDays); }
public static List <EmployeeLeaveDays> GetReportEmployeeLeaveHeader(/*int employeeId,*/ int financialPeriodId, int locationId, int leaveTypeId, DateTime dateFrom, DateTime dateTo, int isApproved) { List <EmployeeLeaveDays> list = new List <EmployeeLeaveDays>(); Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetReportEmployeeLeaveHeader"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@FinancialPeriodId", DbType.Int32, financialPeriodId); db.AddInParameter(dbCommand, "@LocationId", DbType.Int32, locationId); db.AddInParameter(dbCommand, "@LeaveTypeId", DbType.Int32, leaveTypeId); db.AddInParameter(dbCommand, "@DateFrom", DbType.DateTime, dateFrom); db.AddInParameter(dbCommand, "@DateTo", DbType.DateTime, dateTo); db.AddInParameter(dbCommand, "@IsApproved", DbType.Int32, isApproved); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { EmployeeLeaveDays employeeLeaveDays = new EmployeeLeaveDays(); employeeLeaveDays.EmployeeId = Convert.ToInt32(dataReader["EmployeeId"]); employeeLeaveDays.CurrentDays = Convert.ToDecimal(dataReader["CurrentDays"]); employeeLeaveDays.EntitledDays = Convert.ToDecimal(dataReader["EntitledDays"]); employeeLeaveDays.EmployeeNumber = dataReader["EmployeeNumber"].ToString(); employeeLeaveDays.FirstName = dataReader["FirstName"].ToString(); employeeLeaveDays.LastName = dataReader["LastName"].ToString(); employeeLeaveDays.FinancialPeriod = dataReader["FinancialPeriod"].ToString(); //employeeLeaveDays.StartDate = Convert.ToDateTime(dataReader["StartDate"]); //employeeLeaveDays.EndDate = Convert.ToDateTime(dataReader["EndDate"]); //employeeLeaveDays.Days = Convert.ToDecimal(dataReader["Days"]); employeeLeaveDays.TotalDays = Convert.ToDecimal(dataReader["TotalDays"]); employeeLeaveDays.EmployeeLeaveProjection = Convert.ToDecimal(dataReader["EmployeeLeaveProjection"]); employeeLeaveDays.Comment = dataReader["Comment"].ToString(); employeeLeaveDays.ReportsToComment = dataReader["ReportsToComment"].ToString(); employeeLeaveDays.LeaveType = dataReader["LeaveType"].ToString(); list.Add(employeeLeaveDays); } } return(list); }
public static List <EmployeeLeaveDays> GetEmployeeListFilterByReportsToId(string searchValue, int accountId, int financialPeriodId) { List <EmployeeLeaveDays> list = new List <EmployeeLeaveDays>(); Database db = DatabaseFactory.CreateDatabase("Spar-StoreRep"); string sqlCommand = "GetEmployeeListFilterByReportsToId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@SearchValue", DbType.String, searchValue); db.AddInParameter(dbCommand, "@AccountId", DbType.Int32, accountId); db.AddInParameter(dbCommand, "@FinancialPeriodId", DbType.Int32, financialPeriodId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { EmployeeLeaveDays employeeLeaveDays = new EmployeeLeaveDays(); employeeLeaveDays.EmployeeId = Convert.ToInt32(dataReader["EmployeeId"]); employeeLeaveDays.EmployeeNumber = dataReader["EmployeeNumber"].ToString(); employeeLeaveDays.FirstName = dataReader["FirstName"].ToString(); employeeLeaveDays.LastName = dataReader["LastName"].ToString(); employeeLeaveDays.Email = dataReader["Email"].ToString(); employeeLeaveDays.ReportsToEmail = dataReader["ReportsToEmail"].ToString(); employeeLeaveDays.EmployeeLeaveDaysId = Convert.ToInt32(dataReader["EmployeeLeaveDaysId"]); employeeLeaveDays.EmploymentType = dataReader["EmploymentType"].ToString(); employeeLeaveDays.StartDate = Convert.ToDateTime(dataReader["StartDate"]); employeeLeaveDays.EndDate = Convert.ToDateTime(dataReader["EndDate"]); employeeLeaveDays.Days = Convert.ToDecimal(dataReader["Days"]); employeeLeaveDays.isApproved = Convert.ToInt32(dataReader["isApproved"]); employeeLeaveDays.LeaveType = dataReader["LeaveType"].ToString(); employeeLeaveDays.FinancialPeriod = dataReader["FinancialPeriod"].ToString(); list.Add(employeeLeaveDays); } } return(list); }