public IEnumerable <BookingGuestRpt> CheckinReportAll(int type, BookingGuestRpt bg)
{
List <BookingGuestRpt> obj = new List <BookingGuestRpt>();
try
{
MySqlCommand cmd = new MySqlCommand("sp_rpt_BookingByCheckinReport", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("type", type);
cmd.Parameters.AddWithValue("pCheckinDate", bg.FromDate);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
HotelDetailstbl hd = new HotelDetailstbl()
{
HotelDetailsId = Convert.ToInt32(dr["HotelDetailsId"]),
//HotelId = Convert.ToInt32(dr["HotelId"]),
HotelName = dr["HotelName"].ToString(),
Address = dr["Address"].ToString(),
//HotelLocation = dr["HotelLocation"].ToString(),
ContactNumber = dr["ContactNumber"].ToString(),
};
BookingDetailstbl bd = new BookingDetailstbl()
{
BookingDetailsId = Convert.ToInt32(dr["BookingDetailsId"]),
//BookingId = dr["BookingId"].ToString(),
HotelDetailsId = Convert.ToInt32(dr["HotelDetailsId"]),
Checkin = dr["Checkin"].ToString(),
Checkout = dr["Checkout"].ToString(),
NoofRooms = Convert.ToInt32(dr["NoofRooms"]),
AgentPrice = dr["AgentPrice"].ToString(),
AgentID = Convert.ToInt32(dr["AgentId"]),
};
List <RoomDetailstbl> lstrd = new List <RoomDetailstbl>();
List <GuestDetailstbl> lstgd = new List <GuestDetailstbl>();
Supplierstbl s = new Supplierstbl()
{
SupplierID = Convert.ToInt32(dr["SupplierID"]),
Supplier = dr["Supplier"].ToString(),
PersonName = dr["PersonName"].ToString(),
Email = dr["Email"].ToString(),
MobileNo = dr["MobileNo"].ToString(),
Address = dr["Address"].ToString(),
ApiPurchaseDate = dr["ApiPurchaseDate"].ToString(),
ApiKey = dr["ApiKey"].ToString(),
ApiPurchaseValue = dr["ApiPurchaseValue"].ToString(),
AgentLink = dr["AgentLink"].ToString(),
SupplierCode = dr["SupplierCode"].ToString(),
};
Agentstbl a = new Agentstbl()
{
AgentID = Convert.ToInt32(dr["AgentID"]),
AgencyCode = dr["AgencyCode"].ToString(),
AgencyName = dr["AgentName"].ToString(),
AgencyEmail = dr["AgencyEmail"].ToString(),
FirstName = dr["FirstName"].ToString(),
LastName = dr["LastName"].ToString(),
UserName = dr["UserName"].ToString(),
Password = dr["Password"].ToString(),
ContactName = dr["ContactName"].ToString(),
MobileNo = dr["MobileNo"].ToString(),
CategoryId = Convert.ToInt32(dr["CategoryId"]),
Address = dr["Address"].ToString(),
};
lstrd.Add(new RoomDetailstbl
{
RoomDetailsId = Convert.ToInt32(dr["RoomDetailsId"]),
BookingDetailsId = Convert.ToInt32(dr["BookingDetailsId"]),
Adults = Convert.ToInt32(dr["Adults"]),
Kids = Convert.ToInt32(dr["Kids"]),
RoomType = dr["RoomType"].ToString(),
Price = dr["Price"].ToString(),
});
lstgd.Add(new GuestDetailstbl
{
GuestId = Convert.ToInt32(dr["GuestId"]),
BookingDetailsId = Convert.ToInt32(dr["BookingDetailsId"]),
RoomDetailsId = Convert.ToInt32(dr["RoomDetailsId"]),
FirstName = dr["FirstName"].ToString(),
LastName = dr["LastName"].ToString(),
Salutation = dr["Salutation"].ToString(),
Type = dr["Type"].ToString(),
Status = Convert.ToInt32(dr["Status"]),
Age = Convert.ToInt32(dr["Age"]),
});
obj.Add(new BookingGuestRpt
{
HotelDetailscls = hd,
BookingDetailscls = bd,
RoomDetailscls = lstrd,
GuestDetailscls = lstgd,
Supplierscls = s,
Agentscls = a
});
}
dr.Close();
}
catch (Exception ex)
{
obj.Add(new BookingGuestRpt
{
Message = "Error",
ErrorMessage = ex.Message,
});
}
finally
{
con.Close();
}
return(obj);
}
public IEnumerable <BookingDetailstbl> BookingDetails(int type, BookingDetailstbl bd)
{
List <BookingDetailstbl> objBD = new List <BookingDetailstbl>();
try
{
MySqlCommand cmd = new MySqlCommand("Sp_BD_BookingDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("type", type);
cmd.Parameters.AddWithValue("pBookingDetailsId", bd.BookingDetailsId);
cmd.Parameters.AddWithValue("pHotelDetailsId", bd.HotelDetailsId);
cmd.Parameters.AddWithValue("pAgentID", bd.AgentID);
cmd.Parameters.AddWithValue("pSupplierID", bd.SupplierID);
cmd.Parameters.AddWithValue("pSupBookingId", bd.SupBookingId);
cmd.Parameters.AddWithValue("pAgentBookingId", bd.AgentBookingId);
cmd.Parameters.AddWithValue("pCheckin", bd.Checkin);
cmd.Parameters.AddWithValue("pCheckout", bd.Checkout);
cmd.Parameters.AddWithValue("pNoofRooms", bd.NoofRooms);
cmd.Parameters.AddWithValue("pAgentPrice", bd.AgentPrice);
cmd.Parameters.AddWithValue("pSupplierPrice", bd.SupplierPrice);
cmd.Parameters.AddWithValue("pStatus", bd.Status);
cmd.Parameters.AddWithValue("pCancellation", bd.Cancellation);
cmd.Parameters.AddWithValue("pAmendment", bd.Amendment);
cmd.Parameters.AddWithValue("pPaymentType", bd.PaymentType);
cmd.Parameters.AddWithValue("pPaymentStatus", bd.PaymentStatus);
cmd.Parameters.AddWithValue("pNonRefundable", bd.NonRefundable);
cmd.Parameters.AddWithValue("pCurrency", bd.Currency);
cmd.Parameters.AddWithValue("pSupBookRef", bd.SupBookRef);
cmd.Parameters.AddWithValue("pBookingDate", bd.BookingDate);
cmd.Parameters.AddWithValue("pBookingComment", bd.BookingComment);
cmd.Parameters.AddWithValue("pAdditionalInfo", bd.AdditionalInfo);
cmd.Parameters.AddWithValue("pTitle", bd.Title);
cmd.Parameters.AddWithValue("pName", bd.Name);
cmd.Parameters.AddWithValue("pSurName", bd.SurName);
cmd.Parameters.AddWithValue("pNationality", bd.Nationality);
cmd.Parameters.AddWithValue("pMobileNumber", bd.MobileNumber);
cmd.Parameters.AddWithValue("pEmailID", bd.EmailID);
cmd.Parameters.AddWithValue("pBookingType", bd.BookingType);
cmd.Parameters.AddWithValue("pConfirmationID", bd.ConfirmationID);
cmd.Parameters.AddWithValue("pReConfirmationID", bd.ReConfirmationID);
cmd.Parameters.AddWithValue("pCreatedBy", bd.CreatedBy);
cmd.Parameters.AddWithValue("pCreatedDate", bd.CreatedDate);
cmd.Parameters.AddWithValue("pUpdatedBy", bd.UpdatedBy);
cmd.Parameters.AddWithValue("pUpdatedDate", bd.UpdatedDate);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
objBD.Add(new BookingDetailstbl
{
BookingDetailsId = Convert.ToInt32(dr["BookingDetailsId"]),
HotelDetailsId = dr["HotelDetailsId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["HotelDetailsId"]),
AgentID = dr["AgentID"] == DBNull.Value ? 0 : Convert.ToInt32(dr["AgentID"].ToString()),
SupplierID = dr["SupplierID"] == DBNull.Value ? 0 : Convert.ToInt32(dr["SupplierID"].ToString()),
SupBookingId = dr["SupBookingId"].ToString(),
AgentBookingId = dr["AgentBookingId"].ToString(),
Checkin = dr["Checkin"].ToString(),
Checkout = dr["Checkout"].ToString(),
NoofRooms = dr["NoofRooms"] == DBNull.Value ? 0 : Convert.ToInt32(dr["NoofRooms"].ToString()),
AgentPrice = dr["AgentPrice"].ToString(),
SupplierPrice = dr["SupplierPrice"].ToString(),
Status = dr["Status"].ToString(),
Cancellation = dr["Cancellation"].ToString(),
Amendment = dr["Amendment"].ToString(),
PaymentType = dr["PaymentType"].ToString(),
PaymentStatus = dr["PaymentStatus"].ToString(),
NonRefundable = dr["NonRefundable"].ToString(),
Currency = dr["Currency"].ToString(),
SupBookRef = dr["SupBookRef"].ToString(),
BookingDate = dr["BookingDate"].ToString(),
BookingComment = dr["BookingComment"].ToString(),
AdditionalInfo = dr["AdditionalInfo"].ToString(),
Title = dr["Title"].ToString(),
Name = dr["Name"].ToString(),
SurName = dr["SurName"].ToString(),
//Nationality = dr["Nationality"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Nationality"]),
BookingType = dr["BookingType"].ToString(),
MobileNumber = dr["MobileNumber"].ToString(),
EmailID = dr["EmailID"].ToString(),
CreatedBy = dr["CreatedBy"] == DBNull.Value ? 0 : Convert.ToInt32(dr["CreatedBy"]),
CreatedDate = dr["CreatedDate"].ToString(),
UpdatedBy = dr["UpdatedBy"] == DBNull.Value ? 0 : Convert.ToInt32(dr["UpdatedBy"]),
UpdatedDate = dr["UpdatedDate"].ToString(),
ConfirmationID = dr["ConfirmationID"].ToString(),
ReConfirmationID = dr["ReConfirmationID"].ToString(),
Message = "Success",
});
}
dr.Close();
}
catch (Exception ex)
{
objBD.Add(new BookingDetailstbl
{
Message = "Error",
ErrorMessage = ex.Message,
});
}
finally
{
con.Close();
}
return(objBD);
}