public IEnumerable <BookingRequesttbl> BookingRequestUpdate(int type, BookingRequesttbl br)
{
List <BookingRequesttbl> objBrd = new List <BookingRequesttbl>();
try
{
// RequestId, AgentId, Destination, Checkin, Checkout, Nationality, Rating, CountryId, CityId,
// Status, CreatedBy, CreatedDate, UpdatedBy, UpdatedDate, BookingDetailsId,
// PreferedHotels, IsDeleted, SightSeeing
// Id, RequestId, RoomNo, Salutation, FirstName, LastName, Age,
// Type, Status, CreatedBy, CreatedDate, UpdatedBy, UpdatedDate
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["mfbbo"].ConnectionString))
{
using (MySqlCommand cmd = new MySqlCommand("Sp_BookingRequestNew", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("type", type);
cmd.Parameters.AddWithValue("pRequestId", br.RequestId);
cmd.Parameters.AddWithValue("pAgentId", br.AgentId);
cmd.Parameters.AddWithValue("pDestination", br.Destination);
cmd.Parameters.AddWithValue("pCheckin", br.Checkin);
cmd.Parameters.AddWithValue("pCheckout", br.Checkout);
cmd.Parameters.AddWithValue("pNationality", br.Nationality);
cmd.Parameters.AddWithValue("pMobileNumber", br.MobileNumber);
cmd.Parameters.AddWithValue("pEmailID", br.EmailID);
cmd.Parameters.AddWithValue("pRating", br.Rating);
cmd.Parameters.AddWithValue("pCountryId", br.CountryId);
cmd.Parameters.AddWithValue("pCityId", br.CityId);
cmd.Parameters.AddWithValue("pBookingDetailsId", br.BookingDetailsId);
cmd.Parameters.AddWithValue("pPreferedHotels", br.PreferedHotels);
cmd.Parameters.AddWithValue("pIsDeleted", br.IsDeleted);
cmd.Parameters.AddWithValue("pSightSeeing", br.SightSeeing);
cmd.Parameters.AddWithValue("pStatus", br.Status);
cmd.Parameters.AddWithValue("pCreatedBy", br.CreatedBy);
cmd.Parameters.AddWithValue("pCreatedDate", br.CreatedDate);
cmd.Parameters.AddWithValue("pUpdatedBy", br.UpdatedBy);
cmd.Parameters.AddWithValue("pUpdatedDate", br.UpdatedDate);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (MySqlDataReader dr = cmd.ExecuteReader())
{
for (int i = 0; i < br.GuestDetails.Count; i++)
{
BookingReqGuestDetailstbl brg = new BookingReqGuestDetailstbl();
brg = br.GuestDetails[i];
List <BookingReqGuestDetailstbl> lstbrgd = new List <BookingReqGuestDetailstbl>();
lstbrgd = BookingRequestGuestDetails(4, brg).ToList();
}
while (dr.Read())
{
objBrd.Add(new BookingRequesttbl
{
RequestId = dr["RequestId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["RequestId"]),
AgentId = dr["AgentId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["AgentId"]),
Destination = dr["Destination"].ToString(),
Checkin = dr["Checkin"].ToString(),
Checkout = dr["Checkout"].ToString(),
Nationality = dr["Nationality"].ToString(),
MobileNumber = dr["MobileNumber"] == DBNull.Value ? 0 : Convert.ToInt32(dr["MobileNumber"]),
EmailID = dr["EmailID"].ToString(),
Rating = dr["Rating"].ToString(),
CountryId = dr["CountryId"].ToString(),
CityId = dr["CityId"].ToString(),
Status = dr["Status"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Status"]),
CreatedBy = string.IsNullOrEmpty(dr["CreatedBy"].ToString()) ? 0 : Convert.ToInt32(dr["CreatedBy"]),
CreatedDate = dr["CreatedDate"].ToString(),
UpdatedBy = string.IsNullOrEmpty(dr["UpdatedBy"].ToString()) ? 0 : Convert.ToInt32(dr["UpdatedBy"]),
UpdatedDate = dr["UpdatedDate"].ToString(),
BookingDetailsId = dr["BookingDetailsId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["BookingDetailsId"]),
PreferedHotels = dr["PreferedHotels"].ToString(),
IsDeleted = dr["IsDeleted"] == DBNull.Value ? 0 : Convert.ToInt32(dr["IsDeleted"]),
SightSeeing = dr["SightSeeing"].ToString(),
Message = "Success",
GuestDetails = (List <BookingReqGuestDetailstbl>)BookingRequestGuestDetails(4, new BookingReqGuestDetailstbl()
{
RequestId = br.RequestId
}),
});
}
}
}
}
}
catch (Exception ex)
{
objBrd.Add(new BookingRequesttbl
{
Message = "Error",
ErrorMessage = ex.Message,
});
}
finally
{
con.Close();
}
return(objBrd);
}
public IEnumerable <BookingReqGuestDetailstbl> BookingRequestGuestDetails(int type, BookingReqGuestDetailstbl brg)
{
List <BookingReqGuestDetailstbl> objBrd = new List <BookingReqGuestDetailstbl>();
try
{
MySqlCommand cmd = new MySqlCommand("Sp_BR_GuestAll", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("type", type);
cmd.Parameters.AddWithValue("pGuestId", brg.GuestId);
cmd.Parameters.AddWithValue("pRequestId", brg.RequestId);
cmd.Parameters.AddWithValue("pRoomNo", brg.RoomNo);
cmd.Parameters.AddWithValue("pSalutation", brg.Salutation);
cmd.Parameters.AddWithValue("pFirstName", brg.FirstName);
cmd.Parameters.AddWithValue("pLastName", brg.LastName);
cmd.Parameters.AddWithValue("pAges", brg.Age);
cmd.Parameters.AddWithValue("pType", brg.Type);
cmd.Parameters.AddWithValue("pStatus", brg.Status);
cmd.Parameters.AddWithValue("pCreatedBy", brg.CreatedBy);
cmd.Parameters.AddWithValue("pCreatedDate", brg.CreatedDate);
cmd.Parameters.AddWithValue("pUpdatedBy", brg.UpdatedBy);
cmd.Parameters.AddWithValue("pUpdatedDate", brg.UpdatedDate);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
objBrd.Add(new BookingReqGuestDetailstbl
{
RequestId = dr["RequestId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["RequestId"]),
GuestId = dr["GuestId"] == DBNull.Value ? 0 : Convert.ToInt32(dr["GuestId"]),
RoomNo = dr["RoomNo"] == DBNull.Value ? 0 : Convert.ToInt32(dr["RoomNo"]),
Salutation = dr["Salutation"].ToString(),
FirstName = dr["FirstName"].ToString(),
LastName = dr["LastName"].ToString(),
Age = dr["Age"].ToString(),
Type = dr["Type"].ToString(),
Status = dr["Status"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Status"]),
CreatedBy = dr["CreatedBy"] == DBNull.Value ? 0 : Convert.ToInt32(dr["CreatedBy"]),
CreatedDate = dr["CreatedDate"].ToString(),
UpdatedBy = dr["UpdatedBy"] == DBNull.Value ? 0 : Convert.ToInt32(dr["UpdatedBy"]),
Message = "Success",
});
}
dr.Close();
}
catch (Exception ex)
{
objBrd.Add(new BookingReqGuestDetailstbl
{
Message = "Error",
ErrorMessage = ex.Message,
});
}
finally
{
con.Close();
}
return(objBrd);
}
public IEnumerable <BookingRequesttbl> BookingRequestGet(int type, BookingRequesttbl brd)
{
List <BookingRequesttbl> objBrd = new List <BookingRequesttbl>();
try
{
// RequestId, AgentId, Destination, Checkin, Checkout, Nationality, Rating, CountryId, CityId,
// Status, CreatedBy, CreatedDate, UpdatedBy, UpdatedDate, BookingDetailsId,
// PreferedHotels, IsDeleted, SightSeeing
// Id, RequestId, RoomNo, Salutation, FirstName, LastName, Age,
// Type, Status, CreatedBy, CreatedDate, UpdatedBy, UpdatedDate
MySqlCommand cmd = new MySqlCommand("Sp_BR_RequestAll", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("type", type);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
BookingReqGuestDetailstbl bgd = new BookingReqGuestDetailstbl()
{
GuestId = Convert.ToInt32(dr["GuestId"]),
RequestId = Convert.ToInt32(dr["RequestId"]),
RoomNo = Convert.ToInt32(dr["RoomNo"]),
Salutation = dr["Salutation"].ToString(),
FirstName = dr["FirstName"].ToString(),
LastName = dr["LastName"].ToString(),
Type = dr["Type"].ToString(),
Age = dr["Age"].ToString(),
};
objBrd.Add(new BookingRequesttbl
{
RequestId = Convert.ToInt32(dr["RequestId"]),
AgentId = Convert.ToInt32(dr["AgentId"]),
Destination = dr["Destination"].ToString(),
Checkin = dr["Checkin"].ToString(),
Checkout = dr["Checkout"].ToString(),
Nationality = dr["Nationality"].ToString(),
Rating = dr["Rating"].ToString(),
CountryId = dr["CountryId"].ToString(),
CityId = dr["CityId"].ToString(),
Status = Convert.ToInt32(dr["Status"]),
CreatedBy = string.IsNullOrEmpty(dr["CreatedBy"].ToString()) ? 0 : Convert.ToInt32(dr["CreatedBy"]),
CreatedDate = dr["CreatedDate"].ToString(),
UpdatedBy = string.IsNullOrEmpty(dr["UpdatedBy"].ToString()) ? 0 : Convert.ToInt32(dr["UpdatedBy"]),
UpdatedDate = dr["UpdatedDate"].ToString(),
BookingDetailsId = Convert.ToInt32(dr["BookingDetailsId"]),
PreferedHotels = dr["PreferedHotels"].ToString(),
IsDeleted = Convert.ToInt32(dr["IsDeleted"]),
SightSeeing = dr["SightSeeing"].ToString(),
Message = "Success",
});
}
dr.Close();
}
finally
{
con.Close();
}
return(objBrd);
}
