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);
}
}