public ActionResult Editar(int id)
{
var lista = new List <combo>();
lista.Add(new combo {
key = "Masculino", val = "Masculino"
});
lista.Add(new combo {
key = "Femenino", val = "Femenino"
});
//ViewBag.sexo = new SelectList(lista);
ViewBag.sexo = lista;
var db = new ApplicationDbContext();
var o = db.Users.Where(x => x.IdAuto == id).FirstOrDefault();
var u = new userViewModel();
u.Id = o.IdAuto;
u.Usuario = o.UserName;
u.Correo = o.Email;
u.Sexo = o.Sexo;
u.EstatusBool = o.Estatus;
return(View(u));
}
public ActionResult Eliminar(userViewModel u)
{
var db = new ApplicationDbContext();
var o = db.Users.Where(x => x.IdAuto == u.Id).FirstOrDefault();
o.Estatus = false;
db.SaveChanges();
//Contraseña
//Return
var users = db.Users.ToList();
var lista = new List <userViewModel>();
foreach (var item in users)
{
var usuario = new userViewModel();
usuario.Id = item.IdAuto;
usuario.Usuario = item.UserName;
usuario.Correo = item.Email;
usuario.Sexo = item.Sexo;
usuario.Estatus = item.Estatus == true ? "Activo" : "Inactivo";
lista.Add(usuario);
}
return(View("../Home/Index", lista));
}
public ActionResult Index(userViewModel registration)
{
if (ModelState.IsValid)
{
User user = new User();
user.FullName = "Yasa";
user.Country = registration.Country;
user.State = registration.State;
user.City = registration.City;
user.Email = registration.Email;
user.Gender = registration.Gender;
user.Password = registration.Password;
user.Mobile = registration.Mobile;
user.CreatedOn = DateTime.Now;
if (registration.Photo != null)
{
user.Photo = registration.Photo.FileName;
registration.Photo.SaveAs(Server.MapPath("~/Content/" + user.Photo));
}
_context.Users.Add(user);
_context.SaveChanges();
ModelState.Clear();
}
return(View());
}
/// <summary>
/// on click of button,selected item in dropdown-type displays HTML,JSON or plain text data formats.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ShowHideDetails(object sender, RoutedEventArgs e)
{
if (ComboType.SelectedValue == null)
{
MessageBox.Show("Please select content type description");
return;
}
copyContents contentType = new copyContents();
viewModel = new userViewModel();
var dgSelectedData = dgUsers.ItemsSource.Cast <user>();
string textFormat = null;
var selectValue = ComboType.SelectedValue;
if (selectValue.ToString().ToLower().Equals("json"))
{
JavaScriptSerializer serializeData = new JavaScriptSerializer();
textFormat = JsonConvert.SerializeObject(dgSelectedData, Formatting.Indented);
}
else if (selectValue.ToString().ToLower().Equals("html"))
{
textFormat = formHtmlTags(dgSelectedData, x => x.id, x => x.title, x => x.userId, x => x.body);
}
else if (selectValue.ToString().ToLower().Equals("plaintext"))
{
textFormat = GetMyPlaintext(dgSelectedData, x => x.id, x => x.title, x => x.userId, x => x.body);
}
contentType.CopyContent.Text = textFormat;
contentType.Show();
}
public ActionResult Register(userViewModel userInfo, HttpPostedFileBase file)
{
if (ModelState.IsValid)
{
string vCode = Request.Form["txtverifcode1"];
if (vCode != Session["ValidateCode"].ToString())
{
return(Content("<script>;alert('验证码错误！');history.go(-1)</script>"));
}
var user = myContext.UserInfo.Where(u => u.UName == userInfo.Uname).FirstOrDefault();
if (user != null)
{
return(Content("<script>;alert('用户名已被占用！');history.go(-1)</script>"));
}
UserInfo userNew = new UserInfo();
userNew.UID = userInfo.Uid;
userNew.UName = userInfo.Uname;
userNew.UPassWord = userInfo.UPassWord;
myContext.UserInfo.Add(userNew);
myContext.SaveChanges();
return(Content("<script>;alert('注册成功!正在跳转到首页..');window.location.href='/Home/Index'</script>"));
}
else
{
return(View());
}
}
public ActionResult EditUser(string username)
{
userViewModel user = DapperORM.GetSingleUser(username);
user.teams = DapperORM.getTeamData();
user.roles = DapperORM.getRoleData();
return(View(user));
}
/// <summary>
/// fill dataGrid with viewModel.
/// </summary>
public userView()
{
InitializeComponent();
viewModel = new userViewModel();
this.DataContext = viewModel;
viewModel._isCheck = false;
dgUsers.ItemsSource = viewModel.users;
dgUsers.Columns[3].Visibility = Visibility.Hidden;
}
/// <summary>
/// on selection of dropdown column description is visible.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
var comboBox = sender as ComboBox;
viewModel = new userViewModel();
var selectedItems = viewModel.users.Where(i => i.userId == Convert.ToInt16(comboBox.SelectedItem)).ToList();
dgUsers.ItemsSource = selectedItems;
dgUsers.Columns[3].Visibility = Visibility.Visible;
}
/// <summary>
/// fill dropdown on the basis of distinct userId from viewModel.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ComboBox_Loaded(object sender, RoutedEventArgs e)
{
var comboBox = sender as ComboBox;
var id = viewModel.users.Select(i => i.userId).Distinct();
comboBox.ItemsSource = id.ToList();
if (viewModel != null)
{
viewModel = null;
GC.Collect();
}
}
//
// GET: /User/Create
public ActionResult Create()
{
userViewModel user = new userViewModel();
List <company> listcompany = new List <company>();
listcompany = companieservice.GetMany().ToList();
user.companies = listcompany.ToSelectListItems();
return(View(user));
}
public static void updateUser(userViewModel updateUser)
{
using (NpgsqlConnection connection = new NpgsqlConnection("Server=localhost;Port=5432;User Id=postgres;Password=nikola000;Database=BugTrackerDB;"))
{
connection.Open();
var query = @"UPDATE ""Korisnik""
SET ""username"" = '" + updateUser.username + "',\"lozinka\"='" + updateUser.lozinka + "',\"email\"='" + updateUser.email + "',\"timID\"=" + updateUser.timID + ",\"Avatar\"='" + updateUser.Avatar + "',\"ulogaID\"=" + updateUser.ulogaID
+ "WHERE \"korisnikID\"=" + updateUser.korisnikID;
connection.Query <userViewModel>(query);
};
}
public IActionResult Get(int id)
{
var o = _repo.GetUserById(id);
if (o == null)
{
return(NotFound($"User {id} Not Found"));
}
var vm = new userViewModel(o);
return(Ok(vm));
}
//
// GET: /User/Details/5
public ActionResult Details(int id)
{
var user = service.GetById(id);
userViewModel u = new userViewModel();
u.idUser = user.idUser;
u.FirstName = user.FirstName;
u.LastName = user.LastName;
u.Password = user.Password;
u.Email = user.Email;
u.company_Id = user.company_Id;
return(View(u));
}
public IHttpActionResult addUser(userViewModel u)
{
if (ModelState.IsValid)
{
//_context.Users.Add(u);
// _context.SaveChanges();
ModelState.Clear();
return(Ok());
}
else
{
return(BadRequest());
}
}
public ActionResult Eliminar(int id)
{
var db = new ApplicationDbContext();
var o = db.Users.Where(x => x.IdAuto == id).FirstOrDefault();
var u = new userViewModel();
u.Id = o.IdAuto;
u.Usuario = o.UserName;
u.Correo = o.Email;
u.Sexo = o.Sexo;
u.EstatusBool = o.Estatus;
return(View(u));
}
private string UploadFile(userViewModel usrVm)
{
string fileName = null;
if (usrVm.UserPhoto != null)
{
string uploadDir = Path.Combine(WebHostEnvironment.WebRootPath, "Image");
fileName = Guid.NewGuid().ToString() + "-" + usrVm.UserPhoto.FileName;
string filePath = Path.Combine(uploadDir, fileName);
using (var fileStream = new FileStream(filePath, FileMode.Create))
{
usrVm.UserPhoto.CopyTo(fileStream);
}
}
return(fileName);
}
// GET: User
public ActionResult Index()
{
if (Session["USER_ID"] == null)
{
return(RedirectToAction("Login", "USER"));
}
System.Diagnostics.Debug.WriteLine("testing12221: " + Session["ORDER_ID"]);
int USER_ID;
USER_ID = Convert.ToInt32(Session["USER_ID"]);
var user = new userViewModel(USER_ID, Convert.ToInt32(Session["ORDER_ID"]));
ViewBag.User = user;
//var viewResult = new ViewResult();
//viewResult.ViewData.Model
return(View(user));
//return Content("user info:" + user.USER_FNAME + " " + user.USER_LNAME);
}
public ActionResult Create(userViewModel user)
{
user u = new user();
if (ModelState.IsValid)
{
u.idUser = user.idUser;
u.FirstName = user.FirstName;
u.LastName = user.LastName;
u.Password = user.Password;
u.Email = user.Email;
u.company_Id = user.company_Id;
service.Add(u);
service.Commit();
}
return(RedirectToAction("Index"));
}
//
// GET: /User/
public ActionResult Index()
{
IEnumerable <user> users = service.GetMany();
List <userViewModel> models = new List <userViewModel>();
foreach (user us in users)
{
userViewModel u = new userViewModel();
u.idUser = us.idUser;
u.FirstName = us.FirstName;
u.LastName = us.LastName;
u.Password = us.Password;
u.Email = us.Email;
u.company_Id = us.company_Id;
models.Add(u);
}
return(View(models));
}
public ActionResult Index()
{
var db = new ApplicationDbContext();
var o = db.Users.ToList();
var lista = new List <userViewModel>();
foreach (var item in o)
{
var usuario = new userViewModel();
usuario.Id = item.IdAuto;
usuario.Usuario = item.UserName;
usuario.Correo = item.Email;
usuario.Sexo = item.Sexo;
usuario.Estatus = item.Estatus == true ? "Activo" : "Inactivo";
lista.Add(usuario);
}
return(View(lista));
}
public IActionResult Register2(userViewModel usrVm)
{
BlogContext bc = new BlogContext();
//string FileName = UploadFile(usrVm);
string FileName = "30e9b737-e94a-4778-a827-e046858b174d-avatar.png";
var user = new UserTbl
{
UserName = usrVm.UserName,
UserEmail = usrVm.UserEmail,
UserPassword = usrVm.UserPassword,
UserPhoto = FileName
};
bc.UserTbl.Add(user);
bc.SaveChanges();
return(RedirectToAction("Index2"));
}
public async Task <UserListViewModel> Get()
{
var users = _userManager.Users;
List <userViewModel> listUsers = new List <userViewModel>();
foreach (var user in users)
{
var roles = await _userManager.GetRolesAsync(user);
var model = new userViewModel
{
Id = user.Id,
UserName = user.UserName,
Email = user.Email,
Phone = user.PhoneNumber,
userRoles = roles,
};
listUsers.Add(model);
}
UserListViewModel userlist = new UserListViewModel();
userlist.Users = listUsers;
return(userlist);
}
// GET: User
public ActionResult Index(int userid)
{
//当前登录用户的id
bool isOwner = false;
bool isAttention = false;
int now_userid = -1;
if (Session["userid"] != null)
{
now_userid = (int)Session["userid"];
}
if (now_userid == userid)
{
isOwner = true;
}
User u = lpe.User.Where(e => e.UserID == userid).FirstOrDefault();
//用户发布过的帖子
IEnumerable <Post> pub_posts = lpe.Post.Include("User").Where(e => e.Accessibility == 3).Where(e => e.User_Id == userid);
//用户评论过的帖子
IEnumerable <Comment> coms = lpe.Comment.Where(e => e.User_Id == userid);
//非用户发布帖子 评论过的帖子不包含自己发布的帖子
IEnumerable <Post> pubno_posts = lpe.Post.Where(e => e.User_Id != userid);
var query_1 = (from c in coms
join P in pubno_posts
on c.Post_Id equals P.PostID
select P).ToList();
IEnumerable <Post> com_posts = query_1;
//用户收藏的帖子 也不包含自己发布的帖子
IEnumerable <Collect> colls = lpe.Collect.Where(e => e.User_Id == userid);
var query_2 = (from c in colls
join P in pubno_posts
on c.Post_Id equals P.PostID
select P).ToList();
IEnumerable <Post> coll_posts = query_2;
//判断 当前登陆用户是否关注了访问的用户
Follow f = lpe.Follow.Where(e => (e.Followed_Person == userid && e.Fans == now_userid)).FirstOrDefault();
if (f != null)
{
isAttention = true;
}
IEnumerable <Cart> Carts = lpe.Cart.Where(e => e.UserID == userid);
IEnumerable <Adress> Adresses = lpe.Adress.Where(e => e.UserID == now_userid);
IEnumerable <Order_Detail> Order_Details = lpe.Order_Detail.Where(e => e.User_ID == now_userid);
userViewModel uvm = new userViewModel()
{
u = u,
IsOwner = isOwner,
IsAttention = isAttention,
pub_posts = pub_posts,
com_posts = com_posts,
coll_posts = coll_posts,
All_Fans = follow_repository.GetAllFans(userid),
All_Attention = follow_repository.GetAllAttention(userid),
carts = Carts,
adresses = Adresses,
order_Details = Order_Details
};
return(View(uvm));
}
public ActionResult Login(userViewModel model, string returnUrl)
{
if (ModelState.IsValid && WebSecurity.Login(model.LoginModel.UserName, model.LoginModel.Password, persistCookie: model.LoginModel.RememberMe))
{
string username = model.LoginModel.UserName;
var query = from a in db.tbUserCredentials where a.username.Contains(username) select a.userID;
tbUserCredential userCredential = db.tbUserCredentials.Where(uc => uc.username.Equals(username)).Single();
var cUserID = userCredential.userID;
//var queryaccType = from a in db.tbUsers where a.userID.Equals(cUserID) select a.accountType;
//userCredential.tbUser.accountType;
string accType = userCredential.tbUser.accountType;
if (accType.Equals("PM"))
{
Session["PM"] = model.LoginModel.UserName;
Session["pmID"] = cUserID;
Session["PMname"] = userCredential.tbUser.firstName + " " + userCredential.tbUser.lastName;
return(RedirectToAction("Home", "PM"));
}
else if (accType.Equals("Developer"))
{
Session["dev"] = model.LoginModel.UserName;
Session["devID"] = cUserID;
Session["devname"] = userCredential.tbUser.firstName + " " + userCredential.tbUser.lastName;
var dev = from a in db.tbClients where a.userID.Equals(cUserID) select a;
string isComp = dev.FirstOrDefault().isProfileComplete;
if (isComp.Equals("Yes"))
{
return(RedirectToAction("Home", "Developer"));
}
else if (isComp.Equals("No"))
{
string action = dev.FirstOrDefault().actionCont;
try
{
int skillID = dev.FirstOrDefault().tbDevelopers.FirstOrDefault().tbSkills.FirstOrDefault().skillID;
return(RedirectToAction(action, "Developer", new { id = skillID }));
}
catch
{
return(RedirectToAction(action, "Developer"));
}
}
}
else if (accType.Equals("RA"))
{
Session["RA"] = model.LoginModel.UserName;
Session["raID"] = cUserID;
Session["RAname"] = userCredential.tbUser.firstName + " " + userCredential.tbUser.lastName;
return(RedirectToAction("Home", "RequirementEngineer"));
}
else if (accType.Equals("QA"))
{
Session["QA"] = model.LoginModel.UserName;
Session["qaID"] = cUserID;
Session["QAname"] = userCredential.tbUser.firstName + " " + userCredential.tbUser.lastName;
return(RedirectToAction("Home", "QualityAssurance"));
}
}
// If we got this far, something failed, redisplay form
ModelState.AddModelError("", "The username or password is incorrect.");
return(View());
}
/// <summary>
/// on selection of button all the coulmns and their corresponing data display on grid.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DetailsInfo(object sender, RoutedEventArgs e)
{
viewModel = new userViewModel();
dgUsers.ItemsSource = viewModel.users;
dgUsers.Columns[3].Visibility = Visibility.Visible;
}
public ActionResult ViewAllUsers()
{
userViewModel currentUser = DapperORM.GetSingleUser(username);
return(View(currentUser));
}
public ActionResult UserProfile(userViewModel model)
{
DapperORM.updateUser(model);
return(RedirectToAction("UserProfile", "User", new { id = username }));
}
public ActionResult UserProfile(string Username)
{
userViewModel currentUser = DapperORM.GetSingleUser(username);
return(View(currentUser));
}
public ActionResult Register(userViewModel model)
{
if (ModelState.IsValid)
{
// Attempt to register the user
try
{
WebSecurity.CreateUserAndAccount(model.RegisterModel.UserName, model.RegisterModel.Password);
WebSecurity.Login(model.RegisterModel.UserName, model.RegisterModel.Password);
//UsersContext Udb = new UsersContext();
//model.UserProfile.UserName = model.RegisterModel.UserName;
//Udb.UserProfiles.Add(model.UserProfile);
//Udb.SaveChanges();
model.tbUser.accountType = model.RegisterModel.AccountType;
db.tbUsers.Add(model.tbUser);
db.SaveChanges();
//var query = from a in db.tbUsers where a.firstName.Contains(model.tbUser.firstName) select a.userID;
var cUserID = model.tbUser.userID;
Session["usID"] = cUserID;
string action = "";
string controller = "";
if (model.RegisterModel.AccountType.Equals("PM"))
{
tbPM PM = new tbPM();
PM.userID = cUserID;
PM.totalSpending = "0";
PM.awardedProj = "0";
db.tbPMs.Add(PM);
db.SaveChanges();
action = "Home";
controller = "PM";
Session["PM"] = model.RegisterModel.UserName;
Session["pmID"] = cUserID;
Session["PMname"] = model.tbUser.firstName + " " + model.tbUser.lastName;
}
else
{
tbClient client = new tbClient();
client.userID = cUserID;
client.totalEarning = "0";
client.awardedProjects = "0";
client.tagLine = "";
client.overview = "";
client.isProfileComplete = "No";
client.actionCont = "skillEnquiry";
client.completedTasks = 0;
db.tbClients.Add(client);
db.SaveChanges();
if (model.RegisterModel.AccountType.Equals("Developer"))
{
tbDeveloper dev = new tbDeveloper();
int id = db.tbClients.Where(c => c.userID.Equals(cUserID)).FirstOrDefault().clientID;
dev.clientID = id;
dev.affiliation = "";
db.tbDevelopers.Add(dev);
action = "skillEnquiry";
controller = "Developer";
Session["dev"] = model.RegisterModel.UserName;
Session["devID"] = cUserID;
Session["devname"] = model.tbUser.firstName + " " + model.tbUser.lastName;
}
else if (model.RegisterModel.AccountType.Equals("QA"))
{
tbQualityAssurance QA = new tbQualityAssurance();
int id = Convert.ToInt16(from a in db.tbClients where a.clientID.Equals(cUserID) select a.clientID);
QA.clientID = id;
db.tbQualityAssurances.Add(QA);
action = "Home";
controller = "QualityAssurance";
}
else if (model.RegisterModel.AccountType.Equals("RA"))
{
tbRequirementEngineer QA = new tbRequirementEngineer();
int id = db.tbClients.Where(c => c.userID.Equals(cUserID)).FirstOrDefault().clientID;
QA.clientID = id;
db.tbRequirementEngineers.Add(QA);
action = "Home";
controller = "RequirementEngineer";
Session["RA"] = model.RegisterModel.UserName;
Session["raID"] = cUserID;
Session["RAname"] = model.tbUser.firstName + " " + model.tbUser.lastName;
}
}
tbUserCredential uc = new tbUserCredential();
uc.userID = cUserID;
uc.username = model.RegisterModel.UserName;
uc.password = model.RegisterModel.Password;
uc.email = model.RegisterModel.Email;
uc.secretQ = "None";
uc.secretA = "None";
db.tbUserCredentials.Add(uc);
db.SaveChanges();
return(RedirectToAction(action, controller));
}
catch (MembershipCreateUserException e)
{
ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
// POST api/values
public void Post([FromBody] userViewModel value)
{
var res = value;
}
