--------------------------------------------------------------- Log Entry : 4/11/2024 10:03:47 AM - ------------------------------------------------------------- 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:558bb037-9cf1-401b-b3e0-2b824ccfb255 Error Number:241,State:1,Class:16 --------------------------------------------------------------- Log Entry : 4/11/2024 10:21:57 AM - ------------------------------------------------------------- 11 --------------------------------------------------------------- Log Entry : 4/11/2024 11:20:38 AM - ------------------------------------------------------------- 11 --------------------------------------------------------------- Log Entry : 4/11/2024 11:21:10 AM - ------------------------------------------------------------- 11 --------------------------------------------------------------- Log Entry : 4/11/2024 11:21:26 AM - ------------------------------------------------------------- 11 --------------------------------------------------------------- Log Entry : 4/11/2024 11:34:29 AM - ------------------------------------------------------------- 11 --------------------------------------------------------------- Log Entry : 4/11/2024 11:35:14 AM - ------------------------------------------------------------- 11 --------------------------------------------------------------- Log Entry : 4/11/2024 1:09:58 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-04-12","Project":6,"ProjectDes":"RAY UAE (HR/ADMIN)","Location":"KSA","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"S","iRiskLevel":2,"iActionBy":40,"sActionReq":"DF","TargetDate":"2024-04-11","sPath":"","sActionBy_Code":"RU/055","sActionBy":"Muhammad Kamran","sImages":"","iTransId":0,"ActionBy":40,"ActionReq":"DF","Observation":"S","RiskLevel":2,"Images":""}]} --------------------------------------------------------------- Log Entry : 4/11/2024 1:17:38 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-04-11","Project":6,"ProjectDes":"RAY UAE (HR/ADMIN)","Location":"KSA","UserId":1100,"iTransId":0,"Signature":"","Body":[{"sObservation":"DS","iRiskLevel":2,"iActionBy":2602,"sActionReq":"GD","TargetDate":"2024-04-11","sPath":"","sActionBy_Code":"RU/602","sActionBy":"sijina","sImages":"","iTransId":0,"ActionBy":2602,"ActionReq":"GD","Observation":"DS","RiskLevel":2,"Images":""}]} --------------------------------------------------------------- Log Entry : 4/11/2024 1:18:54 PM - ------------------------------------------------------------- RayController Method:PostHSE {"DocDate":"2024-04-11","Project":6,"ProjectDes":"RAY UAE (HR/ADMIN)","Location":"KSA","UserId":1079,"iTransId":9611,"Signature":"","Body":[{"sObservation":"DS","iRiskLevel":3,"iActionBy":2602,"sActionReq":"GD","TargetDate":"2024-04-10","sPath":"","sActionBy_Code":"RU/602","sActionBy":"sijina","sImages":"","iTransId":9611,"ActionBy":2602,"ActionReq":"GD","Observation":"DS","RiskLevel":3,"Images":""}]} --------------------------------------------------------------- Log Entry : 4/11/2024 1:24:55 PM - ------------------------------------------------------------- RayController Method:PostIncident {"iTransId":0,"Project":15,"Location":"LA","Date":"2024-04-11","Time":"13:11","IncidentType":4,"Severity_Rate":3,"Potential_Rate":3,"IncidentDescription":"sd","DamageDescription":"sx","No_Injured_Person":"2","DetailsOfPersons":"x,u","ImmediateCauses":"ef","UnderlyingCauses":"dfg","UserId":1079,"Images":"","sPath":"","Others":"","Body":[{"iResponsible":57,"sCloseDate":"21-2","iAction":1,"sAction_Des":"4","sExtraDetails":""}]} --------------------------------------------------------------- Log Entry : 4/11/2024 1:25:05 PM - ------------------------------------------------------------- AuthorizationEmail sended --------------------------------------------------------------- Log Entry : 4/11/2024 1:36:59 PM - ------------------------------------------------------------- RayController Method:PostLGIC {"iTransId":0,"DocDate":"2024-04-11","Project":35,"ProjectDes":"Risk Mitigation Project - DEWA","Location":"dubai","SiteIncharge":60,"Client":"","DetailsOfLG":"qw","SlNoOfLG":"45","sGeneralComments":"r","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":1,"Items":263,"Compliance":1,"Remarks":""},{"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":2,"Remarks":""},{"SlNo":7,"Items":7,"Compliance":2,"Remarks":""},{"SlNo":11,"Items":264,"Compliance":1,"Remarks":""},{"SlNo":22,"Items":266,"Compliance":3,"Remarks":""},{"SlNo":8,"Items":8,"Compliance":1,"Remarks":""},{"SlNo":9,"Items":9,"Compliance":1,"Remarks":""},{"SlNo":10,"Items":10,"Compliance":2,"Remarks":""},{"SlNo":67,"Items":265,"Compliance":2,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 4/11/2024 1:41:54 PM - ------------------------------------------------------------- RayController Method:PostMCC "{\"iTransId\":0,\"DocDate\":\"2024-04-11\",\"Project\":354,\"ProjectDes\":\"MyRayProject\",\"Location\":\"andaman\",\"SiteIncharge\":58,\"Client\":\"\",\"sGeneralComments\":\"sd\",\"UserId\":1100,\"Mark_Model\":\"fv\",\"DrivingLicenceExpiry\":\"2024-04-23\",\"RegistrationNo\":\"324324324\",\"OperatorName\":\"324\",\"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\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":11,\"Items\":80,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":12,\"Items\":81,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":13,\"Items\":82,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":14,\"Items\":83,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":15,\"Items\":84,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":16,\"Items\":85,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":17,\"Items\":86,\"Compliance\":3,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":18,\"Items\":87,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":19,\"Items\":88,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":20,\"Items\":89,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":21,\"Items\":90,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":22,\"Items\":91,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":23,\"Items\":92,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":24,\"Items\":93,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":25,\"Items\":95,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":26,\"Items\":96,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":27,\"Items\":97,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":28,\"Items\":98,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":29,\"Items\":99,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":30,\"Items\":100,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":31,\"Items\":101,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":32,\"Items\":102,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":33,\"Items\":103,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":34,\"Items\":104,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":35,\"Items\":105,\"Compliance\":2,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":36,\"Items\":151,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"},{\"SlNo\":37,\"Items\":152,\"Compliance\":1,\"Remarks\":\"\",\"ActionTaken\":\"\"}]}" --------------------------------------------------------------- Log Entry : 4/11/2024 1:44:21 PM - ------------------------------------------------------------- RayController Method:PostPPE {"iTransId":0,"DocDate":"2024-04-11","Project":16,"ProjectDes":"HSC Department","Location":"ewr","SiteIncharge":38,"Client":"","sGeneralComments":"dg","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":0,"Items":262,"Compliance":1,"Remarks":""},{"SlNo":1,"Items":52,"Compliance":1,"Remarks":""},{"SlNo":2,"Items":53,"Compliance":2,"Remarks":""},{"SlNo":3,"Items":54,"Compliance":2,"Remarks":""},{"SlNo":4,"Items":55,"Compliance":2,"Remarks":""},{"SlNo":5,"Items":56,"Compliance":1,"Remarks":""},{"SlNo":6,"Items":57,"Compliance":1,"Remarks":""},{"SlNo":7,"Items":58,"Compliance":1,"Remarks":""},{"SlNo":8,"Items":59,"Compliance":2,"Remarks":""},{"SlNo":9,"Items":60,"Compliance":2,"Remarks":""},{"SlNo":10,"Items":61,"Compliance":2,"Remarks":""},{"SlNo":11,"Items":62,"Compliance":1,"Remarks":""},{"SlNo":12,"Items":63,"Compliance":1,"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":1,"Remarks":""},{"SlNo":17,"Items":68,"Compliance":1,"Remarks":""},{"SlNo":18,"Items":69,"Compliance":1,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 4/11/2024 1:48:16 PM - ------------------------------------------------------------- RayController Method:PostQHSE {"iTransId":0,"DocDate":"2024-04-11","Project":19,"ProjectDes":"Purchase Department","Location":"UAE","Client":"","SiteIncharge":56,"Activity":"WFD","sGeneralComments":"s","UserId":1100,"Images":"","Signature":"","Body":[{"SlNo":1,"Items":11,"Compliance":1,"Remarks":""},{"SlNo":2,"Items":12,"Compliance":1,"Remarks":""},{"SlNo":3,"Items":13,"Compliance":1,"Remarks":""},{"SlNo":4,"Items":14,"Compliance":2,"Remarks":""},{"SlNo":5,"Items":15,"Compliance":2,"Remarks":""},{"SlNo":6,"Items":16,"Compliance":2,"Remarks":""},{"SlNo":7,"Items":17,"Compliance":2,"Remarks":""},{"SlNo":8,"Items":18,"Compliance":1,"Remarks":""},{"SlNo":9,"Items":19,"Compliance":1,"Remarks":""},{"SlNo":10,"Items":20,"Compliance":1,"Remarks":""},{"SlNo":11,"Items":21,"Compliance":2,"Remarks":""},{"SlNo":33,"Items":267,"Compliance":2,"Remarks":""},{"SlNo":100,"Items":258,"Compliance":2,"Remarks":""},{"SlNo":8952,"Items":268,"Compliance":3,"Remarks":""},{"SlNo":7,"Items":256,"Compliance":1,"Remarks":""},{"SlNo":12,"Items":22,"Compliance":1,"Remarks":""},{"SlNo":13,"Items":23,"Compliance":2,"Remarks":""},{"SlNo":14,"Items":24,"Compliance":2,"Remarks":""},{"SlNo":15,"Items":25,"Compliance":2,"Remarks":""},{"SlNo":16,"Items":26,"Compliance":1,"Remarks":""},{"SlNo":17,"Items":27,"Compliance":1,"Remarks":""},{"SlNo":18,"Items":28,"Compliance":1,"Remarks":""},{"SlNo":19,"Items":29,"Compliance":2,"Remarks":""},{"SlNo":20,"Items":30,"Compliance":2,"Remarks":""},{"SlNo":21,"Items":31,"Compliance":1,"Remarks":""},{"SlNo":22,"Items":32,"Compliance":2,"Remarks":""},{"SlNo":23,"Items":33,"Compliance":1,"Remarks":""},{"SlNo":24,"Items":34,"Compliance":2,"Remarks":""},{"SlNo":25,"Items":35,"Compliance":1,"Remarks":""},{"SlNo":26,"Items":36,"Compliance":2,"Remarks":""},{"SlNo":27,"Items":37,"Compliance":2,"Remarks":""},{"SlNo":28,"Items":38,"Compliance":2,"Remarks":""},{"SlNo":29,"Items":39,"Compliance":2,"Remarks":""},{"SlNo":30,"Items":40,"Compliance":3,"Remarks":""},{"SlNo":31,"Items":41,"Compliance":3,"Remarks":""},{"SlNo":32,"Items":42,"Compliance":3,"Remarks":""},{"SlNo":33,"Items":43,"Compliance":1,"Remarks":""},{"SlNo":34,"Items":44,"Compliance":1,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 4/11/2024 1:49:20 PM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":0,"Project":23,"ProjectCode":"IT001","Location":"oman","UserId":1100,"Activity":"dsg","CorrectiveAction":"df","Observation":"f","iObserver":130,"Images":"","iType":1,"DocDate":"2024-02-15"}