private static void GetGuestInformation() { // Capture the information about each guest (assumption is at least one guest and unknown maximum) // Info to capture: First name, last name, message to the host string moreGuestsComing = ""; do { GuestModel guest = new GuestModel(); guest.FirstName = GetInfoFromConsole("What is your first name: "); guest.LastName = GetInfoFromConsole("What is your last name: "); guest.MessageToHost = GetInfoFromConsole("What message would you like to tell your host: "); moreGuestsComing = GetInfoFromConsole("Are more guests coming (yes/no): "); guests.Add(guest); Console.Clear(); } while (moreGuestsComing.ToLower() == "yes"); }
private static void AddChoixInDoc(GuestModel guest, List <CategoryModel> categories, DocX doc) { Paragraph paraVotes = doc.InsertParagraph(); var votes = guest.GetVotes(); for (int i = 0; i < 24; i++) { paraVotes.Append("\r\n\r\n" + categories[i].CategoryName + ": ").Bold(); string strToAppend = ""; foreach (var categoryNominee in categories[i].CategoryNominees) { if (votes[i].Contains(categoryNominee.Letter)) { strToAppend += (string.IsNullOrEmpty(strToAppend) ? "" : ", ") + categoryNominee.Description; } } paraVotes.Append(strToAppend); } }
public int RegisterGuest(GuestModel _guest) { try { DataContractJsonSerializer ser = new DataContractJsonSerializer( typeof(GuestModel)); MemoryStream mem = new MemoryStream(); ser.WriteObject(mem, _guest); string data = Encoding.UTF8.GetString(mem.ToArray(), 0, (int)mem.Length); WebClient webClient = new WebClient(); webClient.Headers["Content-type"] = "application/json"; webClient.Encoding = Encoding.UTF8; string response = webClient.UploadString(BASE_URL + "registerGuest", "POST", data); int ID = JsonConvert.DeserializeObject <int>(response); return(ID); } catch { return(-1); } }
public async Task <ActionResult> Index(LoginModel login) { try { GuestModel Guest = null;// = new User(); using (var httpClient = new HttpClient()) { StringContent content = new StringContent(JsonConvert.SerializeObject(login), Encoding.UTF8, "application/json"); using (var response = await httpClient.PostAsync("https://informatik8.ei.hv.se/GuestAPI/api/Login", content)) { string apiResponse = await response.Content.ReadAsStringAsync(); Guest = JsonConvert.DeserializeObject <GuestModel>(apiResponse); } } if (Guest != null) { await SetUserAuthenticated(Guest); var str = JsonConvert.SerializeObject(Guest); HttpContext.Session.SetString("GuestSession", str); return(Redirect("~/Booking/Create/")); } else { ViewData["failedlogin"] = "******"; return(View()); } } catch (Exception ex) { logger.LogWarning("Couldn't login."); System.Diagnostics.Debug.WriteLine(ex.Message); return(View()); } }
public HttpResponseMessage Put(HttpRequestMessage request, int id, [FromBody] GuestModel value) { try { var guest = service.Get(id); if (guest != null) { var mapper = new MapperConfiguration(cfg => cfg.CreateMap <GuestModel, GuestDTO>()).CreateMapper(); var data = mapper.Map <GuestModel, GuestDTO>(value); service.Update(id, data); return(request.CreateResponse(HttpStatusCode.OK)); } return(request.CreateResponse(HttpStatusCode.NotFound)); } catch (Exception exception) { return(request.CreateResponse(HttpStatusCode.BadRequest)); } }
protected void Page_Load(object sender, EventArgs e) { LoggedID = Convert.ToString(Session["ID"]); LevelID = Convert.ToString(Session["Level"]); //disallow staff from purchasing ticket if (LevelID.Equals("Staff")) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Not Allowed to purchase tiicket, please sign-up.');", true); Response.Redirect("Login.aspx"); } else if (LevelID.Equals("Guest")) //Guest logged in { Name = Convert.ToString(Session["Name"]); Surname = Convert.ToString(Session["Surname"]); Email = Convert.ToString(Session["Email"]); GuestServiceClient gsc = new GuestServiceClient(); guest = gsc.findGuestbyID(LoggedID); } else if (LevelID.Equals("Host")) //Host logged in { Name = Convert.ToString(Session["Name"]); Surname = Convert.ToString(Session["Surname"]); Email = Convert.ToString(Session["Email"]); } else //new user { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Please Login or sign up first');", true); Response.Redirect("Login.aspx"); } if (!IsPostBack) { txtU_name.Text = Name; txtU_name.ReadOnly = true; txtU_surname.Text = Surname; txtU_surname.ReadOnly = true; txtU_Email.Text = Email; txtU_Email.ReadOnly = true; } }
private void UpdateData() { this.DoRequest(Task.Run(() => { var letters = new List <string>(); guests = userEventsController.Values.Where(x => x.EventId == eventDetail.Id) .Join(usersController.Values, x => x.UserId, y => y.Id, (x, y) => y) .OrderBy(x => x.Name) .Select(x => { var guestModel = new GuestModel() { Avatar = x.Avatar, Name = x.Name }; var firstLetter = x.Name.FirstOrDefault().ToString(); if (guestModel.IsHeadLetter = letters.Any(y => y.Equals(firstLetter.ToUpper()))) { guestModel.IsHeadLetter = false; } else { guestModel.IsHeadLetter = true; letters.Add(firstLetter.ToUpper()); } return(guestModel); }) .ToList(); }), () => { adapter.Guests = guests; recyclerView.ScheduleLayoutAnimation(); }); }
private static void AddStatistics(List <GuestModel> statistics, GuestModel choix, List <CategoryModel> categories, DocX doc) { Table statsTable = doc.AddTable(25, categories[0].CategoryNominees.Count + 1); foreach (Cell cell in statsTable.Rows[0].Cells) { cell.FillColor = Color.LightGray; } statsTable.Rows[0].Cells[0].Paragraphs[0].Append("CATEGORIES").Bold(); var choixVotes = choix.GetVotes(); foreach (var category in categories) { if (category.CategoryNb == 1) { AddHeaders(statsTable.Rows[0], category); } string categoryName = category.CategoryName; statsTable.Rows[category.CategoryNb].Cells[0].Paragraphs[0].Append(categoryName); statsTable.Rows[category.CategoryNb].Cells[0].FillColor = Color.LightGray; foreach (var categoryNominee in category.CategoryNominees) { int statisticIndex = GetIndexFromLetter(categoryNominee.Letter); bool isChoice = choixVotes[category.CategoryNb - 1].Contains(categoryNominee.Letter); if (statisticIndex != -1) { AddNbVotesInRow(statsTable.Rows, statistics[statisticIndex], category.CategoryNb, statisticIndex, isChoice); } } } doc.InsertTable(statsTable); }
public GuestModel updateGuest(string id, GuestModel eventGuest) { using (EventrixDBDataContext db = new EventrixDBDataContext()) { try { var query = (from add in db.Guests where add.G_ID == Convert.ToInt32(id) select add); if (query.Count() == 1) { Guest res = query.Single(); res.Name = eventGuest.NAME; res.Surname = eventGuest.SURNAME; res.Email = eventGuest.EMAIL; res.Password = eventGuest.PASS; db.SubmitChanges(); eventGuest = new GuestModel() { ID = res.G_ID, NAME = res.Name, SURNAME = res.Surname, EMAIL = res.Email, PASS = res.Password, TYPE = res.Type }; return(eventGuest); } else { return(null); } } catch (Exception) { return(null); } } }
public ViewResult ListAllResponses() { string connectionString = DataAccess.GetConnectionString(); List <GuestModel> guestList = new List <GuestModel>(); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); string sql = "SELECT NickName, FancyMail, AnimalName FROM PartyPeople"; SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { GuestModel guest = new GuestModel(); guest.NickName = reader["NickName"].ToString(); guest.FancyMail = reader["FancyMail"].ToString(); guest.AnimalName = reader["AnimalName"].ToString(); guestList.Add(guest); } } return(View(guestList)); }
public async void Test_Repository_Update(BookingModel booking, StayModel stay) { await _connection.OpenAsync(); try { using (var ctx = new BookingContext(_options)) { await ctx.Database.EnsureCreatedAsync(); await ctx.Bookings.AddAsync(booking); await ctx.Stays.AddAsync(stay); await ctx.SaveChangesAsync(); } using (var ctx = new BookingContext(_options)) { var bookingRentals = new List <BookingRentalModel>(); bookingRentals.Add(new BookingRentalModel { RentalId = 1 }); booking.BookingRentals = bookingRentals; var bookings = new Repository <BookingModel>(ctx); var expected = await ctx.Bookings.FirstAsync(); expected.Status = "updated"; bookings.Update(expected); await ctx.SaveChangesAsync(); var actual = await ctx.Bookings.FirstAsync(); Assert.Equal(expected, actual); } using (var ctx = new BookingContext(_options)) { var stays = new Repository <StayModel>(ctx); var expected = await ctx.Stays.FirstAsync(); expected.DateModified = DateTime.Now; stays.Update(expected); await ctx.SaveChangesAsync(); var actual = await ctx.Stays.FirstAsync(); Assert.Equal(expected, actual); } using (var ctx = new BookingContext(_options)) { List <GuestModel> _guests = new List <GuestModel>(); GuestModel _guest = new GuestModel { Age = "30" }; _guests.Add(_guest); var bookings = new BookingRepository(ctx); var expected = await ctx.Bookings.FirstAsync(); expected.BookingRentals = null; expected.Guests = _guests; bookings.Update(expected); await ctx.SaveChangesAsync(); var actual = await ctx.Bookings.FirstAsync(); Assert.Equal(expected, actual); } } finally { _connection.Close(); } }
string ImportData(FileUpload flInfo, int EventID, EventModel _event) { string path = ""; string response = ""; bool isValidGuestColumn = false; bool isValidStaffColumn = false; bool isValidProductColumn = false; int startColumn; int startRow; ExcelWorksheet GuestworkSheet; ExcelWorksheet StaffworkSheet; ExcelWorksheet ProductworkSheet; int count = 0; if (flInfo.HasFile) { try { string filename = Path.GetFileName(flInfo.FileName); string serverLocation = "~/temp/" + "/" + filename; string SaveLoc = Server.MapPath(serverLocation); flInfo.SaveAs(SaveLoc); path = Server.MapPath("/") + "\\temp\\" + filename; var package = new ExcelPackage(new System.IO.FileInfo(path)); //// package.Workbook.Worksheets["TABNAME"].View.TabSelected = true; startColumn = 1; //where the file in the class excel start startRow = 2; GuestworkSheet = package.Workbook.Worksheets[1]; //read sheet one StaffworkSheet = package.Workbook.Worksheets[2]; //read sheet two ProductworkSheet = package.Workbook.Worksheets[3]; isValidGuestColumn = ValidateGuestColumns(GuestworkSheet); isValidStaffColumn = ValidateStaffColumns(StaffworkSheet); isValidProductColumn = ValidateProductColumns(ProductworkSheet); // isValidColumn = true; } catch { response = "Failed"; return(response); } //check staff sheet object data = null; if (isValidStaffColumn == true && isValidGuestColumn == true && isValidProductColumn == true) { do { data = StaffworkSheet.Cells[startRow, startColumn].Value; //column Number if (data == null) { continue; } //read column class name object Name = StaffworkSheet.Cells[startRow, startColumn].Value; object Email = StaffworkSheet.Cells[startRow, startColumn + 1].Value; object Occupation = StaffworkSheet.Cells[startRow, startColumn + 2].Value; StaffModel _staff = new StaffModel(); _staff.NAME = Name.ToString(); _staff.EMAIL = Email.ToString(); _staff.Occupation = Occupation.ToString(); _staff.PASS = "******"; _staff.EventID = EventID; //import db Eventrix_Client.Registration reg = new Eventrix_Client.Registration(); response = reg.RegisterStaff(_staff); if (response.Contains("successfully")) { count++; //====================-----------Send Email TO Staff-----------------=====================================// //=========================================================================================================// } startRow++; } while (data != null); data = null; startColumn = 1; //where the file in the class excel start startRow = 2; do { data = GuestworkSheet.Cells[startRow, startColumn].Value; //column Number if (data == null) { continue; } object Name = GuestworkSheet.Cells[startRow, startColumn].Value; object Surname = GuestworkSheet.Cells[startRow, startColumn + 1].Value; object Email = GuestworkSheet.Cells[startRow, startColumn + 2].Value; object Tyicket_Type = GuestworkSheet.Cells[startRow, startColumn + 3].Value; GuestModel _guest = new GuestModel(); _guest.NAME = Name.ToString(); _guest.SURNAME = Surname.ToString(); _guest.EMAIL = Email.ToString(); _guest.PASS = "******"; _guest.TYPE = Tyicket_Type.ToString(); Eventrix_Client.Registration reg = new Eventrix_Client.Registration(); int G_ID = reg.RegisterGuest(_guest); //Generate OTP string pass = genCode(Convert.ToString(G_ID)); //HashPass GuestModel gWithPass = new GuestModel(); gWithPass.PASS = pass; response = reg.InsertOTP(gWithPass, Convert.ToString(G_ID)); // response = reg.RegisterGuest(_guest); if (G_ID != -1) { count++; //====================-----------Send Invitation Email-----------------=====================================// EmailClient email = new EmailClient(); email.sendMsgInvite(_guest, _event, pass, EventID); //=========================================================================================================// } startRow++; } while (data != null); //upload product details data = null; startColumn = 1; //where the file in the class excel start startRow = 2; do { data = ProductworkSheet.Cells[startRow, startColumn].Value; //column Number if (data == null) { continue; } object Name = ProductworkSheet.Cells[startRow, startColumn].Value; object Description = ProductworkSheet.Cells[startRow, startColumn + 1].Value; object Quantity = ProductworkSheet.Cells[startRow, startColumn + 2].Value; object Price = ProductworkSheet.Cells[startRow, startColumn + 3].Value; EventProduct _product = new EventProduct(); _product._Name = Name.ToString(); // _product._Desc = Description.ToString(); _product._Quantity = Convert.ToInt32(Quantity.ToString()); _product.ProdRemaining = Convert.ToInt32(Quantity.ToString()); _product._Price = Convert.ToInt32(Price.ToString()); _product.EventID = EventID; ProductServiceClient psv = new ProductServiceClient(); string isProductUpdated = psv.createProduct(_product); if (isProductUpdated.Contains("success")) { count++; } startRow++; } while (data != null); //check record if (count == (GuestworkSheet.Dimension.Rows - 1) + (StaffworkSheet.Dimension.Rows - 1) + (ProductworkSheet.Dimension.Rows - 1)) { response = "success: All Records uploaded"; } else { response = "success: Not All Records uploaded"; } } else { response += " Failed to upload Exceel: Check columns"; } } else { response = "Failed: File not found"; } return(response); }
public void AddNewGuest(GuestModel newGuestModel) { CallServiceClientSafely(channel => channel.AddNewGuest(newGuestModel), $"An error occurred whilst calling GuestsService to add a new guest for '{newGuestModel.FirstName} {newGuestModel.LastName}."); }
public IActionResult Put(int id, [FromBody] GuestModel model) { return(this.Ok()); }
public async Task AddGuest(GuestModel guest) { var newGuest = _mapper.Map <Guest>(guest); await _guestRepository.Add(newGuest); }
protected void btnSubmit_Click(object sender, EventArgs e) { string EVENT_TRACKER; string SUBFOLDER = "Main_Image"; int hostID = Convert.ToInt32(Session["ID"].ToString()); String request = (Request.QueryString["EventID"]); if (request == null) { request = (Request.QueryString["ed"]); } EventServiceClient _eventClient = new EventServiceClient(); EventModel oldEvent = new EventModel(); oldEvent = _eventClient.findByEventID(request); //Editing Address EventAddress currentAdd = new EventAddress(); EventAddress Oldadd = new EventAddress(); MappingClient mc = new MappingClient(); currentAdd = mc.getAddressById(Convert.ToString(oldEvent.EventAddress)); if (txtCountry.Text.Equals("")) { Oldadd.COUNTRY = currentAdd.COUNTRY; } else { Oldadd.COUNTRY = txtCountry.Text; } if (txtCity.Text.Equals("")) { Oldadd.CITY = currentAdd.CITY; } else { Oldadd.CITY = txtCity.Text; } if (txtStreet.Text.Equals("")) { Oldadd.STREET = currentAdd.STREET; } else { Oldadd.STREET = txtStreet.Text; } if (txtProvince.Text.Equals("")) { Oldadd.PROVINCE = currentAdd.PROVINCE; } else { Oldadd.PROVINCE = txtProvince.Text; } EventAddress newAddress = new EventAddress(); newAddress = mc.EditAddress(Oldadd, Convert.ToString(oldEvent.EventAddress)); EventModel _event = new EventModel(); _event.HostID = oldEvent.HostID; _event.Name = txtEventName.Text; //Event Name if (chkBoxPrivate.Checked == true) //Public or Private Event { _event.Type = "Private"; } else { _event.Type = "Public"; } _event.Desc = txtDesc.Text; //Event Description string startdate = ""; string enddate = ""; //DateTime sDate = DateTime.ParseExact(startdate, "yyyy-MM-ddTHH:mm", CultureInfo.InvariantCulture); //DateTime eDate = DateTime.ParseExact(enddate, "yyyy-MM-ddTHH:mm", CultureInfo.InvariantCulture); //_event.sDate = sDate; //Event Start Date //_event.eDate = eDate; //Event End Date if (txtStart.Text.Equals("")) { _event.sDate = oldEvent.sDate; } else { // _event.sDate = DateTime.ParseExact(txtStart.Text, "yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture); //var date = DateTime.Parse(strDate,new CultureInfo("en-US", true)) _event.sDate = Convert.ToString(DateTime.Parse(txtStart.Text, new CultureInfo("en-US", true))); } if (txtEnd.Text.Equals("")) { _event.eDate = oldEvent.eDate; } else { // _event.eDate = DateTime.ParseExact(txtEnd.Text, "yyyy-MM-ddTHH:mm", CultureInfo.InvariantCulture); _event.eDate = Convert.ToString(DateTime.Parse(txtEnd.Text, new CultureInfo("en-US", true))); } _event.EventAddress = newAddress.ID; //Event's address ID //check ticket field if (!txtE_Quantity.Text.Equals("")) { _event.EB_Quantity = Convert.ToInt32(txtE_Quantity.Text); } else { _event.EB_Quantity = 0; } if (!txtR_Quantity.Text.Equals("")) { _event.Reg_Quantity = Convert.ToInt32(txtR_Quantity.Text); } else { _event.Reg_Quantity = 0; } if (!txtV_Quantity.Text.Equals("")) { _event.VIP_Quantity = Convert.ToInt32(txtV_Quantity.Text); } else { _event.VIP_Quantity = 0; } if (!txtVV_Quantity.Text.Equals("")) { _event.VVIP_Quantity = Convert.ToInt32(txtVV_Quantity.Text); } else { _event.VVIP_Quantity = 0; } //Edit Event Event EventServiceClient _editEvent = new EventServiceClient(); EventModel newEvent = new EventModel(); newEvent = _editEvent.updateEvent(_event, request); bool isCreatedTicket = false; //Ticket Controller EVENT_TRACKER = "Event Edited successfully"; //Import users //string ImportSpreadsheet = ""; //ImportSpreadsheet = ImportData(flGuest, newEvent.EventID); //===================Import guest,staff and products============================// string path = ""; string response = ""; bool isValidGuestColumn = false; bool isValidStaffColumn = false; bool isValidProductColumn = false; int startColumn = 0; int startRow = 0; ExcelWorksheet GuestworkSheet = null; ExcelWorksheet StaffworkSheet = null; ExcelWorksheet ProductworkSheet = null; int count = 0; if (flGuest.HasFile) { try { string filename = Path.GetFileName(flGuest.FileName); string serverLocation = "~/Temp/" + "/" + filename; string SaveLoc = Server.MapPath(serverLocation); flGuest.SaveAs(SaveLoc); path = Server.MapPath("/") + "\\Temp\\" + filename; var package = new ExcelPackage(new System.IO.FileInfo(path)); //// package.Workbook.Worksheets["TABNAME"].View.TabSelected = true; startColumn = 1; //where the file in the class excel start startRow = 2; GuestworkSheet = package.Workbook.Worksheets[1]; //read sheet one StaffworkSheet = package.Workbook.Worksheets[2]; //read sheet two ProductworkSheet = package.Workbook.Worksheets[3]; isValidGuestColumn = ValidateGuestColumns(GuestworkSheet); isValidStaffColumn = ValidateStaffColumns(StaffworkSheet); isValidProductColumn = ValidateProductColumns(ProductworkSheet); // isValidColumn = true; } catch { response += "Failed"; } //check staff sheet object data = null; if (isValidStaffColumn == true && isValidGuestColumn == true && isValidProductColumn == true) { do { data = StaffworkSheet.Cells[startRow, startColumn].Value; //column Number if (data == null) { continue; } //read column class name object Name = StaffworkSheet.Cells[startRow, startColumn].Value; object Email = StaffworkSheet.Cells[startRow, startColumn + 1].Value; object Occupation = StaffworkSheet.Cells[startRow, startColumn + 2].Value; StaffModel _staff = new StaffModel(); _staff.NAME = Name.ToString(); _staff.EMAIL = Email.ToString(); _staff.Occupation = Occupation.ToString(); _staff.PASS = "******"; _staff.EventID = newEvent.EventID; //edit to db StaffServiceClient ssv = new StaffServiceClient(); bool isCreated = ssv.createStaff(_staff); if (isCreated == true) { count++; } startRow++; } while (data != null); data = null; startColumn = 1; //where the file in the class excel start startRow = 2; do { data = GuestworkSheet.Cells[startRow, startColumn].Value; //column Number if (data == null) { continue; } object Name = GuestworkSheet.Cells[startRow, startColumn].Value; object Surname = GuestworkSheet.Cells[startRow, startColumn + 1].Value; object Email = GuestworkSheet.Cells[startRow, startColumn + 2].Value; GuestModel _guest = new GuestModel(); _guest.NAME = Name.ToString(); _guest.SURNAME = Surname.ToString(); _guest.EMAIL = Email.ToString(); _guest.PASS = "******"; _guest.TYPE = "Private"; Eventrix_Client.Registration reg = new Eventrix_Client.Registration(); // response = reg.RegisterGuest(_guest); sendMsg(_guest, _event); if (response.Contains("successfully")) { count++; } startRow++; } while (data != null); //upload product details data = null; startColumn = 1; //where the file in the class excel start startRow = 2; do { data = ProductworkSheet.Cells[startRow, startColumn].Value; //column Number if (data == null) { continue; } object Name = ProductworkSheet.Cells[startRow, startColumn].Value; object Description = ProductworkSheet.Cells[startRow, startColumn + 1].Value; object Quantity = ProductworkSheet.Cells[startRow, startColumn + 2].Value; object Price = ProductworkSheet.Cells[startRow, startColumn + 3].Value; EventProduct _product = new EventProduct(); _product._Name = Name.ToString(); // _product._Desc = Description.ToString(); _product._Quantity = Convert.ToInt32(Quantity.ToString()); _product._Price = Convert.ToInt32(Price.ToString()); _product.EventID = newEvent.EventID; ProductServiceClient psv = new ProductServiceClient(); // string isProductUpdated = psv.createProduct(_product); string isProductUpdated = psv.createProduct(_product); if (isProductUpdated.Contains("success")) { count++; } startRow++; } while (data != null); //check record if (count == (GuestworkSheet.Dimension.Rows - 1) + (StaffworkSheet.Dimension.Rows - 1) + (ProductworkSheet.Dimension.Rows - 1)) { response = "success: All Records uploaded"; } else { response = "success: Not All Records uploaded"; } } else { response += " Failed to upload Exceel: Check columns"; } } else { response = "Failed: File not found"; } //==============================================================================// if (response.Contains("success")) { EVENT_TRACKER += "\n Spreadsheet Uploaded"; //Create Tickets isCreatedTicket = isLoadedTicket(newEvent, newEvent.EventID); if (isCreatedTicket == true) { EVENT_TRACKER += "\n Ticket Created"; } else { EVENT_TRACKER += "\n Failed to upload ticket"; } } else { EVENT_TRACKER += "\n Spreadsheet Uploaded"; //Create Tickets isCreatedTicket = isLoadedTicket(newEvent, newEvent.EventID); if (isCreatedTicket == true) { EVENT_TRACKER += "\n Ticket Created"; } else { EVENT_TRACKER += "\n Failed to upload ticket"; } //Unable to upload guest EVENT_TRACKER += "\n failed to upload spreadsheet"; } ////Upload images ImageFile mainPic = new ImageFile(); mainPic = UploadFile(flEventImages, Convert.ToString(newEvent.EventID), SUBFOLDER); //Upload Event Main's Image to client directory if (mainPic != null) { FileUploadClient fuc = new FileUploadClient(); string res1 = fuc.saveImage(mainPic); //Upload Event Main's Image to Database string number = res1; } Response.Redirect("EventDetails.aspx?EventID=" + newEvent.EventID); // Response.Write("<script> Alert("+ EVENT_TRACKER + ");</script>"); }
public void AddGuest(GuestModel guest) { // AllGuests.Push(guest); _guestStream.OnNext(guest); }
public IHttpActionResult addGuest(GuestModel guestModel) { modelManager.addGuest(guestModel); return(Ok()); }
string ImportData(FileUpload flInfo, int EventID) { string path = ""; string response = ""; bool isValidGuestColumn = false; bool isValidStaffColumn = false; bool isValidProductColumn = false; int startColumn; int startRow; ExcelWorksheet GuestworkSheet; ExcelWorksheet StaffworkSheet; ExcelWorksheet ProductworkSheet; int count = 0; if (flInfo.HasFile) { try { string filename = Path.GetFileName(flInfo.FileName); string serverLocation = "~/Temp/" + "/" + filename; string SaveLoc = Server.MapPath(serverLocation); flInfo.SaveAs(SaveLoc); path = Server.MapPath("/") + "\\Temp\\" + filename; var package = new ExcelPackage(new System.IO.FileInfo(path)); //// package.Workbook.Worksheets["TABNAME"].View.TabSelected = true; startColumn = 1; //where the file in the class excel start startRow = 2; GuestworkSheet = package.Workbook.Worksheets[1]; //read sheet one StaffworkSheet = package.Workbook.Worksheets[2]; //read sheet two ProductworkSheet = package.Workbook.Worksheets[3]; isValidGuestColumn = ValidateGuestColumns(GuestworkSheet); isValidStaffColumn = ValidateStaffColumns(StaffworkSheet); isValidProductColumn = ValidateProductColumns(ProductworkSheet); // isValidColumn = true; } catch { response = "Failed"; return(response); } //check staff sheet object data = null; if (isValidStaffColumn == true && isValidGuestColumn == true && isValidProductColumn == true) { do { data = StaffworkSheet.Cells[startRow, startColumn].Value; //column Number if (data == null) { continue; } //read column class name object Name = StaffworkSheet.Cells[startRow, startColumn].Value; object Email = StaffworkSheet.Cells[startRow, startColumn + 1].Value; object Occupation = StaffworkSheet.Cells[startRow, startColumn + 2].Value; StaffModel _staff = new StaffModel(); _staff.NAME = Name.ToString(); _staff.EMAIL = Email.ToString(); _staff.Occupation = Occupation.ToString(); _staff.PASS = "******"; _staff.EventID = EventID; //edit to db StaffServiceClient ssv = new StaffServiceClient(); bool isCreated = ssv.createStaff(_staff); if (isCreated == true) { count++; } startRow++; } while (data != null); data = null; startColumn = 1; //where the file in the class excel start startRow = 2; do { data = GuestworkSheet.Cells[startRow, startColumn].Value; //column Number if (data == null) { continue; } object Name = GuestworkSheet.Cells[startRow, startColumn].Value; object Surname = GuestworkSheet.Cells[startRow, startColumn + 1].Value; object Email = GuestworkSheet.Cells[startRow, startColumn + 2].Value; GuestModel _guest = new GuestModel(); _guest.NAME = Name.ToString(); _guest.SURNAME = Surname.ToString(); _guest.EMAIL = Email.ToString(); _guest.PASS = "******"; _guest.TYPE = "Private"; Eventrix_Client.Registration reg = new Eventrix_Client.Registration(); // response = reg.RegisterGuest(_guest); if (response.Contains("successfully")) { count++; } startRow++; } while (data != null); //upload product details data = null; startColumn = 1; //where the file in the class excel start startRow = 2; do { data = ProductworkSheet.Cells[startRow, startColumn].Value; //column Number if (data == null) { continue; } object Name = ProductworkSheet.Cells[startRow, startColumn].Value; object Description = ProductworkSheet.Cells[startRow, startColumn + 1].Value; object Quantity = ProductworkSheet.Cells[startRow, startColumn + 2].Value; object Price = ProductworkSheet.Cells[startRow, startColumn + 3].Value; EventProduct _product = new EventProduct(); _product._Name = Name.ToString(); _product._Desc = Description.ToString(); _product._Quantity = Convert.ToInt32(Quantity.ToString()); _product._Price = Convert.ToInt32(Price.ToString()); _product.EventID = EventID; ProductServiceClient psv = new ProductServiceClient(); // string isProductUpdated = psv.createProduct(_product); string isProductUpdated = psv.createProduct(_product); if (isProductUpdated.Contains("success")) { count++; } startRow++; } while (data != null); //check record if (count == (GuestworkSheet.Dimension.Rows - 1) + (StaffworkSheet.Dimension.Rows - 1) + (ProductworkSheet.Dimension.Rows - 1)) { response = "success: All Records uploaded"; } else { response = "success: Not All Records uploaded"; } } else { response += " Failed to upload Exceel: Check columns"; } } else { response = "Failed: File not found"; } //Directory.Delete(path, true); return(response); }
protected void btnLogin_Click1(object sender, EventArgs e) { string RSVPEventID = Request.QueryString["e_ID"]; UserLogin LoginClient = new UserLogin(); GuestModel guest = new GuestModel(); EventHostModel host = new EventHostModel(); StaffModel staff = new StaffModel(); string pass = txtLogPass.Text; string email = txtUserName.Text; host = LoginClient.hostLogin(email, pass); if (host == null) //if user is not a host then check guest and host { guest = LoginClient.Guestlogin(email, pass); if (guest == null) //user is not a host nor a guest { staff = LoginClient.staffLogin(email, pass); if (staff == null) //the user is neither staff, guest nor host { // Response.Redirect("Login.aspx"); Popup(false, "Login.aspx"); } else //the user is a staff { SetSessions(staff); int LogID = Convert.ToInt32(Session["ID"]); string homeIndex = "Index.aspx?LoggedID=" + LogID + "&Type=All"; Popup(true, homeIndex); // Response.Redirect(homeIndex); } } else //the user is a guest { string survey = Request.QueryString["purp"]; if (survey != null && RSVPEventID != null) { SetSessions(guest); string strURL = "EventSurvey.aspx?eventID=" + RSVPEventID; // Response.Redirect("EventSurvey.aspx?eventID="+ RSVPEventID); GetProfilePicture(guest.ID.ToString()); //Get guest image or default picture Popup(true, strURL); } else if (RSVPEventID != null) { SetSessions(guest); GetProfilePicture(guest.ID.ToString()); //Get guest image or default picture string strURL = "EventRSVP.aspx?ev=" + RSVPEventID; // Response.Redirect("EventRSVP.aspx?EventID=" + RSVPEventID); Popup(true, strURL); } else { SetSessions(guest); int LogID = Convert.ToInt32(Session["ID"]); GetProfilePicture(LogID.ToString()); //Get guest image or default picture string homeIndex = "Index.aspx?LoggedID=" + LogID + "&Type=Guest"; Popup(true, homeIndex); } } } else //the user is a host { // txtLogName.Text = host.NAME; SetSessions(host); int LogID = Convert.ToInt32(Session["ID"]); string homeIndex = "Index.aspx?LoggedID=" + LogID + "&Type=Host"; Popup(true, homeIndex); } }
public async Task UpdateGuest(GuestModel guest) { await _guestRepository.Update( _mapper.Map <Guest>(guest)); }
public GuestViewModel() { Guest = new GuestModel(); Categories = new List <CategoryViewModel>(); }
public void Test_Validate_GuestModel(GuestModel guest) { var validationContext = new ValidationContext(guest); Assert.Empty(guest.Validate(validationContext)); }
public static void AddGuest(int year, GuestModel guest) { GuestRepository.AddGuest(year, guest); }
public static void EditGuest(int year, GuestModel guest) { GuestRepository.EditGuest(year, guest); }
public async Task <IActionResult> UpdateUserDetails([FromBody] GuestModel guest) { var resonse = await _guestReg.AddGuest(guest); return(Ok(resonse)); }
public async Task <int> AddGuestAsync(GuestModel guestModel, int tenantId) { CustomerModel = guestModel; return(123); }
protected void btnEdit_Click(object sender, EventArgs e) { GuestModel newGuest = new GuestModel(); if (txtNewPas.Text.Equals("") && txtConfirmPas.Text.Equals("") && txtOldpassword.Text.Equals("")) { //newGuest.NAME = txtName.Text; //newGuest.SURNAME = txtLastname.Text; //newGuest.EMAIL = txtEmail.Text; //newGuest.PASS = guestClient.getGuestByGuestID(guestId).PASS; //newGuest.USERTYPE = txtUserType.Text; //guestClient.updateGuest(guestId, newGuest); proxy = new WebClient(); guestUrl = string.Format("http://localhost:53056/GuestEdit.svc/editGuest/{0},{1},{2},{3},{4},{5},{6}", guestId, txtName.Text, txtLastname.Text, txtEmail.Text, pasword, pasword, pasword); byte[] _data = proxy.DownloadData(guestUrl); Stream memory = new MemoryStream(_data); var reader = new StreamReader(memory); string result = reader.ReadToEnd().Replace("editGuest", "").Replace("Result", "").Replace(quote + "", "").Replace("{", "").Replace("}", "").Replace(":", ""); btnEdit.Visible = false; //Changing the profile picture if (profilePic.HasFile) { string response = updateProfilePic(profilePic); //Store attribute of the new profile pic in the WCF database if (response.Contains("Success")) { string filename = Path.GetFileName(profilePic.FileName); string serverLocation = "~/Events/" + guestId + "/" + SUBFOLDER + "/" + filename; string SaveLoc = Server.MapPath(serverLocation); //Get the full image directory location profilePic.SaveAs(SaveLoc); //Save the picture in the given directory img = guestClient.getImageById(guestId); if (img == null) { Session["DEFAULT_IMAGE"] = "ProfilePic.png"; } else { imgLocation = img.Location; Session["PROFILE_IMAGE"] = imgLocation.Substring(imgLocation.IndexOf('E')); } } else { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Profile picture failed to update.');", true); } } //Check if the edit is successful or not if (result.Contains("successfully")) { lblWarning.ForeColor = System.Drawing.Color.White; lblWarning.Text = result; lblWarning.Visible = true; Response.Redirect("EditGuest.aspx"); // Refresh the page to display the updated picture } } else { //Response.Write("<script>alert('Cant edit with null values');</script>"); lblWarning.Text = "Cannot edit with empty values"; lblWarning.Visible = true; } }
public static BookingModel SetFinalBooking(BookingModel booking, RoomModel room, GuestModel str) { BookingModel finalBooking = new BookingModel(); finalBooking.Id = booking.Id; finalBooking.StartDate = booking.StartDate; finalBooking.EndDate = booking.EndDate; finalBooking.RoomId = room.Id; finalBooking.GuestId = str.Id; return(finalBooking); }
public ActionResult AddGuest(GuestModel gmodel) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connBae"].ToString()); con.Open(); SqlCommand cmd = new SqlCommand("AddNewGuest", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@lname", gmodel.LastName); cmd.Parameters.AddWithValue("@fname", gmodel.FirstName); cmd.Parameters.AddWithValue("@email", gmodel.Email); cmd.Parameters.AddWithValue("@comment", gmodel.Comment); cmd.Parameters.AddWithValue("@guestfn_1", gmodel.Guest_1_Fname); cmd.Parameters.AddWithValue("@guestln_1", gmodel.Guest_1_Lname); cmd.Parameters.AddWithValue("@guestfn_2", gmodel.Guest_2_Fname); cmd.Parameters.AddWithValue("@guestln_2", gmodel.Guest_2_Lname); cmd.Parameters.AddWithValue("@guestfn_3", gmodel.Guest_3_Fname); cmd.Parameters.AddWithValue("@guestln_3", gmodel.Guest_3_Lname); cmd.Parameters.AddWithValue("@guestfn_4", gmodel.Guest_4_Fname); cmd.Parameters.AddWithValue("@guestln_4", gmodel.Guest_4_Lname); cmd.Parameters.AddWithValue("@guestfn_5", gmodel.Guest_5_Fname); cmd.Parameters.AddWithValue("@guestln_5", gmodel.Guest_5_Lname); cmd.Parameters.AddWithValue("@guestfn_6", gmodel.Guest_6_Fname); cmd.Parameters.AddWithValue("@guestln_6", gmodel.Guest_6_Lname); cmd.Parameters.AddWithValue("@guestfn_7", gmodel.Guest_7_Fname); cmd.Parameters.AddWithValue("@guestln_7", gmodel.Guest_7_Lname); cmd.Parameters.AddWithValue("@guestfn_8", gmodel.Guest_8_Fname); cmd.Parameters.AddWithValue("@guestln_8", gmodel.Guest_8_Lname); cmd.Parameters.AddWithValue("@guestfn_9", gmodel.Guest_9_Fname); cmd.Parameters.AddWithValue("@guestln_9", gmodel.Guest_9_Lname); cmd.Parameters.AddWithValue("@guestfn_10", gmodel.Guest_10_Fname); cmd.Parameters.AddWithValue("@guestln_10", gmodel.Guest_10_Lname); cmd.Parameters.AddWithValue("@attending", gmodel.Attending); //cmd.Parameters.AddWithValue("@lname", gmodel.LastName); //cmd.Parameters.AddWithValue("@fname", "test"); //cmd.Parameters.AddWithValue("@email", "*****@*****.**"); //cmd.Parameters.AddWithValue("@comment", "test"); //cmd.Parameters.AddWithValue("@guestfn_1", "test"); //cmd.Parameters.AddWithValue("@guestln_1", "test"); //cmd.Parameters.AddWithValue("@guestfn_2", "test"); //cmd.Parameters.AddWithValue("@guestln_2", "test"); //cmd.Parameters.AddWithValue("@guestfn_3", "test"); //cmd.Parameters.AddWithValue("@guestln_3", "test"); //cmd.Parameters.AddWithValue("@guestfn_4", "test"); //cmd.Parameters.AddWithValue("@guestln_4", "test"); //cmd.Parameters.AddWithValue("@guestfn_5", "test"); //cmd.Parameters.AddWithValue("@guestln_5", "test"); //cmd.Parameters.AddWithValue("@guestfn_6", "test"); //cmd.Parameters.AddWithValue("@guestln_6", "test"); //cmd.Parameters.AddWithValue("@guestfn_7", "test"); //cmd.Parameters.AddWithValue("@guestln_7", "test"); //cmd.Parameters.AddWithValue("@guestfn_8", "test"); //cmd.Parameters.AddWithValue("@guestln_8", "test"); //cmd.Parameters.AddWithValue("@guestfn_9", "test"); //cmd.Parameters.AddWithValue("@guestln_9", "test"); //cmd.Parameters.AddWithValue("@guestfn_10", "test"); //cmd.Parameters.AddWithValue("@guestln_10", "test"); //cmd.Parameters.AddWithValue("@attending", true); cmd.ExecuteNonQuery(); con.Close(); return(View("_RSVP")); }