public string selectRole(userDTO userDTO) { string roleOfAccount = string.Empty; roleOfAccount = userDAL.selectRoleAccount(userDTO); // to check what role of this account return(roleOfAccount); }
public userDTO getUserDTO(string emailID) { userPoco result = this.getUser(emailID); userDTO resultDTO = _userDTOMappingObject.UserMapper().Map <userDTO>(result); return(resultDTO); }
public void save(userDTO dto) { String connString = @"Data Source =SAIMA\SQLEXPRESS2012; Initial Catalog = loginDB; Integrated Security = True; Persist Security Info = True; "; using (SqlConnection conn = new SqlConnection(connString)) { conn.Open(); string sqlQuery = ""; if (dto.id > 0) { sqlQuery = string.Format(@"update dbo.userTable SET userId='{0}',userName='******',login='******',password='******',gender='{4}',adress='{5}',age='{6}',nic='{6}',dob='{7}',cricket='{8}',baseBall='{9}',personImg='{10}',email='{11}' WHERE userID{2}", dto.id, dto.name, dto.login, dto.password, dto.gender, dto.adress, dto.age, dto.nic, dto.dob, dto.cricket, dto.baseBall, dto.tennis, dto.image, dto.email); } else { sqlQuery = string.Format(@"INSERT INTO dbo.userTable(userId,userName,adress,nic, dob,,personImg,email) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", dto.id, dto.name, dto.adress, dto.nic, dto.dob, dto.image, dto.email); sqlQuery = sqlQuery + "; Select Scope_Identity()"; } SqlCommand command = new SqlCommand(sqlQuery, conn); int userid = 0; if (dto.id > 0) { command.ExecuteNonQuery(); userid = dto.id; } else { userid = Convert.ToInt32(command.ExecuteScalar()); } } }
public static List <userDTO> GetAllUser() { string sqlQuery = "select * from dbo.userTable"; using (DBHelper helper = new DBHelper) { var reader = helper.ExecuteReader(sqlQuery); List <userDTO> dt = new List <userDTO>(); while (reader.Read() == true) { userDTO dto = new userDTO(); dto.id = reader.GetInt32(reader.GetOrdinal("userId")); dto.name = reader.GetString(reader.GetOrdinal("userName")); dto.login = reader.GetString(reader.GetOrdinal("login")); dto.password = reader.GetString(reader.GetOrdinal("password")); dto.gender = Convert.ToChar(reader.GetString(reader.GetOrdinal("gender"))); dto.adress = reader.GetString(reader.GetOrdinal("adress")); dto.age = reader.GetInt32(reader.GetOrdinal("age")); dto.nic = reader.GetString(reader.GetOrdinal("nic")); dto.dob = reader.GetDateTime(reader.GetOrdinal("dob")); dto.cricket = reader.GetBoolean(reader.GetOrdinal("cricket")); dto.baseBall = reader.GetBoolean(reader.GetOrdinal("baseBall")); dto.tennis = reader.GetBoolean(reader.GetOrdinal("tennis")); dto.image = reader.GetString(reader.GetOrdinal("personImg")); dto.email = reader.GetString(reader.GetOrdinal("email")); if (dto != null) { dt.Add(dto); } } return(dt); } }
public userDTO getCompleteUserSnapshot(string emailAddress) { userPoco userPocoObject = userCRUDValidationObject.getCompletUserProfile(emailAddress); userDTO userDTOObject = userDTOMappingObject.UserMapper().Map <userDTO>(userPocoObject); return(userDTOObject); }
public IList <IuserDTO> readAllUser() { IList <IuserDTO> Ilist = new List <IuserDTO>(); using (this.connection = DbProviderFactories.GetFactory(provider).CreateConnection()) { DbConnectionStringBuilder builder = new DbConnectionStringBuilder(); builder.ConnectionString = this.connectionString; this.connection.ConnectionString = builder.ConnectionString; connection.Open(); DataSet person = new DataSet(); DbDataAdapter tableAdapter = DbProviderFactories.GetFactory(provider).CreateDataAdapter(); DbCommand cmd = DbProviderFactories.GetFactory(provider).CreateCommand(); cmd.Connection = this.connection; cmd.CommandText = "Select * FROM userInfo"; tableAdapter.SelectCommand = cmd; tableAdapter.Fill(person, "Person"); if (person != null & person.Tables.Count > 0) { foreach (DataRow dataRow in person.Tables["Person"].Rows) { IuserDTO user = new userDTO((int)dataRow["Id"]); user.AGE = (int)dataRow["Age"]; user.GENDER = (int)dataRow["Gender"]; user.NAME = (string)dataRow["Name"]; user.MARRIAGESTATUS = (int)dataRow["MarriageStatus"]; Ilist.Add(user); } } } return(Ilist); }
public IList <IuserDTO> readAllUser() { Connect(); DbCommand cmd = this.dfp.CreateCommand(); string sql = "Select * FROM userInfo"; cmd.Connection = this.connection; cmd.CommandText = sql; IList <IuserDTO> Ilist = new List <IuserDTO>(); IuserDTO user; using (DbDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { user = new userDTO(int.Parse(dr["Id"].ToString())); user.NAME = dr["Name"].ToString(); user.AGE = int.Parse(dr["Age"].ToString()); user.GENDER = int.Parse(dr["Gender"].ToString()); user.MARRIAGESTATUS = int.Parse(dr["MarriageStatus"].ToString()); Ilist.Add(user); } } Disconnect(); return(Ilist); }
public int validateUser(userDTO userObj) { String connString = @"Data Source=.\SQLEXPRESS2012; Initial Catalog=Assignment8; Integrated Security=True; Persist Security Info=True;"; using (SqlConnection conn = new SqlConnection(connString)) { conn.Open(); String sqlQuery = String.Format(@"Select * from dbo.users where login=@Login and password=@Password"); SqlCommand command = new SqlCommand(sqlQuery, conn); SqlParameter param = command.Parameters.AddWithValue("@Login", userObj.txtLogin); if (userObj.txtLogin == null) { param.Value = DBNull.Value; } param = command.Parameters.AddWithValue("@Password", userObj.txtPassword); if (userObj.txtPassword == null) { param.Value = DBNull.Value; } SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { reader.Read(); int id = reader.GetInt32(reader.GetOrdinal("id")); return(id); } } return(0); }
public async Task <IActionResult> GetUser(Guid id) { var user = _services.GetUser(id); var _userDTO = new userDTO(); _userDTO = await user; return(Ok(_userDTO)); }
public void Save(userDTO dto) { using (TestEFCoreContext db = new TestEFCoreContext()) { db.User.Add(Mapper.Map <userDTO, User>(dto)); db.SaveChanges(); } }
public ActionResult VisitorsLog() { var user = new userDTO() { userList = _db.signups.ToList() }; return(View(user)); }
public userDTO getUser(string emailAddress) { userDTO resultDTO = userCRUDValidationObject.getUserDTO(emailAddress); //TODO DTO: Map the DTO to POCO here //userDTO userDTOObject = null; //userDTO userDTOObject = userDTOMappingObject.UserMapper().Map<userDTO>(userPocoObject); return(resultDTO); }
public void AddUser(userDTO user) { using (var db = new OnlineStoreEntities()) { user_id target = mapper.Map <user_id>(user); db.user_id.Add(target); db.SaveChanges(); } }
public void createUser(userDTO newUser) { var userEntity = new User(); userEntity.userName = newUser.userName; userEntity.email = newUser.email; userEntity.password = newUser.password; userContext.Database.Log = s => { System.Diagnostics.Debug.WriteLine(s); }; userContext.User.Add(userEntity); userContext.SaveChanges(); }
public int validateUser(userDTO userObj) { userDAO userObjDAO = new userDAO(); int id = userObjDAO.validateUser(userObj); if (id != 0) { return(id); } return(0); }
static void PrintSingleUser(userDTO user) { if (user.address == null) { user.address = "none"; Console.WriteLine(user.id + "\t" + user.user_name + "\t" + user.first_Name + "\t" + user.last_Name + "\t" + user.address); } else { Console.WriteLine(user.id + "\t" + user.user_name + "\t" + user.first_Name + "\t" + user.last_Name + "\t" + user.address); } }
public static userDTO GetUserById(int pid) { var query = string.Format("Select * from dbo.userTable WHERE userId={0}", pid); using (DBHelper helper = new DBHelper()) { var reader = helper.ExecuteReader(query); userDTO dto = null; if (reader.Read()) { dto = fillDTO(reader); } return(dto); } }
public int createUser(userDTO newUser) { var userDal = new UserDAL(); var userDetail = find(newUser.email); if (userDetail != null) { return(0); } else { userDal.createUser(newUser); return(1); } }
public ActionResult ValidateUser(String Login, String Password) { userDTO userInfo = userBO.validateUser(Login, Password); bool flag = false; if (userInfo != null) { sessionManager.User = userInfo; flag = true; } var data = new { success = flag }; return(Json(data, JsonRequestBehavior.AllowGet)); }
public int UpdateUser(userDTO user) { using (OnlineStoreEntities db = new OnlineStoreEntities()) { user_id target = db.user_id .Where(u => u.id == user.id) .FirstOrDefault(); //target = mapper.Map<user_id>(user); target.user_name = user.user_name; target.first_Name = user.first_Name; target.last_Name = user.last_Name; target.address = user.address; db.SaveChanges(); return(target.id); } }
private static userDTO fillDTO(SqlDataReader reader) { var dto = new userDTO(); dto.id = reader.GetInt32(0); dto.name = reader.GetString(1); dto.password = reader.GetString(2); dto.login = reader.GetString(3); dto.gender = reader.GetChar(4); dto.adress = reader.GetString(5); dto.age = reader.GetInt32(6); dto.image = reader.GetString(7); dto.cricket = reader.GetBoolean(8); dto.baseBall = reader.GetBoolean(9); dto.tennis = reader.GetBoolean(10); dto.email = reader.GetString(11); return(dto); }
public async Task <string> Logout(userDTO userInfo) { var user = await userManager.FindByNameAsync(userInfo.Username); if (user != null) { user.LoggedIn = false; await userManager.UpdateAsync(user); //comment out if using postman await chatHub.SendUpdatedUser(user.UserName, user.LoggedIn); await chatHub.UpdateLastVisited(user.UserName); return(user.UserName); } return("User Not Found"); }
public ActionResult Login(userDTO userObj) { userBA userObjBA = new userBA(); int id = userObjBA.validateUser(userObj); if (id != 0) { Session["user"] = userObj.txtLogin; Session["userId"] = id; return(Redirect("/home/home")); } else { ViewBag.txtLogin = userObj.txtLogin; ViewBag.msg = "Incorrect Info"; } return(View()); }
public userDTO find(string email) { userContext.Database.Log = s => { System.Diagnostics.Debug.WriteLine(s); }; var userEntity = userContext.User.SingleOrDefault(user => string.Equals(user.email, email)); if (userEntity == null) { return(null); } else { var userDto = new userDTO(); userDto.userName = userEntity.userName; userDto.password = userEntity.password; userDto.email = userEntity.email; return(userDto); } }
public IuserDTO ReadUser(int userID) { IuserDTO user = null; using (var database = new Company.Person.EntityFrameworkDAL.PersonEntities()) { var result = (from row in database.userInfoes where row.Id == userID select row).FirstOrDefault(); if (result != null) { user = new userDTO(result.Id); user.NAME = result.Name; user.AGE = result.Age; user.GENDER = result.Gender; user.MARRIAGESTATUS = result.MarriageStatus; } } return(user); }
public static int save(userDTO dto) { string sqlQuery = ""; if (dto.id > 0) { sqlQuery = string.Format(@"update dbo.userTable SET userId='{0}',userName='******',password='******' WHERE userID{2}", dto.id, dto.name, dto.password); } else { sqlQuery = string.Format(@"INSERT INTO dbo.userTable(userId,userName,adress,nic, dob,,personImg,email) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", dto.id, dto.name, dto.adress, dto.nic, dto.dob, dto.image, dto.email); sqlQuery = sqlQuery + "; Select Scope_Identity()"; } using (DBHelper helper = new DBHelper()) { return(helper.ExecuteQuery(sqlQuery)); } }
public static int save(userDTO dto) { string sqlQuery = ""; if (dto.id > 0) { sqlQuery = string.Format(@"update dbo.userTable SET userId='{0}',userName='******',login='******',password='******',gender='{4}',adress='{5}',age='{6}',nic='{6}',dob='{7}',cricket='{8}',baseBall='{9}',personImg='{10}',email='{11}' WHERE userID{2}", dto.id, dto.name, dto.login, dto.password, dto.gender, dto.adress, dto.age, dto.nic, dto.dob, dto.cricket, dto.baseBall, dto.tennis, dto.image, dto.email); } else { sqlQuery = string.Format(@"INSERT INTO dbo.userTable(userId,userName,adress,nic, dob,,personImg,email) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", dto.id, dto.name, dto.adress, dto.nic, dto.dob, dto.image, dto.email); sqlQuery = sqlQuery + "; Select Scope_Identity()"; } using (DBHelper helper = new DBHelper()) { return(helper.ExecuteQuery(sqlQuery)); } }
public HttpResponseMessage Register(userDTO id) { try { var newUser = new SistemaAcademico.Classes.User { Email = id.email, Name = id.Name, Name2 = id.Name2, BirthDate = id.birthdate, PhoneNum = id.phoneNum, LastName = id.LastName, UserType = id.userType, Sex = id.sex }; SHA512 SHA = new SHA512Managed(); string password = id.password; var password_bytes = ASCIIEncoding.ASCII.GetBytes(password); byte[] passBytes = new byte[password_bytes.Length]; for (int i = 0; i < password_bytes.Length; i++) { passBytes[i] = password_bytes[i]; } string hashedPass = Convert.ToBase64String(SHA.ComputeHash(passBytes)); newUser.Password = hashedPass; using (var context = new SistemaAcademico.DataModel.AcademicSystemContext()) { context.Usuarios.Add(newUser); context.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, newUser.UserId)); } } catch (Exception e) { if (e.InnerException != null) { return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public ActionResult RegisterUser(userDTO userInfo) { int id = userBO.save(userInfo); bool flag = true; if (id == 0) { flag = false; } else { userInfo.id = id; sessionManager.user = userInfo; } var data = new { success = flag }; return(Json(data, JsonRequestBehavior.AllowGet)); }
public static userDTO validateUser(String login, String password) { String query = String.Format("SELECT * FROM userInfo.user where login='******' and password='******'", login, password); using (sqlConn connection = new sqlConn()) { userDTO user = new userDTO(); var reader = connection.ExcueteReader(query); if (reader.Read()) { user.id = reader.GetInt32(0); user.login = reader.GetString(1); user.name = reader.GetString(2); user.password = reader.GetString(3); } else { user = null; } return(user); } }