/// <summary> /// Add Customer Requirement(Post) /// </summary> /// <param name="post">Post</param> /// <returns>status</returns> public static int AddPost(Post post) { int result; var objpost = new TMSDataLibrary.Post(); result = objpost.AddPost(post.UserId, post.SourceCity, post.DestinationCity, post.Weight, post.SchdDate, post.MaterialTypeId, post.VehicleTypeId); return result; }
/// <summary> /// Add Customer Requirement(Post) /// </summary> /// <param name="post">Post</param> /// <returns>status</returns> public static int AddBooking(Booking book) { int result; var bookingNo = ""; var _objpost = new TMSDataLibrary.Post(); result = _objpost.AddBooking(book.UserId, book.MaterialTypeId, book.TrucktypeId, book.NumberOfTrucks, book.LoadType, book.Status, book.FromCityId, book.ToCityId, book.FromAddress, book.ToAddress, book.Weight, book.SchdDate, book.BookingDate, book.Distance, book.Quotes, out bookingNo, book.LoadService, book.FromPinCode.PincodeId, book.ToPinCode.PincodeId); book.BookingNo = bookingNo; return result; }
/// <summary> /// Gets a single booking on the basis of Id and Type Passed. /// </summary> /// <param name="id"></param> /// <param name="type">Pass type to filter bookings on the basis. Type - UserId, BookingId</param> /// <returns></returns> public static Booking GetBooking(int id, string type) { var post = new TMSDataLibrary.Post(); var oBooking = new Booking(); var dt = post.GetBooking(id, type); if (dt.Rows.Count > 0) { var row = dt.Rows[0]; oBooking.BookingId = Convert.ToInt32(row["BookingId"]); oBooking.FromCityName = row["FromCityName"].ToString(); oBooking.ToCityName = row["ToCityName"].ToString(); oBooking.TransporterVehicle.RegistrationNo = row["RegistrationNo"].ToString(); oBooking.SchdDate = Convert.ToDateTime(row["SchdDate"]); oBooking.TransporterVehicle.TransporterId = Convert.ToInt32(row["TransporterId"]); oBooking.TransporterVehicle.Transporter.TransportName = row["TransportName"].ToString(); oBooking.TransporterVehicle.Transporter.FirstName = row["FirstName"].ToString(); oBooking.TransporterVehicle.Transporter.LastName = row["LastName"].ToString(); oBooking.TransporterVehicle.Transporter.Mobile = row["Mobile"].ToString(); } return oBooking; }
/// <summary> /// Gets a single booking on the basis of bookingNo /// </summary> /// <param name="bookingNo"></param> /// <returns></returns> public static DataTable GetBooking(string bookingNo) { var post = new TMSDataLibrary.Post(); return post.GetBooking(bookingNo); }
/// <summary> /// Update Declinereason in BookingDeatils /// </summary> /// <param name="book"></param> /// <returns></returns> public static int Declinereason(Booking book) { var objpost = new TMSDataLibrary.Post(); var result = objpost.Declinereason(book.BookingId, book.DeclineReason); return result; }
/// <summary> /// Update status of booking /// </summary> /// <param name="book"></param> /// <returns>no of update row</returns> public static int UpdateStatus(Booking book) { var objpost = new TMSDataLibrary.Post(); var result = objpost.Updatestatus(book.Status, book.BookingId); return result; }
/// <summary> /// MaxbookingId /// </summary> /// <param name="bookingid"></param> /// <returns></returns> public static Booking MaxBookingDetailId(int bookingid) { var post = new TMSDataLibrary.Post(); var oBooking = new Booking(); var dt = post.MaxBookingDetailId(bookingid); if (dt.Rows.Count > 0) { oBooking.BookingId = Convert.ToInt32(dt.Rows[0]["BookingDetailId"]); } return oBooking; }
/// <summary> /// Get Total Count for Transporter,Customer,Vehicle /// </summary> /// <returns></returns> public static Post GetTotalNumber() { DataTable dt = new DataTable(); Post post = new Post(); TMSDataLibrary.Post _post = new TMSDataLibrary.Post(); dt = _post.GetTotalNumber(); if (dt.Rows.Count > 0) { post.Transporter = Convert.ToInt32(dt.Rows[0]["TotalCount"]); post.Customer = Convert.ToInt32(dt.Rows[1]["TotalCount"]); post.Vehicle = Convert.ToInt32(dt.Rows[2]["TotalCount"]); post.BookingCount = Convert.ToInt32(dt.Rows[3]["TotalCount"]); } return post; }
/// <summary> /// Get All Posts on the basis of FromCity, ToCity And ScheduledDate. /// </summary> /// <param name="fromCityId">Source City of booking.</param> /// <param name="toCityId">Destination City of booking.</param> /// <param name="schdDate">Scheduled Date of booking</param> /// <param name="loadType">Full Load Or Part Load.</param> /// <returns></returns> public static object GetPost(int fromCityId, int toCityId, DateTime schdDate, int loadType) { var oPost = new TMSDataLibrary.Post(); return oPost.GetPosts(fromCityId, toCityId, schdDate, loadType); }
/// <summary> /// Get All Posts on the basis of FromCity, ToCity And LoadType. /// </summary> /// <param name="fromCityId">Source City of booking.</param> /// <param name="toCityId">Destination City of booking.</param> /// <param name="loadTypeId">Full Load or Partial Load.</param> /// <returns></returns> public static DataTable GetPost(int fromCityId, int toCityId, int loadTypeId, string spAction, string bookingNo) { var post = new TMSDataLibrary.Post(); return post.GetPosts(fromCityId, toCityId, loadTypeId, spAction, bookingNo); }
/// <summary> /// Getv All Posts /// </summary> /// <returns>datatable of posts</returns> public static DataTable GetPost() { var post = new TMSDataLibrary.Post(); return post.GetPosts(); }
public static List<String> GetLatestBookings(string type) { var lstBookings = new List<String>(); var oPost = new TMSDataLibrary.Post(); var dt = oPost.GetLatestBookings(type); if (dt != null) lstBookings.AddRange( from DataRow row in dt.Rows let schdDate = Convert.ToDateTime(row["SchdDate"]) select String.Format(@"From {0} To {1}", row["FromCityName"], row["ToCityName"]) //select String.Format(@"{0} To {1} On {2} At {3}", row["FromCityName"], row["ToCityName"], schdDate.ToString("M"), schdDate.ToString("hh:mm tt")) ); return lstBookings; }
/// <summary> /// Gets counter values for dashboard /// </summary> /// <param name="userId"></param> /// <returns></returns> public static object GetDashboardCounter(int userId) { var oPost = new TMSDataLibrary.Post(); return oPost.GetDashboardCounter(userId); }
public static DataTable GetBookings(int bookingId) { var post = new TMSDataLibrary.Post(); return post.GetBookings(bookingId); }
/// <summary> /// Gets multiple bookings on the basis of Id and Type Passed. /// </summary> /// <param name="userid">User Id</param> /// <param name="type">Pass type to filter bookings on the basis. Type - UserId, BookingId</param> /// <returns></returns> public static DataTable GetBookings(int userid, int count) { var post = new TMSDataLibrary.Post(); return post.GetBookings(userid, count); }