ResponseModel IRoomService.AddRoomsToBuilding(int buildingId, List <RoomModel> roomModels)
{
var isAccessibleBuilding = this.dbContext.Building.WhereActiveAccessibleBuilding(b => b.BuildingID == buildingId).Any();
if (!isAccessibleBuilding)
{
return(new ResponseModel(Enums.StatusCode.Error, "User does not have a permission to add rooms in building."));
}
var existingRoom = this.dbContext.RoomDetail.WhereActiveAccessibleRoom(b => b.BuildingID == buildingId).Select(r => r.Room_Name);
roomModels = roomModels.Where(r => !existingRoom.Any(e => e.Equals(r.RoomName, StringComparison.InvariantCultureIgnoreCase))).ToList();
foreach (var roomModel in roomModels)
{
var room = new RoomDetail
{
Room_Name = roomModel.RoomName,
X = roomModel.X,
Y = roomModel.Y,
BuildingID = buildingId
};
this.dbContext.RoomDetail.Add(room);
}
this.dbContext.SaveChanges();
return(new ResponseModel(Enums.StatusCode.Ok, "Room added to building successfully."));
}
public ActionResult Edit(int Id, FormCollection form1)
{
try
{
RoomDetail rm = new RoomDetail();
RoomDetail Rd = db.RoomDetails.Single(s => s.R_Id == Id);
Rd.RoomType = form1["RoomType"];
if (rm.RoomType == "Standard")
{
rm.Price = 1000;
}
if (rm.RoomType == "Premium")
{
rm.Price = 2000;
}
if (rm.RoomType == "Delux")
{
rm.Price = 3000;
}
return(RedirectToAction("Viewdetails"));
}
catch
{
return(View());
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,AdmissionDate")] RoomDetail roomDetail)
{
if (id != roomDetail.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(roomDetail);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RoomDetailExists(roomDetail.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(roomDetail));
}
public IHttpActionResult Update(RoomDetail Item)
{
ApiResult <RoomResult> rs = new ApiResult <RoomResult>();
if (Item == null)
{
rs.Failed(new ErrorObject
{
Code = "EXCEPTION",
Description = "Đéo nhận dữ liệu truyền vào! 😒 "
});
return(Content(HttpStatusCode.BadRequest, rs));
}
if (!ModelState.IsValid)
{
// Lỗi validate dữ liệu trả ra từ model
foreach (string key in ModelState.Keys)
{
ModelState current = ModelState[key];
foreach (ModelError error in current.Errors)
{
rs.Failed(new ErrorObject()
{
Code = key,
Description = error.ErrorMessage
});
}
}
return(Content(HttpStatusCode.BadRequest, rs));
}
UploadFileResult uploadLogo = null;
if (Item.Avatar.StartsWith("data:image"))
{
uploadLogo = CommonUtil.UploadBase64File(
Item.Avatar,
string.Format("{0}_{1}.png", Item.Name.Replace(" ", "_"), "Avatar"),
ConfigUtil.GetConfigurationValueFromKey("RoomAvatarDerectory", false),
ImageFormat.Png,
20
);
if (uploadLogo != null && !uploadLogo.HasError)
{
Item.Avatar = uploadLogo.FilePath;
}
}
rs = roomDAL.Update(Item, UserInfo.Id);
if (!rs.Succeeded)
{
return(Content(HttpStatusCode.BadRequest, rs));
}
return(Ok(rs));
}
public ActionResult Viewdetails(RoomDetail rm)
{
EmployeeEntities EE = new EmployeeEntities();
List <RoomDetail> RList = EE.RoomDetails.ToList();
return(View(RList));
}
public IHttpActionResult PutMeeting(int id, [FromBody] Models.MeetingM meeting)
{
if (!ModelState.IsValid)
{
return(NotFound());
}
try
{
using (var ctx = new TrainingAndMeetingDBEntities())
{
Meeting tra = new Meeting();
Schedule sch = new Schedule();
RoomDetail rm = new RoomDetail();
MeetingListM mList = new MeetingListM(); //object of model class
var data = db.Meetings.ToList(); //all list of meetings
var existingmeeting = ctx.Meetings.Where(s => s.MeetingId == id)
.FirstOrDefault <Meeting>(); //get existing meeting details
var existingschedule = ctx.Schedules.Where(s => s.ScheduleId == existingmeeting.ScheduleId)
.FirstOrDefault <Schedule>(); // get existing schedule
var existingmeetingattendee = ctx.MeetingsAttendees.Where(s => s.MeetingId == existingmeeting.MeetingId)
.FirstOrDefault <MeetingsAttendee>(); //get existing meeting attendee list
if (existingmeeting != null)
{
existingschedule.StartTime = DateTime.ParseExact(meeting.StartTime, "yyyy-MM-dd HH:mm:ss",
System.Globalization.CultureInfo.InvariantCulture);
existingschedule.EndTime = DateTime.ParseExact(meeting.EndTime, "yyyy-MM-dd HH:mm:ss",
System.Globalization.CultureInfo.InvariantCulture);
existingschedule.RoomId = meeting.RoomId;
var obj = db.Schedules.Add(sch);
ctx.SaveChanges();
existingmeeting.MeetingName = meeting.MeetingName; //add value in training table
existingmeeting.Agenda = meeting.Agenda;
// existingmeetingattendee.MeetingId = meeting.MeetingId;
var obj1 = db.Meetings.Add(tra);
foreach (int userid in meeting.MeetingAttendeeId)
{
MeetingsAttendee list = new MeetingsAttendee(); //object of model class
list.UserId = userid;
list.MeetingId = existingmeeting.MeetingId;
ctx.MeetingsAttendees.Add(list);
ctx.SaveChanges();
}
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
return(Ok(meeting));
}
public async Task <IActionResult> Create([Bind("Id,AdmissionDate")] RoomDetail roomDetail)
{
if (ModelState.IsValid)
{
_context.Add(roomDetail);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(roomDetail));
}
public ActionResult Create(RoomDetail roomDetail)
{
if (ModelState.IsValid)
{
db.RoomDetails.Add(roomDetail);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.Ward_ID = new SelectList(db.Wards, "ID", "Name", roomDetail.Ward_ID);
return View(roomDetail);
}
public ATestDanmuku()
{
//
// The InitializeComponent() call is required for Windows Forms designer support.
//
InitializeComponent();
RoomDetail roomdetail = worklog.GetRoomDetail();
richTextBox1.Text = roomdetail.data.sid + "\n" + roomdetail.data.uid;
//
// TODO: Add constructor code after the InitializeComponent() call.
//
}
public ActionResult delete(int Id)
{
RoomDetail rm = new RoomDetail();
RoomDetail Rd = db.RoomDetails.Find(Id);
db.RoomDetails.Remove(Rd);
db.SaveChanges();
RedirectToAction("ViewDetails");
Total_rooms = Total_rooms - 1;
return(View());
}
public ActionResult Create(FormCollection form)
{
RoomDetail rm = new RoomDetail();
rm.RoomType = form["RoomType"];
// rm.R_Id = Convert.ToInt32(form["R_Id"]);
if (rm.RoomType == "Standard")
{
rm.Price = 1000;
}
if (rm.RoomType == "Premium")
{
rm.Price = 2000;
}
if (rm.RoomType == "Delux")
{
rm.Price = 3000;
}
if (ModelState.IsValid)
{
try
{
db.RoomDetails.Add(rm);
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult item in ex.EntityValidationErrors)
{
// Get entry
DbEntityEntry entry = item.Entry;
string entityTypeName = entry.Entity.GetType().Name;
// Display or log error messages
foreach (DbValidationError subItem in item.ValidationErrors)
{
string message = "Error";
Console.WriteLine(message);
}
}
}
}
Total_rooms = Total_rooms + 1;
return(View());
}
public ApiResult <RoomResult> Insert(RoomDetail Item, int UserId = 0)
{
ApiResult <RoomResult> rs = new ApiResult <RoomResult>()
{
Data = new RoomResult()
};
try
{
DbProvider.SetCommandText2("sp_room_Insert", CommandType.StoredProcedure);
DbProvider.AddParameter("InJson", Libs.SerializeObject(Item), SqlDbType.NVarChar);
DbProvider.AddParameter("UserId", UserId, SqlDbType.Int);
DbProvider.AddParameter("ErrorCode", DBNull.Value, SqlDbType.NVarChar, 100, ParameterDirection.Output);
DbProvider.AddParameter("ReturnMsg", DBNull.Value, SqlDbType.NVarChar, 4000, ParameterDirection.Output);
DbProvider.AddParameter("RoomId", DBNull.Value, SqlDbType.Int, ParameterDirection.Output);
DbProvider.ExecuteNonQuery();
string errorCode = DbProvider.Command.Parameters["ErrorCode"].Value.ToString();
try
{
rs.Data.Id = Int32.Parse(DbProvider.Command.Parameters["RoomId"].Value.ToString());
}
catch (Exception)
{
rs.Data.Id = 0;
}
if (!errorCode.Equals(Constants.SUCCESS))
{
rs.Failed(new ErrorObject()
{
Code = DbProvider.Command.Parameters["ErrorCode"].Value.ToString(),
Description = DbProvider.Command.Parameters["ReturnMsg"].Value.ToString()
});
}
} catch (Exception ex)
{
rs.Failed(new ErrorObject()
{
Code = Constants.ERR_EXCEPTION,
Description = ex.Message
});
}
return(rs);
}
/// <summary>
/// 房间详情
/// </summary>
/// <param name="msg"></param>
public override void OnRoomDetail(ByteString msg)
{
Request request = new Request();
ByteUtils.ByteStringToObject(request, msg);
RoomDetail roomDetail = new RoomDetail();
ByteUtils.ByteStringToObject(roomDetail, request.CpProto);
Logger.Info("OnRoomDetail, roomId={0}, state={1}, maxPlayer={2}, mode={3}, canWatch={4}, owner={5}",
roomDetail.RoomID, roomDetail.State, roomDetail.MaxPlayer, roomDetail.Mode, roomDetail.CanWatch, roomDetail.Owner);
foreach (PlayerInfo player in roomDetail.PlayerInfos)
{
Logger.Info("player userId={0}", player.UserID);
}
}
public IHttpActionResult PutTraining(int id, Models.TrainingModel training)
{
if (!ModelState.IsValid)
{
return(NotFound());
}
try
{
using (var ctx = new TrainingAndMeetingDBEntities())
{
Training tra = new Training();
Schedule sch = new Schedule();
RoomDetail rm = new RoomDetail();
var existingtraining = ctx.Trainings.Where(s => s.TrainingId == id)
.FirstOrDefault <Training>();
var existingschedule = ctx.Schedules.Where(s => s.ScheduleId == existingtraining.ScheduleId)
.FirstOrDefault <Schedule>();
if (existingtraining != null)
{
existingschedule.StartTime = DateTime.ParseExact(training.StartTime, "yyyy-MM-dd HH:mm:ss",
System.Globalization.CultureInfo.InvariantCulture);
existingschedule.EndTime = DateTime.ParseExact(training.EndTime, "yyyy-MM-dd HH:mm:ss",
System.Globalization.CultureInfo.InvariantCulture);
existingschedule.RoomId = training.RoomId;
var obj = db.Schedules.Add(sch);
ctx.SaveChanges();
existingtraining.Topic = training.Topic; //add value in training table
existingtraining.Description = training.Description;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
return(Ok(training));
}
public void Delete(int?ItemID)
{
var itemObj = db.ItemDetails.Find(ItemID);
//remove picture
//remove comment items
db.CommentItems.RemoveRange(db.CommentItems.Where(x => x.ItemID == itemObj.ItemID));
//remove wishlist items
db.WishListItems.RemoveRange(db.WishListItems.Where(x => x.ItemID == itemObj.ItemID));
//remove booking items
db.BookingItems.RemoveRange(db.BookingItems.Where(x => x.ItemID == itemObj.ItemID));
//remove looking fors
LookingFor lookingForObj = db.LookingFors.Where(x => x.LookingForID == itemObj.LookingForID).Single();
db.LookingFors.Remove(lookingForObj);
//remove room details
RoomDetail roomDetailObj = db.RoomDetails.Where(x => x.RoomDetailID == itemObj.RoomDetailID).Single();
db.RoomDetails.Remove(roomDetailObj);
//remove lifestyle
Lifestyle lifestyleObj = db.Lifestyles.Where(x => x.LifestyleID == itemObj.LifestyleID).Single();
db.Lifestyles.Remove(lifestyleObj);
//remove other features
OtherFeature otherFeatureObj = db.OtherFeatures.Where(x => x.OtherFeatureID == itemObj.OtherFeatureID).Single();
db.OtherFeatures.Remove(otherFeatureObj);
//Remove Item
db.ItemDetails.Remove(itemObj);
db.SaveChanges();
}
//获取房间详细
public RoomDetail GetRoomDetail()
{
Dictionary <string, int> parameters = new Dictionary <string, int>();
parameters.Add("uid", 107616417);
WebHeaderCollection header = new WebHeaderCollection();
HttpWebResponse response = HttpHelper.CreatePostHttpResponseInt(get_room_view, parameters, timeout, null, null, false, true, header);
string recievedata = HttpHelper.GetResponseString(response);
JObject json = null;
try {
json = JObject.Parse(recievedata);
} catch (Exception e) {
throw new Exception("登陆出错\n" + e.Message);
}
RoomDetail roomdetail = new RoomDetail();
JsonConvert.PopulateObject(recievedata, roomdetail);
return(roomdetail);
}
public ActionResult ConfirmBooking(BooKingDataForm FormData)
{
if (FormData.StartDate < FormData.EndDate)
{
int result = RoomStore.CheckForReservation(FormData);
if (result > 0)
{
RoomDetail RoomData = RoomStore.GetRoomById(result);
ConfirmBooking Data = new ConfirmBooking
{
StartDate = FormData.StartDate,
EndDate = FormData.EndDate,
Room = new RoomsList {
RoomId = RoomData.RoomDetailscode, RoomNum = RoomData.RoomNumber
},
Price = RoomStore.RecervationPrice(FormData)
};
return(View(Data));
}
}
return(View());
}
public ActionResult Edit(RoomDetail roomDetail)
{
if (ModelState.IsValid)
{
db.Entry(roomDetail).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.Ward_ID = new SelectList(db.Wards, "ID", "Name", roomDetail.Ward_ID);
return View(roomDetail);
}
