public async Task <ActionResult <TblEvent> > PostTblEvent([FromBody] TblEvent tblEvent) { _context.TblEvent.Add(tblEvent); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTblEvent", new { id = tblEvent.Id }, tblEvent)); }
public async Task <IActionResult> PutTblEvent(int id, [FromBody] TblEvent tblEvent) { if (id != tblEvent.Id) { return(BadRequest()); } _context.Entry(tblEvent).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblEventExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public ActionResult DeleteConfirmed(int id) { TblEvent tblEvent = db.TblEvents.Find(id); db.TblEvents.Remove(tblEvent); db.SaveChanges(); return(RedirectToAction("Index")); }
protected void btnDelete_Click(object sender, EventArgs e) { try { LinkButton EventID = (LinkButton)sender; TblEvent.Delete(EventID.CommandArgument); lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, "Event detail has been deleted!", "alert alert-danger alert-icon alert-dismissible", icon, "icon mdi mdi-check"); BindEvents(); } catch { } }
public ActionResult Edit([Bind(Include = "EventId,SchoolId,Event,EventDate,EventTime,EventPlace")] TblEvent tblEvent) { if (ModelState.IsValid) { db.Entry(tblEvent).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SchoolId = new SelectList(db.TblSchools.Where(a => a.SchoolId == tblEvent.SchoolId), "SchoolId", "SchoolCode", tblEvent.SchoolId); return(View(tblEvent)); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TblEvent tblEvent = db.TblEvents.Find(id); if (tblEvent == null) { return(HttpNotFound()); } return(View(tblEvent)); }
public int CreateEvent(DateTime dateTime) { using (DB_YoungEnterpriseContext databaseContext = GetConnection()) { DeleteAllExceptQuestions(databaseContext); TblEvent tblEvent = new TblEvent() { FldEventDate = dateTime }; databaseContext.TblEvent.Add(tblEvent); databaseContext.SaveChanges(); return(tblEvent.FldEventId); } }
public static void AddEvent(string Title, string imgURL, string Discription, string Datepicker, int PostedBy) { DataContext db = new DataContext(); TblEvent tbl = new TblEvent(); tbl.Title = Title; tbl.IsDeleted = false; tbl.imageURL = imgURL; tbl.UserId = PostedBy; tbl.Discription = Discription; tbl.EventDate = Convert.ToDateTime(Datepicker); db.TblEvents.InsertOnSubmit(tbl); db.SubmitChanges(); db.Dispose(); }
public static void UpdateEvent(int EventId, string title, string discription, string imgURL, string Eventdate, int postedby) { DataContext db = new DataContext(); TblTask tbl = new TblTask(); TblEvent result = (from t in db.TblEvents where t.Id == EventId select t).SingleOrDefault(); result.Title = title; result.Discription = discription; result.imageURL = imgURL; result.EventDate = Convert.ToDateTime(Eventdate); result.UpdatedBy = postedby; db.SubmitChanges(); db.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { cmptodayDate.ValueToCompare = DateTime.Now.ToShortDateString(); if (Session["EventID"] != null) { TblEvent obj = new TblEvent(Session["EventID"]); txtHeading.Text = obj.EventHeading; txtDetail.Text = obj.EventDetail; txtFromTime.SelectedDate = Convert.ToDateTime(obj.FromTime); txtTimeTo.SelectedDate = Convert.ToDateTime(obj.ToTime); txtVenue.Text = obj.Venue; txtEventDate.SelectedDate = obj.EventDate; } } }
public static int ReturnLastEventId() { DataContext db = new DataContext(); TblEvent obj = new TblEvent(); var result = (from e in db.TblEvents orderby e.Id descending select e).FirstOrDefault(); obj = result; if (result != null) { return(obj.Id); } else { return(0); } }
public static void DeleteEvent(int Id) { try { DataContext db = new DataContext(); TblEvent result = (from e in db.TblEvents where e.Id == Id select e).Single(); result.IsDeleted = true; db.SubmitChanges(); db.Dispose(); //DataContext db = new DataContext(); //db.TblEvents.DeleteOnSubmit(db.TblEvents.Single(e => e.Id == Id)); //db.SubmitChanges(); //db.Dispose(); } catch (Exception e) { } }
private List <TblEvent> GetUsefulEventData(List <Event> events) { var result = new List <TblEvent>(); foreach (var item in events) { var evt = new TblEvent { IdFromEventbrite = item.id, Name = item.name.text, Description = item.description.text, OrganizationId = item.organizationId, Status = item.status, Venue = item.venue.name + " " + item.venue.address, Category = item.category?.name, TicketAvailable = !item.ticketAvailability.isSoldOut }; result.Add(evt); } return(result); }
protected void btnSave_Click(object sender, EventArgs e) { try { string msg = "Event detail has been added!"; TblEvent obj = new TblEvent(); obj.IsNew = true; if (Session["EventID"] != null) { obj.IsNew = false; obj = new TblEvent(Session["EventID"]); msg = "Event detail has been updated!"; } obj.EventHeading = txtHeading.Text; obj.EventDate = Convert.ToDateTime(String.Format("{0:yyyy/MM/dd}", txtEventDate.SelectedDate)); TimeZoneInfo timeZoneInfo; DateTime dateTime; timeZoneInfo = TimeZoneInfo.FindSystemTimeZoneById("Pakistan Standard Time"); dateTime = TimeZoneInfo.ConvertTime(DateTime.Now, timeZoneInfo); obj.PostedDate = dateTime; obj.FromTime = Convert.ToDateTime(txtFromTime.SelectedTime.ToString()); obj.ToTime = Convert.ToDateTime(txtTimeTo.SelectedTime.ToString()); obj.Venue = txtVenue.Text; obj.EventDetail = txtDetail.Text; obj.IsActive = true; obj.Save(); lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, msg, "alert alert-success alert-icon alert-dismissible", icon, "icon mdi mdi-check"); helper.ClearInputs(Page.Controls); Session["EventID"] = null; } catch (Exception ex) { lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, ex.ToString(), "alert alert-danger alert-icon alert-dismissible", icon, "icon mdi mdi-close-circle-o"); } }
public ActionResult Edit(int?id) { Uri currentUrl = Request.UrlReferrer; if (currentUrl == null) { return(HttpNotFound()); } HttpCookie usesrCookie = Request.Cookies["UserInformation"]; if (usesrCookie == null) { return(RedirectToAction("LoginHomeIndex", "PCMSLogin")); } int?school = Int32.Parse(pcmsLoginController.LoggedOnUserData(usesrCookie)[1]); //Get UserID int?userID = Int32.Parse(pcmsLoginController.LoggedOnUserData(usesrCookie)[3]); if (db.TblUsers.Find(userID) != null) { ViewBag.UserName = db.TblUsers.Find(userID).UserName; } else if (db.TblSystemAdmins.Find(userID) != null) { ViewBag.UserName = "******"; } else { ViewBag.UserName = ""; } bool check = false; int userId = Int32.Parse(pcmsLoginController.LoggedOnUserData(usesrCookie)[3]); if (userId == db.TblSystemAdmins.FirstOrDefault().UserId) { check = true; } ViewBag.PCMS = check; var School = db.TblSchools.Find(school); if (School != null) { ViewBag.SchoolCode = School.SchoolCode; ViewBag.SchoolName = School.SchoolName; } else { ViewBag.SchoolCode = null; ViewBag.SchoolName = null; } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TblEvent tblEvent = db.TblEvents.Find(id); if (tblEvent == null) { return(HttpNotFound()); } ViewBag.School = new SelectList(db.TblSchools.Where(a => a.SchoolId == school), "SchoolId", "SchoolCode", tblEvent.SchoolId); ViewBag.SchoolId = tblEvent.SchoolId; return(View(tblEvent)); }
public DbSet <TblTeam> AllTeams(TblEvent evt) { return(_context.TblTeam); }