/// <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);
}
