public ActionResult GetTrackDetails(int ManualBookingId, string CompanyCode)
{
MessageModel msg = new MessageModel();
ManualBookingTrackNTraceModel MBT = new ManualBookingTrackNTraceModel();
ManualBookingTrackNTraceService bkService = new ManualBookingTrackNTraceService();
MBT = bkService.GetTrackDetails(ManualBookingId, "ripl");
var result = MBT.TrackDs;
var json = JsonConvert.SerializeObject(result, Formatting.Indented);
return(Json(json, JsonRequestBehavior.AllowGet));
}
public ManualBookingTrackNTraceModel GetTrackDetails(int ManualBookingId, string CompanyCode)
{
string conString = CompanyConfigService.getDbCredentials(CompanyCode);
SqlDataAceessLayer _dal = new SqlDataAceessLayer(conString);
string Query = @"SELECT Tracking_Date,Tracking_Time,Location,Reason,Remarks,A.Attachment_Path,[Signature]
FROM Domestic.Trn_Vehicle_Tracking A INNER JOIN
Custom.Trn_Booking_Manual B ON A.Manual_Booking_ID = B.Booking_Manual_ID LEFT OUTER JOIN
Common.Master_Reason C ON A.Reason_ID = C.Reason_ID where A.Manual_Booking_ID = " + ManualBookingId;
DataSet Ds = _dal.ExecuteSql(Query);
ManualBookingTrackNTraceModel mbm = new ManualBookingTrackNTraceModel();
mbm.TrackDs = Ds;
return(mbm);
}