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