public void PostTruckVisualActivities(ReqPostTruckVisualActivities data)
{
System.Threading.Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
using (IDbConnection connection = GetOpenConnection())
{
try
{
string sql = @" update TruckVisualActivities
set ProcessOn = @ProcessOn,
Latitude = @Latitude,
Longitude = @Longitude,
ModifiedBy = @UserID,
ModifiedOn = getdate()
where TVActivityID = @TVActivityID
and ModifiedBy Is null
";
var ProcessOn = string.Empty;
if (data.ProcessOn.HasValue)
{
ProcessOn = data.ProcessOn.Value.ToString("yyyy-MM-dd HH:mm:ss.fff");
}
else
{
ProcessOn = null;
}
connection.ExecuteScalar(sql, new { ProcessOn = ProcessOn, Latitude = data.Latitude, Longitude = data.Longitude, UserID = data.UserID, TVActivityID = data.TVActivityID }, commandType: CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
}
public ResponseInfo <string> PostTruckVisualActivities(ReqPostTruckVisualActivities data)
{
ResponseInfo <string> res = new ResponseInfo <string>();
try
{
EPODDAL.PostTruckVisualActivities(data);
res.ResponseData = "Success";
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
