Log File Initialized... 1/22/2025 12:19:53 AM
1/22/2025 12:19:53 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 12:26:55 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 12:28:31 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 1:17:37 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 2:12:57 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 4:19:06 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 4:58:06 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 5:06:28 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 5:40:18 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 5:53:13 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 5:56:41 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 6:10:26 AM: Invalid Credentials
ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record)
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password)
   at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e)
1/22/2025 6:10:26 AM: Invalid Credentials
ZealERP.ZealFramework.Utils.ZealException: Invalid Credentials
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.ValidateUser(User record)
   at ZealERP.ZealSecurity.Services.NewSecurity.UserService.Login(String UserId, String password)
   at ZealERP.ZealTakaful.TravelTakafulLogin.btnLogin_Click(Object sender, EventArgs e)
1/22/2025 6:10:38 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 7:57:56 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 8:45:46 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 8:56:35 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 9:04:22 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 9:22:53 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 9:27:08 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 9:29:56 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 9:31:24 AM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 5:03:51 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 9:08:50 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 9:46:33 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 10:25:18 PM: Could not find a part of the path 'D:\AAK\ZealERPTest\Uploads\TicketUploads\Profiles\735\null'.
System.IO.DirectoryNotFoundException: Could not find a part of the path 'D:\AAK\ZealERPTest\Uploads\TicketUploads\Profiles\735\null'.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
   at System.IO.FileStream..ctor(String path, FileMode mode)
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetFile(FileDownload FileLogic)
1/22/2025 10:28:30 PM: No Org Mapped for User
1/22/2025 10:29:49 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 10:35:39 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 10:50:08 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 10:50:08 PM: Thread was being aborted.
System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.AbortCurrentThread()
   at System.Web.HttpResponse.End()
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at System.Web.HttpResponse.Redirect(String url)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 11:06:20 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 11:06:20 PM: Thread was being aborted.
System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.AbortCurrentThread()
   at System.Web.HttpResponse.End()
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at System.Web.HttpResponse.Redirect(String url)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 11:08:52 PM:  WITH PERIODINFO AS (SELECT MAX(B.PAYPERIODSDATESID) AS PAYPERIODSDATESID, B.PAYROLLCALANDERID, B.ORG_ID, E.employeeid FROM EMPLOYEE E INNER JOIN EndEmployment E_EMP ON (E_EMP.ORG_ID = E.ORG_ID AND E_EMP.EMPLOYEEID = E.EMPLOYEEID) INNER JOIN ASSIGNMENTS A ON (E.ORG_ID = A.ORG_ID AND E.EMPLOYEEID = A.EMPLOYEEID) LEFT JOIN ELEMENTENTRIESDETAIL B ON (A.ORG_ID = B.ORG_ID AND A.PAYROLLCALANDERID = B.PAYROLLCALANDERID AND E.EMPLOYEEID = B.EMPLOYEEID) INNER JOIN PayTimePeriodsDates C ON (B.ORG_ID = C.ORG_ID AND B.PAYROLLCALANDERID = C.PAYROLLCALANDERID AND B.PAYPERIODSDATESID = C.PAYPERIODSDATESID AND C.STATUS = 'Close') INNER JOIN PayElements P ON (B.ORG_ID = P.ORG_ID AND B.ELEMENTID = P.ELEMENTID AND P.REPORTINGNAME = 'Attendance') WHERE NVL(B.ELEMENTVALUE, 0) <> 0 GROUP BY B.PAYROLLCALANDERID, B.ORG_ID, E.employeeid ) SELECT TO_CHAR(A.ENDDATE, 'dd-Mon-yyyy') AS ENDDATE, TO_CHAR(B.LAST_DATE, 'dd-Mon-yyyy') AS LastDate, ABS(TRUNC(A.ENDDATE - B.LAST_DATE)) AS TotalDays, ABS(TRUNC(B.LAST_DATE - A.ENDDATE)) AS TotalDayss, B.FINAL_SETTLMENT_ID, B.EMPLOYEE_ID, C.EMPLOYEENUMBER, C.EMPLOYEENUMBER || '-' || C.FirstName || ' ' || C.MiddleName || ' ' || C.LastName AS EmployeeName, TO_CHAR(B.CREATION_DATE, 'dd-Mon-yyyy') AS CREATION_DATE, TO_CHAR(B.NOTIFY_DATE, 'dd-Mon-yyyy') AS NotifyDate, TO_CHAR(B.FINAL_PROCESS_DATE, 'dd-Mon-yyyy') AS FinalProcessDate, B.REASON, B.REMARKS, B.ELIGIBLE_FOR_REHIRE, D.DESCRIPTION AS ReasonName, B.FINAL_SETTLEMENT_TAG,A.PAYROLLCALANDERID,B.CREATED_BY FROM PayTimePeriodsDates A INNER JOIN PERIODINFO P ON (A.ORG_ID = P.ORG_ID AND A.PAYROLLCALANDERID = P.PAYROLLCALANDERID AND A.PAYPERIODSDATESID = P.PAYPERIODSDATESID) INNER JOIN FINAL_SETTLEMENT_PROCESS_T B ON (P.EMPLOYEEID = B.EMPLOYEE_ID AND P.ORG_ID = B.ORG_ID) INNER JOIN Employee C ON (B.EMPLOYEE_ID = C.EmployeeID AND B.ORG_ID = C.ORG_ID) INNER JOIN GEN_PARAM_SETUPHD_T E ON (E.ORG_ID = B.ORG_ID AND E.APPLICATION_ID = 22 AND E.SETUP_NAME = 'Reason') INNER JOIN GEN_PARAM_SETUP_DTL_T D ON (E.ORG_ID = D.ORG_ID AND E.APPLICATION_ID = D.APPLICATION_ID AND E.SETUP_ID = D.SETUP_ID AND D.ABBREVIATION = TO_CHAR(B.REASON)) WHERE E.ORG_ID = 10
1/22/2025 11:08:52 PM: Error in route [api/EmployeeSetup/GetEndEmploymentFS] class: EmployeeSetupController:
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00942: table or view does not exist
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.ManagedDataAccess.Client.OracleDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans, Boolean PrintLog)
   at ZealERP.ZealFramework.Utils.DB.ExecuteQuery(String query)
   at ZealERP.ZealTakaful.Services.HCM.EmployeeSetupService.GetEndEmploymentFS(CommonParamsDataModel model)
   at ZealERP.ZealTakaful.Controllers.HCM.EmployeeSetupController.<>c__DisplayClass33_0.<GetEndEmploymentFS>b__0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
1/22/2025 11:20:42 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 11:21:27 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 11:21:27 PM: Thread was being aborted.
System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.AbortCurrentThread()
   at System.Web.HttpResponse.End()
   at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
   at System.Web.HttpResponse.Redirect(String url)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 11:27:18 PM: insert into GEN_PARAM_SETUP_DTL_T (ORG_ID,APPLICATION_ID,SETUP_ID,CODE,DESCRIPTION,ACTIVE,ABBREVIATION,DEFAUL_TAG,SHORT_CODE,REMARKS,DISPLAY_ORDER,CREATED_BY,CREATION_DATE) values (:ORG_ID,:APPLICATION_ID,:SETUP_ID,:CODE,:DESCRIPTION,:ACTIVE,:ABBREVIATION,:DEFAUL_TAG,:SHORT_CODE,:REMARKS,:DISPLAY_ORDER,:CREATED_BY,:CREATION_DATE)  params: ORG_ID=5, APPLICATION_ID=22, SETUP_ID=479, CODE=1, DESCRIPTION=Confirmation Date, ACTIVE=Y, ABBREVIATION=CONFIRMATIONDATE, DEFAUL_TAG=N, SHORT_CODE=, REMARKS=, DISPLAY_ORDER=, CREATED_BY=SHAHZAD, CREATION_DATE=1/22/2025 11:27:18 PM
1/22/2025 11:27:18 PM: ORA-02291: integrity constraint (ZEAL_ERP.FK_PARAM_HD) violated - parent key not found
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-02291: integrity constraint (ZEAL_ERP.FK_PARAM_HD) violated - parent key not found
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans)
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, OracleCommand trans)
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.ExecuteQuery(String query, OracleParameter[] query_params, OracleCommand command)
1/22/2025 11:27:18 PM: ORA-02291: integrity constraint (ZEAL_ERP.FK_PARAM_HD) violated - parent key not found
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-02291: integrity constraint (ZEAL_ERP.FK_PARAM_HD) violated - parent key not found
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans)
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, OracleCommand trans)
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.ExecuteQuery(String query, OracleParameter[] query_params, OracleCommand command)
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadGenParamsDetail(String OrgId, DataTable dt, Boolean AppendRecords, OracleCommand command)
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model, OracleCommand command)
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.<>c__DisplayClass177_0.<UploadItems>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model)
1/22/2025 11:27:18 PM: Error.. in Sheet: Sheet1 at Row No:1 ORA-02291: integrity constraint (ZEAL_ERP.FK_PARAM_HD) violated - parent key not found
1/22/2025 11:27:18 PM: Error in route [api/ZealUploadUtility/UploadFile] class: ZealUploadUtilityController:
ZealERP.ZealFramework.Utils.ZealException: Error.. in Sheet: Sheet1 at Row No:1 ORA-02291: integrity constraint (ZEAL_ERP.FK_PARAM_HD) violated - parent key not found
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model)
   at ZealERP.ZealTakaful.Controllers.GLAS.ZealUploadUtilityController.<UploadFile>b__3_0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
1/22/2025 11:35:17 PM: insert into GEN_PARAM_SETUP_DTL_T (ORG_ID,APPLICATION_ID,SETUP_ID,CODE,DESCRIPTION,ACTIVE,ABBREVIATION,DEFAUL_TAG,SHORT_CODE,REMARKS,DISPLAY_ORDER,CREATED_BY,CREATION_DATE) values (:ORG_ID,:APPLICATION_ID,:SETUP_ID,:CODE,:DESCRIPTION,:ACTIVE,:ABBREVIATION,:DEFAUL_TAG,:SHORT_CODE,:REMARKS,:DISPLAY_ORDER,:CREATED_BY,:CREATION_DATE)  params: ORG_ID=5, APPLICATION_ID=22, SETUP_ID=563, CODE=1, DESCRIPTION=Confirmation Date, ACTIVE=Y, ABBREVIATION=CONFIRMATIONDATE, DEFAUL_TAG=N, SHORT_CODE=, REMARKS=, DISPLAY_ORDER=, CREATED_BY=SHAHZAD, CREATION_DATE=1/22/2025 11:35:17 PM
1/22/2025 11:35:17 PM: ORA-02291: integrity constraint (ZEAL_ERP.FK_PARAM_HD) violated - parent key not found
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-02291: integrity constraint (ZEAL_ERP.FK_PARAM_HD) violated - parent key not found
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans)
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, OracleCommand trans)
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.ExecuteQuery(String query, OracleParameter[] query_params, OracleCommand command)
1/22/2025 11:35:17 PM: ORA-02291: integrity constraint (ZEAL_ERP.FK_PARAM_HD) violated - parent key not found
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-02291: integrity constraint (ZEAL_ERP.FK_PARAM_HD) violated - parent key not found
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, Boolean ExecuteSp, OracleCommand trans)
   at ZealERP.ZealFramework.Utils.DB.ExecuteDML(String query, OracleParameter[] commandParameters, OracleCommand trans)
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.ExecuteQuery(String query, OracleParameter[] query_params, OracleCommand command)
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadGenParamsDetail(String OrgId, DataTable dt, Boolean AppendRecords, OracleCommand command)
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model, OracleCommand command)
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.<>c__DisplayClass177_0.<UploadItems>b__0(OracleCommand command)
   at ZealERP.ZealFramework.Utils.ZealTransactionHandler.ExecuteTransaction(TransactionBody _TransactionBody)
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model)
1/22/2025 11:35:17 PM: Error.. in Sheet: Sheet1 at Row No:1 ORA-02291: integrity constraint (ZEAL_ERP.FK_PARAM_HD) violated - parent key not found
1/22/2025 11:35:17 PM: Error in route [api/ZealUploadUtility/UploadFile] class: ZealUploadUtilityController:
ZealERP.ZealFramework.Utils.ZealException: Error.. in Sheet: Sheet1 at Row No:1 ORA-02291: integrity constraint (ZEAL_ERP.FK_PARAM_HD) violated - parent key not found
   at ZealERP.ZealTakaful.Services.GLAS.ZealUploadUtilityService.UploadItems(UploadUtilityDataModel model)
   at ZealERP.ZealTakaful.Controllers.GLAS.ZealUploadUtilityController.<UploadFile>b__3_0()
   at ZealERP.ZealFramework.Utils.ZealRestApiHandler.GetResponse(ControllerLogic GetDataFromService)
1/22/2025 11:46:34 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)
1/22/2025 11:51:51 PM: User email does not match with employee email
ZealERP.ZealFramework.Utils.ZealException: User email does not match with employee email
   at ZealERP.ZealTakaful.Services.LeaveManagement.LeaveRequestService.GetEmployeeId(String orgId)
   at ZealERP.ZealTakaful.AppSelection.Page_Load(Object sender, EventArgs e)