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