public UserModel UserLogIn(string userName, string password)
{
Osebe tmpUsers = context.Osebe.Where(u => u.UporabniskoIme.CompareTo(userName) == 0 && u.Geslo.CompareTo(password) == 0).FirstOrDefault();
UserModel model = null;
if (tmpUsers != null)
{
if (String.Compare(tmpUsers.UporabniskoIme, userName, false) != 0 && String.Compare(tmpUsers.Geslo, password) != 0)
{
return(null);
}
model = new UserModel();
model.ID = tmpUsers.idOsebe;
model.firstName = tmpUsers.Ime;
model.lastName = tmpUsers.Priimek;
model.email = tmpUsers.Email;
model.dateCreated = tmpUsers.ts.HasValue ? tmpUsers.ts.Value : DateTime.MinValue;
model.Job = tmpUsers.DelovnoMesto;
model.profileImage = tmpUsers.ProfileImage;
model.HasSupervisor = (tmpUsers.OsebeNadrejeni != null ? (tmpUsers.OsebeNadrejeni.Count > 0 ? true : false) : false);
if (tmpUsers.idVloga != null)
{
model.RoleID = tmpUsers.idVloga.Value;
model.Role = tmpUsers.Vloga.Koda;
model.RoleName = tmpUsers.Vloga.Naziv;
}
}
return(model);
}
public void ProcessAutoMessage(SystemMessageEvents message)
{
DataTypesHelper.LogThis("ProcessAutoMessage Method - 1 : BEFORE Open templatePath");
string templatePath = (AppDomain.CurrentDomain.BaseDirectory + ConfigurationManager.AppSettings["EMPLOYEE_MESSAGE_TEMPLATE"].ToString()).Replace("\"", "\\");
StreamReader reader = new StreamReader(templatePath);
DataTypesHelper.LogThis("ProcessAutoMessage Method - 2 : AFTER Open templatePath");
try
{
DataTypesHelper.LogThis("ProcessAutoMessage Method - 3 : BEFORE get avtomatikaList");
List <Avtomatika> avtomatikaList = context.Avtomatika.Where(a => a.OsebaID == message.MasterID && a.Status == (int)Enums.SystemMessageEventStatus.UnProcessed).ToList();
DataTypesHelper.LogThis("ProcessAutoMessage Method - 4 : After get avtomatikaList");
DataTypesHelper.LogThis("ProcessAutoMessage Method - 5 : BEFORE get Get Oseba by message.MasterID");
Osebe oseba = context.Osebe.Where(o => o.idOsebe == message.MasterID).FirstOrDefault();
//DataTypesHelper.LogThis("After getting avtomatika values from DB - " + avtomatikaList.Count.ToString());
DataTypesHelper.LogThis("BEFORE reading template string");
string templateString = reader.ReadToEnd();
DataTypesHelper.LogThis("AFTER reading template string.");
//DataTypesHelper.LogThis("Before if! AvtomatikaList count =" + avtomatikaList.Count.ToString() + " - Oseba :" + (oseba != null).ToString() + " - OsebaID: " + message.MasterID.ToString());
if (avtomatikaList.Count > 0 && oseba != null)
{
//DataTypesHelper.LogThis("*********Before ReplaceDefaultValuesInTemplate**********");
templateString = ReplaceDefaultValuesInTemplate(oseba, templateString);
DataTypesHelper.LogThis("BEFORE ConstructTemplate for clients.");
int index = templateString.IndexOf("##INSERT_CLIENTS_HERE##");
//DataTypesHelper.LogThis("*********Before ConstructTemplate**********");
templateString = templateString.Insert(index, ConstructTemplate(avtomatikaList, templateString));
DataTypesHelper.LogThis("AFTER ConstructTemplate for clients.");
templateString = templateString.Replace("##INSERT_CLIENTS_HERE##", "");
//DataTypesHelper.LogThis("*****After ConstructTemplate method IN ProcessAutoMessage***** - user email : " + avtomatikaList[0].Osebe.Email + "Stopnja nadrejenega : " + avtomatikaList[0].StopnjaNadrejenega.ToString());
DataTypesHelper.LogThis("BEFORE Saving item to SystemEmailMessage table.");
SaveToSystemEmailMessage(oseba.Email, templateString, message.tsIDOsebe, avtomatikaList[0].StopnjaNadrejenega, SystemEmailMessageResource.res_02);
DataTypesHelper.LogThis("AFTER Saving item to SystemEmailMessage table.");
}
int count = 0;
DataTypesHelper.LogThis("BEFORE update avtomatikaList.");
//update Avtomatika table status
foreach (var item in avtomatikaList)
{
//var original = context.Avtomatika.Where(av => av.AvtomatikaID == item.AvtomatikaID).FirstOrDefault();
// if (original != null)
// {
context.Entry(item).Entity.Status = (int)Enums.SystemMessageEventStatus.Processed;
count++;
DataTypesHelper.LogThis("Trenutni count : " + count);
// }
}
DataTypesHelper.LogThis("Avtomatika / Count :" + count.ToString() + "\r\n" + "AvtomatikaList count : " + avtomatikaList.Count.ToString());
context.SaveChanges();
DataTypesHelper.LogThis("BEFORE update UpdateSystemMessageEvents status.");
//update status
message.Status = (int)Enums.SystemMessageEventStatus.Processed;
UpdateSystemMessageEvents(message);
DataTypesHelper.LogThis("AFTER update UpdateSystemMessageEvents status.");
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
reader.Close();
}
}
public int SaveEmployee(EmployeeFullModel model, bool updateRecord = true)
{
try
{
Osebe record = new Osebe();
OsebeNadrejeni nadrejeni = new OsebeNadrejeni();
record.idOsebe = 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;
if (model.idVloga <= 0)
{
record.idVloga = null;
}
else
{
record.idVloga = model.idVloga;
}
if (record.idOsebe == 0)
{
record.ts = DateTime.Now;
record.tsIDOsebe = model.tsIDOsebe;
context.Osebe.Add(record);
context.SaveChanges();
}
else
{
if (updateRecord)
{
Osebe original = context.Osebe.Where(e => e.idOsebe == record.idOsebe).FirstOrDefault();
context.Entry(original).CurrentValues.SetValues(record);
context.SaveChanges();
}
}
if (model.NadrejeniID > 0)
{
var supervisorExistForEmployee = context.OsebeNadrejeni.Where(osn => osn.idOseba == record.idOsebe).FirstOrDefault();
nadrejeni.idOseba = record.idOsebe;
nadrejeni.idNadrejeni = model.NadrejeniID;
if (supervisorExistForEmployee != null)
{
OsebeNadrejeni originalNadrejeni = context.OsebeNadrejeni.Where(e => e.idOseba == record.idOsebe).FirstOrDefault();
nadrejeni.OsebeNadrejeniID = originalNadrejeni.OsebeNadrejeniID;
context.Entry(originalNadrejeni).CurrentValues.SetValues(nadrejeni);
}
else
{
nadrejeni.ts = DateTime.Now;
nadrejeni.tsIDosebe = model.tsIDOsebe;
context.OsebeNadrejeni.Add(nadrejeni);
}
context.SaveChanges();
}
return(record.idOsebe);
}
catch (Exception ex)
{
throw new Exception(ValidationExceptionError.res_08, ex);
}
}
