public List <category_third> GetCategoryThirds(int sid)
{
using (userEntities userEntities = new userEntities())
{
return(userEntities.category_third.Where(p => p.cs_id == sid).ToList());
}
}
public List <category_second> GetCategorySeconds(int fid)
{
using (userEntities userEntities = new userEntities())
{
return(userEntities.category_second.Where(p => p.fc_id == fid).ToList());
}
}
public profile getUser()
{
var myContext = new userEntities();
var profile_x = myContext.profiles.ToList().Find(x => x.id == 1);
return(profile_x);
}
protected void FormsAuthentication_OnAuthenticate(Object sender, FormsAuthenticationEventArgs e)
{
if (FormsAuthentication.CookiesSupported == true)
{
if (Request.Cookies[FormsAuthentication.FormsCookieName] != null)
{
try
{
//let us take out the username now
string username = FormsAuthentication.Decrypt(Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name;
string roles = string.Empty;
using (userEntities entities = new userEntities())
{
userTable user = entities.userTables.SingleOrDefault(u => u.userName == username);
roles = user.userRole;
}
//let us extract the roles from our own custom cookie
//Let us set the Pricipal with our user specific details
e.User = new System.Security.Principal.GenericPrincipal(
new System.Security.Principal.GenericIdentity(username, "Forms"), roles.Split(';'));
}
catch (Exception)
{
//somehting went wrong
}
}
}
}
public ActionResult ModifyPassword(PasswordVM model)
{
if (ModelState.IsValid)
{
var db = new userEntities();
var currentUserEmail = Session["TEMP"];
var v = db.users.Where(u => u.email == currentUserEmail).FirstOrDefault();
if (v != null)
{
var hash = Crypto.HashPassword(model.password);
v.password = hash;
db.SaveChanges();
Session.Remove("TEMP");
return(RedirectToAction("Login", "User"));
}
else
{
ViewData["Message"] = "User doesnt exist";
}
}
return(View(model));
}
public ActionResult CreateUser(RegisterVM model)
{
if (ModelState.IsValid)
{
var db = new userEntities();
var currentUserEmail = model.email;
var v = db.users.Where(u => u.email.Equals(currentUserEmail)).FirstOrDefault();
if (v == null)
{
var hash = Crypto.HashPassword(model.password);
var user = "******";
db.users.Add(new user
{
email = model.email,
firstname = model.firstname,
lastname = model.lastname,
password = hash,
dob = model.dob,
utype = user
});
db.SaveChanges();
Session["UTYPE"] = "USER";
Session["EMAIL"] = model.email;
return(RedirectToAction("Index", "Home"));
}
else
{
ViewData["Message"] = "User already exists";
}
}
return(View(model));
}
//delete a user
public ActionResult Delete(string type, int id)
{
var db = new userEntities();
var foundUser = db.users.Where(u => u.Id.Equals(id)).FirstOrDefault();
db.users.Remove(foundUser);
db.SaveChanges();
if (type == "DOCTOR")
{
return(RedirectToAction("ManageDoctors", "Admin"));
}
else if (type == "USER")
{
return(RedirectToAction("ManagePatients", "Admin"));
}
else if (type == "ADMIN")
{
return(RedirectToAction("ManageAdmins", "Admin"));
}
else
{
return(RedirectToAction("OpenAdminLanding", "Admin"));
}
}
public List <category> GetCategories()
{
using (userEntities userEntities = new userEntities())
{
return(userEntities.category.ToList());
}
}
public ActionResult ShowAddForm(string type, AddVM m)
{
if (Session["UTYPE"] as string == "ADMIN")
{
if (ModelState.IsValid)
{
var db = new userEntities();
var currentUserEmail = m.email;
var v = db.appointments.Where(u => u.user.Equals(currentUserEmail)).FirstOrDefault();
if (v == null)
{
var hash = Crypto.HashPassword("password");
db.users.Add(new user
{
email = m.email,
firstname = m.firstname,
lastname = m.lastname,
password = hash,
dob = m.dob,
utype = type
});
db.SaveChanges();
if (type == "DOCTOR")
{
return(RedirectToAction("ManageDoctors", "Admin"));
}
else if (type == "USER")
{
return(RedirectToAction("ManagePatients", "Admin"));
}
else if (type == "ADMIN")
{
return(RedirectToAction("ManageAdmins", "Admin"));
}
else
{
return(RedirectToAction("OpenAdminLanding", "Admin"));
}
}
else
{
ViewData["Message"] = "User already exists";
}
}
else
{
return(View());
}
return(View());
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public crowd_funding GetCrowdFundingById(int id)
{
using (userEntities userEntities = new userEntities())
{
var data = userEntities.crowd_funding.SingleOrDefault(p => p.id == id);
return(data);
}
}
public ActionResult Delete(int Id)
{
using (var db = new userEntities())
{
var oUser = db.usermvc.Find(Id);
oUser.idState = 3; //pa eliminar
db.Entry(oUser).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(Content("1"));
}
public ActionResult OpenUserLanding(UserLandingVM m)
{
if (ModelState.IsValid)
{
var db = new userEntities();
var currentUserEmail = Session["EMAIL"] as string;
var v = db.appointments.Where(u => u.user.Equals(currentUserEmail) && u.astate.Equals("booked")).FirstOrDefault();
if (v == null)
{
var aBooking = db.appointments.Where(u => u.doctor.Equals(m.doctor) && u.date.Equals(m.date) && u.time.Equals(m.time) && u.astate.Equals("booked")).FirstOrDefault();
if (aBooking != null)
{
ViewData["Message"] = "This doctor is booked at this time and on this date, choose another";
}
else
{
if (IsTimeCorrect(m.time))
{
if (IsDateFuture(m.date))
{
db.appointments.Add(new appointment
{
doctor = m.doctor,
user = Session["EMAIL"] as string,
date = m.date,
time = m.time,
astate = "booked"
});
db.SaveChanges();
return(RedirectToAction("OpenUserLanding", "User"));
}
else
{
ViewData["Message"] = "You need to select a date in the future";
}
}
else
{
ViewData["Message"] = "Surgery is only open between 9:00 and 17:30";
}
}
}
else
{
ViewData["Message"] = "You already have an appointment, attend or cancel it before booking again";
}
}
return(View(m));
}
public ActionResult Register(StudentRegistration U)
{
if (ModelState.IsValid)
{
using (userEntities dc = new userEntities())
{
dc.StudentRegistrations.Add(U);
dc.SaveChanges();
U = null;
ViewBag.Message = "Registration Successfully..";
}
}
return(View(U));
}
public ActionResult Edit(int Id)
{
EditViewModel model = new EditViewModel();
using (var db = new userEntities())
{
var oUser = db.usermvc.Find(Id);
model.Edad = (int)oUser.edad;
model.Email = oUser.email;
model.Id = oUser.id;
}
return(View(model));
}
public user_detail GetUserDetailById(int id)
{
using (userEntities userEntities = new userEntities())
{
try
{
return(userEntities.user_detail.SingleOrDefault(p => p.user_uid == id));
}
catch (Exception ex)
{
Trace.WriteLine(ex);
}
}
return(null);
}
public ActionResult Checker(User u)
{
using (userEntities db = new userEntities())
{
var userDetails = db.Users.Where(x => x.UserName == u.UserName && x.Password == u.Password).FirstOrDefault();
if (userDetails == null)
{
u.LoginError = "Wrong username or password";
return(View("Login", u));
}
else
{
Session["User"] = "******";
return(RedirectToAction("Index"));
}
}
}
public bool SaveAndroidApk(android_update android)
{
using (userEntities userEntities = new userEntities())
{
try
{
userEntities.android_update.Add(android);
int iRent = userEntities.SaveChanges();
return(iRent > 0);
}
catch (Exception ex)
{
Trace.WriteLine(ex);
}
}
return(false);
}
public List <province> GetProvince()
{
List <province> list = new List <province>();
try
{
using (userEntities userEntities = new userEntities())
{
list = userEntities.province.ToList();
return(list);
}
}
catch (Exception ex)
{
Trace.WriteLine(ex);
}
return(list);
}
public List <city> GetCity(int provinceId)
{
List <city> list = new List <city>();
try
{
using (userEntities userEntities = new userEntities())
{
list = userEntities.city.Where(p => p.province_id == provinceId).ToList();
return(list);
}
}
catch (Exception ex)
{
Trace.WriteLine(ex);
}
return(list);
}
public List <android_update> GetAndroidUpdates()
{
List <android_update> list = new List <android_update>();
using (userEntities userEntities = new userEntities())
{
try
{
list = userEntities.android_update.OrderByDescending(p => p.create_time).ToList();
}
catch (Exception ex)
{
Trace.WriteLine(ex);
}
}
return(list);
}
public List <ActorSelectData> GetActorSelectDatas(string key)
{
List <ActorSelectData> list = new List <ActorSelectData>();
using (userEntities userEntity = new userEntities())
{
try
{
var data = from a in userEntity.user_detail
join b in userEntity.city on a.user_city_id equals b.city_id
join c in userEntity.user_base on a.user_uid equals c.user_uid
where c.user_nick.Contains(key) && c.is_actor == 1
select new
{
c.user_nick,
a.user_uid,
b.city_name,
a.user_city_id,
a.user_career,
c.phone
};
foreach (var item in data)
{
list.Add(new ActorSelectData()
{
Phone = item.phone,
ActorName = item.user_nick,
Career = item.user_career,
CityName = item.city_name,
UserId = item.user_uid
});
}
}
catch (Exception ex)
{
Trace.WriteLine(ex);
}
}
return(list);
}
public bool SaveCrowFound(crowd_funding crowdFunding, List <cf_type> cfTypes, List <cf_label> labels)
{
using (userEntities userEntities = new userEntities())
{
using (var tran = userEntities.Database.BeginTransaction())
{
try
{
crowdFunding.cf_fund_amount = 0;
crowdFunding.support_amount = 0;
userEntities.crowd_funding.Add(crowdFunding);
int iRent = userEntities.SaveChanges();
if (iRent > 0)
{
foreach (var item in cfTypes)
{
item.cf_id = crowdFunding.id;
}
userEntities.cf_type.AddRange(cfTypes);
foreach (var item in labels)
{
item.cf_id = crowdFunding.id;
}
userEntities.cf_label.AddRange(labels);
userEntities.SaveChanges();
}
tran.Commit();
return(true);
}
catch (Exception ex)
{
tran.Rollback();
Trace.WriteLine(ex);
}
}
}
return(false);
}
// GET: User
public ActionResult Index()
{
List <UserTableViewModel> lst = null;
using (userEntities db = new userEntities())
{
lst = (from d in db.usermvc
where d.idState == 1
orderby d.email
select new UserTableViewModel
{
Email = d.email,
Id = d.id,
Edad = d.edad
}).ToList();
}
return(View(lst));
}
public ActionResult Add(ViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new userEntities())
{
usermvc oUser = new usermvc();
oUser.idState = 1;
oUser.email = model.Email;
oUser.password = model.Password;
oUser.edad = model.Edad;
db.usermvc.Add(oUser);
db.SaveChanges();
}
return(Redirect(Url.Content("~/User/")));
}
public bool SaveTopData(Dictionary <int, TopDataModel> dict, DateTime dateTime)
{
using (userEntities userEntities = new userEntities())
{
using (var tran = userEntities.Database.BeginTransaction())
{
try
{
var dataList = userEntities.recommendation.Where(p => p.data_date == dateTime).ToList();
if (dataList.Count > 0)
{
userEntities.recommendation.RemoveRange(dataList);
userEntities.SaveChanges();
}
foreach (var item in dict)
{
recommendation data = new recommendation();
data.create_id = 1;
data.create_name = "admin";
data.create_time = HelpFunction.ConvertToTimestamp(DateTime.Now);
data.data_date = item.Value.Date;
data.icon = item.Value.ImgaeUrl;
data.order_index = item.Value.OrderIndex;
data.source_id = item.Value.SourceId;
data.source_type = item.Value.SourceTypeInt;
data.source_title = item.Value.Title;
userEntities.recommendation.Add(data);
}
userEntities.SaveChanges();
tran.Commit();
return(true);
}
catch (Exception ex)
{
tran.Rollback();
Trace.WriteLine(ex);
}
}
}
return(false);
}
public ActionResult ShowUpdateForm(string type, int id, UpdateVM m)
{
var entities = new userEntities();
if (Session["UTYPE"] as string == "ADMIN")
{
if (ModelState.IsValid)
{
var db = new userEntities();
var foundUser = db.users.Where(u => u.Id.Equals(id)).FirstOrDefault();
foundUser.dob = m.dob;
foundUser.firstname = m.firstname;
foundUser.lastname = m.lastname;
db.SaveChanges();
if (foundUser.utype == "DOCTOR")
{
return(RedirectToAction("ManageDoctors", "Admin"));
}
else if (foundUser.utype == "USER")
{
return(RedirectToAction("ManagePatients", "Admin"));
}
else if (foundUser.utype == "ADMIN")
{
return(RedirectToAction("ManageAdmins", "Admin"));
}
}
else
{
return(View());
}
return(View());
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public bool UpdateUserDetailById(int id, string text)
{
using (userEntities userEntities = new userEntities())
{
try
{
var data = userEntities.user_detail.SingleOrDefault(p => p.user_uid == id);
if (data != null)
{
data.user_intro = text;
userEntities.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Trace.WriteLine(ex);
}
}
return(false);
}
public List <UserRequstModel> GetRequstModels()
{
List <UserRequstModel> list = new List <UserRequstModel>();
using (userEntities data = new userEntities())
{
int index = 1;
var res = from a in data.actor_requst
join b in data.user_base on a.user_uid equals b.user_uid
select new
{
a.career,
a.experience,
a.gender,
a.org,
a.requst_time,
a.tel,
a.user_uid,
b.user_nick
};
;
foreach (var item in res)
{
UserRequstModel model = new UserRequstModel();
model.Career = item.career;
model.Experience = item.experience;
model.Gender = item.gender;
model.Org = item.org;
model.Tel = item.tel;
model.UserUid = item.user_uid;
model.UserNick = item.user_nick;
model.RequstTime = HelpFunction.GetDateTime(item.requst_time);
model.Num = index;
index++;
list.Add(model);
}
}
return(list);
}
public List <TopDataModel> TopQureyList(DateTime dateTime)
{
List <TopDataModel> list = new List <TopDataModel>();
using (userEntities userEntities = new userEntities())
{
var res = userEntities.recommendation.Where(p => p.data_date == dateTime).ToList();
foreach (var item in res)
{
TopDataModel model = new TopDataModel();
model.Date = item.data_date;
model.ImgaeUrl = item.icon;
model.Id = item.id;
model.SourceId = item.source_id;
//推荐来源类型，1、艺人 2、众筹 3视频
model.SourceTypeInt = item.source_type;
model.Title = item.source_title;
if (item.source_type == 1)
{
model.SourceType = "艺人";
}
else if (item.source_type == 2)
{
model.SourceType = "众筹";
}
else if (item.source_type == 3)
{
model.SourceType = "视频";
}
model.OrderIndex = item.order_index;
list.Add(model);
}
}
return(list);
}
public ContentResult Enter(string user, string password)
{
try
{
using (userEntities db = new userEntities())
{
var oUser = db.usermvc.FirstOrDefault(f => f.email == user && f.password == password && f.idState == 1);
if (oUser != null)
{
Session["User"] = oUser;
return(Content("1"));
}
else
{
return(Content("Usuario invalido :("));
}
}
}
catch (Exception ex)
{
return(Content("Fallido" + ex.Message));
}
}
