public FacultyCRUDForm(RegistrationEntities RE)
{
InitializeComponent();
RegistrationEntities = RE;
errorLabel.Text = String.Empty;
updateListBox();
}
public void setId()
{
var db = new RegistrationEntities();
int[] data = (from s in db.Employees select s.EmployeeID).ToArray();
int c = 0, i, j;
if (db.Employees.Count() == 0)
{
id = 1;
}
else
{
for (int k = 0; k < data.Length; k++)
{
i = data[k];
j = i - (c++);
if (j > 1)
{
id = c;
break;
}
else
{
id = i + 1;
}
}
}
}
public JsonResult SaveEvent(Calendar e)
{
var status = false;
using (RegistrationEntities dc = new RegistrationEntities())
{
if (e.EventID > 0)
{
//Update the event
var v = dc.Calendars.Where(a => a.EventID == e.EventID).FirstOrDefault();
if (v != null)
{
v.Subject = e.Subject;
v.Start = e.Start;
v.End = e.End;
v.Description = e.Description;
v.IsFullDay = e.IsFullDay;
v.ThemeColor = e.ThemeColor;
}
}
else
{
dc.Calendars.Add(e);
}
dc.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
public SectionCRUDForm(RegistrationEntities registrationEntities)
{
InitializeComponent();
RegEnt = registrationEntities;
ErrorLabel.Text = "";
//Initialize List of Course IDs and Faculty IDs, list on side
CourseIDDropdownBox.Items.Clear();
FacultyIDDropdownBox.Items.Clear();
foreach (Course c in RegEnt.Courses)
{
string cID = c.Id.ToString();
string cNumber = c.Number;
string cName = c.Name;
CourseIDDropdownBox.Items.Add(cID);
CourseListBox.Items.Add(cID.PadRight(10 - cID.Length) + cNumber.PadRight(10 - cNumber.Length) + cName);
}
foreach (Faculty f in RegEnt.Faculties)
{
string fID = f.Id.ToString();
string fName = f.Name;
FacultyIDDropdownBox.Items.Add(fID);
FacultyListBox.Items.Add(fID.PadRight(10 - fID.Length) + fName);
}
UpdateSectionListBox();
}
public enrollmentCRUDForm(RegistrationEntities RE)
{
InitializeComponent();
RegistrationEntities = RE;
sectionComboBox.Items.Clear();
studentComboBox.Items.Clear();
gradeComboBox.Items.Clear();
ErrorLabel.Text = String.Empty;
InitializeSectionsListBox();
InitializeStudentsListBox();
foreach (Section sec in RegistrationEntities.Sections)
{
sectionComboBox.Items.Add(sec.Id);
}
foreach (Student stu in RegistrationEntities.Students)
{
studentComboBox.Items.Add(stu.Id);
}
gradeComboBox.SelectedIndex = -1;
string[] grades = new string[] { "A", "A-", "B", "B-", "C", "C-", "D", "D-", "F", "I" };
gradeComboBox.DataSource = grades;
UpdateEnrollmentListBox();
}
public decimal GetUserCalories(User user)
{
decimal calories = 0;
decimal heightCentimeters = UnitConverter.MetersToCentimeters(user.HeighInt) + user.HeighDec;//estatura en centimetros
int age = Selery.Library.Common.Helper.GetAge(user.BirthDate.Value);
spSelectActivityByID_Result activity = null;
using (var context = new RegistrationEntities())
{
activity = context.spSelectActivityByID(user.ActivityID).FirstOrDefault();
}
//calcular el gasto de calorias.
if (user.Gender == (int)Selery.BO.Core.Enum.Gender.Male)
{
//( (10*peso)+(6.25*estatura)-(5*edad)+5 )*factor
calories = ((10 * user.Weight) + ((decimal)6.25 * heightCentimeters) - (5 * age) + 5) * activity.Factor;
}
else
{
//( ( 10*peso)+(6.25*estatura)-(5*edad)-161 )*factor
calories = ((10 * user.Weight) + ((decimal)6.25 * heightCentimeters) - (5 * age) + 161) * activity.Factor;
}
return(calories);
}
public ActionResult SaveRegisterDetails(Register registerDetails)
{
//We check if the model state is valid or not. We have used DataAnnotation attributes.
//If any form value fails the DataAnnotation validation the model state becomes invalid.
if (ModelState.IsValid)
{
//create database context using Entity framework
using (var databaseContext = new RegistrationEntities())
{
//If the model state is valid i.e. the form values passed the validation then we are storing the User's details in DB.
user reglog = new user();
//Save all details in RegitserUser object
reglog.FirstName = registerDetails.FirstName;
reglog.LastName = registerDetails.LastName;
reglog.Email = registerDetails.Email;
reglog.Password = registerDetails.Password;
//Calling the SaveDetails method which saves the details.
databaseContext.users.Add(reglog);
databaseContext.SaveChanges();
}
ViewBag.Message = "User Details Saved";
return(View("Register"));
}
else
{
//If the validation fails, we are returning the model object with errors to the view, which will display the error messages.
return(View("Register", registerDetails));
}
}
//come back to!!!!!!!!!!!!!!
public ActionResult ClientEmailSearch(string email)
{
email = email.Trim();
RegistrationEntities database = new RegistrationEntities();
Client s = database.Clients.Find(email);
if (email == "")
{
Messagebox("Please enter an email to search for");
return(View("ClientIndex"));
}
try
{
if (!(s is null))
{
if (s.Email == email)
{
return(View(s));
}
else
{
Messagebox("Client not found");
return(View("ClientIndex"));
}
}
else
{
Messagebox("Client not found");
return(View("ClientIndex"));
}
}
/// <summary>
/// Crea un nuevo usuario
/// </summary>
/// <param name="firstName"></param>
/// <param name="lastName"></param>
/// <param name="email"></param>
/// <param name="password"></param>
/// <returns></returns>
public User CreateUser(User user)
{
using (var context = new RegistrationEntities())
{
int userID = (int)context.spInsertUser(user.FirstName, user.LastName, user.Email, (long?)user.FacebookID.ToNull(), user.Password).FirstOrDefault().UserID;
return(SelectUserByID(userID));
}
}
public User UpdateUserProfile(User user)
{
using (var context = new RegistrationEntities())
{
decimal?rowcount = context.spUserProfileUpdate(user.UserID, user.Weight, user.ActivityID).SingleOrDefault();
return(this.SelectUserByID(user.UserID));//refrescar el usuario y regresarlo
}
}
public studentFilteringByMajorForm(RegistrationEntities RE)
{
InitializeComponent();
RegistrationEntities = RE;
errorLabel.Text = String.Empty;
fillListBoxWithEverythingInTable();
loadMajorIntoComboBox();
}
public JsonResult getQuestion()
{
RegistrationEntities entities = new RegistrationEntities();
List <Concern> concern = (from account in entities.Concerns
select account).ToList();
return(Json(concern));
}
public bool IsEmail(string emailID)
{
using (RegistrationEntities rs = new RegistrationEntities())
{
var v = rs.Users.Where(a => a.Email == emailID).FirstOrDefault();
return(v != null);
}
}
public CourseCRUDForm(RegistrationEntities RE)
{
InitializeComponent();
RegEnt = RE;
UpdateCourseListBox();
ErrorLabel.Text = String.Empty;
}
public JsonResult StudentInfraction()
{
RegistrationEntities entities = new RegistrationEntities();
List <Infraction> inf = (from account in entities.Infractions
select account).ToList();
return(Json(inf));
}
public JsonResult AjaxMethod()
{
RegistrationEntities entities = new RegistrationEntities();
List <Member> members = (from account in entities.Members
select account).ToList();
return(Json(members));
}
public CourseFilteringByDepartmentForm(RegistrationEntities RE)
{
InitializeComponent();
RegistrationEntities = RE;
errorLabel.Text = String.Empty;
fillListBoxWithEverythingInCourseTable();
loadDepartmentComboBox();
}
public ActionResult DeleteEvent(string clientEmail, string eventName)
{
//trimming the whitespace of our parsed variables
clientEmail = clientEmail.ToLower().Trim();
eventName = eventName.Trim();
//grabbing both databases (clients and registrations)
RegistrationEntities cdb = new RegistrationEntities();
RegistrationEntities2 rdb = new RegistrationEntities2();
//creating lists for both databases that contain the parsed variables
List <Client> clients = cdb.Clients.Where(x => x.Email.ToLower() == clientEmail.ToLower()).ToList();
List <Register> reg = rdb.Registers.Where(x => x.EventName.ToLower() == eventName.ToLower()).ToList();
try
{
//if a valid client has been parsed
if (clients.Capacity > 0)
{
//grabbing all items that contain the client email in registration db
var r = rdb.Registers.Where(x => x.Email.ToLower() == clientEmail.ToLower()).ToList();
foreach (var ev in reg)
{
//checking to make sure a valid event has been parsed
if (reg.Capacity > 0)
{
//ensuring correct client registration is deleted
if (ev.Email == clientEmail)
{
rdb.Registers.Remove(ev);
rdb.SaveChanges();
//alerting user
Messagebox("Registration deletion Successfull");
return(View());
}
}
//deleting the events in the registration db that have the same name as the parsed event name
}
Messagebox("Please Enter a Valid Event");
return(View("EventIndex"));
}
//if no valid client email was parsed
else
{
//alerting user
Messagebox("Please Enter a Valid Client");
return(View("EventIndex"));
}
}
catch
{
//alerting user if an error was found
Messagebox("Event Registration Not Found, Registration Deletion Failed, Please Try Again");
return(View("EventIndex"));
}
}
// GET: Client
public ActionResult Index()
{
RegistrationEntities database = new RegistrationEntities();
var client = from c in database.Clients
orderby c.Email
select c;
return(View(client));
}
public JsonResult GetEvents()
{
using (RegistrationEntities dc = new RegistrationEntities())
{
var events = dc.Calendars.ToList();
return(new JsonResult {
Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public int FindUserByFacebookID(long facebookID)
{
int userID = 0;
using (var context = new RegistrationEntities())
{
userID = context.spFindUserByFacebookID(facebookID).FirstOrDefault().UserID;
}
return(userID);
}
public ActionResult Index(System_Users obj)
{
if (ModelState.IsValid)
{
RegistrationEntities db = new RegistrationEntities();
db.System_Users.Add(obj);
db.SaveChanges();
}
return(View(obj));
}
public int FindUserByEmail(string email)
{
int userID = 0;
using (var context = new RegistrationEntities())
{
userID = context.spFindUserByEmail(email).FirstOrDefault().UserID;
}
return(userID);
}
public Boolean IsProfileComplete(int userID)
{
spIsProfileComplete_Result retVal;
using (var context = new RegistrationEntities())
{
retVal = context.spIsProfileComplete(userID).FirstOrDefault();
}
return(retVal.IsProfileComplete.HasValue ? retVal.IsProfileComplete.Value : false);
}
public int UserWeightInsert(int userID, decimal weight)
{
decimal?userWeightID = 0;
using (var context = new RegistrationEntities())
{
userWeightID = context.spUserWeightInsert(userID, weight).FirstOrDefault().UserWeightID;
}
return(Convert.ToInt32(userWeightID.Value));
}
public User SelectUserByEmail(string email)
{
User user = null;
using (var context = new RegistrationEntities())
{
spSelectUserByEmail_Result userEF = context.spSelectUserByEmail(email).FirstOrDefault();
if (userEF != null)
{
user = new User();
user.ActivationDate = userEF.ActivationDate.HasValue ? userEF.ActivationDate.Value : DateTime.MinValue;
user.ActivityID = userEF.ActivityID.HasValue ? userEF.ActivityID.Value : 0;
user.BirthDate = userEF.BirthDate.HasValue ? userEF.BirthDate.Value : (DateTime?)null;
user.CreatedDate = userEF.CreatedDate;
user.CreatedBy = userEF.CreatedBy.HasValue ? userEF.CreatedBy.Value : 0;
user.Description = userEF.Description;
user.Email = userEF.Email;
user.FacebookID = userEF.FacebookID.HasValue ? userEF.FacebookID.Value : 0;
user.FirstName = userEF.FirstName;
user.Gender = userEF.Gender.HasValue ? userEF.Gender.Value : 0;
user.Heigh = userEF.Heigh.HasValue ? userEF.Heigh.Value : 0;
user.HeighDec = userEF.HeighDec.HasValue ? userEF.HeighDec.Value : 0;
user.HeighInt = userEF.HeighInt.HasValue ? userEF.HeighInt.Value : 0;
user.IsApproved = userEF.IsApproved.HasValue ? userEF.IsApproved.Value : false;
user.IsLockedOut = userEF.IsLockedOut.HasValue ? userEF.IsLockedOut.Value : false;
user.LastLoginDate = userEF.LastLoginDate.HasValue ? userEF.LastLoginDate.Value : DateTime.MinValue;
user.LastName = userEF.LastName;
user.LastUpdatedBy = userEF.LastUpdatedBy.HasValue ? userEF.LastUpdatedBy.Value : 0;
user.LastUpdatedDate = userEF.LastUpdatedDate.HasValue ? userEF.LastUpdatedDate.Value : DateTime.MinValue;
user.Password = null;
user.TerminationDate = userEF.TerminationDate.HasValue ? userEF.TerminationDate.Value : DateTime.MinValue;
user.UserID = userEF.UserID;
user.CurrentProgram = _workoutRepository.SelectCurrentUserProgram(user.UserID);
user.IsProfileComplete = this.IsProfileComplete(user.UserID);
user.Weight = userEF.Weight.HasValue ? userEF.Weight.Value : 0;
user.BMI = userEF.BMI.HasValue ? userEF.BMI.Value : 0;
user.Calories = userEF.Calories.HasValue ? userEF.Calories.Value : 0;
if (userEF.GoalID.HasValue)
{
spSelectGoalByID_Result goalEF = context.spSelectGoalByID(userEF.GoalID.Value).FirstOrDefault();
Goal goal = new Goal();
goal.GoalID = goalEF.GoalID;
goal.GoalName = goalEF.GoalName;
goal.IsEnabled = goalEF.IsEnabled;
goal.CreatedDate = goalEF.CreatedDate;
user.Goal = goal;
}
}
}
return(user);
}
/// <summary>
///
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
/// <remarks>
/// Se llama cuando el usuario inicia su programa.
/// Si ya inicio almenos un programa la siguiente vez, el birthdate y sexo no deben cambiar
/// </remarks>
public User UpdateUserRegistration(User user)
{
using (var context = new RegistrationEntities())
{
decimal heigh = user.HeighInt + UnitConverter.CentimetersToMeters(user.HeighDec); //estatura en metros
user.BMI = Selery.BO.Nutrition.Profile.GetBMI(heigh, user.Weight);
int age = Selery.Library.Common.Helper.GetAge(user.BirthDate.Value);
//selecctionar el goaltype en base al bmi
Selery.BO.Core.Enum.GoalType goalTypeID = Selery.BO.Nutrition.Profile.GetGoalType(user.BMI);
//TODO: por ahora solo tenemos 2 goals, el 1 es de LoseWeight y el 2 es de Maintain
//cuando haya mas Goals vamos a tener que hacer refactor a este metodo.
int goalID = (goalTypeID == Selery.BO.Core.Enum.GoalType.LoseWeight ? (int)Selery.BO.Core.Enum.GoalType.LoseWeight : (int)Selery.BO.Core.Enum.GoalType.Maintain);
//Las calorias ya vienen en el usuario
int?rowcount = context.spUserRegistrationUpdate(user.UserID,
user.Gender,
user.HeighInt,
user.HeighDec,
user.BirthDate,
goalID,
user.BMI,
user.Calories).SingleOrDefault();
decimal?id = context.spUserActivityInsert(user.UserID, user.ActivityID).SingleOrDefault();
}
using (var context = new WorkoutEntities())
{
//iniciar el programa
//guardar cual es el BMI del usuario al inicio del programa
int?rowcount = context.spUserProgramUpdate(user.UserID, user.CurrentProgram.ProgramID, user.BMI).SingleOrDefault();
}
//insertar el peso
this.UserWeightInsert(user.UserID, user.Weight);
//inicializar menu
using (var context = new NutritionEntities())
{
int?rowcount = context.spUserDailyMenuInitialize(user.UserID, user.CurrentProgram.ProgramID).SingleOrDefault();
}
return(this.SelectUserByID(user.UserID));
}
public studentCRUDForm(RegistrationEntities RE)
{
InitializeComponent();
RegistrationEntities = RE;
errorLabel.Text = String.Empty;
foreach (Major m in RegistrationEntities.Majors)
{
majorComboBox.Items.Add(m.Name);
}
UpdateListBox();
}
private void courseFilteringByDepartment_Click(object sender, EventArgs e)
{
if (CanOpenNewForm())
{
RegistrationEntities = new RegistrationEntities();
CourseFilteringByDepartmentForm CourseFilteringByDepartmentForm = new CourseFilteringByDepartmentForm(RegistrationEntities);
CourseFilteringByDepartmentForm.Show();
}
else
{
MessageBox.Show("You can only have one form open at a time.");
}
}
public ActionResult Registered(Registration registration)
{
using (RegistrationEntities db = new RegistrationEntities())
{
try
{
db.Registration.Add(registration);
db.SaveChanges();
} catch
{
return(RedirectToAction("Index"));
}
}
ViewBag.Name = registration.NameAndSurname;
return(View());
}
