public ActionResult SaveEvent(string naziv, string opis, string datum, string datumOdpretprodaja, string datumOdProdaja, int organizator, decimal postotakprovizije, int mjesto, int dvorana, int status, Boolean prikaznaWebu, int id, string image, string videoLink, int? galleryId)
{
LK_Event ev = AdriaTicketData.LK_Events.FirstOrDefault(x => x.EVE_Id == id);
if (ev == null)
ev = new LK_Event();
if(datum != "undefined")
ev.EVE_Datum = DateTime.ParseExact(datum, "dd.MM.yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
if (datumOdpretprodaja != "undefined")
ev.EVE_DatumOdPretprodaja = DateTime.ParseExact(datumOdpretprodaja, "dd.MM.yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
if (datumOdProdaja != "undefined")
ev.EVE_DatumOdProdaja = DateTime.ParseExact(datumOdProdaja, "dd.MM.yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
ev.EVE_DvoranaId = dvorana;
ev.EVE_FlagOnlineProdaja = true;
ev.EVE_MjestoId = mjesto;
ev.EVE_Naziv = naziv;
ev.EVE_Opis =HttpUtility.HtmlDecode(opis);
ev.EVE_ImageExist = true;
ev.EVE_ImagePath = image;
ev.EVE_ReklamaExist = false;
ev.EVE_Stanje = 'A';
ev.EVE_Timestamp = DateTime.Now;
ev.EVE_OrganizatorId = organizator;
ev.EVE_PostotakProvizije = postotakprovizije;
ev.EVE_PrikaziNaWebu = prikaznaWebu;
ev.EVE_StatusEventaId = status;
string msg = "";
if (id == 0)
{
msg = "insert";
AdriaTicketData.LK_Events.InsertOnSubmit(ev);
}
else
{
msg = "update";
}
AdriaTicketData.SubmitChanges();
if (id > 0 && videoLink != null)
{
BK_VideoGallery video = new BK_VideoGallery();
video.eventID = id;
video.videoLink = videoLink;
AdriaTicketData.BK_VideoGalleries.InsertOnSubmit(video);
}
else if(id > 0 && videoLink == null)
{
BK_VideoGallery video = AdriaTicketData.BK_VideoGalleries.FirstOrDefault(x => x.eventID == id);
AdriaTicketData.BK_VideoGalleries.DeleteOnSubmit(video);
}
else if(id == 0 && videoLink != null)
{
LK_Event temp = AdriaTicketData.LK_Events.FirstOrDefault(x=> x.EVE_Naziv == naziv);
BK_VideoGallery video = new BK_VideoGallery();
video.eventID = temp.EVE_Id;
video.videoLink = videoLink;
AdriaTicketData.BK_VideoGalleries.InsertOnSubmit(video);
}
if (id > 0 && galleryId != null)
{
var galery = AdriaTicketData.BK_REL_Event_ImageGalleries.FirstOrDefault(x => x.EventId == id);
if(galery != null)
{
galery.EventId = id;
galery.ImageGalleriesId = Convert.ToInt16(galleryId);
}else
{
galery = new BK_REL_Event_ImageGallery();
galery.EventId = id;
galery.ImageGalleriesId = Convert.ToInt16(galleryId);
AdriaTicketData.BK_REL_Event_ImageGalleries.InsertOnSubmit(galery);
}
}
else if (galleryId != null)
{
LK_Event temp = AdriaTicketData.LK_Events.FirstOrDefault(x => x.EVE_Naziv == naziv);
BK_REL_Event_ImageGallery galery = new BK_REL_Event_ImageGallery();
galery.EventId = temp.EVE_Id;
galery.ImageGalleriesId = Convert.ToInt16(galleryId);
AdriaTicketData.BK_REL_Event_ImageGalleries.InsertOnSubmit(galery);
}
AdriaTicketData.SubmitChanges();
return Json(msg, JsonRequestBehavior.AllowGet);
}
partial void DeleteBK_VideoGallery(BK_VideoGallery instance);
partial void InsertBK_VideoGallery(BK_VideoGallery instance);
partial void UpdateBK_VideoGallery(BK_VideoGallery instance);
private void detach_BK_VideoGalleries(BK_VideoGallery entity)
{
this.SendPropertyChanging();
entity.LK_Event = null;
}