public ActionResult DeleteConfirmed(int id) { SerioveCislo serioveCislo = db.SerioveCislo.Find(id); try { db.SerioveCislo.Remove(serioveCislo); db.SaveChanges(); } catch (Exception ex) { log.Error("Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } return(RedirectToAction("Index")); }
public static SerioveCislo GetSerioveCisloById(int SC) { SerioveCislo serioveCislo = new SerioveCislo(); using (var dbCtx = new Model1Container()) { serioveCislo = dbCtx.SerioveCislo.Where(r => r.Id == SC).Include(t => t.Artikl).FirstOrDefault(); //serioveCislo.Artikl = dbCtx.Artikl.Where(r => r.Id == serioveCislo.ArtiklId).FirstOrDefault(); } return(serioveCislo); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SerioveCislo serioveCislo = db.SerioveCislo.Find(id); if (serioveCislo == null) { return(HttpNotFound()); } return(View(serioveCislo)); }
public ActionResult Create([Bind(Include = "Id,ArtiklId,DatumVyroby,DatumPosledniTlakoveZkousky,SerioveCislo1")] SerioveCislo serioveCislo) { if (ModelState.IsValid) { try { db.SerioveCislo.Add(serioveCislo); db.SaveChanges(); } catch (Exception ex) { log.Error("Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } return(RedirectToAction("Index")); } ViewBag.ArtiklId = new SelectList(db.Artikl, "Id", "Nazev", serioveCislo.ArtiklId); return(View(serioveCislo)); }
public ActionResult Edit(int?id, int umisteni, int provoz, int zakaznik) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SerioveCislo serioveCislo = db.SerioveCislo.Find(id); if (serioveCislo == null) { return(HttpNotFound()); } serioveCislo.provoz = provoz; serioveCislo.umisteni = umisteni; serioveCislo.zakaznik = zakaznik; ViewBag.ArtiklId = new SelectList(db.Artikl.Where(r => r.SkupinaArtiklu1.Id != 129), "Id", "Nazev", serioveCislo.ArtiklId); return(View(serioveCislo)); }
public static int AddSeriovecislo(SCImport scimport) { int id = 0; SerioveCislo seriovecislo = new SerioveCislo(); seriovecislo.ArtiklId = scimport.ArtiklId; seriovecislo.DatumPosledniTlakoveZkousky = scimport.DatumTlkZk; seriovecislo.DatumVyroby = scimport.DatumVyroby; seriovecislo.SerioveCislo1 = scimport.SerioveCislo; using (var dbCtx = new Model1Container()) { try { dbCtx.SerioveCislo.Add(seriovecislo); dbCtx.SaveChanges(); } catch (Exception ex) { log.Error("Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } id = seriovecislo.Id; } return(id); }
public ActionResult Edit([Bind(Include = "Id,ArtiklId,DatumVyroby,DatumPosledniTlakoveZkousky,SerioveCislo1")] SerioveCislo serioveCislo, int provoz, int umisteni, int zakaznik, string objekt, int?objektid) { if (ModelState.IsValid) { try { db.Entry(serioveCislo).State = EntityState.Modified; db.SaveChanges(); } catch (Exception ex) { log.Error("Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } if (objekt != null) { return(RedirectToAction("Details", objekt, new { id = objektid })); } else { return(RedirectToAction("Details", "Umistenis", new { id = umisteni, provoz, zakaznik })); } } ViewBag.ArtiklId = new SelectList(db.Artikl.Where(r => r.SkupinaArtiklu1.Id != 129), "Id", "Nazev", serioveCislo.ArtiklId); return(RedirectToAction("Details", "Umistenis", new { id = umisteni, provoz, zakaznik })); }
public static void VymenaLahve(int RevizeSCid, int AriclId, string SC, DateTime DatumVyroby, DateTime DatumDodani) { RevizeSC oldRevizeSC = new RevizeSC(); Revize revize = new Revize(); Provoz provoz = new Provoz(); RevizeSC newRevizeSC = new RevizeSC(); SCProvozu oldSCProvozu = new SCProvozu(); SCProvozu newSCProvozu = new SCProvozu(); SerioveCislo oldSerioveCislo = new SerioveCislo(); SerioveCislo newSerioveCislo = new SerioveCislo(); VymenyLahvi vymenyLahvi = new VymenyLahvi(); oldRevizeSC = RevizeSC.GetRevizeSCByRevizeSCid(RevizeSCid); oldSCProvozu = SCProvozu.GetSCProvozuById(oldRevizeSC.SCProvozuId); oldSerioveCislo = SerioveCislo.GetSerioveCisloById(oldSCProvozu.SerioveCisloId); revize = Revize.GetById(oldRevizeSC.RevizeId); provoz = Provoz.GetById(revize.ProvozId); SCImport sCImport = new SCImport(); sCImport.ArtiklId = oldSerioveCislo.ArtiklId; sCImport.ArtiklSAPKod = oldSerioveCislo.Artikl.KodSAP; sCImport.Baterie = oldSCProvozu.Baterie; sCImport.BaterieArtikl = oldSCProvozu.BaterieArtikl; sCImport.DatumBaterie = oldSCProvozu.DatumBaterie; sCImport.DatumDodani = DatumDodani; sCImport.DatumPosledniZmeny = revize.DatumRevize; sCImport.DatumPrirazeni = revize.DatumRevize; sCImport.DatumPyro = oldSCProvozu.DatumPyro; sCImport.DatumRevize = oldSCProvozu.DatumRevize; sCImport.DatumTlkZk = revize.DatumRevize; sCImport.DatumVymeny = null; sCImport.DatumVyroby = revize.DatumRevize; sCImport.Lokace = oldSCProvozu.Lokace; sCImport.Proverit = false; sCImport.Provozy = oldSCProvozu.ProvozId; sCImport.SerioveCislo = SC; sCImport.Submitted = true; sCImport.Umisteni = oldSCProvozu.Umisteni.Value; sCImport.Zakaznik = provoz.ZakaznikId; sCImport.ZakaznikSAPKod = provoz.Zakaznik.KodSAP; sCImport.Znaceni = oldSCProvozu.Znaceni; // vytvoreni Serioveho cisla akcniho prvku var id = SerioveCislo.AddSeriovecislo(sCImport); newSerioveCislo = SerioveCislo.GetSerioveCisloById(id); // vyvoreni noveho provozusc var idscprovozu = SCProvozu.AddSCProvozu(sCImport, id); newSCProvozu = SCProvozu.GetSCProvozuById(idscprovozu); //Dohledani serioveho cisla lahve var seriovecislolahve = DohledaniSeriovehoCislaLahveDleSeriovehoCislaAkcnihoprvku(newSerioveCislo.SerioveCislo1, newSerioveCislo.Artikl.KodSAP); // vytvoření vazby vymeny mezi jednotlivými SCProvozu vymenyLahvi = VymenyLahvi.GenerujVymenu(oldSCProvozu, newSCProvozu, revize.DatumRevize, revize.Id, seriovecislolahve); // zneaktivneni stareho provozusc SCProvozu.ZneaktivniSCProvozu(oldSCProvozu, revize.DatumRevize); // odebrani stare revizesc RevizeSC.Remove(oldRevizeSC.Id); // vymena v nasledujicich otevrenych revizich stareho revizesc za noveho RevizeSC.ChangeRevizeSCForUpcomingOpenRevision(oldSCProvozu, newSCProvozu, revize.DatumRevize); }
public static List <SIL_dobaprovozu> Calc_SIL_DobaProvozu(int Rok, SIL_dobaprovozu PrumerDobyProvozu) { List <SIL_dobaprovozu> list = new List <SIL_dobaprovozu>(); string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; StringBuilder sql = new StringBuilder(); sql.Append($" declare @rok as int = {Rok} "); sql.Append($" declare @prumerTAKU float = '{PrumerDobyProvozu.TAKU.ToString().Replace(",", ".")}'"); sql.Append($" declare @prumerTAKUII float = '{PrumerDobyProvozu.TAKUII.ToString().Replace(",", ".")}'"); sql.Append(" select *, " + "case when (((x.II - X.I) * 1.0 / x.PocetdnimeziIaIIrevizi) * 1.0 IS NULL) then @prumerTAKU else CAST(((x.II - X.I) * 1.0 / x.PocetdnimeziIaIIrevizi) * 1.0 as float) end as 'TAKU'," + " case when (((x.II - X.I) * 1.0 / x.PocetdnimeziIaIIrevizi * 1.0) * 365.25 IS null) then @prumerTAKUII else CAST(((x.II - X.I) * 1.0 / x.PocetdnimeziIaIIrevizi * 1.0) * 365.25 as float) end as 'TAKUII' " + " from( select t0.NazevZakaznika," + "t0.Id as 'ZakaznikId', " + "t1.NazevProvozu,t1.Id as 'ProvozId', " + "t2.NazevUmisteni,t2.Id as 'UmisteniId', " + "t5.Nazev as 'Artikl'," + "t5.Id as 'ArtiklId', " + "t4.SerioveCislo, " + "t4.Id as 'SerioveCisloId'," + "t3.Id as 'SCProvozuId', " + "(SELECT HodinyProvozu FROM( SELECT ROW_NUMBER() OVER(ORDER BY coalesce(t0.KontrolaProvedenaDne, t0.Datumrevize) desc) AS rownumber, t1.HodinyProvozu from Revize t0 left join RevizeSC t1 on t0.Id = t1.RevizeId where Rok <= @rok and t1.SCProvozuId = t3.id) as foo WHERE rownumber = 2) as 'I',"); sql.Append("(SELECT KontrolaProvedenaDne FROM( SELECT ROW_NUMBER() OVER(ORDER BY coalesce(t0.KontrolaProvedenaDne, t0.Datumrevize) desc) AS rownumber, t0.KontrolaProvedenaDne from Revize t0 left join RevizeSC t1 on t0.Id = t1.RevizeId where Rok <= @rok and t1.SCProvozuId = t3.id) as foo WHERE rownumber = 2 ) as 'DatumI', "); sql.Append(" (SELECT HodinyProvozu FROM( SELECT ROW_NUMBER() OVER (ORDER BY coalesce(t0.KontrolaProvedenaDne, t0.Datumrevize) desc) AS rownumber, t1.HodinyProvozu from Revize t0 left join RevizeSC t1 on t0.Id = t1.RevizeId where Rok <= @rok and t1.SCProvozuId = t3.id) as foo WHERE rownumber = 1) as 'II',"); sql.Append(" (SELECT KontrolaProvedenaDne FROM( SELECT ROW_NUMBER() OVER(ORDER BY coalesce(t0.KontrolaProvedenaDne, t0.Datumrevize) desc) AS rownumber, t0.KontrolaProvedenaDne from Revize t0 left join RevizeSC t1 on t0.Id = t1.RevizeId where Rok <= @rok and t1.SCProvozuId = t3.id) as foo WHERE rownumber = 1 ) as 'DatumII',"); sql.Append(" CAST(DateDiff(D, ((SELECT KontrolaProvedenaDne FROM( SELECT ROW_NUMBER() OVER(ORDER BY coalesce(t0.KontrolaProvedenaDne, t0.Datumrevize) desc) AS rownumber, t0.KontrolaProvedenaDne from Revize t0 left join RevizeSC t1 on t0.Id = t1.RevizeId where Rok <= @rok and t1.SCProvozuId = t3.id) as foo WHERE rownumber = 2)),"); sql.Append(" (SELECT KontrolaProvedenaDne FROM( SELECT ROW_NUMBER() OVER (ORDER BY coalesce(t0.KontrolaProvedenaDne, t0.Datumrevize) desc) AS rownumber, t0.KontrolaProvedenaDne from Revize t0 left join RevizeSC t1 on t0.Id = t1.RevizeId where Rok <= @rok and t1.SCProvozuId = t3.id) as foo WHERE rownumber = 1)) as decimal) as 'PocetdnimeziIaIIrevizi',"); sql.Append(" (select COUNT(*) from Revize t0 left join RevizeSC t1 on t0.Id = t1.RevizeId where Rok = @rok and t1.SCProvozuId = t3.id) as 'count' from Zakaznik t0 left join Provoz t1 on t1.ZakaznikId = t0.Id left join Umisteni t2 on t2.ProvozId = t1.Id "); sql.Append(" left join SCProvozu t3 on t3.Umisteni = t2.Id left join SerioveCislo t4 on t4.Id = t3.SerioveCisloId left join Artikl t5 on t5.Id = t4.ArtiklId left join SkupinaArtiklu t6 on t6.Id = t5.SkupinaArtiklu"); sql.Append(" where t6.Id = 130 and (select COUNT(*) from Revize t0 left join RevizeSC t1 on t0.Id = t1.RevizeId where Rok = @rok and t1.SCProvozuId = t3.id) > 0 and t3.StatusId = 1 ) X"); //log.Debug($"Nacteni dat pri importu artiklu z SAP {sql.ToString()}"); SqlConnection cnn = new SqlConnection(connectionString); //SqlConnection con = new SqlConnection(cnn); SqlCommand cmd = new SqlCommand { Connection = cnn, CommandText = sql.ToString() }; cnn.Open(); cmd.ExecuteNonQuery(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { //MAKES IT HERE while (dr.Read()) { SIL_dobaprovozu sil = new SIL_dobaprovozu(); try { sil.ZakaznikId = dr.GetInt32(dr.GetOrdinal("ZakaznikId")); } catch (Exception ex) { log.Debug("Error number: ZakaznikId " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sil.ProvozId = dr.GetInt32(dr.GetOrdinal("ProvozId")); } catch (Exception ex) { log.Debug("Error number: ProvozId" + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sil.UmisteniId = dr.GetInt32(dr.GetOrdinal("UmisteniId")); } catch (Exception ex) { log.Debug("Error number: UmisteniId" + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sil.SCProvozuId = dr.GetInt32(dr.GetOrdinal("SCProvozuId")); } catch (Exception ex) { log.Debug("Error number: SCProvozuId" + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sil.SerioveCisloId = dr.GetInt32(dr.GetOrdinal("SerioveCisloId")); } catch (Exception ex) { log.Debug("Error number: SerioveCisloId" + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sil.ArtiklId = dr.GetInt32(dr.GetOrdinal("ArtiklId")); } catch (Exception ex) { log.Debug("Error number: ArtiklId" + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sil.DobaprovozuI = dr.GetInt64(dr.GetOrdinal("I")); } catch (Exception ex) { log.Debug("Error number: DobaprovozuI" + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sil.DobaprovozuII = dr.GetInt64(dr.GetOrdinal("II")); } catch (Exception ex) { log.Debug("Error number: DobaprovozuII" + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sil.DniMeziRevizemi = dr.GetDecimal(dr.GetOrdinal("PocetdnimeziIaIIrevizi")); } catch (Exception ex) { log.Debug("Error number: DniMeziRevizemi" + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sil.PocetReviziVRoce = dr.GetInt32(dr.GetOrdinal("count")); } catch (Exception ex) { log.Debug("Error number: PocetReviziVRoce" + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sil.TAKU = Convert.ToDecimal(dr.GetDouble(dr.GetOrdinal("TAKU"))); } catch (Exception ex) { log.Debug("Error number: TAKU" + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sil.TAKUII = Convert.ToDecimal(dr.GetDouble(dr.GetOrdinal("TAKUII"))); } catch (Exception ex) { log.Debug("Error number: TAKUII" + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sil.DatumI = (dr.GetDateTime(dr.GetOrdinal("DatumI"))); } catch (Exception ex) { log.Debug("Error number: TAKUII" + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { sil.DatumII = (dr.GetDateTime(dr.GetOrdinal("DatumII"))); } catch (Exception ex) { log.Debug("Error number: TAKUII" + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } sil.Zakaznik = Zakaznik.GetById(sil.ZakaznikId); sil.Provoz = Provoz.GetById(sil.ProvozId); sil.Umisteni = Umisteni.GetById(sil.UmisteniId); sil.SerioveCislo = SerioveCislo.GetSerioveCisloById(sil.SerioveCisloId); sil.SCProvozu = SCProvozu.GetSCProvozuById(sil.SCProvozuId); sil.Artikl = Artikl.GetArtiklById(sil.ArtiklId); list.Add(sil); } } cnn.Close(); return(list); }
public ActionResult ImportSCtoServis([Bind(Include = "Zakaznik, Provozy, Umisteni, SerioveCislo, ArtiklId, DatumVyroby, DatumVymeny, DatumDodani, Submitted, DatumRevize, DatumBaterie, DatumPyro, DatumTlkZk, DatumPrirazeni, Lokace, Znaceni,Baterie,Proverit, BaterieArtikl,UpravenaPeriodaRevize,UpravenaPeriodaBaterie,UpravenaPeriodaPyro,UpravenaPeriodaTlkZk,DatumRevizeTlakoveNadoby,DatumVnitrniRevizeTlakoveNadoby,UpravenaPeriodaRevizeTlakoveNadoby,UpravenaPeriodaVnitrniRevizeTlakoveNadoby ")] SCImport scimport) { int id = 0; int idscprovozu = 0; ViewBag.SkupinaArtiklu = db.Artikl.Where(t => t.Id == scimport.ArtiklId).Select(t => t.SkupinaArtiklu).FirstOrDefault(); ViewBag.Revize = db.Artikl.Where(t => t.Id == scimport.ArtiklId).Select(t => t.Revize).FirstOrDefault(); ViewBag.TlakovaZk = db.Artikl.Where(t => t.Id == scimport.ArtiklId).Select(t => t.TlakovaZk).FirstOrDefault(); ViewBag.VymenaBaterie = db.Artikl.Where(t => t.Id == scimport.ArtiklId).Select(t => t.VymenaBaterie).FirstOrDefault(); ViewBag.VymenaPyro = db.Artikl.Where(t => t.Id == scimport.ArtiklId).Select(t => t.VymenaPyro).FirstOrDefault(); ViewBag.TlakovaNadoba = db.Artikl.Where(t => t.Id == scimport.ArtiklId).Select(t => t.TlakovaNadoba).FirstOrDefault(); //if (scimport.DatumVyroby == DateTime.MinValue) { scimport.DatumVyroby = DateTime.Now; } //if (scimport.DatumDodani == DateTime.MinValue) { scimport.DatumDodani = DateTime.Now; } if (scimport.DatumPosledniZmeny == DateTime.MinValue) { scimport.DatumPosledniZmeny = DateTime.Now; } if (scimport.Submitted == true) { if (scimport.DatumPrirazeni == null) { scimport.DatumPrirazeni = scimport.DatumDodani; } //if (scimport.DatumTlkZk == null) { scimport.DatumTlkZk = scimport.DatumVyroby; } id = SerioveCislo.AddSeriovecislo(scimport); idscprovozu = SCProvozu.AddSCProvozu(scimport, id); // uložení datumů do sesion if (scimport.DatumBaterie > DateTime.MinValue || scimport.DatumBaterie == null) { Session["DatumBaterie"] = scimport.DatumBaterie; } if (scimport.DatumDodani > DateTime.MinValue || scimport.DatumDodani == null) { Session["DatumDodani"] = scimport.DatumDodani; } if (scimport.DatumPrirazeni > DateTime.MinValue || scimport.DatumPrirazeni == null) { Session["DatumPrirazeni"] = scimport.DatumPrirazeni; } if (scimport.DatumPyro > DateTime.MinValue || scimport.DatumPyro == null) { Session["DatumPyro"] = scimport.DatumPyro; } if (scimport.DatumRevize > DateTime.MinValue || scimport.DatumRevize == null) { Session["DatumRevize"] = scimport.DatumRevize; } if (scimport.DatumTlkZk > DateTime.MinValue || scimport.DatumTlkZk == null) { Session["DatumTlkZk"] = scimport.DatumTlkZk; } if (scimport.DatumVymeny > DateTime.MinValue || scimport.DatumVymeny == null) { Session["DatumVymeny"] = scimport.DatumVymeny; } if (scimport.DatumVyroby > DateTime.MinValue || scimport.DatumVyroby == null) { Session["DatumVyroby"] = scimport.DatumVyroby; } if (scimport.UpravenaPeriodaRevize != null) { Session["UpravenaPeriodaRevize"] = scimport.UpravenaPeriodaRevize; } if ((id > 0) || (idscprovozu > 0)) { return(RedirectToAction("Details", "Umistenis", new { id = scimport.Umisteni, Provoz = scimport.Provozy, scimport.Zakaznik })); } } if ((scimport.Submitted == false) || ((id == 0) || (idscprovozu == 0))) { // načtení datumů ze session try { var DatumBaterie = Convert.ToDateTime(Session["DatumBaterie"]); if (DatumBaterie > DateTime.MinValue) { scimport.DatumBaterie = DatumBaterie; } else { scimport.DatumBaterie = null; } } catch (Exception ex) { log.Debug("Details - Seassion Read - DatumBaterie - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { var DatumDodani = Convert.ToDateTime(Session["DatumDodani"]); if (DatumDodani > DateTime.MinValue) { scimport.DatumDodani = DatumDodani; } else { scimport.DatumDodani = DateTime.Now; } } catch (Exception ex) { log.Debug("Details - Seassion Read - DatumDodani - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { var DatumPrirazeni = Convert.ToDateTime(Session["DatumPrirazeni"]); if (DatumPrirazeni > DateTime.MinValue) { scimport.DatumPrirazeni = DatumPrirazeni; } else { scimport.DatumPrirazeni = DateTime.Now; } } catch (Exception ex) { log.Debug("Details - Seassion Read - DatumPrirazeni - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { var DatumPyro = Convert.ToDateTime(Session["DatumPyro"]); if (DatumPyro > DateTime.MinValue) { scimport.DatumPyro = DatumPyro; } else { scimport.DatumPyro = null; } } catch (Exception ex) { log.Debug("Details - Seassion Read - DatumPyro - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { var DatumRevize = Convert.ToDateTime(Session["DatumRevize"]); if (DatumRevize > DateTime.MinValue) { scimport.DatumRevize = DatumRevize; } else { scimport.DatumRevize = null; } } catch (Exception ex) { log.Debug("Details - Seassion Read - DatumRevize - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { var DatumTlkZk = Convert.ToDateTime(Session["DatumTlkZk"]); if (DatumTlkZk > DateTime.MinValue) { scimport.DatumTlkZk = DatumTlkZk; } else { scimport.DatumTlkZk = null; } } catch (Exception ex) { log.Debug("Details - Seassion Read - DatumTlkZk - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { var DatumVymeny = Convert.ToDateTime(Session["DatumVymeny"]); if (DatumVymeny > DateTime.MinValue) { scimport.DatumVymeny = DatumVymeny; } else { scimport.DatumVymeny = null; } } catch (Exception ex) { log.Debug("Details - Seassion Read - DatumVymeny - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { var DatumVyroby = Convert.ToDateTime(Session["DatumVyroby"]); if (DatumVyroby > DateTime.MinValue) { scimport.DatumVyroby = DatumVyroby; } else { scimport.DatumVyroby = DateTime.Now; } } catch (Exception ex) { log.Debug("Details - Seassion Read - DatumVyroby - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } try { int?UpravenaPeriodaRevize = Convert.ToInt32(Session["UpravenaPeriodaRevize"]); if (UpravenaPeriodaRevize != null && UpravenaPeriodaRevize != 0) { scimport.UpravenaPeriodaRevize = UpravenaPeriodaRevize; } else { scimport.UpravenaPeriodaRevize = null; } } catch (Exception ex) { log.Debug("Details - Seassion Read - DatumVyroby - Error number: " + ex.HResult + " - " + ex.Message + " - " + ex.Data + " - " + ex.InnerException); } ViewBag.Zakaznik = new SelectList(db.Zakaznik, "Id", "NazevZakaznika", scimport.Zakaznik); ViewBag.Provozy = new SelectList(db.Provoz.Where(p => p.ZakaznikId == scimport.Zakaznik), "Id", "NazevProvozu", scimport.Provozy); ViewBag.Umisteni = new SelectList(db.Umisteni.Where(u => u.ProvozId == scimport.Provozy), "Id", "NazevUmisteni", scimport.Umisteni); ViewBag.ArtiklId = new SelectList(db.Artikl.Where(r => r.SkupinaArtiklu1.Id != 129), "Id", "Nazev", scimport.ArtiklId); ViewBag.BaterieArtikl = new SelectList(db.Artikl.Where(r => r.SkupinaArtiklu1.Id == 2), "Id", "Nazev"); } return(View(scimport)); }