public ActionResult DeleteConfirmed(int id)
{
EventsDetail eventsDetail = db.EventsDetails.Find(id);
db.EventsDetails.Remove(eventsDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "event_detailID,eventID,Name,Description,Age_InYears")] EventsDetail eventsDetail)
{
if (ModelState.IsValid)
{
db.Entry(eventsDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.eventID = new SelectList(db.Events, "eventID", "Name", eventsDetail.eventID);
return(View(eventsDetail));
}
// GET: EventsDetails/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventsDetail eventsDetail = db.EventsDetails.Find(id);
if (eventsDetail == null)
{
return(HttpNotFound());
}
return(View(eventsDetail));
}
// GET: EventsDetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventsDetail eventsDetail = db.EventsDetails.Find(id);
if (eventsDetail == null)
{
return(HttpNotFound());
}
ViewBag.eventID = new SelectList(db.Events, "eventID", "Name", eventsDetail.eventID);
return(View(eventsDetail));
}
public long Post(ref EventVm vm, string userId)
{
using (var db = new LMISEntities())
using (var transaction = db.Database.BeginTransaction())
{
try
{
var id = vm.EventId;
if (id > 0) //Update
{
var tr = db.Events
.Where(r => r.IsDeleted == null && r.EventId == id)
.ToList().Single();
tr.OrganizationContactID = vm.ContactId;
tr.StartDate = vm.StartDate.AsUtc();
tr.EndDate = vm.EndDate.AsUtc();
tr.EventTypeID = vm.Type;
tr.Price = vm.Price;
tr.EventContactTelephone = vm.ContactTelephone;
tr.EventContactWebsite = vm.ContactWebsite;
tr.UploadPath = vm.FilePath;
tr.IsInternal = vm.IsInternal;
tr.IsInformal = vm.IsInformal;
tr.IsApproved = (byte)vm.Approval;
tr.UpdateUserID = userId;
tr.UpdateDate = DateTime.UtcNow;
//Delete detail records
var dr = db.EventsDetails
.Where(r => r.EventId == id)
.ToList();
db.EventsDetails.RemoveRange(dr);
}
else //Insert
{
var tr = new Event
{
OrganizationContactID = vm.ContactId,
StartDate = vm.StartDate.AsUtc(),
EndDate = vm.EndDate.AsUtc(),
EventTypeID = vm.Type,
Price = vm.Price,
EventContactTelephone = vm.ContactTelephone,
EventContactWebsite = vm.ContactWebsite,
UploadPath = vm.FilePath,
IsInternal = vm.IsInternal,
IsInformal = vm.IsInformal,
IsApproved = (byte)vm.Approval,
PostUserID = userId,
PostDate = DateTime.UtcNow,
RejectReason = ""
};
db.Events.Add(tr);
db.SaveChanges();
vm.EventId = (long)tr.EventId;
}
//Insert detail records
var ds = Utils.MultilingualDataSet(
new Dictionary <string, GlobalString>
{
{ "c1", vm.Title },
{ "c2", vm.Address },
{ "c3", vm.ContactAddress }
});
foreach (var r in ds)
{
var dr = new EventsDetail()
{
EventId = vm.EventId,
LanguageID = r["c1"].L,
EventTitle = r["c1"].T,
EventAddress = r["c2"].T,
EventContactAddress = r["c3"].T
};
db.EventsDetails.Add(dr);
}
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
ExceptionDispatchInfo.Capture(ex).Throw();
}
}
return(vm.EventId);
}
