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