// Author: Mark Poffenroth
/// <summary>
/// Queries database for all BookingDetail records
/// </summary>
/// <returns>List of BookingDetail objects.</returns>
public static List<BookingDetail> GetBookingDetails()
{
// Create list of BookingDetail objects to return
List<BookingDetail> bookingDetails = new List<BookingDetail>();
// SQL query to get package details
SqlConnection connection = TravelExpertsDB.GetConnection();
string selectStatement = "SELECT BookingDetailId, ItineraryNo, TripStart, " +
" TripEnd, Description, Destination, BasePrice, AgencyCommission, " +
" BookingId, RegionId, ClassId, FeeId, ProductSupplierId " +
" FROM BookingDetails ";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
try
{
// Read query results and enter data into package list
connection.Open();
SqlDataReader reader = selectCommand.ExecuteReader();
while (reader.Read())
{
BookingDetail bookingDetail = new BookingDetail();
bookingDetail.BookingDetailId = Convert.ToInt32(reader["BookingDetailId"]);
bookingDetail.ItineraryNo = Convert.ToDouble(reader["ItineraryNo"]);
bookingDetail.TripStart = Convert.ToDateTime(reader["TripStart"]);
bookingDetail.TripEnd = Convert.ToDateTime(reader["TripEnd"]);
bookingDetail.Description = reader["Description"].ToString();
bookingDetail.Destination = reader["Destination"].ToString();
bookingDetail.BasePrice = Convert.ToDouble(reader["BasePrice"]);
bookingDetail.AgencyCommission = Convert.ToDouble(reader["AgencyCommission"]);
bookingDetail.BookingId = Convert.ToInt32(reader["BookingId"]);
bookingDetail.RegionId = Convert.ToInt32(reader["RegionId"]);
bookingDetail.ClassId = Convert.ToInt32(reader["ClassId"]);
bookingDetail.FeeId = Convert.ToInt32(reader["FeeId"]);
bookingDetail.ProductSupplierId = Convert.ToInt32(reader["ProductSupplierId"]);
bookingDetails.Add(bookingDetail);
}
reader.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
return bookingDetails;
}
public static void insertBooking(int cid, int rmid, List<int>Listsid)
{
var context = new MovieTheaterEntities();
Booking bk = new Booking();
bk.Customer_ID = cid;
bk.RoomMovie_ID = rmid;
bk.Amount = Listsid.Count * bk.RoomMovie.Price;
foreach (int sid in Listsid)
{
BookingDetail bd = new BookingDetail();
bd.Seat_ID = sid;
bk.BookingDetail.Add(bd);
}
context.Booking.Add(bk);
context.SaveChanges();
}
private void BtnSubmit_Click(object sender, EventArgs e)
{
string formattedPostcode = TxtPostcode.Text.Replace(" ", String.Empty);
bool success = BookingDetail.CreateBooking(TxtName.Text,
Convert.ToInt32(TxtHouseNumber.Text),
TxtHouseName.Text, TxtStreet.Text,
formattedPostcode, DtpDateFrom.Value,
Convert.ToInt32(TxtDays.Text),
Convert.ToDouble(TxtPrice.Text),
Room.GetRoomByID((int)CmbRoom.SelectedValue),
TxtBookingNotes.Text);
if (success)
{
this.Close();
}
else
{
MessageBox.Show("An error occured creating booking.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public IEnumerable <ControlData> Post(BookingDetail objbookingDetail)
{
List <ControlData> objListcontroldata = new List <ControlData>();
try
{
DataTable objdt = objHomeDAL.AcceptRejectCLData(objbookingDetail.AcceptReject, objbookingDetail.ReasonID, objbookingDetail.StrReason, objbookingDetail.ROID, objbookingDetail.PEID, objbookingDetail.IsClassified, objbookingDetail.UserId).Tables[0];
ControlData objcontroldata;
foreach (DataRow dr in objdt.Rows)
{
objcontroldata = new ControlData();
objcontroldata.ID = Convert.ToInt32(dr[0]);
objcontroldata.Value = Convert.ToString(dr[1]);
objListcontroldata.Add(objcontroldata);
}
}
catch (Exception ex)
{
}
return(objListcontroldata);
}
public IActionResult BookTicket([FromBody] BookingDetail book)
{
_log4net.Info("AdminController - BookTicket");
try
{
var booking = adm.BookTicket(book);
if (booking > 0)
{
return(Ok(booking));
}
else
{
return(NoContent());
}
}
catch (Exception)
{
return(BadRequest());
}
}
public async Task <Bicycles> Reserve(BookingDetail value)
{
try
{
var result = dbContext.Bicycles.Where(b =>
b.TypeId == value.TypeId &&
b.HubId == value.HubId &&
b.IsRent == false
).FirstOrDefault();
if (result != null)
{
result.IsRent = true;
dbContext.SaveChanges();
return(result);
}
return(null);
}
catch (Exception exp)
{
throw new Exception("server error:cannot find bicycle" + exp.Message);
}
}
public IEnumerable <ControlData> Post(BookingDetail objbookingDetail)
{
List <ControlData> objListcontroldata = new List <ControlData>();
try
{
string strXml = "<ebooking><actionname>" + objbookingDetail.Parametername + "</actionname><agencyname>" + objbookingDetail.ParamValueStr + "</agencyname></ebooking>";
DataTable objdt = objHomeDAL.GeteBookingControlData(strXml).Tables[0];
ControlData objcontroldata;
foreach (DataRow dr in objdt.Rows)
{
objcontroldata = new ControlData();
objcontroldata.ID = Convert.ToInt32(dr[0]);
objcontroldata.Value = Convert.ToString(dr[1]);
objListcontroldata.Add(objcontroldata);
}
}
catch (Exception ex)
{
}
return(objListcontroldata);
}
public IActionResult RoomsAvaible()
{
DateTime startDate = DateTime.Now;
DateTime endDate = startDate.AddDays(1);
List <Room> roomIsBooking = CheckRoom(startDate, endDate);
List <Room> rooms = _context.Rooms.ToList();
List <ViewRoom> viewRooms = new List <ViewRoom>();
for (int i = 0; i < rooms.Count; i++)
{
ViewRoom viewRoom = new ViewRoom();
viewRoom.Status = false;
for (int j = 0; j < roomIsBooking.Count; j++)
{
if (rooms[i].ID == roomIsBooking[j].ID)
{
BookingDetail bookingDetail = FindBookingDetailToday(startDate, endDate, rooms[i].ID);
if (bookingDetail != null)
{
List <string> CustomerList;
using (SqlConnection connection = new SqlConnection(Connection))
{
CustomerList = connection.Query <string>("select Customers.Name from Customers inner join BookingDetails on BookingDetails.ID=Customers.BookingDetailId where BookingDetails.ID =" + bookingDetail.ID).ToList();
}
viewRoom.NameCustomers = CustomerList;
viewRoom.CheckIn = bookingDetail.CheckInExpected;
viewRoom.CheckOut = bookingDetail.CheckOutExpected;
viewRoom.Status = true;
break;
}
}
}
viewRoom.ID = rooms[i].ID;
viewRoom.NameRoom = rooms[i].Name;
viewRooms.Add(viewRoom);
}
return(View(viewRooms));
}
public void UpdateBooking(BookingDetailVM bookingDetailVM, List <int> listDel)
{
Booking booking = new Booking();
mapper.Map(bookingDetailVM, booking);
booking.BookIdclient = bookingDetailVM.clientVM.IdClient;
booking.BookIduser = QLUserBLL.stoUser.IdUser; //user se dc luu o tang BLL khi dang nhap
List <BookingDetail> listadd = new List <BookingDetail>();
foreach (SubBookingDetailVM valVM in bookingDetailVM.ListSub)
{
BookingDetail bookingDetail = new BookingDetail();
mapper.Map(valVM, bookingDetail);
bookingDetail.BoodetIdbook = booking.IdBook;
if (bookingDetail.IdBoodet == 0)
{
listadd.Add(bookingDetail);
}
}
try
{
if (listDel.Count != 0)
{
_bookingDALManageFacade.DelBookingDetail(listDel);
}
_bookingDALManageFacade.UpdateBooking(booking);
if (listadd.Count != 0)
{
_bookingDALManageFacade.AddBookingDetail(listadd);
}
}
catch (Exception e)
{
/* Console.WriteLine(e.Message);*/
throw;
}
}
public static string CallApi(BookingDetail objBookingDetail)
{
HttpClient client = new HttpClient();
client.BaseAddress = new Uri(objBookingDetail.ApiName);
client.DefaultRequestHeaders.Accept.Clear();
JavaScriptSerializer Serializer = new JavaScriptSerializer();
var json = Serializer.Serialize(objBookingDetail);
var stringContent = new StringContent(json, System.Text.UnicodeEncoding.UTF8, "application/json");
var result = client.PostAsync(objBookingDetail.ApiName, stringContent).Result;
var responseValue = string.Empty;
Task task = result.Content.ReadAsStreamAsync().ContinueWith(t =>
{
var stream = t.Result;
using (var reader = new StreamReader(stream))
{
responseValue = reader.ReadToEnd();
}
});
task.Wait();
return(responseValue.ToString());
}
public void BookTicket_InvalidInput_ReturnsBadRequest()
{
try
{
var mock = new Mock <admin>(sysdb);
AdminController obj = new AdminController(mock.Object);
BookingDetail book = new BookingDetail {
Id = 24, PassengerId = 2225, PassengerName = "Rahul", Category = "AC Sleeper", Price = 900
};
var data = obj.BookTicket(book);
var res = data as BadRequestObjectResult;
Assert.AreEqual(400, res.StatusCode);
}
catch (Exception e)
{
Assert.AreEqual("Object reference not set to an instance of an object.", e.Message);
}
}
public IEnumerable <ControlData> Post(BookingDetail objbookingDetail)
{
List <ControlData> objListcontroldata = new List <ControlData>();
try
{
string strXml = "<ebooking><actionname>" + objbookingDetail.Parametername + "</actionname>"
+ "<loguserid>" + objbookingDetail.UserId + "</loguserid>"
+ "<revenuecentreid>" + objbookingDetail.RevenueCentreID + "</revenuecentreid></ebooking>";
DataTable objdt = objHomeDAL.GeteBookingControlData(strXml).Tables[0];
ControlData objcontroldata;
foreach (DataRow dr in objdt.Rows)
{
objcontroldata = new ControlData();
objcontroldata.PendingROID = Convert.ToString(dr["ROID"]);
objListcontroldata.Add(objcontroldata);
}
}
catch (Exception ex)
{
}
return(objListcontroldata);
}
public ActionResult checkout(BookingDetail bkd)
{
List <Bookcar> li = TempData["Bookcar"] as List <Bookcar>;
// TempData.Keep("Bookcar");
BillingDetail bd = new BillingDetail();
bd.BillDate = System.DateTime.Now;
bd.TotalAmount = Convert.ToDouble(TempData["bill"]);
bd.Customer_Id = Convert.ToInt32(Session["Customer_Id"].ToString());
db.BillingDetails.Add(bd);
db.SaveChanges();
foreach (var item in li)
{
BookingDetail bdetail = new BookingDetail();
bdetail.CarId = item.carid;
bdetail.Billid = bd.Billid;
bdetail.Prize = item.bill;
bdetail.StartDate = item.StartDate;
bdetail.EndDate = item.EndDate;
bdetail.PickupLoc = item.PickupLoc;
db.BookingDetails.Add(bdetail);
db.SaveChanges();
}
TempData.Remove("bill");
TempData.Remove("Bookcar");
TempData["msg"] = "Transaction completed.....";
TempData.Keep();
return(RedirectToAction("Index", "User"));
// return RedirectToAction("User","Index");
//return View("viewcar");
}
public void AddBooking(BookingDetailVM result)
{
int idBook = _bookingDALManageFacade.GetBookingnextid();
Booking booking = new Booking();
mapper.Map(result, booking);
booking.BookIduser = QLUserBLL.stoUser.IdUser;
Client client = new Client();
mapper.Map(result.clientVM, client);
List <BookingDetail> listadd = new List <BookingDetail>();
foreach (SubBookingDetailVM val in result.ListSub)
{
BookingDetail bookingDetail = new BookingDetail();
mapper.Map(val, bookingDetail);
bookingDetail.BoodetIdbook = idBook;
listadd.Add(bookingDetail);
}
try
{
if (client.IdClient == 0)
{
booking.BookIdclient = _bookingDALManageFacade.AddClient(client);
}
else
{
booking.BookIdclient = client.IdClient;
}
_bookingDALManageFacade.AddBooking(booking);
_bookingDALManageFacade.AddBookingDetail(listadd);
}
catch (Exception)
{
throw;
}
}
public IEnumerable <ControlData> Post(BookingDetail objbookingDetail)
{
List <ControlData> objListcontroldata = new List <ControlData>();
try
{
string strXml = "<ebooking><actionname>" + objbookingDetail.Parametername + "</actionname><adcatname>" + objbookingDetail.ParamValueStr + "</adcatname>"
+ "<loguserid>" + objbookingDetail.UserId + "</loguserid>"
+ "<adtypeid>" + objbookingDetail.AdtypeId + "</adtypeid><isclassified>" + objbookingDetail.IsClassified + "</isclassified></ebooking>";
DataTable objdt = objHomeDAL.GeteBookingControlData(strXml).Tables[0];
ControlData objcontroldata;
foreach (DataRow dr in objdt.Rows)
{
objcontroldata = new ControlData();
objcontroldata.CategoryID = Convert.ToString(dr[0]);
objcontroldata.Value = Convert.ToString(dr[1]);
objListcontroldata.Add(objcontroldata);
}
}
catch (Exception ex)
{
}
return(objListcontroldata);
}
public List <BookingDetail> view(string room_category)
{
SqlConnection con = new SqlConnection("server=intvmsql01;user id=PJ09TMS101_1718;password=tcstvm;database=DB09TMS101_1718");
con.Open();
SqlCommand cmd = new SqlCommand("room_ki_cat", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@roomcat", room_category);
List <BookingDetail> lst = new List <BookingDetail>();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BookingDetail s = new BookingDetail();
s.Booking_id = Convert.ToInt16(reader["bid"]);
s.Name = reader["name"].ToString();
s.Age = Convert.ToInt16(reader["age"]);
lst.Add(s);
}
return(lst);
}
public List <List <string> > Post(BookingDetail objbookingDetail)
{
List <List <string> > listarray = new List <List <string> >();
try
{
string strXml = "<ebooking><actionname>" + objbookingDetail.Parametername + "</actionname>"
+ "<fromdate>" + objbookingDetail.FromDate + "</fromdate>"
+ "<todate>" + objbookingDetail.ToDate + "</todate></ebooking>";
DataTable objdt = objHomeDAL.eBookingActions(strXml).Tables[0];
List <String> columnlist = (from dc in objdt.Columns.Cast <DataColumn>()
select dc.ColumnName).ToList();
listarray.Add(columnlist);
foreach (DataRow dr in objdt.Rows)
{
listarray.Add(dr.ItemArray.Select(o => o.ToString()).ToList());
}
}
catch (Exception ex)
{
Utility.ReportError("DisplayValidateAdController::Post:", ex);
}
return(listarray);
}
public ActionResult Create(BookingDetail bookingDetail)
{
if (Session["UserRole"] != null && Session["UserRole"].ToString() == "2")
{
if (ModelState.IsValid)
{
bookingDetail.UserId = Convert.ToInt32(Session["UserId"]);
bookingDetail.Status = "Book";
db.BookingDetails.Add(bookingDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserName = new SelectList(db.UserDetails.Where(u => u.UserTypeId == 2), "FirstName", "FirstName");
ViewBag.HotelId = new SelectList(db.HotelDetails, "HotelId", "HotelName", bookingDetail.HotelId);
return(View(bookingDetail));
}
else
{
Response.Write("<script>alert('Session logged out. Sign in again');</script>");
FormsAuthentication.SignOut();
Session.Clear();
return(RedirectToAction("SignIn", "Auth"));
}
}
public BookingViewModel(BookingDetail bookingDetail)
{
this.BookingDetail = bookingDetail;
}
private void LoadBookingWindow(object obj)
{
var tabledetail = (TableAvailablityDetail)obj;
var bookingDetail = new BookingDetail() { TableId = tabledetail.TableId, BookingDate = BookingDate, CheckInTime = CheckInTime };
BookTableEvent.Instance.Publish(bookingDetail);
}
private void ZubosFrmViewBookings_Load(object sender, EventArgs e)
{
DgvBookings.DataSource = BookingDetail.GetAllBookingsAsDataTable();
DgvBookings.Columns[(DgvBookings.Columns.Count - 2)].Width = 350;
}
private void OpenCustomerView(BookingDetail obj)
{
BookingViewModel viewModel = new BookingViewModel(obj);
BookingView view = new BookingView(viewModel);
view.ShowDialog();
}
public IEnumerable <CSRateCalculation> Post(BookingDetail objbookingDetail)
{
List <CSRateCalculation> objListRate = new List <CSRateCalculation>();
try
{
HomeDAL objHomeDAL = new HomeDAL();
string strXml = string.Empty;
string dates = objbookingDetail.DateSelected;
string[] selecteddate = dates.Split(',');
string packages = objbookingDetail.PackageID;
string[] selectedpackages = packages.Split(',');
string peids = objbookingDetail.PEID;
string[] selectedpeids = peids.Split(',');
string packageids = string.Empty;
string statusids = objbookingDetail.Status;
string[] selectedstatusids = statusids.Split(',');
string cauditstatusids = objbookingDetail.AuditStatus;
string[] selectedcauditstatusids = cauditstatusids.Split(',');
int totalrecordreturn = objbookingDetail.list.Count;
if (selectedpackages.Length == 1)
{
packageids = objbookingDetail.PackageID;
}
else
{
packageids = "0";
}
if (selecteddate.Length > 0)
{
strXml += "<ebooking>"
+ "<orderlevel>"
+ "<roid>" + objbookingDetail.ROID + "</roid>"
+ "<bookingdate>" + objbookingDetail.BookingDate + "</bookingdate>"
+ "<revenuecentreid>" + objbookingDetail.RevenueCentreID + "</revenuecentreid>"
+ "<bookingcentreid>" + objbookingDetail.BookingCentreID + "</bookingcentreid>"
+ "<ratecentreid>" + objbookingDetail.RevenueCentreID + "</ratecentreid>"
+ "<bookingexecid>" + objbookingDetail.UserId + "</bookingexecid>"
+ "<ronumber>" + objbookingDetail.RONumber + "</ronumber>"
+ "<agencyid>" + objbookingDetail.AgencyID + "</agencyid>"
+ "<clientid>" + objbookingDetail.ClientID + "</clientid>"
+ "<ccname>" + objbookingDetail.ClientName + "</ccname>"
+ "<ccvatnumber>" + objbookingDetail.ClientVatNum + "</ccvatnumber>"
//+ "<adflag>1</adflag>"
//+ "<rateflag>0</rateflag>"
+ "<packageid>" + packageids + "</packageid>"
+ "<packagelist>" + objbookingDetail.PackageID + "</packagelist>"
+ "<productid>" + objbookingDetail.ProductID + "</productid>"
+ "<totalinsertions>" + selecteddate.Length + "</totalinsertions>"
+ "<uom>" + objbookingDetail.UOMID + "</uom>"
+ "<isclassified>" + objbookingDetail.IsClassified + "</isclassified>"
+ "<ratefieldchanged>" + objbookingDetail.RateFieldChanged + "</ratefieldchanged>"
+ "<boxtypeid>" + objbookingDetail.BoxTypeID + "</boxtypeid>"
+ "<paymentmode>" + objbookingDetail.PaymentTypeID + "</paymentmode>"
+ "<ismanualbilling>" + objbookingDetail.IsManualBilling + "</ismanualbilling>";
for (var i = 0; i < totalrecordreturn; i++)
{
var date = objbookingDetail.list[i].ScheduledDate.Substring(0, 10);
strXml += "<insertlevel>"
+ "<insnum>" + objbookingDetail.list[i].InsNum + "</insnum>"
+ "<invoicenum>0</invoicenum>";
var peid = objbookingDetail.list[i].PEID;
strXml += "<itemlevel>"
+ "<peid>" + peid + "</peid>"
+ "<status>" + objbookingDetail.list[i].Status + "</status>"
+ "<auditstatus>" + objbookingDetail.list[i].AuditStatus + "</auditstatus>"
+ "<paymentstatus>0</paymentstatus>"
+ "<materialstatus>0</materialstatus>"
+ "<adtypeid>" + objbookingDetail.AdtypeId + "</adtypeid>";
strXml += "<adtype1>" + objbookingDetail.list[i].AdtypeID1 + "</adtype1>"
+ "<adtype2>" + objbookingDetail.list[i].AdtypeID2 + "</adtype2>"
+ "<adtype3>" + objbookingDetail.list[i].AdtypeID3 + "</adtype3>"
+ "<adtype4>" + objbookingDetail.list[i].AdtypeID4 + "</adtype4>"
+ "<stylesheetid>" + objbookingDetail.list[i].StyleSheetID + "</stylesheetid>"
+ "<materialid>" + objbookingDetail.list[i].MaterialID + "</materialid>";
strXml += "<iscd>" + objbookingDetail.IsCD + "</iscd>"
+ "<islogo>" + objbookingDetail.IsLogo + "</islogo>";
if (objbookingDetail.IsCD == 0)
{
strXml += "<totalwords>" + objbookingDetail.list[i].TotalWords + "</totalwords>"
+ "<mbodycount>" + objbookingDetail.list[i].MBodyCount + "</mbodycount>"
+ "<charcount>" + objbookingDetail.list[i].CharCount + "</charcount>"
+ "<bodytext>" + objbookingDetail.list[i].U_BodyText + "</bodytext>";
}
else
{
strXml += "<totalwords>" + objbookingDetail.TotalWords + "</totalwords>"
+ "<mbodycount>" + objbookingDetail.MBodyCount + "</mbodycount>"
+ "<charcount>" + objbookingDetail.CharCount + "</charcount>"
+ "<bodytext>" + objbookingDetail.AdText + "</bodytext>";
}
strXml += "<releaseid>0</releaseid>"
+ "<scheduleddate>" + date + "</scheduleddate>"
+ "<adcolumns>" + objbookingDetail.ClassifiedCol + "</adcolumns>"
+ "<fileheight>" + objbookingDetail.LogoHeight + "</fileheight>";
if (objbookingDetail.IsCD == 0)
{
strXml += "<adsize>" + objbookingDetail.list[i].AdSizeHeight + "*" + objbookingDetail.AdsizeWidth + "</adsize>"
+ "<adheight>" + objbookingDetail.list[i].AdSizeHeight + "</adheight>"
+ "<adwidth>" + objbookingDetail.AdsizeWidth + "</adwidth>"
+ "<adarea>" + Convert.ToDouble(objbookingDetail.list[i].AdSizeHeight) * Convert.ToDouble(objbookingDetail.AdsizeWidth) + "</adarea>"
+ "<billablesize>" + objbookingDetail.list[i].AdSizeHeight + "*" + objbookingDetail.AdsizeWidth + "</billablesize>"
+ "<billableheight>" + objbookingDetail.list[i].AdSizeHeight + "</billableheight>"
+ "<billablewidth>" + objbookingDetail.AdsizeWidth + "</billablewidth>"
+ "<billablearea>" + Convert.ToDouble(objbookingDetail.list[i].AdSizeHeight) * Convert.ToDouble(objbookingDetail.AdsizeWidth) + "</billablearea>";
}
else
{
strXml += "<adsize>" + objbookingDetail.AdsizeHeight + "*" + objbookingDetail.AdsizeWidth + "</adsize>"
+ "<adheight>" + objbookingDetail.AdsizeHeight + "</adheight>"
+ "<adwidth>" + objbookingDetail.AdsizeWidth + "</adwidth>"
+ "<adarea>" + Convert.ToDouble(objbookingDetail.AdsizeHeight) * Convert.ToDouble(objbookingDetail.AdsizeWidth) + "</adarea>"
+ "<billablesize>" + objbookingDetail.AdsizeHeight + "*" + objbookingDetail.AdsizeWidth + "</billablesize>"
+ "<billableheight>" + objbookingDetail.AdsizeHeight + "</billableheight>"
+ "<billablewidth>" + objbookingDetail.AdsizeWidth + "</billablewidth>"
+ "<billablearea>" + Convert.ToDouble(objbookingDetail.AdsizeHeight) * Convert.ToDouble(objbookingDetail.AdsizeWidth) + "</billablearea>";
}
strXml += "<itemratefieldchanged>" + objbookingDetail.list[i].ItemRateFieldChanged + "</itemratefieldchanged>"
+ "<agreedrate>" + objbookingDetail.list[i].AgreedRate + "</agreedrate>"
+ "<agreedamount>" + objbookingDetail.list[i].AgreedAmount + "</agreedamount>"
+ "<agreeddiscper>" + objbookingDetail.list[i].AgreedDiscPer + "</agreeddiscper>"
+ "<extrachargesper>" + objbookingDetail.list[i].ExtraChargesPer + "</extrachargesper>"
+ "<extrachargesamount>" + objbookingDetail.list[i].ExtraChargesAmount + "</extrachargesamount>"
+ "<extradiscountper>" + objbookingDetail.list[i].ExtraDiscPer + "</extradiscountper>"
+ "<extradiscountamount>" + objbookingDetail.list[i].ExtraDiscAmount + "</extradiscountamount>"
+ "<extraboxchargesper>" + objbookingDetail.ExtraBoxChargesPer + "</extraboxchargesper>"
+ "<extraboxchargesamount>" + objbookingDetail.ExtraBoxChargesAmount + "</extraboxchargesamount>"
+ "<readonlyflag>" + objbookingDetail.list[i].ReadOnlyFlag + "</readonlyflag>"
+ "<boxnumber>" + objbookingDetail.list[i].BoxNumber + "</boxnumber>"
+ "<startcol>" + objbookingDetail.list[i].StartCol + "</startcol>"
+ "<yposition>" + objbookingDetail.list[i].Yposition + "</yposition>"
+ "</itemlevel>";
strXml += "</insertlevel>";
}
if (objbookingDetail.PaymentTypeID == 1)
{
strXml += "<receiptetail>"
+ "<receiptamount>" + objbookingDetail.TotalReceivable + "</receiptamount>"
+ "<totalamountpaid>" + objbookingDetail.ReceiptAmount + "</totalamountpaid>"
+ "<writeoffamount>" + objbookingDetail.WriteoffAmount + "</writeoffamount>"
+ "<receiptdate>" + DateTime.Now.ToString("dd/MM/yyyy") + "</receiptdate>";
if (objbookingDetail.Amount != 0)
{
strXml += "<paymentdetail>"
+ "<paymentmodeid>" + objbookingDetail.PaymentModeID + "</paymentmodeid>"
+ "<chequenumber>" + objbookingDetail.ChequeNumber + "</chequenumber>"
+ "<chequedate></chequedate>"
+ "<amount>" + objbookingDetail.Amount + "</amount>"
+ "<bankid>" + objbookingDetail.BankID + "</bankid>"
+ "<bankname>" + objbookingDetail.BranchBankName + "</bankname>"
+ "<branchid>" + objbookingDetail.BankNameID + "</branchid>"
+ "<branchname>" + objbookingDetail.BranchName + "</branchname>"
+ "<bankbranchcode>" + objbookingDetail.BankName + "</bankbranchcode>"
+ "</paymentdetail>";
}
if (objbookingDetail.Amount1 != 0)
{
strXml += "<paymentdetail>"
+ "<paymentmodeid>" + objbookingDetail.PaymentModeID1 + "</paymentmodeid>"
+ "<chequenumber>" + objbookingDetail.ChequeNumber1 + "</chequenumber>"
+ "<chequedate></chequedate>"
+ "<amount>" + objbookingDetail.Amount1 + "</amount>"
+ "<bankid>" + objbookingDetail.BankID1 + "</bankid>"
+ "<bankname>" + objbookingDetail.BranchBankName1 + "</bankname>"
+ "<branchid>" + objbookingDetail.BankNameID1 + "</branchid>"
+ "<branchname>" + objbookingDetail.BranchName1 + "</branchname>"
+ "<bankbranchcode>" + objbookingDetail.BankName1 + "</bankbranchcode>"
+ "</paymentdetail>";
}
if (objbookingDetail.Amount2 != 0)
{
strXml += "<paymentdetail>"
+ "<paymentmodeid>" + objbookingDetail.PaymentModeID2 + "</paymentmodeid>"
+ "<chequenumber>" + objbookingDetail.ChequeNumber2 + "</chequenumber>"
+ "<chequedate></chequedate>"
+ "<amount>" + objbookingDetail.Amount2 + "</amount>"
+ "<bankid>" + objbookingDetail.BankID2 + "</bankid>"
+ "<bankname>" + objbookingDetail.BranchBankName2 + "</bankname>"
+ "<branchid>" + objbookingDetail.BankNameID2 + "</branchid>"
+ "<branchname>" + objbookingDetail.BranchName2 + "</branchname>"
+ "<bankbranchcode>" + objbookingDetail.BankName2 + "</bankbranchcode>"
+ "</paymentdetail>";
}
strXml += "</receiptetail>";
}
strXml += "</orderlevel></ebooking>";
}
DataTable objdt = objHomeDAL.GeteBookingRateData(strXml).Tables[0];
CSRateCalculation objRate;
if (objdt.Rows.Count > 0)
{
objRate = new CSRateCalculation();
objRate.IsValid = Convert.ToInt16(objdt.Rows[0]["ErrorFlag"]);
if (objRate.IsValid == 1 || objRate.IsValid == -2)
{
objRate.ErrorMessage = Convert.ToString(objdt.Rows[0]["ErrorMessage"]);
objRate.IsValid = Convert.ToInt16(objdt.Rows[0]["ErrorFlag"]);
objListRate.Add(objRate);
}
else
{
foreach (DataRow dr in objdt.Rows)
{
objRate = new CSRateCalculation();
objRate.StartCol = Convert.ToString(dr["StartCol"]);
objRate.Yposition = Convert.ToString(dr["Yposition"]);
objRate.BoxNumber = Convert.ToString(dr["BoxNumber"]);
objRate.RecID = Convert.ToInt16(dr["RecID"]);
objRate.BaseRate = Convert.ToDouble(dr["BaseRate"]);
objRate.CardRate = Convert.ToDouble(dr["CardRate"]);
objRate.CardAmount = Convert.ToDouble(dr["CardAmount"]);
objRate.AgreedRate = Convert.ToDouble(dr["AgreedRate"]);
objRate.AgreedAmount = Convert.ToDouble(dr["AgreedAmount"]);
objRate.AgreedDiscPer = Convert.ToDouble(dr["AgreedDiscPer"]);
objRate.AgreedDiscAmount = Convert.ToDouble(dr["AgreedDiscAmount"]);
objRate.RateCardID = Convert.ToInt16(dr["RateCardID"]);
objRate.AdRateID = Convert.ToInt16(dr["AdRateID"]);
objRate.RateDiff = Convert.ToDouble(dr["RateDiff"]);
objRate.BillableArea = Convert.ToDouble(dr["BillableArea"]);
objRate.SizeID = Convert.ToInt16(dr["SizeID"]);
objRate.AdSizeWidth = Convert.ToDouble(dr["SizeWidth"]);
objRate.AdSizeHeight = Convert.ToDouble(dr["SizeHeight"]);
objRate.AdSizeArea = Convert.ToDouble(dr["SizeArea"]);
objRate.ColWidth = Convert.ToDouble(dr["ColWidth"]);
objRate.ColumnSize = Convert.ToDouble(dr["ColumnSize"]);
objRate.Gutter = Convert.ToDouble(dr["Gutter"]);
objRate.AgencyCommissionPer = Convert.ToDouble(dr["AgencyCommissionPer"]);
objRate.AgencyCommissionAmount = Convert.ToDouble(dr["AgencyCommissionAmount"]);
objRate.PreVATAmount = Convert.ToDouble(dr["PreVATAmount"]);
objRate.Receivable = Convert.ToDouble(dr["Receivable"]);
objRate.NetReceivable = Convert.ToDouble(dr["NetReceivable"]);
objRate.ColorRate = Convert.ToDouble(dr["ColorRate"]);
objRate.PremiaRate = Convert.ToDouble(dr["PremiaRate"]);
objRate.VATPer = Convert.ToDouble(dr["VATPer"]);
objRate.VATAmount = Convert.ToDouble(dr["VATAmount"]);
objRate.WtPer = Convert.ToDouble(dr["WtPer"]);
objRate.WTAmount = Convert.ToDouble(dr["WTAmount"]);
objRate.ExtraDiscPer = Convert.ToDouble(dr["ExtraDiscPer"]);
objRate.ExtraDiscAmount = Convert.ToDouble(dr["ExtraDiscAmount"]);
objRate.ExtraChargesPer = Convert.ToDouble(dr["ExtraChargesPer"]);
objRate.ExtraChargesAmount = Convert.ToDouble(dr["ExtraChargesAmount"]);
objRate.ExtraBoxChargesPer = Convert.ToDouble(dr["BoxChargesPer"]);
objRate.ExtraBoxChargesAmount = Convert.ToDouble(dr["BoxChargesAmount"]);
objRate.ScheduledDate = Convert.ToDateTime(dr["ScheduledDate"]).ToString("dd/MM/yyyy");
objRate.InsNum = Convert.ToInt16(dr["InsNum"]);
objRate.PackageID = Convert.ToInt16(dr["PackageID"]);
objRate.PublicationID = Convert.ToInt16(dr["PublicationID"]);
objRate.PEID = Convert.ToInt16(dr["PEID"]);
objRate.PremiaID = Convert.ToInt16(dr["PremiaID"]);
objRate.ColorID = Convert.ToInt16(dr["ColorID"]);
objRate.SchemeID = Convert.ToInt16(dr["SchemeID"]);
objRate.SchemeDetailID = Convert.ToInt16(dr["SchemeDetailID"]);
objRate.SchemeAmount = Convert.ToDouble(dr["SchemeAmount"]);
objRate.SchemeName = Convert.ToString(dr["SchemeName"]);
objRate.SchemeDays = Convert.ToString(dr["SchemeDays"]);
objRate.AdTypeID = Convert.ToInt16(dr["AdTypeID"]);
objRate.StyleSheetID = Convert.ToInt16(dr["StyleSheetID"]);
objRate.StyleSheetName = Convert.ToString(dr["StyleSheetName"]);
objRate.MinAmount = Convert.ToDouble(dr["MinAmount"]);
objRate.MinArea = Convert.ToDouble(dr["MinArea"]);
objRate.UOM = Convert.ToInt16(dr["UOM"]);
objRate.Status = Convert.ToInt16(dr["Status"]);
objRate.AuditStatus = Convert.ToInt16(dr["AuditStatus"]);
objRate.MaterialType = Convert.ToInt16(dr["MaterialType"]);
objRate.MaterialSource = Convert.ToInt16(dr["MaterialSource"]);
objRate.ReceiptPayTypeID = Convert.ToInt16(dr["ReceiptPayTypeID"]);
objRate.MBodyCount = Convert.ToString(dr["MBodyCount"]);
objRate.RateFieldChanged = Convert.ToInt16(dr["RateFieldChanged"]);
objRate.PECode = Convert.ToString(dr["PECode"]);
objRate.AdStatus = Convert.ToString(dr["AdStatus"]);
objRate.AdClassification = Convert.ToString(dr["AdClassification"]);
objRate.AdtypeID1 = Convert.ToInt16(dr["Adtype1"]);
objRate.AdtypeID2 = Convert.ToInt16(dr["Adtype2"]);
objRate.AdtypeID3 = Convert.ToInt16(dr["Adtype3"]);
objRate.AdtypeID4 = Convert.ToInt16(dr["Adtype4"]);
objRate.MaterialID = Convert.ToString(dr["MaterialID"]);
objRate.ReadOnlyFlag = Convert.ToString(dr["ReadOnlyFlag"]);
objRate.AdColumns = Convert.ToString(dr["AdColumns"]);
objRate.ItemRateFieldChanged = Convert.ToInt16(dr["ItemRateFieldChanged"]);
objRate.PackageIDSent = Convert.ToInt16(dr["PackageIDSent"]);
objRate.U_BodyText = Convert.ToString(dr["bodytext"]);
objRate.TotalWords = Convert.ToString(dr["totalwords"]);
objRate.CharCount = Convert.ToString(dr["charcount"]);
objListRate.Add(objRate);
}
}
}
}
catch (Exception ex)
{
Utility.ReportError("DisplayRateCalculationController::Post:", ex);
}
return(objListRate);
}
public static void Initialize(ToolBookingContext context)
{
context.Database.EnsureCreated();
if (context.BookingDetails.Any())
{
return; // DB has been seeded
}
var blacklists = new Blacklist[]
{
new Blacklist {
UserID = "61010001"
},
new Blacklist {
UserID = "61010002"
},
new Blacklist {
UserID = "61010003"
},
new Blacklist {
UserID = "61010004"
},
new Blacklist {
UserID = "61010005"
},
};
foreach (Blacklist b in blacklists)
{
context.Blacklists.Add(b);
}
context.SaveChanges();
var tools = new Tool[]
{
new Tool {
ToolID = 1, Toolname = "Voltmeter", Quantity = 20
},
new Tool {
ToolID = 2, Toolname = "Arduino", Quantity = 20
},
new Tool {
ToolID = 3, Toolname = "Osilloscope", Quantity = 20
},
new Tool {
ToolID = 4, Toolname = "Soldering Iron", Quantity = 20
},
new Tool {
ToolID = 5, Toolname = "Pliers", Quantity = 20
},
};
foreach (Tool t in tools)
{
context.Tools.Add(t);
}
context.SaveChanges();
var bookingdetails = new BookingDetail[]
{
new BookingDetail {
BookingID = 1, ToolID = 1, UserID = "61010001", start_time = "1621670400"
},
new BookingDetail {
BookingID = 2, ToolID = 2, UserID = "61010002", start_time = "1621670400"
},
new BookingDetail {
BookingID = 3, ToolID = 3, UserID = "61010003", start_time = "1621670400"
},
new BookingDetail {
BookingID = 4, ToolID = 4, UserID = "61010004", start_time = "1621670400"
},
};
foreach (BookingDetail b in bookingdetails)
{
context.BookingDetails.Add(b);
}
context.SaveChanges();
}
public bool InsertUpdateBookingDetail(BookingDetail item)
{
return(new DLBookingDetail().InsertUpdateObject(item));
}
public Dictionary <string, object> Post(BookingDetail objbookingDetail)
{
Dictionary <string, object> OrderDetails = new Dictionary <string, object>();
List <OpenOrder> objListOpenOrder = new List <OpenOrder>();
List <CompositeReceiptOrder> objListCompositeReceiptOrder = new List <CompositeReceiptOrder>();
List <CompositeReceiptROID> objListCompositeReceiptROID = new List <CompositeReceiptROID>();
OpenOrder objOpenOder;
try
{
HomeDAL objHomeDAL = new HomeDAL();
string strXml = string.Empty;
strXml += "<ebooking><actionname>opencompositereceipt</actionname><receiptid>" + objbookingDetail.ReceiptID + "</receiptid></ebooking>";
DataSet objds = objHomeDAL.eBookingActions(strXml);
if (objds.Tables.Count == 1)
{
objOpenOder = new OpenOrder();
objOpenOder.IsValid = Convert.ToInt16(objds.Tables[0].Rows[0]["ErrorFlag"]);
if (objOpenOder.IsValid == 1)
{
objOpenOder.ErrorMessage = Convert.ToString(objds.Tables[0].Rows[0]["ErrorMessage"]);
objOpenOder.IsValid = Convert.ToInt16(objds.Tables[0].Rows[0]["ErrorFlag"]);
objListOpenOrder.Add(objOpenOder);
OrderDetails.Add("OpenOrder", objListOpenOrder);
}
}
else
{
DataTable objdt = objds.Tables[0];
DataTable objdt1 = objds.Tables[1];
CompositeReceiptOrder objCompositeReceiptOder;
if (objdt.Rows.Count > 0)
{
foreach (DataRow dr in objdt.Rows)
{
objCompositeReceiptOder = new CompositeReceiptOrder();
objCompositeReceiptOder.ReceiptID = Convert.ToInt64(dr["ReceiptID"]);
objCompositeReceiptOder.TotalPayableAmount = Convert.ToDouble(dr["TotalPayableAmount"]);
objCompositeReceiptOder.TotalAmountPaid = Convert.ToDouble(dr["TotalAmountPaid"]);
objCompositeReceiptOder.WriteOffAmount = Convert.ToDouble(dr["WriteOffAmount"]);
objCompositeReceiptOder.LogUserID = Convert.ToInt64(dr["LogUserID"]);
objCompositeReceiptOder.ReceiptStatus = Convert.ToInt16(dr["ReceiptStatus"]);
objCompositeReceiptOder.ReceiptRemarks = Convert.ToString(dr["ReceiptRemarks"]);
objCompositeReceiptOder.CancelDate = Convert.ToString(dr["CancelDate"]);
objCompositeReceiptOder.BillingRemarks = Convert.ToString(dr["BillingRemarks"]);
objCompositeReceiptOder.CancellationRemarks = Convert.ToString(dr["CancellationRemarks"]);
objCompositeReceiptOder.ReceiptDate = Convert.ToString(dr["ReceiptDate"]);
objCompositeReceiptOder.AdvancedUsed = Convert.ToDouble(dr["AdvancedUsed"]);
objCompositeReceiptOder.AdvancedRecieved = Convert.ToDouble(dr["AdvancedRecieved"]);
objCompositeReceiptOder.ReceiptCentreID = Convert.ToInt16(dr["ReceiptCentreID"]);
objCompositeReceiptOder.ReceiptNumber = Convert.ToInt64(dr["ReceiptNumber"]);
objCompositeReceiptOder.IsClassified = Convert.ToInt16(dr["IsClassified"]);
objCompositeReceiptOder.CancelledUserId = Convert.ToInt16(dr["CancelledUserId"]);
objCompositeReceiptOder.AgencyID = Convert.ToInt16(dr["AgencyID"]);
objCompositeReceiptOder.ClientID = Convert.ToInt16(dr["ClientID"]);
objCompositeReceiptOder.CasualClient = Convert.ToString(dr["CasualClient"]);
objCompositeReceiptOder.AgencyName = Convert.ToString(dr["AgencyName"]);
objCompositeReceiptOder.BillTo = Convert.ToInt16(dr["BillTo"]);
objCompositeReceiptOder.RevenueCentreid = Convert.ToInt16(dr["RevenueCentreid"]);
objCompositeReceiptOder.MachineName = Convert.ToString(dr["MachineName"]);
objCompositeReceiptOder.CasualAddress = Convert.ToString(dr["CasualAddress"]);
objCompositeReceiptOder.City = Convert.ToString(dr["City"]);
objCompositeReceiptOder.Phone = Convert.ToString(dr["Phone"]);
objCompositeReceiptOder.Zip = Convert.ToString(dr["Zip"]);
objCompositeReceiptOder.ReceiptPaymentMode = Convert.ToInt16(dr["PaymentMode"]);
objCompositeReceiptOder.BankID = Convert.ToInt16(dr["BankID"]);
objCompositeReceiptOder.CheckNumber = Convert.ToString(dr["Number"]);
objCompositeReceiptOder.PaymentDate = Convert.ToString(dr["PaymentDate"]);
objCompositeReceiptOder.Amount = Convert.ToDouble(dr["Amount"]);
objCompositeReceiptOder.BankName = Convert.ToString(dr["BankName"]);
objCompositeReceiptOder.BranchName = Convert.ToString(dr["BranchName"]);
objCompositeReceiptOder.BranchID = Convert.ToInt16(dr["BranchID"]);
objCompositeReceiptOder.BankBranchCode = Convert.ToString(dr["BankBranchCode"]);
objCompositeReceiptOder.CashReceived = Convert.ToDouble(dr["CashReceived"]);
objCompositeReceiptOder.CashRefund = Convert.ToDouble(dr["CashRefund"]);
objCompositeReceiptOder.AdvanceReceiptID = Convert.ToInt64(dr["AdvanceReceiptID"]);
objListCompositeReceiptOrder.Add(objCompositeReceiptOder);
}
}
CompositeReceiptROID objCompositeReceiptROID;
if (objdt1.Rows.Count > 0)
{
foreach (DataRow dr in objdt1.Rows)
{
objCompositeReceiptROID = new CompositeReceiptROID();
objCompositeReceiptROID.ROID = Convert.ToString(dr["ROID"]);
objCompositeReceiptROID.Net = Convert.ToDouble(dr["Net"]);
objListCompositeReceiptROID.Add(objCompositeReceiptROID);
}
}
OrderDetails.Add("CompoReceiptOrder", objListCompositeReceiptOrder);
OrderDetails.Add("CompoReceiptROID", objListCompositeReceiptROID);
}
}
catch (Exception ex)
{
Utility.ReportError("DisplayOpenOrderController::Post:", ex);
}
return(OrderDetails);
}
public async Task <Bicycles> reserve(BookingDetail value)
{
return(await this._bicycleService.reserve(value));
}
public BookingDetail Post(BookingDetail objbookingDetail)
{
string strXml = string.Empty;
try
{
HomeDAL objHomeDAL = new HomeDAL();
string roids = objbookingDetail.PendingROID;
string[] selectedroids = roids.Split(',');
strXml += "<ebooking><orderlevel><receiptetail>"
+ "<agencyid>" + objbookingDetail.AgencyID + "</agencyid><clientid>" + objbookingDetail.ClientID + "</clientid>"
+ "<casualclientname>" + objbookingDetail.CasualClientName + "</casualclientname><casualaddress>" + objbookingDetail.CasualClientAddress + "</casualaddress>"
+ "<City>" + objbookingDetail.CasualClientCity + "</City><Phone>" + objbookingDetail.CasualClientPhoneNo + "</Phone><Zip>" + objbookingDetail.CasualClientZipCode + "</Zip>"
+ "<revenuecentreid>" + objbookingDetail.RevenueCentreID + "</revenuecentreid><loguserid>" + objbookingDetail.UserId + "</loguserid>"
+ "<totalamountreceivable>" + objbookingDetail.ReceivableAmount + "</totalamountreceivable>"
+ "<receiptamount>" + objbookingDetail.TotalReceivable + "</receiptamount>"
+ "<writeoffamount>" + objbookingDetail.WriteoffAmount + "</writeoffamount>"
+ "<totalamountpaid>" + objbookingDetail.ReceiptAmount + "</totalamountpaid>"
+ "<receiptdate>" + DateTime.Now.ToString("dd/MM/yyyy") + "</receiptdate>"
+ "<saveflag>" + objbookingDetail.SaveFlag + "</saveflag>"
+ "<receiptremarks></receiptremarks>";
for (var i = 0; i < selectedroids.Length; i++)
{
strXml += "<OrdersPaid>"
+ "<ROID>" + selectedroids[i] + "</ROID>"
+ "</OrdersPaid>";
}
if (objbookingDetail.Amount != 0)
{
strXml += "<paymentdetail>"
+ "<paymentmodeid>" + objbookingDetail.PaymentModeID + "</paymentmodeid><chequenumber>" + objbookingDetail.ChequeNumber + "</chequenumber><chequedate></chequedate>"
+ "<amount>" + objbookingDetail.Amount + "</amount><bankid>" + objbookingDetail.BankID + "</bankid><bankname>" + objbookingDetail.BranchBankName + "</bankname>"
+ "<branchid>" + objbookingDetail.BankNameID + "</branchid><branchname>" + objbookingDetail.BranchName + "</branchname>"
+ "<bankbranchcode>" + objbookingDetail.BankName + "</bankbranchcode>"
+ "<advanceamount>" + objbookingDetail.AdvanceAmount + "</advanceamount><advancereceiptid>" + objbookingDetail.AdvanceReceiptID + "</advancereceiptid>"
+ "<advanceutilised>" + objbookingDetail.AdvanceUtilised + "</advanceutilised>"
+ "</paymentdetail>";
}
if (objbookingDetail.Amount1 != 0)
{
strXml += "<paymentdetail>"
+ "<paymentmodeid>" + objbookingDetail.PaymentModeID1 + "</paymentmodeid><chequenumber>" + objbookingDetail.ChequeNumber1 + "</chequenumber><chequedate></chequedate>"
+ "<amount>" + objbookingDetail.Amount1 + "</amount><bankid>" + objbookingDetail.BankID1 + "</bankid><bankname>" + objbookingDetail.BranchBankName1 + "</bankname>"
+ "<branchid>" + objbookingDetail.BankNameID1 + "</branchid><branchname>" + objbookingDetail.BranchName1 + "</branchname>"
+ "<bankbranchcode>" + objbookingDetail.BankName1 + "</bankbranchcode>"
+ "<advanceamount>" + objbookingDetail.AdvanceAmount1 + "</advanceamount><advancereceiptid>" + objbookingDetail.AdvanceReceiptID1 + "</advancereceiptid>"
+ "<advanceutilised>" + objbookingDetail.AdvanceUtilised1 + "</advanceutilised>"
+ "</paymentdetail>";
}
if (objbookingDetail.Amount2 != 0)
{
strXml += "<paymentdetail>"
+ "<paymentmodeid>" + objbookingDetail.PaymentModeID2 + "</paymentmodeid><chequenumber>" + objbookingDetail.ChequeNumber2 + "</chequenumber><chequedate></chequedate>"
+ "<amount>" + objbookingDetail.Amount2 + "</amount><bankid>" + objbookingDetail.BankID2 + "</bankid><bankname>" + objbookingDetail.BranchBankName2 + "</bankname>"
+ "<branchid>" + objbookingDetail.BankNameID2 + "</branchid><branchname>" + objbookingDetail.BranchName2 + "</branchname>"
+ "<bankbranchcode>" + objbookingDetail.BankName2 + "</bankbranchcode>"
+ "<advanceamount>" + objbookingDetail.AdvanceAmount2 + "</advanceamount><advancereceiptid>" + objbookingDetail.AdvanceReceiptID2 + "</advancereceiptid>"
+ "<advanceutilised>" + objbookingDetail.AdvanceUtilised2 + "</advanceutilised>"
+ "</paymentdetail>";
}
strXml += "</receiptetail></orderlevel></ebooking>";
DataTable objdt = objHomeDAL.BookNewReceiptXML(strXml).Tables[0];
if (objdt.Rows.Count > 0)
{
objbookingDetail.IsValid = Convert.ToInt16(objdt.Rows[0]["ErrorFlag"]);
if (objbookingDetail.IsValid > 0)
{
objbookingDetail.ErrorMessage = Convert.ToString(objdt.Rows[0]["ErrorMessage"]);
objbookingDetail.IsValid = Convert.ToInt16(objdt.Rows[0]["ErrorFlag"]);
}
else
{
objbookingDetail.ReceiptID = Convert.ToInt64(objdt.Rows[0]["ReceiptID"]);
objbookingDetail.IsValid = Convert.ToInt16(objdt.Rows[0]["ErrorFlag"]);
objbookingDetail.ErrorMessage = Convert.ToString(objdt.Rows[0]["ErrorMessage"]);
}
}
}
catch (Exception ex)
{
Utility.ReportLogError("SP_Name::EBK_SP_CreateReceiptXML:", ex, strXml);
}
return(objbookingDetail);
}
public Dictionary <string, object> Post(BookingDetail objbookingDetail)
{
Dictionary <string, object> OrderDetails = new Dictionary <string, object>();
List <OpenOrder> objListOpenOrder = new List <OpenOrder>();
List <ReceiptOrder> objListReceiptOrder = new List <ReceiptOrder>();
List <ROFilesOrder> objListROFilesOrder = new List <ROFilesOrder>();
OpenOrder objOpenOder;
try
{
HomeDAL objHomeDAL = new HomeDAL();
string strXml = string.Empty;
strXml += "<ebooking><actionname>openbookingid</actionname><bookingid>" + objbookingDetail.BookingID + "</bookingid>"
+ "<loguserid>" + objbookingDetail.UserId + "</loguserid>"
+ "<logcentreid>" + objbookingDetail.RevenueCentreID + "</logcentreid>"
+ "<isclassified>" + objbookingDetail.IsClassified + "</isclassified></ebooking>";
DataSet objds = objHomeDAL.eBookingActions(strXml);
if (objds.Tables.Count == 1)
{
objOpenOder = new OpenOrder();
objOpenOder.IsValid = Convert.ToInt16(objds.Tables[0].Rows[0]["ErrorFlag"]);
if (objOpenOder.IsValid == 1)
{
objOpenOder.ErrorMessage = Convert.ToString(objds.Tables[0].Rows[0]["ErrorMessage"]);
objOpenOder.IsValid = Convert.ToInt16(objds.Tables[0].Rows[0]["ErrorFlag"]);
objListOpenOrder.Add(objOpenOder);
OrderDetails.Add("OpenOrder", objListOpenOrder);
}
}
else
{
DataTable objdt = objds.Tables[0];
DataTable objdt1 = objds.Tables[1];
DataTable objdt2 = objds.Tables[2];
if (objdt.Rows.Count > 0)
{
foreach (DataRow dr in objdt.Rows)
{
objOpenOder = new OpenOrder();
objOpenOder.StartCol = Convert.ToString(dr["StartCol"]);
objOpenOder.Yposition = Convert.ToString(dr["Yposition"]);
objOpenOder.BoxNumber = Convert.ToString(dr["BoxNumber"]);
objOpenOder.RevenueCentreID = Convert.ToInt16(dr["RevenueCentreID"]);
objOpenOder.BookingCentreID = Convert.ToInt16(dr["BookingCentreID"]);
objOpenOder.IsClassified = Convert.ToInt16(dr["IsClassified"]);
objOpenOder.RODate = Convert.ToString(dr["RODate"]);
objOpenOder.BookingDate = Convert.ToDateTime(dr["BookingDate"]).ToString("dd/MM/yyyy HH:mm:ss.fff");
objOpenOder.BookingExecID = Convert.ToInt16(dr["BookingExecID"]);
objOpenOder.BookingNumber = Convert.ToString(dr["BookingNumber"]);
objOpenOder.RONumber = Convert.ToString(dr["RONumber"]);
objOpenOder.AgencyID = Convert.ToInt16(dr["AgencyID"]);
objOpenOder.ClientID = Convert.ToInt16(dr["ClientID"]);
objOpenOder.AgentID = Convert.ToInt16(dr["AgentID"]);
objOpenOder.CanvassorID = Convert.ToInt16(dr["CanvassorID"]);
objOpenOder.ROType = Convert.ToInt16(dr["ROType"]);
objOpenOder.BillingCycle = Convert.ToInt16(dr["BillingCycle"]);
objOpenOder.BillTo = Convert.ToInt16(dr["BillTo"]);
objOpenOder.BillType = Convert.ToInt16(dr["BillType"]);
objOpenOder.PaymentModeID = Convert.ToInt16(dr["PaymentMode"]);
objOpenOder.IsManualBilling = Convert.ToInt16(dr["IsManualBilling"]);
objOpenOder.SourceOrder = Convert.ToInt16(dr["SourceOrder"]);
objOpenOder.ROStatus = Convert.ToInt16(dr["ROStatus"]);
objOpenOder.RateFieldChanged = Convert.ToInt16(dr["RateFieldChanged"]);
objOpenOder.ProductID = Convert.ToInt16(dr["ProductID"]);
objOpenOder.BrandID = Convert.ToInt16(dr["BrandID"]);
objOpenOder.SMEID = Convert.ToInt16(dr["SMEID"]);
objOpenOder.BoxTypeID = Convert.ToInt16(dr["BoxTypeID"]);
objOpenOder.ROID = Convert.ToInt64(dr["ROID"]);
objOpenOder.BookingID = Convert.ToInt64(dr["BookingID"]);
objOpenOder.InsNum = Convert.ToInt16(dr["InsNum"]);
objOpenOder.PEID = Convert.ToInt16(dr["PEID"]);
objOpenOder.ReleaseID = Convert.ToInt16(dr["ReleaseID"]);
objOpenOder.ProdPEID = Convert.ToInt16(dr["ProdPEID"]);
objOpenOder.ProdReleaseID = Convert.ToInt16(dr["ProdReleaseID"]);
objOpenOder.ScheduledDate = Convert.ToDateTime(dr["ScheduledDate"]).ToString("dd/MM/yyyy");
objOpenOder.PackageID = Convert.ToInt16(dr["PackageID"]);
objOpenOder.AdTypeID = Convert.ToInt16(dr["AdTypeID"]);
objOpenOder.PremiaID = Convert.ToInt16(dr["PremiaID"]);
objOpenOder.ColorID = Convert.ToInt16(dr["Color"]);
objOpenOder.Status = Convert.ToInt16(dr["Status"]);
objOpenOder.AuditStatus = Convert.ToInt16(dr["AuditStatus"]);
objOpenOder.Free_or_Paid = Convert.ToInt16(dr["Free_or_Paid"]);
objOpenOder.FreeAds = Convert.ToInt16(dr["FreeAds"]);
objOpenOder.PaidAds = Convert.ToInt16(dr["PaidAds"]);
objOpenOder.ItemRateFieldChanged = Convert.ToInt16(dr["ItemRateFieldChanged"]);
objOpenOder.RateCardID = Convert.ToInt16(dr["RateCardID"]);
objOpenOder.AdRateID = Convert.ToInt16(dr["AdRateID"]);
objOpenOder.CardRate = Convert.ToDouble(dr["CardRate"]);
objOpenOder.CardAmount = Convert.ToDouble(dr["CardAmount"]);
objOpenOder.AgreedRate = Convert.ToDouble(dr["AgreedRate"]);
objOpenOder.AgreedAmount = Convert.ToDouble(dr["AgreedAmount"]);
objOpenOder.PECardBaseRate = Convert.ToDouble(dr["PECardBaseRate"]);
objOpenOder.ColorRate = Convert.ToDouble(dr["PECardCOlourRate"]);
objOpenOder.PremiaRate = Convert.ToDouble(dr["PECardPremiaRate"]);
objOpenOder.AgreedDiscPer = Convert.ToDecimal(dr["AgreedDiscPer"]);
objOpenOder.AgreedDiscAmount = Convert.ToDouble(dr["AgreedDiscAmount"]);
objOpenOder.CommissionPer = Convert.ToDouble(dr["CommissionPer"]);
objOpenOder.CommissionAmount = Convert.ToDouble(dr["CommissionAmount"]);
objOpenOder.DisCountColorPer = Convert.ToDouble(dr["DisCountColorPer"]);
objOpenOder.DisCountPremiaPer = Convert.ToDouble(dr["DisCountPremiaPer"]);
// objOpenOder.ExtraDiscountforPE = Convert.ToDouble(dr["ExtraDiscountforPE"]);
objOpenOder.ExtraChargesForPE = Convert.ToDouble(dr["ExtraChargesForPE"]);
objOpenOder.ExtraChargesPer = Convert.ToDouble(dr["ExtraChargesPer"]);
objOpenOder.ExtraDiscPer = Convert.ToDouble(dr["ExtraDiscPer"]);
objOpenOder.ExtraDiscAmount = Convert.ToDouble(dr["ExtraDiscAmount"]);
objOpenOder.ExtraBoxChargesPer = Convert.ToDouble(dr["BoxChargesPer"]);
objOpenOder.ExtraBoxChargesAmount = Convert.ToDouble(dr["BoxChargesAmount"]);
objOpenOder.PreVATAmountforPE = Convert.ToDouble(dr["PreVATAmountforPE"]);
objOpenOder.NetAmountforPE = Convert.ToDouble(dr["NetAmountforPE"]);
objOpenOder.Net = Convert.ToDouble(dr["Net"]);
objOpenOder.Receivable = Convert.ToDouble(dr["Receivable"]);
objOpenOder.VatPer = Convert.ToDouble(dr["VatPer"]);
objOpenOder.VatAmount = Convert.ToDouble(dr["VatAmount"]);
objOpenOder.WTPer = Convert.ToDouble(dr["WTPer"]);
objOpenOder.WTAmount = Convert.ToDouble(dr["WTAmount"]);
objOpenOder.MaterialID = Convert.ToString(dr["MaterialID"]);
objOpenOder.AdsizeID = Convert.ToInt16(dr["AdsizeID"]);
objOpenOder.Adsize = Convert.ToString(dr["AdSize"]);
objOpenOder.AdSizeHeight = Convert.ToDouble(dr["AdHeight"]);
objOpenOder.AdSizeWidth = Convert.ToDouble(dr["AdColsize"]);
objOpenOder.BillableSize = Convert.ToString(dr["BillableSize"]);
objOpenOder.BillableColSize = Convert.ToDouble(dr["BillableColSize"]);
objOpenOder.BillableHeight = Convert.ToDouble(dr["BillableHeight"]);
objOpenOder.BillableArea = Convert.ToDouble(dr["BillableArea"]);
objOpenOder.UOM = Convert.ToInt16(dr["UOM"]);
objOpenOder.SchemeID = Convert.ToInt16(dr["SchemeID"]);
objOpenOder.SchemeDetailID = Convert.ToInt16(dr["SchemedetailID"]);
objOpenOder.MaterialSource = Convert.ToInt16(dr["MaterialSource"]);
objOpenOder.MaterialType = Convert.ToInt16(dr["MaterialType"]);
objOpenOder.MaterialStatus = Convert.ToInt16(dr["MaterialStatus"]);
objOpenOder.AgencyName = Convert.ToString(dr["AgencyName"]);
objOpenOder.ClientName = Convert.ToString(dr["ClientName"]);
objOpenOder.CasualClientName = Convert.ToString(dr["CasualClientName"]);
objOpenOder.CanvassorName = Convert.ToString(dr["CanvassorName"]);
objOpenOder.UserName = Convert.ToString(dr["UserName"]);
objOpenOder.CentreName = Convert.ToString(dr["CentreName"]);
objOpenOder.MaterialPath = Convert.ToString(dr["MaterialPath"]);
objOpenOder.JobPath = Convert.ToString(dr["JobPath"]);
objOpenOder.ROFilePath = Convert.ToString(dr["ROFilePath"]);
objOpenOder.PkgIDs = Convert.ToString(dr["PkgIDs"]);
objOpenOder.PremiaName = Convert.ToString(dr["PremiaName"]);
objOpenOder.SizeName = Convert.ToString(dr["SizeName"]);
objOpenOder.ColorName = Convert.ToString(dr["ColorName"]);
objOpenOder.CustomerTypeID = Convert.ToInt16(dr["CasualRegularFlag"]);
objOpenOder.SchedulingInstructions = Convert.ToString(dr["SchedulingInstructions"]);
objOpenOder.BillingInstruction = Convert.ToString(dr["BillingInstruction"]);
objOpenOder.ProdInstructions = Convert.ToString(dr["ProdInstructions"]);
objOpenOder.Caption = Convert.ToString(dr["Caption"]);
objOpenOder.CasualAddress = Convert.ToString(dr["CasualAddress"]);
objOpenOder.CityID = Convert.ToInt32(dr["CityID"]);
objOpenOder.Zip = Convert.ToString(dr["Zip"]);
objOpenOder.Phone = Convert.ToString(dr["Phone"]);
objOpenOder.NicNumber = Convert.ToString(dr["NICNumber"]);
objOpenOder.VatNumber = Convert.ToString(dr["VATNumber"]);
objOpenOder.MBodyCount = Convert.ToString(dr["MBodyCount"]);
objOpenOder.AdClassification = Convert.ToString(dr["AdClassification"]);
objOpenOder.AdtypeID1 = Convert.ToInt32(dr["Adtype1"]);
objOpenOder.AdtypeID2 = Convert.ToInt32(dr["Adtype2"]);
objOpenOder.AdtypeID3 = Convert.ToInt32(dr["Adtype3"]);
objOpenOder.AdtypeID4 = Convert.ToInt32(dr["Adtype4"]);
objOpenOder.AllowCasualClient = Convert.ToInt32(dr["AllowCasualClient"]);
objOpenOder.BoxAddress = Convert.ToString(dr["BoxAddress"]);
objOpenOder.IsCD = Convert.ToInt32(dr["IsCD"]);
objOpenOder.StyleSheetID = Convert.ToInt32(dr["StyleSheetID"]);
objOpenOder.IsLogo = Convert.ToInt32(dr["IsLogo"]);
objOpenOder.U_BodyText = Convert.ToString(dr["U_BodyText"]);
objOpenOder.PECode = Convert.ToString(dr["PECode"]);
objOpenOder.AdStatus = Convert.ToString(dr["AdStatus"]);
objOpenOder.FileNames = Convert.ToString(dr["FileNames"]);
objOpenOder.ReasonForUnconfirmationID = Convert.ToString(dr["ReasonForUnconfirmationID"]);
objOpenOder.FileHeight = Convert.ToString(dr["FileHeight"]);
objOpenOder.ReadOnlyFlag = Convert.ToString(dr["ReadOnlyFlag"]);
objOpenOder.BlockB4ScheduledDate = Convert.ToDateTime(dr["BlockB4ScheduledDate"]).ToString("dd/MM/yyyy");
objOpenOder.AdColumns = Convert.ToString(dr["CDADColumns"]);
objOpenOder.MaterialTypeDescription = Convert.ToString(dr["MaterialTypeDescription"]);
objOpenOder.DeferredPayment = Convert.ToInt16(dr["DeferredPayment"]);
objOpenOder.AgencyPaymentMode = Convert.ToInt16(dr["AgencyPaymentMode"]);
objOpenOder.CompositeReceiptID = Convert.ToString(dr["CompositeReceiptID"]);
objListOpenOrder.Add(objOpenOder);
}
}
ROFilesOrder objROFilesOrder;
if (objdt1.Rows.Count > 0)
{
foreach (DataRow dr in objdt1.Rows)
{
objROFilesOrder = new ROFilesOrder();
objROFilesOrder.ROID = Convert.ToInt64(dr["ROID"]);
objROFilesOrder.ROFileName = Convert.ToString(dr["ROFileName"]);
objROFilesOrder.ROFileType = Convert.ToString(dr["ROFileType"]);
objROFilesOrder.ROFileTitle = Convert.ToString(dr["ROFileTitle"]);
objListROFilesOrder.Add(objROFilesOrder);
}
}
ReceiptOrder objReceiptOder;
if (objdt2.Rows.Count > 0)
{
foreach (DataRow dr in objdt2.Rows)
{
objReceiptOder = new ReceiptOrder();
objReceiptOder.ReceiptID = Convert.ToInt64(dr["ReceiptID"]);
objReceiptOder.ReceiptNumber = Convert.ToInt64(dr["ReceiptNumber"]);
objReceiptOder.ReceiptPaymentMode = Convert.ToInt16(dr["PaymentMode"]);
objReceiptOder.BankID = Convert.ToInt16(dr["BankID"]);
objReceiptOder.BranchID = Convert.ToInt16(dr["BranchID"]);
objReceiptOder.CheckNumber = Convert.ToString(dr["Number"]);
objReceiptOder.Amount = Convert.ToDouble(dr["Amount"]);
objReceiptOder.TotalAmountPaid = Convert.ToDouble(dr["TotalAmountPaid"]);
objReceiptOder.WriteOffAmount = Convert.ToDouble(dr["WriteOffAmount"]);
objReceiptOder.CashRefund = Convert.ToDouble(dr["CashRefund"]);
objReceiptOder.CashReceived = Convert.ToDouble(dr["CashReceived"]);
objListReceiptOrder.Add(objReceiptOder);
}
}
OrderDetails.Add("OpenOrder", objListOpenOrder);
OrderDetails.Add("ROFilesOrder", objListROFilesOrder);
OrderDetails.Add("ReceiptOrder", objListReceiptOrder);
}
}
catch (Exception ex)
{
Utility.ReportError("DisplayOpenOrderController::Post:", ex);
}
return(OrderDetails);
}
public BookingDetail Post(BookingDetail objbookingDetail)
{
string strXml = string.Empty;
try
{
HomeDAL objHomeDAL = new HomeDAL();
string dates = objbookingDetail.DateSelected;
string[] selecteddate = dates.Split(',');
string packages = objbookingDetail.PackageID;
string[] selectedpackages = packages.Split(',');
string peids = objbookingDetail.PEID;
string[] selectedpeids = peids.Split(',');
string adtypeids = objbookingDetail.AdtypeId;
string[] selectedadtypeids = adtypeids.Split(',');
string mattypeids = objbookingDetail.MaterialType;
string[] selectedmattypeids = mattypeids.Split(',');
string matsourceids = objbookingDetail.MaterialSource;
string[] selectedmatsourceids = matsourceids.Split(',');
string boxtypeids = objbookingDetail.BoxTypeID;
string[] selectedboxtypeids = boxtypeids.Split(',');
string uomids = objbookingDetail.UOMID;
string[] selecteduomids = uomids.Split(',');
string statusids = objbookingDetail.Status;
string[] selectedstatusids = statusids.Split(',');
string cauditstatusids = objbookingDetail.AuditStatus;
string[] selectedcauditstatusids = cauditstatusids.Split(',');
string cardrates = objbookingDetail.CardRate;
string[] selectedcardrates = cardrates.Split(',');
string cardamounts = objbookingDetail.CardAmount;
string[] selectedcardamounts = cardamounts.Split(',');
string ratecardids = objbookingDetail.RateCardID;
string[] selectedratecardids = ratecardids.Split(',');
string adrateids = objbookingDetail.AdRateID;
string[] selectedadrateids = adrateids.Split(',');
string agreedrates = objbookingDetail.AgreedRate;
string[] selectedagreedrates = agreedrates.Split(',');
string agreedamounts = objbookingDetail.AgreedAmount;
string[] selectedagreedamounts = agreedamounts.Split(',');
string agreeddispers = objbookingDetail.AgreedDiscPer;
string[] selectedagreeddispers = agreeddispers.Split(',');
string agreeddisamounts = objbookingDetail.AgreedDiscAmount;
string[] selectedagreeddisamounts = agreeddisamounts.Split(',');
string prevatamounts = objbookingDetail.PreVATAmount;
string[] selectedprevatamounts = prevatamounts.Split(',');
string vatapers = objbookingDetail.VATPer;
string[] selectedvatapers = vatapers.Split(',');
string vatamounts = objbookingDetail.VATAmount;
string[] selectedvatamounts = vatamounts.Split(',');
string agencycommissionpers = objbookingDetail.AgencyCommissionPer;
string[] selectedagencycommissionpers = agencycommissionpers.Split(',');
string agencycommissionamounts = objbookingDetail.AgencyCommissionAmount;
string[] selectedagencycommissionamounts = agencycommissionamounts.Split(',');
string schemeids = objbookingDetail.SchemeID;
string[] selecteschemeids = schemeids.Split(',');
string schemedetailids = objbookingDetail.SchemeDetailID;
string[] selectedschemedetailids = schemedetailids.Split(',');
string extrachargespers = objbookingDetail.ExtraChargesPer;
string[] selectedextrachargespers = extrachargespers.Split(',');
string extrachargesamounts = objbookingDetail.ExtraChargesAmount;
string[] selectedextrachargesamounts = extrachargesamounts.Split(',');
string extradiscpers = objbookingDetail.ExtraDiscPer;
string[] selectedextradiscpers = extradiscpers.Split(',');
string extradiscamount = objbookingDetail.ExtraDiscAmount;
string[] selectedextradiscamount = extradiscamount.Split(',');
string extraboxchargespers = objbookingDetail.ExtraBoxChargesPer;
string[] selectedextraboxchargespers = extraboxchargespers.Split(',');
string extraboxchargesamounts = objbookingDetail.ExtraBoxChargesAmount;
string[] selectedextraboxchargesamounts = extraboxchargesamounts.Split(',');
string receivableamounts = objbookingDetail.Receivable;
string[] selectedreceivableamounts = receivableamounts.Split(',');
string packageids = string.Empty;
int totalrecordreturn = Convert.ToInt16(objbookingDetail.TotalRecordReturn);
int FileLength = Convert.ToInt16(objbookingDetail.FileLength);
string[] rofilename = { };
string[] rofiletype = { };
string[] rofiletitle = { };
if (FileLength != 0)
{
string filename = objbookingDetail.RoFileName;
rofilename = filename.Split(',');
string filetype = objbookingDetail.RoFileType;
rofiletype = filetype.Split(',');
string filetitle = objbookingDetail.RoFileTitle;
rofiletitle = filetitle.Split(',');
}
if (selectedpackages.Length == 1)
{
packageids = objbookingDetail.PackageID;
}
else
{
packageids = "0";
}
if (selecteddate.Length > 0)
{
strXml += "<ebooking>"
+ "<orderlevel>"
+ "<roid>" + objbookingDetail.ROID + "</roid>"
+ "<bookingdate>" + objbookingDetail.BookingDate + "</bookingdate>"
+ "<revenuecentreid>" + objbookingDetail.RevenueCentreID + "</revenuecentreid>"
+ "<bookingcentreid>" + objbookingDetail.BookingCentreID + "</bookingcentreid>"
+ "<bookingexecid>" + objbookingDetail.UserId + "</bookingexecid>"
+ "<ronumber>" + objbookingDetail.RONumber + "</ronumber>"
+ "<agencyid>" + objbookingDetail.AgencyID + "</agencyid>"
+ "<clientid>" + objbookingDetail.ClientID + "</clientid>"
+ "<canvassorid>" + objbookingDetail.CanvassorID + "</canvassorid>"
+ "<loguserid>" + objbookingDetail.UserId + "</loguserid>"
+ "<isclassified>" + objbookingDetail.IsClassified + "</isclassified>"
+ "<sourceroid>" + objbookingDetail.SourceROID + "</sourceroid>"
+ "<ratefieldchanged>" + objbookingDetail.RateFieldChanged + "</ratefieldchanged>"
+ "<casualclientname>" + objbookingDetail.CasualClientName + "</casualclientname>"
+ "<casualclientaddress>" + objbookingDetail.CasualClientAddress + "</casualclientaddress>"
+ "<contactperson>" + objbookingDetail.ContactPerson + "</contactperson>"
+ "<casualclientcity>" + objbookingDetail.CasualClientCity + "</casualclientcity>"
+ "<casualclientzipcode>" + objbookingDetail.CasualClientZipCode + "</casualclientzipcode>"
+ "<casualclientphoneno>" + objbookingDetail.CasualClientPhoneNo + "</casualclientphoneno>"
+ "<casualcontactperson>" + objbookingDetail.CasualContactPerson + "</casualcontactperson>"
+ "<casualclientnicnumber>" + objbookingDetail.CasualClientNicNumber + "</casualclientnicnumber>"
+ "<casualclientvatnumber>" + objbookingDetail.CasualClientVatNumber + "</casualclientvatnumber>"
+ "<casualclientemailid>" + objbookingDetail.CasualClientEmailID + "</casualclientemailid>"
+ "<casualclientpassword>" + objbookingDetail.CasualClientPassword + "</casualclientpassword>"
+ "<totalorders>" + objbookingDetail.TotalOrders + "</totalorders>"
+ "<smeid>" + objbookingDetail.SMEID + "</smeid>"
+ "<productid>" + objbookingDetail.ProductID + "</productid>"
+ "<brandid>" + objbookingDetail.BrandID + "</brandid>"
+ "<rotype>" + objbookingDetail.ROType + "</rotype>"
+ "<reasonforunconfirmationid>" + objbookingDetail.UnConfirmReason + "</reasonforunconfirmationid>"
+ "<billtype>" + objbookingDetail.BillType + "</billtype>"
+ "<ordernumber>" + objbookingDetail.OrderNumber + "</ordernumber>"
+ "<uniquenumber>" + objbookingDetail.UniqueCode + "</uniquenumber>"
+ "<customertype>" + objbookingDetail.CustomerTypeID + "</customertype>"
+ "<paymentmode>" + objbookingDetail.PaymentTypeID + "</paymentmode>"
+ "<ismanualbilling>" + objbookingDetail.IsManualBilling + "</ismanualbilling>"
+ "<rostatus>" + objbookingDetail.ROStatus + "</rostatus>"
+ "<packagelist>" + objbookingDetail.PackageID + "</packagelist>"
+ "<billinginstruction>" + objbookingDetail.BillingIns + "</billinginstruction>"
+ "<receivableamount>" + objbookingDetail.ReceivableAmount + "</receivableamount>"
+ "<saveflag>" + objbookingDetail.SaveFlag + "</saveflag>"
+ "<machineid>" + objbookingDetail.MachineID + "</machineid>"
+ "<machinename>" + objbookingDetail.MachineName + "</machinename>"
+ "<deferredpayment>" + objbookingDetail.CheckDifferValue + "</deferredpayment>";
// new code
for (var i = 0; i < totalrecordreturn; i++) // selecteddate.Length
{
var date = objbookingDetail.list[i].ScheduledDate.Substring(0, 10);
strXml += "<insertlevel>"
+ "<insnum>" + objbookingDetail.list[i].InsNum + "</insnum>"
+ "<packageid>" + packageids + "</packageid>"
+ "<no_of_insertions>" + selecteddate.Length + "</no_of_insertions>"
+ "<invoicenum>0</invoicenum>";
var peid = objbookingDetail.list[i].PEID;
strXml += "<itemlevel>"
+ "<peid>" + peid + "</peid>"
+ "<caption>" + objbookingDetail.Caption + "</caption>"
+ "<schedulinginstructions>" + objbookingDetail.SchedulingIns + "</schedulinginstructions>"
+ "<prodinstructions>" + objbookingDetail.ProdInstructions + "</prodinstructions>"
+ "<adtypeid>" + objbookingDetail.list[i].AdTypeID + "</adtypeid>";
strXml += "<adtype1>" + objbookingDetail.list[i].AdtypeID1 + "</adtype1>"
+ "<adtype2>" + objbookingDetail.list[i].AdtypeID2 + "</adtype2>"
+ "<adtype3>" + objbookingDetail.list[i].AdtypeID3 + "</adtype3>"
+ "<adtype4>" + objbookingDetail.list[i].AdtypeID4 + "</adtype4>"
+ "<materialid>" + objbookingDetail.list[i].MaterialID + "</materialid>";
strXml += "<stylesheetid>" + objbookingDetail.list[i].StyleSheetID + "</stylesheetid>"
+ "<iscd>" + objbookingDetail.IsCD + "</iscd>"
+ "<islogo>" + objbookingDetail.IsLogo + "</islogo>"
+ "<filenames>" + objbookingDetail.FileNames + "</filenames>"
+ "<publishstatus>0</publishstatus>"
+ "<mbodychanged>" + objbookingDetail.MBodyChange + "</mbodychanged>"
+ "<bodycount>" + objbookingDetail.TotalWords + "</bodycount>"
+ "<mbodycount>" + objbookingDetail.MBodyCount + "</mbodycount>"
+ "<charcount>" + objbookingDetail.CharCount + "</charcount>"
+ "<headeradtext></headeradtext>"
+ "<bodytext>" + objbookingDetail.AdText + "</bodytext>"
+ "<footertext></footertext>"
+ "<materialtype>" + objbookingDetail.MaterialType + "</materialtype>"
+ "<materialsource>" + objbookingDetail.MaterialSource + "</materialsource>"
+ "<boxtypeid>" + objbookingDetail.BoxTypeID + "</boxtypeid>"
+ "<boxaddress>" + objbookingDetail.BoxAddress + "</boxaddress>"
+ "<releaseid>0</releaseid>"
+ "<scheduleddate>" + date + "</scheduleddate>"
+ "<free_or_paid>1</free_or_paid>"
+ "<uom>" + objbookingDetail.list[i].UOM + "</uom>"
+ "<ratecardid>" + objbookingDetail.list[i].RateCardID + "</ratecardid>"
+ "<adrateid>" + objbookingDetail.list[i].AdRateID + "</adrateid>"
+ "<status>" + objbookingDetail.list[i].Status + "</status>"
+ "<auditstatus>" + objbookingDetail.list[i].AuditStatus + "</auditstatus>"
+ "<paymentstatus>0</paymentstatus>"
+ "<materialstatus>0</materialstatus>";
strXml += "<cardrate>" + objbookingDetail.list[i].CardRate + "</cardrate>"
+ "<cardamount>" + objbookingDetail.list[i].CardAmount + "</cardamount>"
+ "<itemratefieldchanged>" + objbookingDetail.list[i].ItemRateFieldChanged + "</itemratefieldchanged>"
+ "<agreedrate>" + objbookingDetail.list[i].AgreedRate + "</agreedrate>"
+ "<agreedamount>" + objbookingDetail.list[i].AgreedAmount + "</agreedamount>"
+ "<agreeddiscount>" + objbookingDetail.list[i].AgreedDiscAmount + "</agreeddiscount>"
+ "<agreeddisper>" + objbookingDetail.list[i].AgreedDiscPer + "</agreeddisper>"
+ "<prevatamountforpe>" + objbookingDetail.list[i].PreVATAmount + "</prevatamountforpe>"
+ "<netamountforpe>" + objbookingDetail.list[i].Receivable + "</netamountforpe>"
+ "<pevatper>" + objbookingDetail.list[i].VATPer + "</pevatper>"
+ "<pevatamount>" + objbookingDetail.list[i].VATAmount + "</pevatamount>"
+ "<extrachargesper>" + objbookingDetail.list[i].ExtraChargesPer + "</extrachargesper>"
+ "<extrachargesforpe>" + objbookingDetail.list[i].ExtraChargesAmount + "</extrachargesforpe>"
+ "<extradiscper>" + objbookingDetail.list[i].ExtraDiscPer + "</extradiscper>"
+ "<extradiscountforpe>" + objbookingDetail.list[i].ExtraDiscAmount + "</extradiscountforpe>"
+ "<extraboxchargesper>" + selectedextraboxchargespers[i] + "</extraboxchargesper>"
+ "<extraboxchargesamount>" + objbookingDetail.list[i].ExtraBoxChargesAmount + "</extraboxchargesamount>"
+ "<commissionper>" + objbookingDetail.list[i].AgencyCommissionPer + "</commissionper>"
+ "<commissionamount>" + objbookingDetail.list[i].AgencyCommissionAmount + "</commissionamount>";
strXml += "<schemeid>" + objbookingDetail.list[i].SchemeID + "</schemeid>"
+ "<schemedetailid>" + objbookingDetail.list[i].SchemeDetailID + "</schemedetailid>"
+ "<adcolumns>" + objbookingDetail.ClassifiedCol + "</adcolumns>"
+ "<fileheight>" + objbookingDetail.LogoHeight + "</fileheight>"
+ "<adsize>" + objbookingDetail.AdsizeHeight + "*" + objbookingDetail.AdsizeWidth + "</adsize>"
+ "<adheight>" + objbookingDetail.AdsizeHeight + "</adheight>"
+ "<adwidth>" + objbookingDetail.AdsizeWidth + "</adwidth>"
+ "<adarea>" + Convert.ToDouble(objbookingDetail.AdsizeHeight) * Convert.ToDouble(objbookingDetail.AdsizeWidth) + "</adarea>"
+ "<billablesize>" + objbookingDetail.AdsizeHeight + "*" + objbookingDetail.AdsizeWidth + "</billablesize>"
+ "<billableheight>" + objbookingDetail.AdsizeHeight + "</billableheight>"
+ "<billablewidth>" + objbookingDetail.AdsizeWidth + "</billablewidth>"
+ "<billablearea>" + Convert.ToDouble(objbookingDetail.AdsizeHeight) * Convert.ToDouble(objbookingDetail.AdsizeWidth) + "</billablearea>"
+ "<boxnumber>" + objbookingDetail.list[i].BoxNumber + "</boxnumber>"
+ "<startcol>" + objbookingDetail.list[i].StartCol + "</startcol>"
+ "<yposition>" + objbookingDetail.list[i].Yposition + "</yposition>"
+ "</itemlevel>";
strXml += "</insertlevel>";
}
if (objbookingDetail.PaymentTypeID == 1 && objbookingDetail.CheckDifferValue == 0)
{
strXml += "<receiptetail>"
+ "<receiptamount>" + objbookingDetail.TotalReceivable + "</receiptamount>"
+ "<totalamountpaid>" + objbookingDetail.ReceiptAmount + "</totalamountpaid>"
+ "<writeoffamount>" + objbookingDetail.WriteoffAmount + "</writeoffamount>"
+ "<receiptdate>" + DateTime.Now.ToString("dd/MM/yyyy") + "</receiptdate>";
if (objbookingDetail.Amount != 0)
{
strXml += "<paymentdetail>"
+ "<paymentmodeid>" + objbookingDetail.PaymentModeID + "</paymentmodeid>"
+ "<chequenumber>" + objbookingDetail.ChequeNumber + "</chequenumber>"
+ "<chequedate></chequedate>"
+ "<amount>" + objbookingDetail.Amount + "</amount>"
+ "<bankid>" + objbookingDetail.BankID + "</bankid>"
+ "<bankname>" + objbookingDetail.BranchBankName + "</bankname>"
+ "<branchid>" + objbookingDetail.BankNameID + "</branchid>"
+ "<branchname>" + objbookingDetail.BranchName + "</branchname>"
+ "<bankbranchcode>" + objbookingDetail.BankName + "</bankbranchcode>"
+ "</paymentdetail>";
}
if (objbookingDetail.Amount1 != 0)
{
strXml += "<paymentdetail>"
+ "<paymentmodeid>" + objbookingDetail.PaymentModeID1 + "</paymentmodeid>"
+ "<chequenumber>" + objbookingDetail.ChequeNumber1 + "</chequenumber>"
+ "<chequedate></chequedate>"
+ "<amount>" + objbookingDetail.Amount1 + "</amount>"
+ "<bankid>" + objbookingDetail.BankID1 + "</bankid>"
+ "<bankname>" + objbookingDetail.BranchBankName1 + "</bankname>"
+ "<branchid>" + objbookingDetail.BankNameID1 + "</branchid>"
+ "<branchname>" + objbookingDetail.BranchName1 + "</branchname>"
+ "<bankbranchcode>" + objbookingDetail.BankName1 + "</bankbranchcode>"
+ "</paymentdetail>";
}
if (objbookingDetail.Amount2 != 0)
{
strXml += "<paymentdetail>"
+ "<paymentmodeid>" + objbookingDetail.PaymentModeID2 + "</paymentmodeid>"
+ "<chequenumber>" + objbookingDetail.ChequeNumber2 + "</chequenumber>"
+ "<chequedate></chequedate>"
+ "<amount>" + objbookingDetail.Amount2 + "</amount>"
+ "<bankid>" + objbookingDetail.BankID2 + "</bankid>"
+ "<bankname>" + objbookingDetail.BranchBankName2 + "</bankname>"
+ "<branchid>" + objbookingDetail.BankNameID2 + "</branchid>"
+ "<branchname>" + objbookingDetail.BranchName2 + "</branchname>"
+ "<bankbranchcode>" + objbookingDetail.BankName2 + "</bankbranchcode>"
+ "</paymentdetail>";
}
strXml += "</receiptetail>";
}
strXml += "<rofiles>"
+ "<roid>" + objbookingDetail.ROID + "</roid>"
+ "<loguserid>" + objbookingDetail.UserId + "</loguserid>";
if (FileLength == 0)
{
strXml += "<rofiledetail>"
+ "<rofilename></rofilename>"
+ "<rofiletype></rofiletype>"
+ "<rofiletitle></rofiletitle>"
+ "<isprinted>0</isprinted>"
+ "<portedflag>0</portedflag>"
+ "</rofiledetail>";
}
else
{
for (var k = 0; k < FileLength; k++)
{
strXml += "<rofiledetail>"
+ "<rofilename>" + rofilename[k] + "</rofilename>"
+ "<rofiletype>" + rofiletype[k] + "</rofiletype>"
+ "<rofiletitle>" + rofiletitle[k] + "</rofiletitle>"
+ "<isprinted>0</isprinted>"
+ "<portedflag>0</portedflag>"
+ "</rofiledetail>";
}
}
strXml += "</rofiles>";
strXml += "</orderlevel></ebooking>";
}
DataTable objdt = objHomeDAL.BookOrdersXML(strXml).Tables[0];
if (objdt.Rows.Count > 0)
{
objbookingDetail.IsValid = Convert.ToInt16(objdt.Rows[0]["ErrorFlag"]);
//if (objbookingDetail.IsValid == 1 || objbookingDetail.IsValid == 2 || objbookingDetail.IsValid == 3 || objbookingDetail.IsValid == -2)
if (objbookingDetail.IsValid > 0)
{
objbookingDetail.ErrorMessage = Convert.ToString(objdt.Rows[0]["ErrorMessage"]);
objbookingDetail.IsValid = Convert.ToInt16(objdt.Rows[0]["ErrorFlag"]);
}
else
{
objbookingDetail.ROID = Convert.ToInt64(objdt.Rows[0]["ROID"]);
objbookingDetail.ReceiptID = Convert.ToInt64(objdt.Rows[0]["ReceiptID"]);
objbookingDetail.JobSequence = Convert.ToString(objdt.Rows[0]["JobSequence"]);
objbookingDetail.IsValid = Convert.ToInt16(objdt.Rows[0]["ErrorFlag"]);
objbookingDetail.ErrorMessage = Convert.ToString(objdt.Rows[0]["ErrorMessage"]);
}
}
}
catch (Exception ex)
{
Utility.ReportLogError("SP_Name::EBK_SP_BookOrdersXML:", ex, strXml);
}
return(objbookingDetail);
}
public static List<BookingDetail> GetBookingDetailsForCustomer(int customerId)
{
List<BookingDetail> bookingDetails = new List<BookingDetail>();
SqlConnection connection = TravelExpertsDB.GetConnection();
string query = "SELECT bd.BookingId, bd.ItineraryNo, bd.BookingDetailId, bd.TripStart, bd.TripEnd, " +
" bd.Description, bd.Destination, bd.BasePrice " +
" FROM BookingDetails bd " +
" INNER JOIN Bookings b ON b.BookingId = bd.BookingId " +
" INNER JOIN Customers c ON c.CustomerId = b.CustomerId " +
" WHERE c.CustomerId = @CustomerID";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@CustomerID", customerId);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
BookingDetail bookingDetail = new BookingDetail();
bookingDetail.BookingDetailId = Convert.ToInt32(reader["BookingDetailId"]);
bookingDetail.ItineraryNo = Convert.ToDouble(reader["ItineraryNo"]);
bookingDetail.TripStart = Convert.ToDateTime(reader["TripStart"]);
bookingDetail.TripEnd = Convert.ToDateTime(reader["TripEnd"]);
bookingDetail.Description = reader["Description"].ToString();
bookingDetail.Destination = reader["Destination"].ToString();
bookingDetail.BasePrice = Convert.ToDouble(reader["BasePrice"]);
bookingDetail.BookingId = Convert.ToInt32(reader["BookingId"]);
bookingDetails.Add(bookingDetail);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
return bookingDetails;
}
public IEnumerable <PrintReceipt> Post(BookingDetail objbookingDetail)
{
Dictionary <string, object> OrderDetails = new Dictionary <string, object>();
List <PrintReceipt> objListPrintReceipt = new List <PrintReceipt>();
PrintReceipt objPrintReceipt;
try
{
HomeDAL objHomeDAL = new HomeDAL();
string strXml = string.Empty;
strXml += "<ebooking><actionname>printreceipt</actionname><receiptid>" + objbookingDetail.ReceiptID + "</receiptid></ebooking>";
DataTable objdt = objHomeDAL.eBookingActions(strXml).Tables[0];
if (objdt.Rows.Count > 0)
{
//objOpenOder.IsValid = Convert.ToInt16(objdt.Rows[0]["ErrorFlag"]);
//if (objOpenOder.IsValid == 1)
//{
// objOpenOder.ErrorMessage = Convert.ToString(objdt.Rows[0]["ErrorMessage"]);
// objOpenOder.IsValid = Convert.ToInt16(objdt.Rows[0]["ErrorFlag"]);
// objListOpenOrder.Add(objOpenOder);
// OrderDetails.Add("OpenOrder", objListOpenOrder);
//}
//else
//{
foreach (DataRow dr in objdt.Rows)
{
objPrintReceipt = new PrintReceipt();
objPrintReceipt.OrderReceiptNo = Convert.ToString(dr["OrderReceiptNo"]);
objPrintReceipt.ClientName = Convert.ToString(dr["ClientName"]);
objPrintReceipt.Address = Convert.ToString(dr["Address"]);
objPrintReceipt.City = Convert.ToString(dr["City"]);
objPrintReceipt.Phone = Convert.ToString(dr["Phone"]);
objPrintReceipt.Zip = Convert.ToString(dr["Zip"]);
objPrintReceipt.BookedBy = Convert.ToString(dr["BookedBy"]);
objPrintReceipt.BookedBy = Convert.ToString(dr["BookedBy"]);
objPrintReceipt.REVISION_NUMBER = Convert.ToString(dr["REVISION_NUMBER"]);
objPrintReceipt.IsClassified = Convert.ToString(dr["isClassified"]);
objPrintReceipt.VATNumber = Convert.ToString(dr["VATNumber"]);
objPrintReceipt.Premia = Convert.ToString(dr["Premia"]);
objPrintReceipt.Size = Convert.ToString(dr["Size"]);
objPrintReceipt.Publication = Convert.ToString(dr["Publication"]);
objPrintReceipt.AdTypeName = Convert.ToString(dr["AdTypeName"]);
objPrintReceipt.Pubdate = Convert.ToString(dr["Pubdate"]);
objPrintReceipt.Cost = Convert.ToString(dr["Cost"]);
objPrintReceipt.VatAmount = Convert.ToString(dr["VatAmount"]);
objPrintReceipt.Total = Convert.ToString(dr["Total"]);
objPrintReceipt.Date = Convert.ToString(dr["Date"]);
objPrintReceipt.AgencyName = Convert.ToString(dr["AgencyName"]);
objPrintReceipt.AgencyCode = Convert.ToString(dr["AgencyCode"]);
objPrintReceipt.Category1 = Convert.ToString(dr["Category1"]);
objPrintReceipt.Category2 = Convert.ToString(dr["Category2"]);
objPrintReceipt.Material = Convert.ToString(dr["Material"]);
objListPrintReceipt.Add(objPrintReceipt);
}
}
}
catch (Exception ex)
{
Utility.ReportError("PrintReceiptController::Post:", ex);
}
return(objListPrintReceipt);
}
public virtual void AddDetail(BookingDetail bookingDetail)
{
bookingDetail.Booking = this;
Detail.Add(bookingDetail);
}
public string CreateBooking(Booking booking, int accomodationPackageId)
{
// New implementation
lock (Lock)
{
AccomodationService accomodationService = new AccomodationService();
var model =
accomodationService.CheckAccomodationsAvailability(
accomodationPackageId, booking.FromDate, booking.ToDate);
if (model != null && model.Count() >= booking.NoOfAccomodation)
{
BookingDetail bookingDetailSingleObj = new BookingDetail();
//if (booking.NoOfAccomodation == 1)
//{
// bookingDetailSingleObj.AccomodationId = model.FirstOrDefault().Id;
// //BookingId = bookingViewModel.
// //booking.BookingDetails.Add(bookingDetailSingleObj);
//}
//else
//{
// result.Data = new { success = true, message = "Rooms Availabale", data = ids };
List <BookingDetail> bookingDetails = new List <BookingDetail>();
foreach (var accomodation in model.Take(booking.NoOfAccomodation))
{
BookingDetail bookingDetailObj = new BookingDetail()
{
AccomodationId = accomodation.Id,
//BookingId = bookingViewModel.
};
bookingDetails.Add(bookingDetailObj);
}
//if (booking.NoOfAccomodation == 1)
//{
// booking.BookingDetails = bookingDetails.Take(1).ToList();
//}
booking.BookingDetails = bookingDetails;
//}
HMSContext context = new HMSContext();
context.Bookings.Add(booking);
//context.BookingDetails.Add(bookingDetail);
//var result = await context.SaveChangesAsync() > 0;
var result = context.SaveChanges() > 0;
if (result == true)
{
return
("You have Successfuly reserved your Accomodation , soon you will receive message and email , Booking Id :" +
booking.Id);
}
return("Somethinbg went wrong");
}
else if (model.Count() < booking.NoOfAccomodation && model.Count() != 0)
{
return("You Asked for " + booking.NoOfAccomodation +
" Accomodations but " + model.Count() + " Accomodation Availabale Only , plz Try Again");
}
else
{
return("All Rooms Are Booked!");
}
}
// old implementation
//HMSContext context = new HMSContext();
//context.Bookings.Add(booking);
////context.BookingDetails.Add(bookingDetail);
////var result = await context.SaveChangesAsync() > 0;
//var result = context.SaveChanges() > 0;
//UpdateState(booking.BookingDetails.Select(z => z.Accomodation.Id).ToList(), false);
//if (result == true)
//{
// return booking.Id;
//}
////}
//return 0;
}
public ZubosFrmEditBooking(BookingDetail bookingObj)
{
InitializeComponent();
selectedBooking = bookingObj;
}
// returns a List of BookingDetail objects from the database
public static List <BookingDetail> GetAllBookingDetails()
{
List <BookingDetail> bookingDetails = new List <BookingDetail>(); // instantiate an empty List of Bookings
SqlConnection conn = TravelExpertsDB.GetConnection(); // instantiate a DB connection object
// prepare the SQL statement
string selectStatement = "SELECT * FROM BookingDetails";
SqlCommand selectCommand = new SqlCommand(selectStatement, conn);
try
{
conn.Open();
SqlDataReader dr = selectCommand.ExecuteReader();
while (dr.Read())
{
BookingDetail bookingDetail = new BookingDetail();
bookingDetail.BookingDetailId = (int)dr["BookingDetailId"];
// if necessary convert DB null values to C# nulls
if (dr["ItineraryNo"] == DBNull.Value)
{
bookingDetail.ItineraryNo = null;
}
else
{
bookingDetail.ItineraryNo = (double)dr["ItineraryNo"];
}
if (dr["TripStart"] == DBNull.Value)
{
bookingDetail.TripStart = null;
}
else
{
bookingDetail.TripStart = (DateTime)dr["TripStart"];
}
if (dr["TripEnd"] == DBNull.Value)
{
bookingDetail.TripEnd = null;
}
else
{
bookingDetail.TripEnd = (DateTime)dr["TripEnd"];
}
if (dr["Description"] == DBNull.Value)
{
bookingDetail.Description = null;
}
else
{
bookingDetail.Description = (string)dr["Description"];
}
if (dr["Destination"] == DBNull.Value)
{
bookingDetail.Destination = null;
}
else
{
bookingDetail.Destination = (string)dr["Destination"];
}
if (dr["BasePrice"] == DBNull.Value)
{
bookingDetail.BasePrice = null;
}
else
{
bookingDetail.BasePrice = (decimal)dr["BasePrice"];
}
if (dr["AgencyCommission"] == DBNull.Value)
{
bookingDetail.AgencyCommission = null;
}
else
{
bookingDetail.AgencyCommission = (decimal)dr["AgencyCommission"];
}
if (dr["BookingId"] == DBNull.Value)
{
bookingDetail.BookingId = null;
}
else
{
bookingDetail.BookingId = (int)dr["BookingId"];
}
if (dr["RegionId"] == DBNull.Value)
{
bookingDetail.RegionId = null;
}
else
{
bookingDetail.RegionId = (string)dr["RegionId"];
}
if (dr["ClassId"] == DBNull.Value)
{
bookingDetail.ClassId = null;
}
else
{
bookingDetail.ClassId = (string)dr["ClassId"];
}
if (dr["FeeId"] == DBNull.Value)
{
bookingDetail.FeeId = null;
}
else
{
bookingDetail.FeeId = (string)dr["FeeId"];
}
if (dr["ProductSupplierId"] == DBNull.Value)
{
bookingDetail.ProductSupplierId = null;
}
else
{
bookingDetail.ProductSupplierId = (int)dr["ProductSupplierId"];
}
bookingDetails.Add(bookingDetail);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(bookingDetails);
}
public async Task <Booking> Book(BookingDetail value)
{
Bicycles result;
bool flag;
try
{
// check bicycel is there
using (var httpClient = new HttpClient())
{
using (var response = await httpClient.PostAsJsonAsync("http://localhost:57207/api/Bicycle/reserve/", value))
{
if (response.IsSuccessStatusCode == true)
{
string apiResponse = await response.Content.ReadAsStringAsync();
result = (Bicycles)JsonConvert.DeserializeObject(apiResponse, typeof(Bicycles));
}
else
{
throw new Exception("bicycle is not there");
}
}
}
}
catch (Exception exp)
{
throw exp;
}
Booking bookingObj = new Booking()
{
BicycleId = result.BicycleId,
DateTime = DateTime.Now,
UserName = value.UserName,
BicycleNumber = result.BicycleNumber,
DeliveryAddress = value.DeliveryAddress,
Latitude = value.Latitude,
Longitude = value.Longitude,
Active = true
};
try
{
_db.Bookings.Add(bookingObj);
await _db.SaveChangesAsync();
}
catch (Exception exp)
{
throw exp;
}
var bookingResult = _db.Bookings.Where(b =>
b.BicycleId == result.BicycleId && b.Active == true
).FirstOrDefault();
try
{
/// for updating delivery databse
using (var httpClient = new HttpClient())
{
using (var response = await httpClient.PostAsJsonAsync("http://localhost:64966/api/DeliveryBike/AddDelivery", bookingResult.BookingId))
{
string apiResponse = await response.Content.ReadAsStringAsync();
flag = (bool)JsonConvert.DeserializeObject(apiResponse, typeof(bool));
}
}
}
catch (Exception exp)
{
throw exp;
}
if (flag == true)
{
return(bookingResult);
}
else
{
throw new Exception("Cannot set delivery");
}
}
