--------------------------------------------------------------- Log Entry : 3/27/2024 10:19:34 AM - ------------------------------------------------------------- RayController Method:PostQHSE {"iTransId":0,"DocDate":"2024-03-27","Project":187,"ProjectDes":"DEPARTMENTAL COST","Location":"INDIA","Client":"","SiteIncharge":22,"Activity":"ASDF","sGeneralComments":"GHJ","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":2,"Remarks":""},{"SlNo":9,"Items":19,"Compliance":2,"Remarks":""},{"SlNo":10,"Items":20,"Compliance":2,"Remarks":""},{"SlNo":11,"Items":21,"Compliance":2,"Remarks":""},{"SlNo":100,"Items":258,"Compliance":2,"Remarks":""},{"SlNo":7,"Items":256,"Compliance":3,"Remarks":""},{"SlNo":12,"Items":22,"Compliance":3,"Remarks":""},{"SlNo":13,"Items":23,"Compliance":3,"Remarks":""},{"SlNo":14,"Items":24,"Compliance":3,"Remarks":""},{"SlNo":15,"Items":25,"Compliance":1,"Remarks":""},{"SlNo":16,"Items":26,"Compliance":2,"Remarks":""},{"SlNo":17,"Items":27,"Compliance":2,"Remarks":""},{"SlNo":18,"Items":28,"Compliance":2,"Remarks":""},{"SlNo":19,"Items":29,"Compliance":3,"Remarks":""},{"SlNo":20,"Items":30,"Compliance":3,"Remarks":""},{"SlNo":21,"Items":31,"Compliance":3,"Remarks":""},{"SlNo":22,"Items":32,"Compliance":1,"Remarks":""},{"SlNo":23,"Items":33,"Compliance":1,"Remarks":""},{"SlNo":24,"Items":34,"Compliance":1,"Remarks":""},{"SlNo":25,"Items":35,"Compliance":3,"Remarks":""},{"SlNo":26,"Items":36,"Compliance":3,"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":1,"Remarks":""},{"SlNo":33,"Items":43,"Compliance":2,"Remarks":""},{"SlNo":34,"Items":44,"Compliance":2,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 3/27/2024 10:23:50 AM - ------------------------------------------------------------- RayController Method:PostQHSE {"iTransId":3036,"DocDate":"2024-02-23","Project":352,"ProjectDes":"tr65trt8ui","Location":"LA","Client":"","SiteIncharge":8,"Activity":"a","sGeneralComments":"g","UserId":1100,"Images":"qhse_1080_16314323022024.jpg","Signature":"qhse_sign_1080_16315223022024.jpg","Body":[{"SlNo":1,"Items":11,"Compliance":1,"Remarks":""},{"SlNo":2,"Items":12,"Compliance":1,"Remarks":""},{"SlNo":3,"Items":13,"Compliance":2,"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":2,"Remarks":""},{"SlNo":9,"Items":19,"Compliance":2,"Remarks":""},{"SlNo":10,"Items":20,"Compliance":1,"Remarks":""},{"SlNo":11,"Items":21,"Compliance":2,"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":1,"Remarks":""},{"SlNo":16,"Items":26,"Compliance":2,"Remarks":""},{"SlNo":17,"Items":27,"Compliance":2,"Remarks":""},{"SlNo":18,"Items":28,"Compliance":2,"Remarks":""},{"SlNo":19,"Items":29,"Compliance":1,"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":2,"Remarks":""},{"SlNo":24,"Items":34,"Compliance":1,"Remarks":""},{"SlNo":25,"Items":35,"Compliance":2,"Remarks":""},{"SlNo":26,"Items":36,"Compliance":1,"Remarks":""},{"SlNo":27,"Items":37,"Compliance":1,"Remarks":""},{"SlNo":28,"Items":38,"Compliance":1,"Remarks":""},{"SlNo":29,"Items":39,"Compliance":2,"Remarks":""},{"SlNo":30,"Items":40,"Compliance":1,"Remarks":""},{"SlNo":31,"Items":41,"Compliance":2,"Remarks":""},{"SlNo":32,"Items":42,"Compliance":2,"Remarks":""},{"SlNo":33,"Items":43,"Compliance":2,"Remarks":""},{"SlNo":34,"Items":44,"Compliance":1,"Remarks":""}]} --------------------------------------------------------------- Log Entry : 3/27/2024 10:35:13 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":0,"Project":23,"ProjectCode":"IT001","Location":"karnataka","UserId":1100,"Activity":"as","CorrectiveAction":"fh","Observation":"ty","iObserver":21,"Images":"","iType":2,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 3/27/2024 10:42:02 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":109131,"Project":1356,"ProjectCode":"Test proj","Location":"wwwwww","UserId":1100,"Activity":"testActivity","CorrectiveAction":"Test","Observation":"test","iObserver":11,"Images":"Screenshot 2024-02-05 114251.png","iType":2,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 3/27/2024 10:47:39 AM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":0,"Project":354,"ProjectCode":"1234","Location":"QATAR","UserId":1100,"Activity":"zx","CorrectiveAction":"bn","Observation":"cv","iObserver":49,"Images":"","iType":1,"DocDate":"2024-02-15"} --------------------------------------------------------------- Log Entry : 3/27/2024 1:10:39 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:b68c4156-3d28-482e-bb34-bb5b56bd5cda Error Number:241,State:1,Class:16 --------------------------------------------------------------- Log Entry : 3/27/2024 1:35:58 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:607f9cf2-790f-4e6d-b051-0acb5d1cfae4 Error Number:241,State:1,Class:16 --------------------------------------------------------------- Log Entry : 3/27/2024 1:38:29 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:9865c325-670f-45c4-b11d-5da9c7d1a368 Error Number:241,State:1,Class:16 --------------------------------------------------------------- Log Entry : 3/27/2024 1:39:35 PM - ------------------------------------------------------------- RayController Method:PostStopCard {"iTransId":0,"DocDate":"2024-03-27","Project":352,"ProjectCode":"004","Location":"loc","Activity":"act","Observation":"ob","CorrectiveAction":"c","iObserver":2602,"UserId":1079,"Images":"013913273392024.jpg","iType":1} --------------------------------------------------------------- Log Entry : 3/27/2024 3:28:02 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:81442fb2-ed3a-40c1-b6d0-be0548c78521 Error Number:241,State:1,Class:16 --------------------------------------------------------------- Log Entry : 3/27/2024 10:07:04 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:0db3235f-7975-4856-8099-ce65c54a4e9a Error Number:241,State:1,Class:16