/// <summary> /// offline /// </summary> /// <param name="model"></param> public void InsertData(RoomStatusModel model) { List <string> sqls = new List <string>(); List <SqlParameter[]> cmdParms = new List <SqlParameter[]>(); StringBuilder str; DateTime startDate = new DateTime(model.Year, 1, 1); DateTime endDate = startDate.AddYears(1).AddDays(-1); for (DateTime dt = startDate; dt <= endDate; dt = dt.AddDays(1)) { str = new StringBuilder(); str.AppendLine("Insert into RoomStatus"); str.AppendLine(" (StatusDate, RoomType, Available,CreateUser,CreateTime,UpdateUser,UpdateTime)"); str.AppendLine(" Values (@StatusDate, @RoomType, 0, 'system', getdate(), 'system', getdate())"); SqlParameter[] paras = new SqlParameter[2]; paras[0] = new SqlParameter("@StatusDate", dt); paras[1] = new SqlParameter("@RoomType", model.RoomType); sqls.Add(str.ToString()); cmdParms.Add(paras); } SqlAccess mySqlAccess = new SqlAccess(); mySqlAccess.ExecuteNonQuerys(sqls, cmdParms); }
// GET: RoomStatus public ActionResult Index() { var details = new RoomStatusModel { FloorList = floorBL.ListFloor(), RoomTypeList = roomTypeBL.ListRoomType(), RoomList = roomBL.ListRoom() }; return(View(details)); }
/// <summary> /// offline /// </summary> /// <param name="model"></param> /// <returns></returns> public RoomStatusModel GetSearchData(RoomStatusModel model) { StringBuilder sql = new StringBuilder(); sql.AppendLine("SELECT "); sql.AppendLine(" RoomStatusID, StatusDate, RoomType, Available"); sql.AppendLine(" FROM RoomStatus WITH(NOLOCK)"); sql.AppendLine(" WHERE 1=1"); sql.AppendLine(" and StatusDate >= @StartDate"); sql.AppendLine(" and StatusDate <= @EndDate"); sql.AppendLine(" and RoomType = @RoomType"); sql.AppendLine(" order by StatusDate asc"); SqlParameter[] paras = new SqlParameter[3]; DateTime dtStart = new DateTime(model.Year, model.Month, 1); paras[0] = new SqlParameter("@StartDate", dtStart); DateTime dtEnd = dtStart.AddMonths(1).AddDays(-1); paras[1] = new SqlParameter("@EndDate", dtEnd); paras[2] = new SqlParameter("@RoomType", model.RoomType); SqlAccess mySqlAccess = new SqlAccess(); DataSet ds = mySqlAccess.ExecuteAdapter(sql.ToString(), paras); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //roomStatusModel.RoomStatusUpdate = DataMappingHelper<RoomStatusUpdateModel>.DataTableToList(ds.Tables[0]); model.OpertationStatus = GlobalVariable.UpdateStatus.Update; DataTable dt = ds.Tables[0]; model.ChooseDate = string.Empty; foreach (DataRow dw in dt.Rows) { if (Convert.ToBoolean(dw["Available"])) { model.ChooseDate += Convert.ToDateTime(dw["StatusDate"].ToString()).Day.ToString() + ","; } } } else { model.OpertationStatus = GlobalVariable.UpdateStatus.Add; } return(model); }
private async Task PageOnLoad() { IsRunningIndicator = true; IsVisibleIndicator = true; IsVisibleData = false; RoomStatusModel roomStatusModel = new RoomStatusModel(); var responce = await GetAPIservice.GetReservationDetails(Settings.HotelCode, ReservationsHeader.ReservationID); if (!string.IsNullOrEmpty(responce)) { ReservationDetailsModel reservationDetails = JsonConvert.DeserializeObject <ReservationDetailsModel>(responce); if (reservationDetails != null) { reservationDetails.RoomStatusColor = "Black"; if (!string.IsNullOrEmpty(ReservationsHeader.RoomNumber) && ReservationsHeader.RoomNumber.All(Char.IsDigit)) { var roomResponce = await GetAPIservice.GetRoomStatus(Settings.HotelCode, ReservationsHeader.RoomNumber); if (!string.IsNullOrEmpty(roomResponce)) { roomStatusModel = JsonConvert.DeserializeObject <RoomStatusModel>(roomResponce); if (roomStatusModel != null) { reservationDetails.RoomStatusColor = roomStatusModel.RoomStatus == "Clean" ? "Green" : roomStatusModel.RoomStatus == "Inspected" ? "Orange" : "Red"; reservationDetails.RoomStatus = !string.IsNullOrEmpty(roomStatusModel.RoomStatus) ? roomStatusModel.RoomStatus : "Not Assigned"; } } } else { reservationDetails.RoomStatusColor = "Red"; reservationDetails.RoomStatus = !string.IsNullOrEmpty(roomStatusModel.RoomStatus) ? roomStatusModel.RoomStatus : "Not Assigned"; reservationDetails.RoomNumber = reservationDetails.RoomNumber.All(Char.IsDigit) && !string.IsNullOrEmpty(reservationDetails.RoomNumber) ? reservationDetails.RoomNumber : "Not Assigned"; } BadgeRemarksIcon = $"Numbers/badge{Constants.SelectedNoticesRemarksSet.RemarksList.Count}.png"; ReservationDetails = reservationDetails; IsRunningIndicator = false; IsVisibleIndicator = false; IsVisibleData = true; } } }
/// <summary> /// offline /// </summary> /// <param name="model"></param> public void InsertData(RoomStatusModel model) { List <string> sqls = new List <string>(); List <SqlParameter[]> cmdParms = new List <SqlParameter[]>(); StringBuilder str; DateTime startDate = new DateTime(model.Year, model.Month, 1); DateTime endDate = startDate.AddMonths(1).AddDays(-1); string[] chooseList = model.ChooseDate.Split(','); for (DateTime dt = startDate; dt <= endDate; dt = dt.AddDays(1)) { str = new StringBuilder(); str.AppendLine("Insert into RoomStatus"); str.AppendLine(" (StatusDate, RoomType, Available,CreateUser,CreateTime,UpdateUser,UpdateTime)"); str.AppendLine(" Values (@StatusDate, @RoomType, @Available, @CreateUser, getdate(), @UpdateUser, getdate())"); SqlParameter[] paras = new SqlParameter[5]; paras[0] = new SqlParameter("@StatusDate", dt); paras[1] = new SqlParameter("@RoomType", model.RoomType); string[] isexist = Array.FindAll(chooseList, m => (m == dt.Day.ToString())); if (isexist.Length > 0) { paras[2] = new SqlParameter("@Available", true); } else { paras[2] = new SqlParameter("@Available", false); } paras[3] = new SqlParameter("@CreateUser", Common.VariableConvert.ConvertStringToDBValue(model.CreateUser)); paras[4] = new SqlParameter("@UpdateUser", Common.VariableConvert.ConvertStringToDBValue(model.UpdateUser)); sqls.Add(str.ToString()); cmdParms.Add(paras); } SqlAccess mySqlAccess = new SqlAccess(); mySqlAccess.ExecuteNonQuerys(sqls, cmdParms); }