public static USERS getAndSetConfirmUser(string email, string code, out string mensaje)
{
goliazco_FWEntities entity = null;
USERS updateUser = null;
mensaje = "";
try
{
using (entity = new goliazco_FWEntities())
{
updateUser = (from t in entity.USERS where t.email == email && t.codeConfirm == code select t).FirstOrDefault();
if (updateUser != null)
{
updateUser.codeConfirm = "";
updateUser.estado = "Confirmed";
entity.SaveChanges();
}
else
{
mensaje = "User not found or link not longer available";
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return updateUser;
}
public static List<DAYS> getActiveDaysForReport()
{
List<DAYS> activeDays = null;
try
{
using (goliazco_FWEntities entity = new goliazco_FWEntities())
{
activeDays = (from t in entity.DAYS where t.state == "Active" select t).ToList();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return activeDays;
}
public static List<DAYS> getDays()
{
List<DAYS> daysAvailables = null;
try
{
using (goliazco_FWEntities entity = new goliazco_FWEntities())
{
daysAvailables = (from t in entity.DAYS select t).ToList();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return daysAvailables;
}
public static DAYS getDay(int day)
{
DAYS getDay = null;
goliazco_FWEntities entity = null;
try
{
entity = new goliazco_FWEntities();
//getDay = (from t in entity.DAYS where t.Day == day select t).FirstOrDefault();
getDay = (from t in entity.DAYS where t.idDay == day select t).FirstOrDefault();
getDay.DAYS_CONFIG = (from t in entity.DAYS_CONFIG where t.idDay == getDay.idDay select t).ToList();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return getDay;
}
/// <summary>
/// Allow to delete an attached exercise to a day
/// </summary>
/// <param name="idExercise">The specific Id of Exercise</param>
/// <returns>true or false that it was deleted</returns>
public static bool DeleteExercise(int idExercise)
{
bool resp = false;
try
{
using (goliazco_FWEntities entity = new goliazco_FWEntities())
{
DAYS_CONFIG exercise = (from t in entity.DAYS_CONFIG where t.idReportNum == idExercise select t).FirstOrDefault();
entity.DAYS_CONFIG.Remove(exercise);
entity.SaveChanges();
resp = true;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return resp;
}
public static bool ingresarError(string error)
{
bool resp = true;
try
{
using (goliazco_FWEntities entity = new goliazco_FWEntities())
{
LOG_ERROR logerror = new LOG_ERROR();
logerror.fecha = DateTime.Now;
logerror.error = error;
entity.LOG_ERROR.Add(logerror);
entity.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return resp;
}
public static bool DeleteUser(int idUser)
{
bool resp = false;
try
{
using (goliazco_FWEntities entity = new goliazco_FWEntities())
{
USERS userDeleted = (from t in entity.USERS where t.idUser == idUser select t).FirstOrDefault();
//if (userDeleted.DAYS_REPORT != null && userDeleted.DAYS_REPORT.Count > 0)
//{
// foreach (DAYS_REPORT diaReportado in userDeleted.DAYS_REPORT)
// {
// if (diaReportado != null)
// {
// if (diaReportado.REPORT_DAY != null && diaReportado.REPORT_DAY.Count > 0)
// {
// foreach (REPORT_DAY rep in diaReportado.REPORT_DAY)
// {
// entity.REPORT_DAY.Remove(rep);
// }
// }
// entity.DAYS_REPORT.Remove(diaReportado);
// }
// }
//}
if (userDeleted != null)
{
entity.USERS.Remove(userDeleted);
entity.SaveChanges();
resp = true;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return resp;
}
public static bool SaveChangesUser(int idUser, string name, string email, string country, string gender, string birthDate, string poseidonPB, string hadesPB, string venusPB)
{
bool resp = false;
try
{
using (goliazco_FWEntities entity = new goliazco_FWEntities())
{
USERS currentUser = (from t in entity.USERS where t.idUser == idUser select t).FirstOrDefault();
if (currentUser != null)
{
currentUser.name = name;
currentUser.email = email;
currentUser.nationality = country;
currentUser.gender = gender;
if (!string.IsNullOrEmpty(poseidonPB))
currentUser.poseidon_pb = poseidonPB;
if (!string.IsNullOrEmpty(hadesPB))
currentUser.hades_pb = hadesPB;
if (!string.IsNullOrEmpty(venusPB))
currentUser.venus_pb = venusPB;
string[] formats = { "dd/MM/yyyy" };
currentUser.birthDate = DateTime.ParseExact(birthDate, formats, new CultureInfo("en-US"), DateTimeStyles.None);
entity.SaveChanges();
resp = true;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return resp;
}
public static USERS registerUser(USERS user)
{
goliazco_FWEntities entity = null;
try
{
using (entity = new goliazco_FWEntities())
{
entity.USERS.Add(user);
entity.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return user;
}
public static USERS loginUser(string email, string pass)
{
USERS getLogedUser = null;
try
{
using (goliazco_FWEntities entity = new goliazco_FWEntities())
{
getLogedUser = (from t in entity.USERS where t.email == email && t.pass == pass select t).FirstOrDefault();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return getLogedUser;
}
public static List<USERS> getUsers()
{
List<USERS> usersList = null;
try
{
using (goliazco_FWEntities entity = new goliazco_FWEntities())
{
usersList = (from t in entity.USERS orderby t.name select t).ToList();
foreach (USERS user in usersList)
{
user.age = GetAge(user.birthDate);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return usersList;
}
public static DAYS_REPORT getReportedDayByUser(int idUser, int day)
{
DAYS_REPORT reportedDay = null;
goliazco_FWEntities entity = null;
try
{
entity = new goliazco_FWEntities();
entity.Configuration.LazyLoadingEnabled = true;
reportedDay = (from t in entity.DAYS_REPORT where t.idUser == idUser && t.day == day select t).FirstOrDefault();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return reportedDay;
}
public static bool saveNewDay(int day, string date, string state)
{
bool resp = false;
try
{
using (goliazco_FWEntities entity = new goliazco_FWEntities())
{
DAYS newDay = new DAYS();
string[] formats = { "dd/MM/yyyy" };
newDay.Day = day;
newDay.completeDay = DateTime.ParseExact(date, formats, new CultureInfo("en-US"), DateTimeStyles.None);
newDay.state = state;
entity.DAYS.Add(newDay);
entity.SaveChanges();
resp = true;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return resp;
}
public static bool SaveInform(int idUser, int day, int idRegister, int[] idReportedDays, string[] names, string[] dataTypes, string[] inform)
{
bool resp = false;
try
{
goliazco_FWEntities entity = new goliazco_FWEntities();
if (idRegister > 0)
{
DAYS_REPORT reportedDay = (from t in entity.DAYS_REPORT where t.idRegister == idRegister && t.idUser == idUser select t).FirstOrDefault();
reportedDay.date = DateTime.Now;
if (reportedDay != null)
{
int i;
for (i = 0; i < idReportedDays.Length; i++)
{
REPORT_DAY reporteDeDia = (from t in reportedDay.REPORT_DAY where t.idReportDay == idReportedDays[i] select t).FirstOrDefault();
reporteDeDia.Name = names[i];
reporteDeDia.DataInform = dataTypes[i];
reporteDeDia.Inform = inform[i];
}
if (names.Length > idReportedDays.Length)
{
for (int j = i; j < names.Length; j++)
{
REPORT_DAY newReport = new REPORT_DAY();
newReport.Name = names[j];
newReport.DataInform = dataTypes[j];
newReport.Inform = inform[j];
reportedDay.REPORT_DAY.Add(newReport);
}
}
}
entity.SaveChanges();
resp = true;
}
else
{
entity.Configuration.LazyLoadingEnabled = true;
entity.Configuration.ValidateOnSaveEnabled = true;
DAYS_REPORT newReportedDay = new DAYS_REPORT();
newReportedDay.USERS = (from t in entity.USERS where t.idUser == idUser select t).FirstOrDefault();
newReportedDay.day = day;
newReportedDay.date = DateTime.Now;
for (int i = 0; i < names.Length; i++)
{
//THis is a new report any day. only report 1 excercise
REPORT_DAY reportForDay = new REPORT_DAY();
reportForDay.Inform = inform[i];
reportForDay.Name = names[i];
reportForDay.DataInform = dataTypes[i];
newReportedDay.REPORT_DAY.Add(reportForDay);
}
entity.DAYS_REPORT.Add(newReportedDay);
entity.SaveChanges();
resp = true;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return resp;
}
public static bool SaveConfigForDay(int day, int idDay, string date, string state, int[] idDiasConfigurados, string[] names, string[] dataTypes, string[] descriptions)
{
bool resp = false;
try
{
goliazco_FWEntities entity = new goliazco_FWEntities();
if (idDay > 0)
{
DAYS dayConfig = (from t in entity.DAYS where t.idDay == idDay select t).FirstOrDefault();
if (dayConfig != null)
{
string[] formats = { "dd/MM/yyyy" };
dayConfig.completeDay = DateTime.ParseExact(date, formats, new CultureInfo("en-US"), DateTimeStyles.None);
dayConfig.state = state;
int i = 0;
if (dayConfig.DAYS_CONFIG != null && dayConfig.DAYS_CONFIG.Count > 0)
{
for (i = 0; i < idDiasConfigurados.Length; i++)
{
DAYS_CONFIG diaYaConfigurado = (from t in dayConfig.DAYS_CONFIG where t.idReportNum == idDiasConfigurados[i] select t).FirstOrDefault();
diaYaConfigurado.name = names[i];
diaYaConfigurado.dataType = dataTypes[i];
diaYaConfigurado.description = descriptions[i];
}
}
if (names.Length > idDiasConfigurados.Length)
{
for (int j = i; j < names.Length; j++)
{
DAYS_CONFIG newConfigForDay = new DAYS_CONFIG();
newConfigForDay.name = names[j];
newConfigForDay.dataType = dataTypes[j];
newConfigForDay.description = descriptions[j];
dayConfig.DAYS_CONFIG.Add(newConfigForDay);
}
}
}
entity.SaveChanges();
resp = true;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return resp;
}
public static USERS updateUser(USERS user, string codeNew)
{
goliazco_FWEntities entity = null;
USERS updateUser = null;
try
{
using (entity = new goliazco_FWEntities())
{
updateUser = (from t in entity.USERS where t.idUser == user.idUser select t).FirstOrDefault();
updateUser.codeConfirm = codeNew;
entity.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return updateUser;
}
public static USERS validateUser(USERS user)
{
try
{
using (goliazco_FWEntities entity = new goliazco_FWEntities())
{
user = (from t in entity.USERS where t.idUser == user.idUser select t).FirstOrDefault();
user.estado = "Confirmed";
entity.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return user;
}
public static List<REPORT_DAY> getDiasReportados(int iddia)
{
try
{
using (goliazco_FWEntities entity = new goliazco_FWEntities())
{
return (from p in entity.REPORT_DAY where p.idRegister == iddia select p).ToList();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return null;
}
public static DAYS_REPORT getDiaReportado(int idUser, int day)
{
DAYS_REPORT dia = null;
try
{
using (goliazco_FWEntities entity = new goliazco_FWEntities())
{
dia = (from t in entity.DAYS_REPORT where t.idUser == idUser && t.day == day select t).FirstOrDefault();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return dia;
}
public static USERS getUser(int idUser)
{
USERS user = null;
try
{
using (goliazco_FWEntities entity = new goliazco_FWEntities())
{
user = (from t in entity.USERS where t.idUser == idUser select t).FirstOrDefault();
}
}
catch (Exception ex)
{
}
return user;
}