public ActionResult AddNewVisitor(VisitorModel model, string operation) { model.lstblock = HttpContext.Application["lstblock"] as List <string>; model.lstrelation = HttpContext.Application["lstrelations"] as List <string>; if (operation == "In") { DateTime intime = Request.RequestContext.HttpContext.Timestamp; model.In_Time = intime.ToString(); omodelmanager.VisitorIn(model); ModelState.Clear(); return(View(model)); } else if (operation == "Search") { ovisitormodel = omodelmanager.GetVisitor(model); ovisitormodel.lstblock = HttpContext.Application["lstblock"] as List <string>; ovisitormodel.lstrelation = HttpContext.Application["lstrelations"] as List <string>; ModelState.Clear(); return(View(ovisitormodel)); } else if (operation == "Out") { DateTime outtime = Request.RequestContext.HttpContext.Timestamp; model.Out_Time = outtime.ToString(); omodelmanager.VisitorOut(model); ModelState.Clear(); return(View(model)); } return(View()); }
public async Task <IActionResult> Post(VisitorModel visitorModel) { var visitor = _mapper.Map <Visitor>(visitorModel); var createdTicket = await _visitorService.AddAsync(visitor); return(Ok(createdTicket)); }
public JsonResult Visitor_Filter(string startDate, string endDate) { string jsonString = string.Empty; try { visitor = new BaseLayer.VisitorBase(); visitor.StartDate = startDate; visitor.EndDate = endDate; List <VisitorModel> VisitorList = new List <VisitorModel>(); VisitorModel model = new VisitorModel(); actionResult = visitorAction.Visitor_Filter(visitor); if (actionResult.IsSuccess && actionResult.dtResult.Rows.Count > 0) { for (int i = 0; i < actionResult.dtResult.Rows.Count; i++) { jsonString += "<tr id=" + actionResult.dtResult.Rows[i]["VisitorID"].ToString() + ">"; jsonString += "<td>" + actionResult.dtResult.Rows[i]["VisitorDate"] + "</td><td>" + actionResult.dtResult.Rows[i]["VisitorName"] + "</td><td>" + actionResult.dtResult.Rows[i]["GroupIdentifier"] + "</td><td>" + actionResult.dtResult.Rows[i]["FromHoursMinutes"] + "</td><td>" + actionResult.dtResult.Rows[i]["ToHoursMinutes"] + "</td><td><a href='Index?visitorID=" + actionResult.dtResult.Rows[i]["VisitorID"].ToString() + "' class='btn small btn-info btn-sm btn-icon' title='Edit Visitor'><i class='fa fa-pencil'></i></a> | <a href ='javascript:;' onclick='DeleteVisitor(" + actionResult.dtResult.Rows[i]["VisitorID"].ToString() + ",this);' class='btn small btn-danger btn-sm -icon delete-sm' title='Delete Visitor'><i class='fa fa-trash'></i></a></td>"; jsonString += "</tr>"; } } } catch (Exception) { jsonString = "-1"; return(Json(jsonString, JsonRequestBehavior.AllowGet)); } return(Json(jsonString, JsonRequestBehavior.AllowGet)); }
public VisitorModel GetVisitorCentres() { string NATIONAL_PARK_API_PATH = BASE_URL + "visitorcenters?parkCode=acad,dena,cabr,cave,grca,jotr,yose,zion,yell,glac"; string parksData = ""; VisitorModel visitors = null; //httpClient.BaseAddress = new Uri(NATIONAL_PARK_API_PATH); // It can take a few requests to get back a prompt response, if the API has not received // calls in the recent past and the server has put the service on hibernation try { using (var httpClient = new HttpClient { BaseAddress = new Uri(NATIONAL_PARK_API_PATH) }) { httpClient.DefaultRequestHeaders.Accept.Clear(); httpClient.DefaultRequestHeaders.Add("X-Api-Key", API_KEY); httpClient.DefaultRequestHeaders.Accept.Add( new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json")); HttpResponseMessage response = httpClient.GetAsync(NATIONAL_PARK_API_PATH).GetAwaiter().GetResult(); parksData = response.Content.ReadAsStringAsync().GetAwaiter().GetResult(); if (!parksData.Equals("")) { // JsonConvert is part of the NewtonSoft.Json Nuget package visitors = JsonConvert.DeserializeObject <VisitorModel>(parksData); } } } catch (Exception e) { // This is a useful place to insert a breakpoint and observe the error message Console.WriteLine(e.Message); } return(visitors); }
public void VisitorIn(VisitorModel model) { using (SqlConnection cn = new SqlConnection(cns)) { using (SqlCommand cmd = new SqlCommand("visitorin", cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cell", model.Visitor_Cellno); cmd.Parameters.AddWithValue("@visitor_name", model.VisitorName); cmd.Parameters.AddWithValue("@age", model.Age); cmd.Parameters.AddWithValue("@gender", model.Gender); cmd.Parameters.AddWithValue("@address", model.Address); cmd.Parameters.AddWithValue("@relation", model.Relation); cmd.Parameters.AddWithValue("@date_time_in", model.In_Time); cmd.Parameters.AddWithValue("@member_name", model.MemberName); cmd.Parameters.AddWithValue("@block", model.Block); cmd.Parameters.AddWithValue("@flat_no", model.Flatno); try { cn.Open(); int count = cmd.ExecuteNonQuery(); } catch (SqlException ex) { throw ex; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } }
public void VisitorOut(VisitorModel model) { using (SqlConnection cn = new SqlConnection(cns)) { using (SqlCommand cmd = new SqlCommand("visitorout", cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cell", model.Visitor_Cellno); cmd.Parameters.AddWithValue("@date_time_out", model.Out_Time); try { cn.Open(); int count = cmd.ExecuteNonQuery(); } catch (SqlException ex) { throw ex; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } }
/// <summary> /// Добавляет запись о заселение посетителей /// </summary> /// <param name="idRoom">Id комнаты</param> /// <param name="idUser">Id пользователя</param> /// <param name="model">Модель для добавления</param> /// <returns></returns> public async Task <Guid> AddAsync(int idRoom, Guid idUser, VisitorModel model) { if (model == null) { throw new NullReferenceException($"Ссылка на модель указывает на null."); } var resultRoom = await _roomService.FindByIdAsync(idRoom); var resultUser = await _userService.FindByIdAsync(idUser); if (resultRoom.IsFree) { //Занимаем комнату resultRoom.IsFree = false; } else { throw new ArgumentException($"Комната под id:{idRoom} уже занята."); } var resultVisitor = new Visitor(resultRoom.Id, resultUser.Id, model.Date); await _context.Visitors.AddAsync(resultVisitor); await _context.SaveChangesAsync(); return(resultVisitor.Id); }
public ActionResult Create(VisitorModel visitorModel) { try { Visitor visitor = new Visitor { ID = visitorModel.ID, Comment = visitorModel.Comment, vName = visitorModel.vName }; if (ModelState.IsValid) { if (visitor.ID > 0) { visitorRepository.UpdateVisitor(visitor); } else { visitorRepository.InsertVisitor(visitor); } } else { return(View(visitorModel)); } return(RedirectToAction("Index")); } catch (Exception) { return(View(visitorModel)); } }
internal static Visitor ToDataModel(this VisitorModel visitorModel) { return(new Visitor { Name = visitorModel.Name, Address = visitorModel.Address, }); }
public async Task <IActionResult> Put(Guid visitorId, VisitorModel visitorModel) { var visitor = await _visitorService.GetAsync(visitorId); _mapper.Map(visitorModel, visitor); var updatedPlace = await _visitorService.UpdateAsync(visitorId, visitor); return(Ok(updatedPlace)); }
public ActionResult VisitorGrid(int id, string namefilter) { var m = new VisitorModel(id, namefilter); ViewBag.orgname = Session["ActiveOrganization"] + " - Guests"; UpdateModel(m.Pager); DbUtil.LogActivity("Viewing Visitors for {0}".Fmt(Session["ActiveOrganization"])); return(View("VisitorGrid", m)); }
public ActionResult <ResponseModel> AddVisitor([FromBody] VisitorModel model) { var storageVisitor = Mapper.ConvertVisitorDomainModelToStorage(model); dbContext.Visitors.Add(storageVisitor); dbContext.SaveChanges(); return(new ResponseModel { IsSuccess = true, Message = "Save Successful." }); }
void Start() { movement = GetComponent <VisitorMovement>(); model = GetComponent <VisitorModel>(); happiness = 0.5f; // Start at 50% happinessFailed = false; ui = GameObject.Instantiate <HappyUI>(uiPrefab); ui.Follow(transform); }
public ActionResult VisitorGrid(int id, string namefilter) { var qb = DbUtil.Db.QueryBuilderVisitedCurrentOrg(); InitExportToolbar(id, qb.QueryId); var m = new VisitorModel(id, qb.QueryId, namefilter); UpdateModel(m.Pager); DbUtil.LogActivity("Viewing Visitors for {0}".Fmt(Session["ActiveOrganization"])); return(View("VisitorGrid", m)); }
public Task <int> SaveVisitorAsync(VisitorModel item) { if (item.ID != 0) { return(Database.UpdateAsync(item)); } else { return(Database.InsertAsync(item)); } }
public IActionResult GetById(int id) { VisitorModel visitor = _visitorManager.GetVisitorById(id); if (visitor == null) { return(NotFound()); } return(Ok(visitor)); }
bool ICRUDService.Delete(int id) { VisitorModel visitor = _context.Visitors.Where(v => v.VisitorModelID == id).FirstOrDefault(); _context.Visitors.Remove(visitor); if (_context.SaveChanges() == 1) { return(true); } return(false); }
public VisitorModel GetVisitor(VisitorModel model) { VisitorModel visitor = new VisitorModel(); using (SqlConnection cn = new SqlConnection(cns)) { using (SqlCommand cmd = new SqlCommand("searchvisitor", cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cell", model.Visitor_Cellno); try { cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { visitor.Visitor_Cellno = dr["visitor_cell"].ToString(); visitor.VisitorName = dr["visitor_name"].ToString(); visitor.Age = (int)dr["age"]; visitor.Gender = dr["gender"].ToString(); visitor.Address = dr["address"].ToString(); visitor.Relation = dr["relation"].ToString(); visitor.MemberName = dr["member_name"].ToString(); visitor.Block = dr["block"].ToString(); visitor.Flatno = (int)dr["flat_no"]; string in_time = dr["date_time_in"].ToString(); string out_time = dr["date_time_out"].ToString(); if (in_time != string.Empty && out_time != string.Empty) { } else if (in_time != string.Empty) { visitor.In_Time = dr["date_time_in"].ToString(); } } dr.Close(); } } catch (SqlException ex) { throw ex; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } return(visitor); }
/// <summary> /// Maps a VisitorModel to Visitor. /// </summary> /// <param name="visitorModel">The visitor model.</param> /// <returns>A visitor</returns> public static Visitor ToVisitor(this VisitorModel visitorModel) { return(new Visitor() { Id = visitorModel.Id, CreatedBy = visitorModel.CreatedBy, CreatedOn = visitorModel.CreatedOn, UpdatedBy = visitorModel.UpdatedBy, UpdatedOn = visitorModel.UpdatedOn, Mobile = visitorModel.Mobile, Email = visitorModel.Email, Name = visitorModel.Name }); }
public ActionResult Index(int userId) { //visar profilsidan på användaren med id:t som skickas in var model = UnitOfWork.ProfileRepository.GetProfile(userId); //Kollar om profilen tillhör den nuvarande användaren if (UnitOfWork.ProfileRepository.GetProfileId(User.Identity.GetUserId()) == model.Id) { return(RedirectToAction("IndexMe")); } var visitorModel = new VisitorModel() { ProfileId = model.Id, VisitorId = UnitOfWork.ProfileRepository.GetProfileId(User.Identity.GetUserId()) }; // Hämtar alla besökare var visitorModels = UnitOfWork.VisitorRepository.GetVisitorProfiles(model.Id); bool duplicate = false; // Kollar om den inloggade användaren finns på besökarlistan foreach (var visitor in visitorModels) { if (visitor.VisitorId == UnitOfWork.ProfileRepository.GetProfileId(User.Identity.GetUserId())) { duplicate = true; } } // om besökaren inte redan finns i besökarlistan och listan är mindre än 5 if ((visitorModels.Count < 5) && (!duplicate)) { UnitOfWork.VisitorRepository.AddVisitor(visitorModel); } // om besökaren inte redan finns i besökarlistan, men listan är full else if (!duplicate) { // den äldsta besökaren tas bort och den nya läggs till UnitOfWork.VisitorRepository.RemoveOldestVisitor(); UnitOfWork.VisitorRepository.AddVisitor(visitorModel); } var viewModel = new ProfileIndexViewModel(model); UnitOfWork.Save(); return(View(viewModel)); }
public int CheckLogin(string email, string password) { string hashedpassword = MD5Hash.GetMD5(password); VisitorModel visitor = _context.Visitors .Where(v => v.Email == email) .Where(v => v.Password == hashedpassword) .FirstOrDefault(); if (visitor != null) { return(visitor.VisitorModelID); } return(0); }
public IActionResult Create([FromBody] CreateVisitorRequest request) { VisitorModel visitor = _visitorManager.CreateVisitor(request.LinkId, request.IPAddress, request.UserAgent, request.OSInfo, request.DeviceInfo, request.BrowserInfo); if (visitor == null) { return(BadRequest()); } return(CreatedAtAction(nameof(GetById), new { id = visitor.Id }, null)); }
public ActionResult Create(int id = 0) { Visitor visitor = new Visitor(); if (id > 0) { visitor = visitorRepository.GetVisitorById(id); } VisitorModel visitorModel = new VisitorModel { ID = visitor.ID, Comment = visitor.Comment, vName = visitor.vName }; return(View(visitorModel)); }
public async Task VisitArticleAsync(string id, string remoteIp, string userAgent) { using var activity = traceActivityDecorator.StartActivity(); var model = new VisitorModel { Date = DateTime.Now, RemoteIp = remoteIp, Article = id, UserAgent = userAgent }; await visitorRepository.InsertAsync(model); await cache.RemoveSaveAsync(CacheKeys.AllVisitors.Name); await cache.RemoveSaveAsync(CacheKeys.VisitorsByArticleId.Name(id)); }
public List <VisitorModel> GetAllVisitor() { List <VisitorModel> visitorlist = new List <VisitorModel>(); using (SqlConnection cn = new SqlConnection(cns)) { using (SqlCommand cmd = new SqlCommand("getallvisitor", cn)) { cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { VisitorModel vm = new VisitorModel(); vm.Visitor_Id = (int)dr["visitor_id"]; vm.VisitorName = dr["visitor_name"].ToString(); vm.Visitor_Cellno = dr["visitor_cell"].ToString(); vm.Age = (int)dr["age"]; vm.Gender = dr["gender"].ToString(); vm.Address = dr["address"].ToString(); vm.Relation = dr["relation"].ToString(); vm.MemberName = dr["member_name"].ToString(); vm.Block = dr["block"].ToString(); vm.Flatno = (int)dr["flat_no"]; vm.In_Time = dr["date_time_in"].ToString(); vm.Out_Time = dr["date_time_out"].ToString(); visitorlist.Add(vm); } } } catch (SqlException ex) { throw ex; } finally { if (cn.State == ConnectionState.Open) { cn.Close(); } } } } return(visitorlist); }
// GET: Visitor/Visitor public ActionResult Index(int?visitorID = 0) { VisitorModel model = new VisitorModel(); List <VisitorModel> visitorList = new List <VisitorModel>(); model.GroupIdentifier = "Group " + DateTime.Now.ToString("dd-MMMM-yyyy hh:mm"); model.VisitorDate = DateTime.Now.Date.ToString(); model.FromHoursMinutes = DateTime.Now.ToString("hh:mm tt"); model.ToHoursMinutes = DateTime.Now.ToString("hh:mm tt"); if (visitorID.Value > 0) { visitor.VisitorID = visitorID.Value; actionResult = visitorAction.Visitor_Load(visitor); if (actionResult.IsSuccess && actionResult.dtResult.Rows.Count > 0) { DataRow row = actionResult.dtResult.Rows[0]; model.VisitorID = row["VisitorID"] != DBNull.Value ? Convert.ToInt32(row["VisitorID"]) : 0; model.VisitorName = row["VisitorName"] != DBNull.Value ? row["VisitorName"].ToString() : ""; model.Description = row["Description"] != DBNull.Value ? row["Description"].ToString() : ""; model.FromHoursMinutes = row["FromHoursMinutes"] != DBNull.Value ? row["FromHoursMinutes"].ToString() : ""; model.ToHoursMinutes = row["ToHoursMinutes"] != DBNull.Value ? row["ToHoursMinutes"].ToString() : ""; model.VisitorDate = row["VisitorDate"] != DBNull.Value ? row["VisitorDate"].ToString() : ""; model.GroupIdentifier = row["GroupIdentifier"] != DBNull.Value ? row["GroupIdentifier"].ToString() : "Group " + DateTime.Now.ToString("dd-MMMM-yyyy hh:mm"); } } actionResult = visitorAction.Visitor_Filter(visitor); if (actionResult.IsSuccess && actionResult.dtResult.Rows.Count > 0) { visitorList = (from DataRow row in actionResult.dtResult.Rows select new VisitorModel { VisitorID = row["VisitorID"] != DBNull.Value ? Convert.ToInt32(row["VisitorID"]) : 0, VisitorName = row["VisitorName"] != DBNull.Value ? row["VisitorName"].ToString() : "", Description = row["Description"] != DBNull.Value ? row["Description"].ToString() : "", FromHoursMinutes = row["FromHoursMinutes"] != DBNull.Value ? row["FromHoursMinutes"].ToString() : "", ToHoursMinutes = row["ToHoursMinutes"] != DBNull.Value ? row["ToHoursMinutes"].ToString() : "", VisitorDate = row["VisitorDate"] != DBNull.Value ? row["VisitorDate"].ToString() : "", GroupIdentifier = row["GroupIdentifier"] != DBNull.Value ? row["GroupIdentifier"].ToString() : "Group " + DateTime.Now.ToString("dd-MMMM-yyyy hh:mm") }).ToList(); } model.VisitorList = visitorList; return(View(model)); }
public async Task <int> AddVisitor(VisitorModel visitorModel) { var visitor = new Visitor() { Name = visitorModel.Name, SecondName = visitorModel.SecondName, Patronymic = visitorModel.Patronymic, RoomId = visitorModel.RoomId, ArrivalDate = visitorModel.ArrivalDate, DepartureDate = visitorModel.DepartureDate, TotalCost = visitorModel.TotalCost }; await _hotelContext.Visitors.AddAsync(visitor); await _hotelContext.SaveChangesAsync(); return(visitor.VisitorId); }
public HttpResponseMessage Post(VisitorModel entity) { if (ModelState.IsValid) { using (var db = new vmsDBContext()) { Visitors vstr = new Visitors(); vstr.Name = entity.Name; vstr.Guests = entity.Guests; vstr.Email = entity.Email; vstr.Phone = entity.Phone; vstr.IdCard = entity.IdCard; vstr.Vehicle = entity.Vehicle; vstr.VehicleNu = entity.VehicleNu; vstr.Color = entity.Color; vstr.ParkineZone = entity.ParkineZone; vstr.Building = entity.Building; vstr.MeeTTo = entity.MeeTTo; vstr.TokenNo = entity.TokenNo; vstr.EntryDate = DateTime.Now; db.Visitors.Add(vstr); db.SaveChanges(); //db.Entry(vstr).GetDatabaseValues(); InOuts inout = new InOuts(); inout.VisitorID = vstr.VisitorID; inout.InTime = entity.InTime; inout.Status = "Security Checkin"; inout.EntryDate = DateTime.Now; db.InOuts.Add(inout); db.SaveChanges(); } HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, new { entity }); return(response); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } }
/// <summary> /// Изменяет запись, добавляя информацию о выезде /// </summary> /// <returns>Возвращает сумму, которую надо заплатить(в рублях)</returns> public async Task <int> DepartureAsync(Guid idVisitor, VisitorModel model) { if (model == null) { throw new NullReferenceException($"Ссылка на модель указывает на null."); } var resultVisitor = Visitors.SingleOrDefault(x => x.Id == idVisitor); if (resultVisitor == null) { throw new NullReferenceException($"Записи с таким id:{idVisitor} нету."); } if (resultVisitor.ArrivalDate > model.Date) { throw new ArgumentException($"Дата выезда({model.Date}) меньше чем дата въезда({resultVisitor.ArrivalDate})."); } if (resultVisitor.Room.IsFree) { throw new ArgumentException($"Комната свободна, и оттуда некому пока выезжать."); } resultVisitor.DateOfDeparture = model.Date; //Освобождаем комнату resultVisitor.Room.IsFree = true; //Данные необходимые для подсчёта var days = resultVisitor.DateOfDeparture.DayOfYear - resultVisitor.ArrivalDate.DayOfYear; var peopleCount = resultVisitor.Room.MaxCount; var priceForType = _prices[resultVisitor.Room.RoomOptionId]; //Формула для подсчёта сцены(почти произвольная) var resultPrice = peopleCount * priceForType + days * priceForType; //Записывается в запись итоговая цена resultVisitor.Price = resultPrice; await _context.SaveChangesAsync(); return(resultPrice); }
public async Task <VisitorModel> Register(VisitorModel visitorModel) { _loggingService.Log($"Request has been recieved at {ServiceName} "); try { var id = Guid.NewGuid(); var metadata = new FileMetadata <Guid> { ID = id, Name = visitorModel.Name + id, ContentType = ".jpeg" }; MemoryStream stream = new MemoryStream(Convert.FromBase64String(visitorModel.Image)); var status = await _storageAdaper.Upload(stream, metadata); if (status.StatusCode != HttpStatusCode.Created && status.StatusCode != HttpStatusCode.OK) { throw new OperationCanceledException($"Could not store file into CDN,respnse is {status.Error?.Message}"); } _loggingService.Log($"File has been uploaded into CDN with id {status.FullyQualifiedPublicId}"); var visitor = visitorModel.ToDataModel(); visitor.UpdatedOn = DateTime.UtcNow; visitor.StrorageUrl = status.SecureUri.ToString(); visitor.ID = id; var res = await _registrationDataService.Register(visitor); if (!res) { throw new Exception("There was exception happend in the DB layer"); } visitorModel.BarCode = GenerateQrCode(id.ToString()); return(visitorModel); } catch (Exception ex) { _loggingService.Log(ex); throw new OperationCanceledException(); } }