--------------------------------------------------------------- Log Entry : 3/26/2024 12:32:34 PM - ------------------------------------------------------------- RayController Method: Ray System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string. at Sang.Ray.Mob.Api.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Ray.Mob.Api.Controllers.RayController.GetBestEmployee() ClientConnectionId:399a7bd0-b8ab-460d-adf2-f82698b4e74d Error Number:241,State:1,Class:16 --------------------------------------------------------------- Log Entry : 3/26/2024 12:33:09 PM - ------------------------------------------------------------- RayController Method: Ray System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string. at Sang.Ray.Mob.Api.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Ray.Mob.Api.Controllers.RayController.GetBestEmployee() ClientConnectionId:300a0ab7-b7c5-415f-9e12-6d7909295b0a Error Number:241,State:1,Class:16 --------------------------------------------------------------- Log Entry : 3/26/2024 1:08:40 PM - ------------------------------------------------------------- RayController Method: Ray System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string. at Sang.Ray.Mob.Api.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Ray.Mob.Api.Controllers.RayController.GetBestEmployee() ClientConnectionId:a15fc709-8a78-43ea-b7bf-2a5bdc719cf3 Error Number:241,State:1,Class:16 --------------------------------------------------------------- Log Entry : 3/26/2024 2:34:54 PM - ------------------------------------------------------------- RayController Method: Ray System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string. at Sang.Ray.Mob.Api.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Ray.Mob.Api.Controllers.RayController.GetBestEmployee() ClientConnectionId:42238a64-e324-4c01-922f-b506a25fd1f9 Error Number:241,State:1,Class:16 --------------------------------------------------------------- Log Entry : 3/26/2024 3:20:18 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-03-26","Project":35,"ProjectDes":"Risk Mitigation Project - DEWA","Location":"DUBAI","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"QWE","iRiskLevel":3,"iActionBy":2603,"sActionReq":"RTY","TargetDate":"2024-03-26","sPath":"","sActionBy_Code":"RU/603","sActionBy":"sijina-test","sImages":"","iTransId":0,"imageFiles":[{}],"ActionBy":2603,"ActionReq":"RTY","Observation":"QWE","RiskLevel":3,"Images":"KI.PNG"}]} --------------------------------------------------------------- Log Entry : 3/26/2024 3:21:21 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":0,"iHSETransDtId":9484,"Date":"2024-03-26","Status":4,"Remarks":"HOLD","UserId":1079,"Images":""} --------------------------------------------------------------- Log Entry : 3/26/2024 3:28:16 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":9484,"iHSETransDtId":9484,"Date":"2024-03-26","Status":8,"Remarks":"ty","UserId":1079,"Images":""} --------------------------------------------------------------- Log Entry : 3/26/2024 3:32:19 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":9484,"iHSETransDtId":9484,"Date":"2024-03-26","Status":1,"Remarks":"j","UserId":1100,"Images":""} --------------------------------------------------------------- Log Entry : 3/26/2024 3:34:15 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":9484,"iHSETransDtId":9484,"Date":"2024-03-26","Status":3,"Remarks":"k","UserId":1079,"Images":""} --------------------------------------------------------------- Log Entry : 3/26/2024 3:36:48 PM - ------------------------------------------------------------- RayController Method:PostCloseHSE {"iTransDtId":9484,"iHSETransDtId":9484,"Date":"2024-03-26","Status":5,"Remarks":"kl","UserId":1079,"Images":""} --------------------------------------------------------------- Log Entry : 3/26/2024 4:08:34 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":0,"DocDate":"2024-03-26","Project":19,"ProjectDes":"Purchase Department","Location":"Muscat","SiteIncharge":16,"Client":"","DetailsOfLG":"er","SlNoOfLG":"yt","sGeneralComments":"fjj","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":2,"Items":2,"Compliance":1,"Remarks":""},{"SlNo":3,"Items":3,"Compliance":1,"Remarks":""},{"SlNo":4,"Items":4,"Compliance":1,"Remarks":""},{"SlNo":5,"Items":5,"Compliance":1,"Remarks":""},{"SlNo":6,"Items":6,"Compliance":1,"Remarks":""},{"SlNo":7,"Items":7,"Compliance":1,"Remarks":""},{"SlNo":8,"Items":8,"Compliance":1,"Remarks":""},{"SlNo":9,"Items":9,"Compliance":2,"Remarks":""},{"SlNo":10,"Items":10,"Compliance":3,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 3/26/2024 4:16:36 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":3077,"DocDate":"2024-03-25","Project":337,"ProjectDes":"wer2","Location":"FINLAND","SiteIncharge":8,"Client":"","DetailsOfLG":"r","SlNoOfLG":"FGH","sGeneralComments":"JKL","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":2,"Items":2,"Compliance":1,"Remarks":""},{"SlNo":3,"Items":3,"Compliance":1,"Remarks":""},{"SlNo":4,"Items":4,"Compliance":2,"Remarks":""},{"SlNo":5,"Items":5,"Compliance":2,"Remarks":""},{"SlNo":6,"Items":6,"Compliance":1,"Remarks":""},{"SlNo":7,"Items":7,"Compliance":2,"Remarks":""},{"SlNo":8,"Items":8,"Compliance":2,"Remarks":""},{"SlNo":9,"Items":9,"Compliance":2,"Remarks":""},{"SlNo":10,"Items":10,"Compliance":2,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 3/26/2024 4:31:04 PM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":0,\"DocDate\":\"2024-03-26\",\"Project\":6,\"ProjectDes\":\"RAY UAE (HR/ADMIN)\",\"Location\":\"umm al quwain\",\"SiteIncharge\":29,\"Client\":\"\",\"sGeneralComments\":\"erf\",\"UserId\":1100,\"Mark_Model\":\"sd\",\"DrivingLicenceExpiry\":\"2025-04-23\",\"RegistrationNo\":\"erw\",\"OperatorName\":\"rtew\",\"Images\":\"\",\"Signature\":\"\",\"Body\":[{\"SlNo\":1,\"Items\":70,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":2,\"Items\":71,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":3,\"Items\":72,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":4,\"Items\":73,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":5,\"Items\":74,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":6,\"Items\":75,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":7,\"Items\":76,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":8,\"Items\":77,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":9,\"Items\":78,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":10,\"Items\":79,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":11,\"Items\":80,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":12,\"Items\":81,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":13,\"Items\":82,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":14,\"Items\":83,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":15,\"Items\":84,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":16,\"Items\":85,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":17,\"Items\":86,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":18,\"Items\":87,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":19,\"Items\":88,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":20,\"Items\":89,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":21,\"Items\":90,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":22,\"Items\":91,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":23,\"Items\":92,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":24,\"Items\":93,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":25,\"Items\":95,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":26,\"Items\":96,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":27,\"Items\":97,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":28,\"Items\":98,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":29,\"Items\":99,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":30,\"Items\":100,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":31,\"Items\":101,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":32,\"Items\":102,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":33,\"Items\":103,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":34,\"Items\":104,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":35,\"Items\":105,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":36,\"Items\":151,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":37,\"Items\":152,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"}]}" --------------------------------------------------------------- Log Entry : 3/26/2024 4:38:49 PM - ------------------------------------------------------------- RayController Method:PostPPE {"iTransId":0,"DocDate":"2024-03-26","Project":337,"ProjectDes":"wer2","Location":"sharjah","SiteIncharge":20,"Client":"","sGeneralComments":"e","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":1,"Items":52,"Compliance":3,"Remarks":""},{"SlNo":2,"Items":53,"Compliance":3,"Remarks":""},{"SlNo":3,"Items":54,"Compliance":3,"Remarks":""},{"SlNo":4,"Items":55,"Compliance":3,"Remarks":""},{"SlNo":5,"Items":56,"Compliance":3,"Remarks":""},{"SlNo":6,"Items":57,"Compliance":2,"Remarks":""},{"SlNo":7,"Items":58,"Compliance":2,"Remarks":""},{"SlNo":8,"Items":59,"Compliance":2,"Remarks":""},{"SlNo":9,"Items":60,"Compliance":1,"Remarks":""},{"SlNo":10,"Items":61,"Compliance":1,"Remarks":""},{"SlNo":11,"Items":62,"Compliance":1,"Remarks":""},{"SlNo":12,"Items":63,"Compliance":2,"Remarks":""},{"SlNo":13,"Items":64,"Compliance":2,"Remarks":""},{"SlNo":14,"Items":65,"Compliance":2,"Remarks":""},{"SlNo":15,"Items":66,"Compliance":2,"Remarks":""},{"SlNo":16,"Items":67,"Compliance":3,"Remarks":""},{"SlNo":17,"Items":68,"Compliance":3,"Remarks":""},{"SlNo":18,"Items":69,"Compliance":3,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 3/26/2024 7:16:26 PM - ------------------------------------------------------------- RayController Method: Ray System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string. at Sang.Ray.Mob.Api.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Ray.Mob.Api.Controllers.RayController.GetBestEmployee() ClientConnectionId:1252e73b-64bd-460a-a413-a6541fb2ed6b Error Number:241,State:1,Class:16