public void SaveEmail(SystemEmailMessage_PDO model)
{
if (model.SystemEmailMessageID != 0)
{
model.Status = (int)Enums.SystemEmailMessageStatus.Processed;
var original = context.SystemEmailMessage_PDO.Where(sem => sem.SystemEmailMessageID == model.SystemEmailMessageID).FirstOrDefault();
context.Entry(original).CurrentValues.SetValues(model);
context.SaveChanges();
}
}
public int SaveSettings(SettingsModel model, bool updateRecord = true)
{
try
{
Nastavitve n = new Nastavitve();
n.NastavitveID = model.NastavitveID;
n.Opombe = model.Opombe;
n.PovprasevanjeStevilcenjePredpona = model.PovprasevanjeStevilcenjePredpona;
n.PovprasevanjeStevilcenjeStev = model.PovprasevanjeStevilcenjeStev;
n.EmailSifriranjeSSL = model.EmailSifriranjeSSL;
n.EmailStreznik = model.EmailStreznik;
n.EmailVrata = model.EmailVrata > 0 ? model.EmailVrata : (int?)null;
n.tsUpdate = DateTime.Now;
n.tsUpdateUserID = model.tsUpdateUserID;
n.PosiljanjePoste = model.PosiljanjePoste;
n.ts = model.ts.Equals(DateTime.MinValue) ? (DateTime?)null : model.ts;
n.tsIDOsebe = model.tsIDOsebe;
if (n.NastavitveID == 0)
{
n.ts = DateTime.Now;
n.tsIDOsebe = n.tsIDOsebe;
context.Nastavitve.Add(n);
context.SaveChanges();
}
else
{
if (updateRecord)
{
Nastavitve original = context.Nastavitve.Where(nas => nas.NastavitveID == n.NastavitveID).FirstOrDefault();
context.Entry(original).CurrentValues.SetValues(n);
context.SaveChanges();
}
}
return(n.NastavitveID);
}
catch (Exception ex)
{
throw new Exception(ValidationExceptionError.res_08, ex);
}
}
public int SaveClient(ClientFullModel model, bool updateRecord = true)
{
try
{
Stranka_PDO client = new Stranka_PDO();
client.StrankaID = model.idStranka;
client.KodaStranke = model.KodaStranke;
client.NazivPrvi = model.NazivPrvi;
client.NazivDrugi = model.NazivDrugi;
client.Naslov = model.Naslov;
client.StevPoste = model.StevPoste;
client.NazivPoste = model.NazivPoste;
client.Email = model.Email;
client.Telefon = model.Telefon;
client.FAX = model.FAX;
client.InternetniNalov = model.InternetniNalov;
client.KontaktnaOseba = model.KontaktnaOseba;
client.RokPlacila = model.RokPlacila;
client.ts = model.ts.CompareTo(DateTime.MinValue) == 0 ? (DateTime?)null : model.ts;
client.tsIDOsebe = model.tsIDOsebe;
client.TipStrankaID = model.TipStrankaID;
client.JezikID = model.JezikID;
client.PrivzetaEM = model.PrivzetaEM;
client.ZadnjaIzbranaKategorija = model.ZadnjaIzbranaKategorija;
client.KontaktnaOseba_PDO = new List <KontaktnaOseba_PDO>();
client.StrankaZaposleni_PDO = new List <StrankaZaposleni_PDO>();
client.tsUpdate = DateTime.Now;
//client.tsUpdateUserID = model.tsIDOsebe;
if (client.StrankaID == 0)
{
client.ts = DateTime.Now;
client.tsIDOsebe = model.tsIDOsebe;
context.Stranka_PDO.Add(client);
context.SaveChanges();
}
else
{
if (updateRecord)
{
Stranka_PDO original = context.Stranka_PDO.Where(s => s.StrankaID == client.StrankaID).FirstOrDefault();
context.Entry(original).CurrentValues.SetValues(client);
context.SaveChanges();
}
}
if ((model.StrankaZaposleni != null) && (model.StrankaZaposleni.Count > 0))
{
model.StrankaZaposleni[0].idStranka = client.StrankaID;
if (model.StrankaZaposleni[0].idStrankaOsebe == 0)
{
SaveClientEmployee(model.StrankaZaposleni[0], false);
}
else
{
SaveClientEmployee(model.StrankaZaposleni[0]);
}
}
return(client.StrankaID);
}
catch (Exception ex)
{
throw new Exception(ValidationExceptionError.res_08, ex);
}
}
public int SaveEmployee(EmployeeFullModel model, bool updateRecord = true)
{
try
{
Osebe_PDO record = new Osebe_PDO();
OsebeNadrejeni_PDO nadrejeni = new OsebeNadrejeni_PDO();
record.OsebaID = model.idOsebe;
record.Naslov = model.Naslov;
record.Email = model.Email;
record.DelovnoMesto = model.DelovnoMesto;
record.DatumZaposlitve = model.DatumZaposlitve;
record.Ime = model.Ime;
record.Priimek = model.Priimek;
record.DatumRojstva = model.DatumRojstva;
record.UporabniskoIme = model.UporabniskoIme;
record.Geslo = model.Geslo;
record.TelefonGSM = model.TelefonGSM;
record.Zunanji = model.Zunanji;
record.ProfileImage = model.ProfileImage;
record.VlogaID = model.idVloga;
record.tsUpdate = DateTime.Now;
record.tsUpdateUserID = model.tsIDOsebe;
record.ts = model.ts.Equals(DateTime.MinValue) ? (DateTime?)null : model.ts;
record.tsIDOsebe = model.tsIDOsebe;
record.PDODostop = model.PDODostop;
record.EmailGeslo = model.EmailGeslo;
record.EmailSifriranjeSSL = model.EmailSifriranjeSSL;
record.EmailStreznik = model.EmailStreznik;
record.EmailVrata = model.EmailVrata > 0 ? model.EmailVrata : (int?)null;
record.Podpis = model.Podpis;
record.PantheonUsrID = model.PantheonUsrID;
if (record.OsebaID == 0)
{
record.ts = DateTime.Now;
record.tsIDOsebe = model.tsIDOsebe;
context.Osebe_PDO.Add(record);
context.SaveChanges();
}
else
{
if (updateRecord)
{
Osebe_PDO original = context.Osebe_PDO.Where(e => e.OsebaID == record.OsebaID).FirstOrDefault();
context.Entry(original).CurrentValues.SetValues(record);
context.SaveChanges();
}
}
if (model.NadrejeniID > 0)
{
var supervisorExistForEmployee = context.OsebeNadrejeni_PDO.Where(osn => osn.OsebaID == record.OsebaID).FirstOrDefault();
nadrejeni.OsebaID = record.OsebaID;
nadrejeni.NadrejeniID = model.NadrejeniID;
if (supervisorExistForEmployee != null)
{
OsebeNadrejeni_PDO originalNadrejeni = context.OsebeNadrejeni_PDO.Where(e => e.OsebaID == record.OsebaID).FirstOrDefault();
nadrejeni.OsebeNadrejeniID = originalNadrejeni.OsebeNadrejeniID;
context.Entry(originalNadrejeni).CurrentValues.SetValues(nadrejeni);
}
else
{
nadrejeni.ts = DateTime.Now;
nadrejeni.tsIDosebe = model.tsIDOsebe;
context.OsebeNadrejeni_PDO.Add(nadrejeni);
}
context.SaveChanges();
}
return(record.OsebaID);
}
catch (Exception ex)
{
throw new Exception(ValidationExceptionError.res_08, ex);
}
}
