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