public List <Dogodek> GetDogodek() { List <Dogodek> dogodki = new List <Dogodek>(); int time; var zazeni = new MySqlCommand("SELECT * FROM dogodki LIMIT 5", con);//Limit je nastavljen na 5 con.Open(); zazeni.ExecuteNonQuery(); MySqlDataReader beripodatke = zazeni.ExecuteReader(); while (beripodatke.Read()) { Dogodek dogodek = new Dogodek(); dogodek.id = Convert.ToInt32(beripodatke["id"]); dogodek.naziv = beripodatke["naziv"].ToString(); if (int.TryParse(beripodatke["cas"].ToString(), out time)) { dogodek.cas = time; } dogodki.Add(dogodek); } beripodatke.Close(); return(dogodki); }//pridobitev vseh dogodtkov
public int SaveEvent(EventFullModel model, bool updateRecord = true) { try { Dogodek newEvent = new Dogodek(); newEvent.idDogodek = model.idDogodek; newEvent.idStranka = model.idStranka; newEvent.idKategorija = model.idKategorija; //newEvent.Skrbnik = model.Skrbnik; newEvent.Skrbnik = context.OsebeNadrejeni.Where(od => od.idOseba == model.Izvajalec.Value).FirstOrDefault().idNadrejeni; newEvent.Izvajalec = model.Izvajalec; newEvent.idStatus = (model.idStatus == 0) ? 1 : model.idStatus; if (newEvent.idStatus > 0) { SaveLastEventStatusToStranka(newEvent.idStatus.Value, newEvent.idStranka.Value); } newEvent.Opis = model.Opis; newEvent.DatumOtvoritve = model.DatumOtvoritve; newEvent.Rok = model.Rok; newEvent.DatumZadZaprtja = model.DatumZadZaprtja; newEvent.Tip = model.Tip; newEvent.RokIzvedbe = model.RokIzvedbe; newEvent.Priloge = model.Priloge; newEvent.ts = model.ts.Equals(DateTime.MinValue) ? DateTime.Now : model.ts; newEvent.tsIDOsebe = (model.tsIDOsebe > 0) ? model.tsIDOsebe : (int?)null; if (newEvent.idDogodek == 0) { newEvent.ts = DateTime.Now; newEvent.tsIDOsebe = model.tsIDOsebe; context.Dogodek.Add(newEvent); context.SaveChanges(); } else { if (updateRecord) { Dogodek original = context.Dogodek.Where(d => d.idDogodek == newEvent.idDogodek).FirstOrDefault(); context.Entry(original).CurrentValues.SetValues(newEvent); context.SaveChanges(); } } return(newEvent.idDogodek); } catch (Exception ex) { throw new Exception(ValidationExceptionError.res_08, ex); } }
public Dogodek GetDogodekPoId(int id) { var zazeni = new MySqlCommand("SELECT * FROM dogodki where id=" + id, con); con.Open(); zazeni.ExecuteNonQuery(); MySqlDataReader beripodatke = zazeni.ExecuteReader(); Dogodek dogodek = new Dogodek(); while (beripodatke.Read()) { dogodek.id = Convert.ToInt32(beripodatke["id"]); dogodek.naziv = beripodatke["naziv"].ToString(); dogodek.cas = Convert.ToInt32(beripodatke["cas"]); } beripodatke.Close(); return(dogodek); }//pridobivanje id po ID
public void ProcessEventMessage(SystemMessageEvents message, Enums.SystemMessageEventCodes eventCode = Enums.SystemMessageEventCodes.EVENT_DOGODEK) { StreamReader reader = null; try { //DataTypesHelper.LogThis("*****IN Method ProcessEventMessage*****"); int employeeHierarchyLevel = GetEmployeeHierarchyLevel(eventCode); string emailSubject = SystemEmailMessageResource.res_03; string templatePath = (AppDomain.CurrentDomain.BaseDirectory + ConfigurationManager.AppSettings["NEW_EVENT_TEMPLATE"].ToString()).Replace("\"", "\\"); DataTypesHelper.LogThis(AppDomain.CurrentDomain.BaseDirectory); Dogodek dogodek = context.Dogodek.Where(dog => dog.idDogodek == message.MasterID).FirstOrDefault(); EventMessageTemplateModel modelForTemplate = new EventMessageTemplateModel(); if (EventPreparationOrReport(eventCode)) { templatePath = (AppDomain.CurrentDomain.BaseDirectory + ConfigurationManager.AppSettings["MEETING_WARNING_TEMPLATE"].ToString()).Replace("\"", "\\"); modelForTemplate.Tip = EventPreparation(eventCode) ? "Priprava" : "Poročilo"; modelForTemplate.Zamuda = DateTime.Now.Subtract(dogodek.DatumOtvoritve.Value).Days; modelForTemplate.Otvoritev = dogodek.DatumOtvoritve.Value; modelForTemplate.ServerTag = ConfigurationManager.AppSettings["ServerTag"].ToString(); emailSubject = SystemEmailMessageResource.res_04.Replace("%Tip%", modelForTemplate.Tip); } //DataTypesHelper.LogThis("*****Afer if statement of checking if event is about priprava or Poročilo***** EVENT ID: " + dogodek.idDogodek.ToString()); //DataTypesHelper.LogThis("*****TemplatePath: ********" + templatePath); reader = new StreamReader(templatePath); //DataTypesHelper.LogThis("***1***"); modelForTemplate.idDogodek = dogodek.idDogodek; //DataTypesHelper.LogThis("***2***"); modelForTemplate.ImeIzvajalec = dogodek.Osebe != null ? dogodek.Osebe.Ime : ""; //DataTypesHelper.LogThis("***3***"); modelForTemplate.PriimekIzvajalec = dogodek.Osebe != null ? dogodek.Osebe.Priimek : ""; //DataTypesHelper.LogThis("***4***"); modelForTemplate.ImeSkrbnik = dogodek.Osebe1 != null ? dogodek.Osebe1.Ime : ""; //DataTypesHelper.LogThis("***5***"); modelForTemplate.PriimekSkrbnik = dogodek.Osebe1 != null ? dogodek.Osebe1.Priimek : ""; //DataTypesHelper.LogThis("***6***"); modelForTemplate.Kategorija = dogodek.Kategorija != null ? dogodek.Kategorija.Naziv : ""; //DataTypesHelper.LogThis("***7***"); modelForTemplate.KategorijaKoda = dogodek.Kategorija != null ? dogodek.Kategorija.Koda : ""; //DataTypesHelper.LogThis("***8***"); modelForTemplate.NazivPrvi = dogodek.Stranka != null ? dogodek.Stranka.NazivPrvi : ""; //DataTypesHelper.LogThis("***9***"); modelForTemplate.Opis = dogodek.Opis; //DataTypesHelper.LogThis("***10***"); modelForTemplate.EmailTo = dogodek.Osebe != null ? dogodek.Osebe.Email : ""; //DataTypesHelper.LogThis("***11***"); modelForTemplate.Rok = dogodek.Rok.HasValue ? dogodek.Rok.Value : DateTime.MinValue; //DataTypesHelper.LogThis("***12***"); modelForTemplate.Status = dogodek.StatusDogodek != null ? dogodek.StatusDogodek.Naziv : ""; //DataTypesHelper.LogThis("***13***"); string templateString = reader.ReadToEnd(); //DataTypesHelper.LogThis("*****Before ReplaceDefaultValuesInTemplate*****"); templateString = ReplaceDefaultValuesInTemplate(modelForTemplate, templateString); //DataTypesHelper.LogThis("*****After ReplaceDefaultValuesInTemplate*****"); if (String.IsNullOrEmpty(modelForTemplate.Opis)) { templateString = templateString.Replace("$%Opis%$ ", ""); } //DataTypesHelper.LogThis("*****Before if statement Sporocila*****"); if (dogodek.Sporocila != null && eventCode.Equals(Enums.SystemMessageEventCodes.EVENT_DOGODEK)) { foreach (var item in dogodek.Sporocila) { int index = templateString.IndexOf("##INSERT_MESSAGE_HERE##"); templateString = templateString.Insert(index, item.OpisDel + "<br />"); } } //DataTypesHelper.LogThis("*****After if statement Sporocila*****"); templateString = templateString.Replace("##INSERT_MESSAGE_HERE##", ""); if (dogodek.Osebe != null) { SaveToSystemEmailMessage(dogodek.Osebe.Email, templateString, dogodek.Osebe.idOsebe, employeeHierarchyLevel, emailSubject); } //DataTypesHelper.LogThis("*****After SaveSystemEmailMessage*****"); //TODO: Update Avtomatika tabela //update status message.Status = (int)Enums.SystemMessageEventStatus.Processed; //DataTypesHelper.LogThis("*****Before UpdateSysteMessageEvents*****"); UpdateSystemMessageEvents(message); //DataTypesHelper.LogThis("*****After UpdateSysteMessageEvents*****"); } catch (Exception ex) { DataTypesHelper.LogThis("Error:" + ex.Message); throw new Exception(ex.Message); } finally { reader.Close(); } }