public async Task <RoomImages> UpdateRoomImagesAysnc(RoomImages roomImages) { var res = await _unitOfWork.RoomImagesRepository.UpdateAsync(roomImages); //_unitOfWork.RoomImagesRepo.SaveChangesAsync(); return(res); }
public void loadData() { List <RoomImages> imageList = new List <RoomImages>(); int roomID = 0; SqlCommand cmd = new SqlCommand("RoomSearch", conn); //Instruct the command object to execute it cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@roomNo", Session["roomNo"].ToString())); SqlDataReader dataReader = null; try { conn.Open(); dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { roomID = Convert.ToInt32(dataReader["RoomID"].ToString()); roomNo.Value = dataReader["RoomNo"].ToString(); roomType.Value = dataReader["RoomType"].ToString(); roomAvailable.Value = dataReader["RoomAvailability"].ToString();; //dataReader["RoomAvailability"].ToString(); roomPrice.Value = dataReader["RoomPrice"].ToString(); } dataReader.Close(); cmd = new SqlCommand("RoomImageSearch", conn); //Instruct the command object to execute it cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@roomID", roomID)); dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { RoomImages roomImages = new RoomImages(); roomImages.imgID = Convert.ToInt32(dataReader["imgID"].ToString()); roomImages.imgName = dataReader["imgName"].ToString(); roomImages.imgPath = dataReader["imgPath"].ToString(); roomImages.roomID = Convert.ToInt32(dataReader["roomID"].ToString()); imageList.Add(roomImages); } img1Link.HRef = imageList[0].imgPath; img2Link.HRef = imageList[1].imgPath; img1.Src = imageList[0].imgPath; img2.Src = imageList[1].imgPath; } catch (Exception ex) { Console.WriteLine(ex.Message); } dataReader.Close(); conn.Close(); }
public int UploadHomeReport(string id, string hotelName, int hotelId) { try { string drive = ConfigurationManager.AppSettings["PicDrive"]; string folderName = ConfigurationManager.AppSettings["FolderName"]; folderName = folderName + "/" + hotelName + "~" + hotelId; string driveToSave = Path.Combine(drive, folderName); HotelInformation hInfo = new HotelInformation(); RoomImages roomImg = new RoomImages(); int result = 0; if (CheckDirectory(driveToSave)) { if (Request.Files.Count > 0) { foreach (string file in Request.Files) { HttpPostedFileBase hpf = Request.Files[file] as HttpPostedFileBase; hpf.SaveAs(Path.Combine(driveToSave, hpf.FileName)); roomImg.PicName = hpf.FileName; roomImg.RoomID = id; roomImg.HotelID = hotelId; roomImg.IsEnable = 0; roomImg.Flag = "A"; result = hInfo.SaveRoomImages(roomImg); } } } return(result); } catch (Exception ex) { ExceptionHandling.WriteException(ex); Response.StatusCode = (int)HttpStatusCode.BadRequest; return(0); } }
public async Task <RoomImages> UpdateRoomImagesAsync([FromBody] RoomImages rooms) { return(await _roomsService.UpdateRoomImagesAysnc(rooms)); }
public async Task <RoomImages> AddRoomImagesAsync([FromBody] RoomImages roomImages) { return(await _RoomImagesService.AddRoomImagesAysnc(roomImages)); }