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