public static void SetParameters(tblUser U, string account)
{
UserName = U.FirstName+" "+U.Surname;
UserID = U.ID;
Roles_GroupID = U.RoleGroupID;
Email = U.Email;
Account = account;
AccountID = U.AccountID;
}
protected void btnRegister_Click(object sender, EventArgs e)
{
tblUser user = new tblUser();
user.fldUsername = txtUser.Text.Trim();
user.fldPassword = txtPassword.Text.Trim();
user.fldRole = txtRole.Text.Trim().ToLower();
if (!DBAccess.DoesUsernameAlreadyExists(user.fldUsername))
{
DBAccess.CreateUser(user);
lblInfo.Text = "User Created Successfully!";
}
}
public void TestMethod1()
{
try
{
var test = new SampleArchitecture.NativeDAL.RNDEntities();
////var value = test.User.Add(new tblUser { Id = 5, Name = "hello", Password = "******" });
var tlbuser = new tblUser { ID = 24, Name = "hello24", Password = "******" };
var value = test.User.Add(tlbuser);
}
catch (Exception)
{
}
}
protected void btnSignUp_Click(object sender, EventArgs e)
{
dbDataContext db = new dbDataContext();
tblUser user = new tblUser();
user.password = txtpass1.Text;
user.pkeid = txteid.Text;
user.status = "unBlock";
user.uname = txtuname.Text;
db.tblUsers.InsertOnSubmit(user);
db.SubmitChanges();
Response.Redirect("SignIn.aspx");
}
internal bool SaveStripeDetails(StripeModel objReq)
{
using (var db = new WizzDataContext())
{
tblUser userData = new tblUser();
userData = db.tblUsers.Where(x => x.pkUserId == Convert.ToInt64(objReq.userId)).FirstOrDefault();
userData.stripeId = objReq.stripeAcKey;
db.SubmitChanges();
return true;
}
}
internal string adminLogin(AdminModel objReq)
{
string i = "0";
try
{
using (var db = new WizzDataContext())
{
tblUser admin = new tblUser();
if (objReq != null)
{
admin = db.tblUsers.Where(e => e.userEmail == objReq.email && e.registerType == 1).FirstOrDefault();
if (admin != null)
{
if (objReq.password.ToLower() == admin.password)
{
i = "loggedIn";
CurrentUser user = new CurrentUser()
{
PkUserId = Convert.ToString(admin.pkUserId),
Email = admin.userEmail,
isActive = Convert.ToString(admin.isActive),
usertype = Convert.ToString(admin.registerType),
};
string json = JsonConvert.SerializeObject(user);
FormsAuthentication.SetAuthCookie(json, true);
}
else
{
i = "Invalid password !";
}
}
else
{
i = "The Email Id is not registered with us !";
}
}
return i;
}
}
catch (Exception ex)
{
i = ex.ToString();
return i;
}
}
internal RespIsTeacherRequest isTeacher(IsTeacherRequest objReq)
{
var isTutor = Convert.ToBoolean(objReq.isTutor);
RespIsTeacherRequest response = new RespIsTeacherRequest();
response.isAlreadySignup = "False";
using (var db = new WizzDataContext())
{
tblUser tUser = new tblUser();
int fkuserid = Convert.ToInt32(objReq.userId);
tUser = db.tblUsers.Where(x => x.pkUserId == fkuserid).FirstOrDefault();
if (tUser == null)
response.isTutor="False";
// return false;
else
{
var tutor = db.tblTutorProfiles.Where(t => t.fkUserId == fkuserid).FirstOrDefault();
//check already signup or not
if (tutor==null)
{
response.isAlreadySignup = "False";
}
else
{
response.isAlreadySignup = "True";
}
if (tutor == null && objReq.isTutor=="True")
{
response.isAlreadySignup = "False";
}
else
{
response.isTutor = isTutor.ToString();
tUser.isTeacher = isTutor;
db.SubmitChanges();
}
// return true;
}
}
return response;
}
internal int ChangePassword(AdminChangePassword objReq)
{
using (var db = new WizzDataContext())
{
tblUser tUser = new tblUser();
CurrentUser cu = new CurrentUser();
tUser = db.tblUsers.Where(x => x.pkUserId == Convert.ToInt32(cu.PkUserId)).FirstOrDefault();
if (tUser.password != objReq.oldPassword)
return 0;
else
{
tUser.password = objReq.newPassword.Trim();
db.SubmitChanges();
return 1;
}
}
}
public int AddNew(LoginUser loginUser)
{
if (null != loginUser)
{
using (var entities = new atmEntities())
{
// check existing
var exist = (from a in entities.tblUsers where a.LoginId == loginUser.LoginId select a).SingleOrDefault();
if (null != exist)
{
loginUser.UserId = exist.UserId;
return Update(loginUser);
}
var u = new tblUser
{
UserName = loginUser.UserName,
AlternativeEmail = loginUser.AlternativeEmail,
ApplicantId = loginUser.ApplicantId,
Email = loginUser.Email,
FullName = loginUser.FullName.ToUpper(),
Password = loginUser.Password,
Salt = loginUser.Salt,
LoginId = loginUser.LoginId,
FirstTime = loginUser.FirstTime,
IsLocked = loginUser.IsLocked,
LastLoginDt = loginUser.LastLoginDt,
LastLoginDt2 = loginUser.LastLoginDt2,
ServiceCd = loginUser.ServiceCd,
CreatedBy = loginUser.CreatedBy,
CreatedDt = DateTime.Now,
ModifiedBy = loginUser.ModifiedBy,
ModifiedDt = loginUser.ModifiedDt
};
entities.tblUsers.Add(u);
if (entities.SaveChanges() != 0)
return u.UserId;
}
}
return 0;
}
private void deleteUserBtn_Click(object sender, EventArgs e)
{
var newConnection = new dbContextDataContext();
var currentUser = newConnection.tblUsers.Where(od => od.UniqueID == myUser.UniqueID).SingleOrDefault();
if (currentUser != null)
{
newConnection.tblUsers.DeleteOnSubmit(currentUser);
newConnection.SubmitChanges();
userLookUp.Properties.DataSource = newConnection.tblUsers;
myUser = new tblUser();
updateForm();
userLookUp.EditValue = null;
}
else
{
myUser = new tblUser();
updateForm();
userLookUp.EditValue = null;
}
}
public static int CreateUser(tblUser employee)
{
int result = 0;
using (SqlConnection con =DBConfig.GetConnection())
{
//con.Open();
string SQL = "sp_insert_User";
SqlCommand CMD = new SqlCommand(SQL, con);
string password = Encryption(employee.fldPassword);
CMD.CommandType = CommandType.StoredProcedure;
CMD.Parameters.AddWithValue("@fldUsername", employee.fldUsername);
CMD.Parameters.AddWithValue("@fldPassword", password);
CMD.Parameters.AddWithValue("@fldRole", employee.fldRole);
result = CMD.ExecuteNonQuery();
CMD.Connection.Close();
CMD = null;
return result;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Bindoffice();
BindRoles();
}
if (!string.IsNullOrEmpty(Request["id"]))
{
string aan = Request["id"].ToString();
_user = Users.getUserByAAN(aan);
if (_user == null)
{
Response.Redirect("~/admin/users.aspx");
Response.End();
}
if (!Page.IsPostBack)
{
getData();
}
}
//userinformation.aspx
}
/// <summary>
/// Get all data about users posts from the database
/// </summary>
/// <returns>The list of all users posts</returns>
public List <tblPost> GetAllUserPosts(tblUser user)
{
try
{
List <tblPost> list = new List <tblPost>();
List <tblPost> allPosts = GetAllPosts().ToList();
for (int i = 0; i < allPosts.Count; i++)
{
if (allPosts[i].UserID == user.UserID)
{
list.Add(allPosts[i]);
}
}
return(list.OrderByDescending(x => x.DateOfPost).ToList());
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public void Insert()
{
try
{
using (MusicEntities dc = new MusicEntities())
{
tblUser newuser = new tblUser();
Id = dc.tblUsers.Any() ? dc.tblUsers.Max(p => p.Id) + 1 : 1;
UserPass = GetHash();
//Set the class details to the datarow
Map(newuser);
dc.tblUsers.Add(newuser);
dc.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int Update(User user)
{
using (BoBEntities bob = new BoBEntities())
{
tblUser row = bob.tblUsers.FirstOrDefault(c => c.Id == user.Id);
int results = 0;
if (row != null)
{
row.FirstName = user.FirstName;
row.LastName = user.LastName;
row.Password = GetHash(user.Password);
row.Username = user.Username;
row.ImageSource = user.ImageSource;
results = bob.SaveChanges();
}
else
{
throw new Exception("Row was not found");
}
return(results);
}
}
public void StudentDelete()
{
try
{
using (ITIndeedEntities dc = new ITIndeedEntities())
{
tblStudent student = dc.tblStudents.Where(s => s.Id == this.StudentID).FirstOrDefault();
tblUser user = dc.tblUsers.Where(u => u.Id == student.UserId).FirstOrDefault();
if (student != null)
{
dc.tblStudents.Remove(student);
dc.tblUsers.Remove(user);
dc.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
using (var obj = new OntologyDataContext())
{
if (OntologyHelper.Context.tblUsers.Count(a => a.UserName == txtUsername.Text) > 0)
{
lblError.Text = "User Name already exists";
}
else
{
var user = new tblUser();
user.Date = DateTime.Now;
user.MailId = txtMailId.Text;
user.MobileNumber = Convert.ToInt64(txtMobileNumber.Text);
user.Password = txtPassword.Text;
user.UserName = txtUsername.Text;
obj.tblUsers.InsertOnSubmit(user);
obj.SubmitChanges();
Session["UserName"] = txtUsername.Text;
Response.Redirect("Home.aspx");
}
}
}
// GET: Admin/tblRegistrations/Edit/5
public ActionResult Acept(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblRegistration tblRegistration = db.tblRegistrations.Find(id + ".com");
if (tblRegistration == null)
{
return(HttpNotFound());
}
db.tblRegistrations.Remove(tblRegistration);
db.SaveChanges();
tblUser user = new tblUser();
user.email = tblRegistration.email;
user.password = tblRegistration.password;
user.role = "User";
db.tblUsers.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public tblUser GetUsernamePassword(string username, string password)
{
try
{
using (CakeRecipesDBEntities context = new CakeRecipesDBEntities())
{
string usernameFromDB = (from e in context.tblUsers where e.Username == username select e.Username).FirstOrDefault();
if (username == usernameFromDB)
{
tblUser user = (from e in context.tblUsers where e.Username.Equals(username) where e.UserPassword.Equals(password) select e).First();
return(user);
}
return(null);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public static bool IsUserDeferred(long userId, out DateTime?deferUntil)
{
deferUntil = DateTime.Now;
DataClassesDataContext dataContext = new DataClassesDataContext();
var varUser = from userinfo in dataContext.tblUsers where userinfo.Id == userId select userinfo;
tblUser oUser = varUser.FirstOrDefault();
if (oUser != null)
{
if (oUser.IsDefferred)
{
deferUntil = oUser.DebarUntil;
return(true);
}
else
{
deferUntil = null;
return(false);
}
}
return(false);
}
public static void ReactivateUser(long userId, bool removeBar, bool removeDefer)
{
DataClassesDataContext dataContext = new DataClassesDataContext();
var varUser = from userinfo in dataContext.tblUsers where userinfo.Id == userId select userinfo;
tblUser oUser = varUser.FirstOrDefault();
if (oUser != null)
{
if (removeBar)
{
oUser.IsDebarred = false;
oUser.DebarUntil = null;
}
if (removeDefer)
{
oUser.IsDefferred = false;
oUser.DeferUntil = null;
}
//dataContext.tblUsers.DeleteOnSubmit(oUser);
}
dataContext.SubmitChanges();
}
// GET: ProductCategories/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblUser objSource = (tblUser)Session["UserDetails"];
tblProductCategory tblProductCategory = db.tblProductCategories.Find(id);
if (tblProductCategory == null)
{
return(HttpNotFound());
}
else
{
tblProductCategory.IsActive = false;
tblProductCategory.UpdatedBy = objSource.Id;
tblProductCategory.UpdatedOn = DateTime.Now;
db.Entry(tblProductCategory).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Vote(int?id, int star)
{
HttpCookie member_cookie = Request.Cookies["member_id"];
tblUser user = db.tblUsers.Find(int.Parse(member_cookie.Value.ToString()));
if (db.tblRates.FirstOrDefault(t => t.Rate_Post == id && t.Rate_User == user.User_ID) != null)
{
db.tblRates.FirstOrDefault(t => t.Rate_Post == id && t.Rate_User == user.User_ID).Rate_Star = star;
}
else
{
tblRate addItem = new tblRate()
{
Rate_User = user.User_ID,
Rate_Star = star,
Rate_Post = id,
Rate_DateVote = DateTime.Now
};
db.tblRates.Add(addItem);
}
db.SaveChanges();
return(RedirectToAction("Details", new { id }));
}
public ActionResult Create([Bind(Include = "Username,Firstname,Lastname,Password,Administrator,Gesperrt")] tblUser tblUser)
{
if (Verify.IsUserAdmin(User.Identity.Name))
{
try
{
if (ModelState.IsValid)
{
db.tblUser.Add(tblUser);
db.SaveChanges();
return(RedirectToAction("Start"));
}
}
catch
{
}
return(View(tblUser));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
/// <summary>
/// Executes the Accept Frient Request
/// </summary>
private void AcceptExecute()
{
try
{
tblUser clickedUser = new tblUser()
{
FirstName = userData.GetUser(PandingUser.User1ID).FirstName,
LastName = userData.GetUser(PandingUser.User1ID).LastName
};
userData.AcceptFriendRequest(PandingUser);
FriendList = userData.GetAllFriends(LoggedInUser.CurrentUser).ToList();
PendingList = userData.GetAllPandingUsers(LoggedInUser.CurrentUser).ToList();
InfoLabel = $"Accepted {clickedUser.FirstName} {clickedUser.LastName} user friend request.";
InfoLabelBG = "#FF8BC34A";
SnackPendingInfo();
}
catch (Exception ex)
{
Xceed.Wpf.Toolkit.MessageBox.Show("Cannot accept friend request right now." + ex);
}
}
public List <tblUser> GetFriends(tblUser user)
{
try
{
using (SocialNetworkDbEntities context = new SocialNetworkDbEntities())
{
tblUser userInDb = (from x in context.tblUsers
where x.UserID == user.UserID
select x).First();
List <tblUser> list = new List <tblUser>();
list = userInDb.tblUsers1.ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
internal int ChangePassword(ChangePasswordModel objReq)
{
using (var db = new WizzDataContext())
{
tblUser tUser = new tblUser();
int fkuserid = Convert.ToInt32(objReq.userId);
tUser = db.tblUsers.Where(x => x.pkUserId == fkuserid).FirstOrDefault();
if (tUser == null)
return 0;
else if (tUser.isActive == false || tUser.isDelete == true)
return 2;
else if (tUser.password != objReq.oldPassword)
return 3;
else
{
tUser.password = objReq.Password.Trim();
db.SubmitChanges();
return 1;
}
}
}
public bool AddSong(tblUser user, vwSong song)
{
try
{
using (DAN_LEntities context = new DAN_LEntities())
{
tblSong newSong = new tblSong();
newSong.SongName = song.SongName;
newSong.Author = song.Author;
newSong.Duration = song.Duration;
newSong.UserID = user.UserID;
context.tblSongs.Add(newSong);
context.SaveChanges();
song.SongID = newSong.SongID;
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
public ActionResult Registration(RegistrationViewModel uv)
{
using (OnlineVotingSystemEntities db = new OnlineVotingSystemEntities())
{
tblUser tbl = db.tblUsers.Where(u => u.UserName == uv.UserName || u.Email == uv.Email).FirstOrDefault();
if (tbl != null)
{
return(Json(new { success = false, message = "User Already Register" }, JsonRequestBehavior.AllowGet));
}
else
{
tblUser tb = new tblUser();
tb.UserName = uv.UserName;
tb.Password = OnlineVotingSystemForCollege.Models.EncryptPassword.textToEncrypt(uv.Password);
tb.Fullname = uv.FullName;
tb.Email = uv.Email;
tb.EmailVerification = false;
tb.ActivationCode = Guid.NewGuid();
db.tblUsers.Add(tb);
db.SaveChanges();
tblUserRole ud = new tblUserRole();
ud.UserId = tb.UserId;
ud.RoleId = 2;
db.tblUserRoles.Add(ud);
db.SaveChanges();
tblIdRequest tbid = new tblIdRequest();
tbid.UserEmail = tb.Email;
tbid.FullName = tb.Fullname;
tbid.UserId = tb.UserId;
db.tblIdRequests.Add(tbid);
db.SaveChanges();
return(Json(new { success = true, message = "Registration Completed . A Email would be send to your email" + tb.Email + "If You are a Valid User" }, JsonRequestBehavior.AllowGet));
}
}
}
private bool IsUseDefaultPassword()
{
_newUserInfo = new tblUser();
_newUserInfo.Username = UIPViewModel.UserNameText;
_newUserInfo.IsAdmin = false;
_newUserInfo.IsActive = true;
_newUserInfo.FullName = UIPViewModel.FullNameText;
_newUserInfo.Address = UIPViewModel.AdressText;
_newUserInfo.Link = UIPViewModel.LinkText;
_newUserInfo.Phone = UIPViewModel.PhoneText;
_newUserInfo.Job = UIPViewModel.JobText;
_newUserInfo.Email = UIPViewModel.EmailText;
if (String.IsNullOrEmpty(UIPViewModel?.NewPassword))
{
var queryRes = App.Current.ShowApplicationMessageBox("Trường mật khẩu bị bỏ trống, bạn muốn dùng mật khẩu mặc định là \"abc@13579\"?",
HPSolutionCCDevPackage.netFramework.AnubisMessageBoxType.YesNo,
HPSolutionCCDevPackage.netFramework.AnubisMessageImage.Question,
OwnerWindow.MainScreen,
"Thông báo!");
if (queryRes == HPSolutionCCDevPackage.netFramework.AnubisMessgaeResult.ResultYes)
{
_newUserInfo.Password = "******";
return(true);
}
else
{
return(false);
}
}
else
{
_newUserInfo.Password = UIPViewModel.NewPassword;
}
return(true);
}
public ActionResult Edit(tblUser tbluser, int id, FormCollection collection)
{
if (ModelState.IsValid)
{
db.Entry(tbluser).State = EntityState.Modified;
var user = db.tblUsers.First(p => p.id == id);
string pass = tbluser.Password;
if (pass == user.Password)
{
tbluser.Password = EncryptandDecrypt.Encrypt(tbluser.Password);
}
else
{
tbluser.Password = EncryptandDecrypt.Encrypt(tbluser.Password);
}
tbluser.UserName = user.UserName;
tbluser.DateCreate = DateTime.Now;
string idUser = Request.Cookies["Username"].Values["UserID"];
tbluser.idUser = int.Parse(idUser);
db.SaveChanges();
#region [Updatehistory]
Updatehistoty.UpdateHistory("Edit User", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
#endregion
if (collection["btnSave"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã sửa tài khoản thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Users/Index"));
}
if (collection["btnSaveCreate"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm tài khoản thành công, mời bạn thêm tài khoản mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Users/Create"));
}
}
return(View(tbluser));
}
public bool EmployerLoadUserById(Guid userId)
{
try
{
using (ITIndeedEntities dc = new ITIndeedEntities())
{
tblEmployer employer = dc.tblEmployers.Where(e => e.UserId == userId).FirstOrDefault();
tblUser user = dc.tblUsers.Where(u => u.Id == employer.UserId).FirstOrDefault();
if (employer != null & user != null)
{
this.EmployerId = employer.Id;
this.RepresentativeFirstName = employer.RepresentativeFirstName;
this.RepresentativeLastName = employer.RepresentativeLastName;
this.Phone = employer.Phone;
this.Email = employer.Email;
this.OrganizationName = employer.OrganizationName;
this.Industry = employer.Industry;
this.Password = user.Password;
this.UserName = user.UserName;
this.UserId = employer.UserId;
this.ProfilePicture = employer.ProfilePicture;
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult SignUp(tblAccount account, tblUser usertbl)
{
var listacc = (from acc_check in data.tblAccounts where acc_check.userName == account.userName select acc_check).FirstOrDefault();
if (listacc == null)
{
using (data)
{
try
{
tblAccount acc = new tblAccount();
acc = account;
data.tblAccounts.Add(acc);
data.SaveChanges();
int idacc = data.tblAccounts.Max(id => id.id_acc);
tblUser User = new tblUser();
User.id_acc = idacc;
User.nickName = usertbl.nickName;
data.tblUsers.Add(User);
data.SaveChanges();
Session["account"] = acc;
Session["nickName"] = usertbl.nickName;
return(Json(new { Result = "True" }));
}
catch (Exception ex)
{
return(Json(new { Result = ex }));
}
}
}
else
{
return(Json(new { Result = "Tài khoản đã tồn tại" }));
}
return(View("Index_Login"));
}
public static async Task <bool> UserLogin(string url)
{
tblUser tbluser = new tblUser();
bool result = false;
var request = System.Net.WebRequest.Create(url) as HttpWebRequest;
if (request != null)
{
request.Method = "GET";
request.ServicePoint.Expect100Continue = false;
request.Timeout = 20000;
request.ContentType = "application/json";
using (WebResponse response = await request.GetResponseAsync())
{
using (Stream stream = response.GetResponseStream())
{
string x = JsonObject.Load(stream).ToString();
JsonObject jObj = (JsonObject)JsonObject.Parse(x);
JsonArray jArr = (JsonArray)jObj["result"];
foreach (var item in jArr)
{
tbluser.id = 1;
tbluser.userid = Convert.ToString((int)item["id"]);
tbluser.username = item ["username"];
tbluser.password = item ["password"];
tbluser.fname = item ["fname"];
tbluser.lname = item ["lname"];
tbluser.token = item ["token"];
tbluser.status = "1";
GlobalVariables.GlobalUserid = Convert.ToString((int)item["id"]);
ItemRepository.UserLogin(tbluser);
}
}
}
}
return(result);
}
/// <summary>
/// Deletes user if the uderID exists
/// </summary>
/// <param name="userID">the user that is being deleted</param>
public void DeleteUser(int userID)
{
List <tblUser> allUsers = GetAllUsers();
try
{
using (EmployeeDBEntities context = new EmployeeDBEntities())
{
bool isUser = IsUserID(userID);
if (isUser == true)
{
// find the user before removing them
tblUser userToDelete = (from r in context.tblUsers where r.UserID == userID select r).First();
// Update the manager id for users where we deleted their manager
for (int i = 0; i < allUsers.Count; i++)
{
if (userToDelete.UserID == allUsers[i].ManagerID)
{
int? managerID = allUsers[i].ManagerID;
tblUser usersToEdit = (from ss in context.tblUsers where ss.ManagerID == managerID select ss).First();
usersToEdit.ManagerID = null;
context.SaveChanges();
}
}
context.tblUsers.Remove(userToDelete);
context.SaveChanges();
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public async Task <bool> ChangePwd(User user)
{
try
{
var repo = uow.UserRepo();
tblUser temp = null;
foreach (var item in await repo.GetEntities())
{
if (item.UserId == user.UserId)
{
temp = item;
break;
}
}
if (null == temp)
{
return(false);
}
temp.Salt = BCrypt.Net.BCrypt.GenerateSalt();
temp.Pwd = BCrypt.Net.BCrypt.HashPassword(user.Pwd.Trim(), temp.Salt);
var GUID = Guid.NewGuid();
byte[] key = GUID.ToByteArray();
string token = Convert.ToBase64String(key.ToArray());
temp.Uid = GUID.ToString();
temp.Token = token;
var filter = Builders <tblUser> .Filter.Eq(x => x.UserId, temp.UserId);
return(await repo.UpdateEntities(filter, temp));
}
catch (Exception)
{
return(false);
throw;
}
}
public SavingResult ApproveUser(int UserID, bool Approval)
{
SavingResult res = new Models.Template.SavingResult();
using (dbUltraCoralEntities db = new DAL.dbUltraCoralEntities())
{
tblUser SaveModel = db.tblUsers.Find(UserID);
if (SaveModel == null)
{
res.ExecutionResult = eExecutionResult.ValidationError;
res.ValidationError = "Invalid request. User has been deleted or moved.";
return(res);
}
SaveModel.IsApproved = Approval;
SaveModel.redt = DateTime.Now;
SaveModel.reuid = (Common.Props.LoginUser != null? (int?)Common.Props.LoginUser.UserID : null);
db.tblUsers.Attach(SaveModel);
db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified;
//--
try
{
db.SaveChanges();
res.PrimeKeyValue = SaveModel.UserID;
res.ExecutionResult = eExecutionResult.CommitedSucessfuly;
}
catch (Exception ex)
{
ex = Common.Functions.FindFinalError(ex);
res.ExecutionResult = eExecutionResult.ErrorWhileExecuting;
res.Exception = ex;
}
}
return(res);
}
public bool EmployerInsert()
{
try
{
using (ITIndeedEntities dc = new ITIndeedEntities())
{
tblUser user = new tblUser();
user.UserName = this.UserName;
user.Password = this.Password;
this.UserInsert();
tblUser userGetUserId = dc.tblUsers.Where(u => u.UserName == this.UserName).FirstOrDefault();
Guid guidUserId = userGetUserId.Id;
tblEmployer employer = new tblEmployer();
employer.Id = Guid.NewGuid();
employer.RepresentativeFirstName = this.RepresentativeFirstName;
employer.RepresentativeLastName = this.RepresentativeLastName;
employer.Phone = this.Phone;
employer.Email = this.Email;
employer.OrganizationName = this.OrganizationName;
employer.Industry = this.Industry;
employer.UserId = guidUserId;
employer.ProfilePicture = this.ProfilePicture;
dc.tblEmployers.Add(employer);
dc.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddEmployee(vwEmployee addemployee)
{
try
{
using (DAN_LIIIEntities context = new DAN_LIIIEntities())
{
tblUser user = new tblUser
{
DateOfBirth = addemployee.DateOfBirth,
Email = addemployee.Email,
NameSurname = addemployee.NameSurname,
Pasword = addemployee.Pasword,
Username = addemployee.Username
};
context.tblUsers.Add(user);
context.SaveChanges();
addemployee.UserID = user.UserID;
tblEmployee employee = new tblEmployee
{
UserID = user.UserID,
Citizenship = addemployee.Citizenship,
Engagment = addemployee.Engagment,
Gender = addemployee.Gender,
HotelFloor = addemployee.HotelFloor,
};
context.tblEmployees.Add(employee);
context.SaveChanges();
addemployee.EmployeeID = employee.EmployeeID;
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonResult SaveUser(UserViewModel model)
{
var result = false;
try
{
if (model.userId > 0)
{
tblUser u = db.tblUsers.SingleOrDefault(x => x.isDeleted == false && x.userId == model.userId);
u.userName = model.userName;
u.userEmail = model.userEmail;
u.userPassword = model.userPassword;
u.status = model.status;
u.designationId = model.designationId;
db.SaveChanges();
result = true;
}
else
{
tblUser u = new tblUser();
u.userName = model.userName;
u.userEmail = model.userEmail;
u.userPassword = model.userPassword;
u.status = model.status;
u.isDeleted = false;
u.designationId = model.designationId;
db.tblUsers.Add(u);
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
///
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public bool UpdateUser(tbUser u)
{
tblUser u1 = new tblUser();
var info = (from u2 in db.tblUsers where u2.Id == u.Id select u2).FirstOrDefault();
tbUser c1 = GetUserDetail().Find(delegate(tbUser o) { return(u.EmailId.Trim().Equals(o.EmailId.Trim())); });
u1 = (tblUser)info;
if (c1 != null && c1.Id != u.Id)
{
return(false);
}
else
{
if (info != null)
{
u1.Id = u.Id;
u1.FirstName = u.FName;
u1.LastName = u.LName;
u1.PhoneNo = u.PhoneNumber;
u1.CellPhoneNo = u.CellPhone;
u1.EmailId = u.EmailId;
//u1.CreatedDate = u.CreatedDate;
u1.ModifyDate = DateTime.Now;
u1.Password = u.Password;
u1.Status = u.Status;
}
try
{
db.SubmitChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
//------------------- END PASSWORD METHODS ---------------------
#endregion User Password
#region Password Recovery
//------------------- START PASSWORD RECOVERY METHODS ---------------------
// Generate ForgotPasswordKey
public Guid ForgotPasswordKeyGen(string email)
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Create a new row in the table for this forgotten password request
tblUser user = dc.tblUsers.Where(u => u.Email == email).FirstOrDefault();
tblForgotPassword fp = new tblForgotPassword();
ForgotPasswordList previouslinks = new ForgotPasswordList();
// Clears previous reset links associated with user
previouslinks.ClearForgottenPasswordsByUser(user);
try
{
// Inserting new reset link in DB (User currently has none in DB here)
fp.Id = Guid.NewGuid();
fp.UserId = dc.tblUsers.FirstOrDefault(u => u.Email == email).Id;
// Expiration of reset link set to 2 hours from link creation
fp.ExpirationDate = DateTime.Now.AddHours(2);
dc.tblForgotPasswords.Add(fp);
dc.SaveChanges();
return(fp.Id);
}
catch (Exception ex)
{
throw ex;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// method for adding new user
/// </summary>
private void SaveExecute()
{
try
{
using (SocialNetworkEntities context = new SocialNetworkEntities())
{
tblUser newUser = new tblUser();
newUser.FirstName = user.FirstName;
newUser.LastName = user.LastName;
newUser.BirthDate = user.BirthDate;
newUser.Username = user.Username;
if (PasswordValidation(user.UserPassword))
{
newUser.UserPassword = user.UserPassword;
}
else
{
MessageBox.Show("Wrong password. Password must have at least 8 characters.\n(1 upper char, 1 lower char, 1 number and 1 special char)\nPlease try again.");
}
newUser.UserID = user.UserID;
context.tblUsers.Add(newUser);
context.SaveChanges();
MessageBox.Show("The user created successfully.");
}
signUp.Close();
}
catch (Exception)
{
MessageBox.Show("Wrong inputs, please check your inputs or try again.");
}
}
public int CreateNewUser(LoginUser user, List<string> messages)
{
using (var entities = new atmEntities())
{
var exist = (from a in entities.tblUsers where a.LoginId == user.LoginId select a).SingleOrDefault();
if (null != exist) return 0;
var usr = new tblUser
{
AlternativeEmail = user.AlternativeEmail,
ApplicantId = user.ApplicantId,
CreatedBy = user.CreatedBy,
CreatedDt = DateTime.Now,
FullName = user.FullName,
FirstTime = user.FirstTime,
Email = user.Email,
IsLocked = user.IsLocked,
LastLoginDt = user.LastLoginDt,
LoginId = user.LoginId,
Password = ObjectBuilder.GetObject<ICryptorService>("CryptorService").ComputeHashInString(user.Salt, user.Password),
Salt = user.Salt,
ServiceCd = user.ServiceCd,
UserName = user.UserName
};
if (entities.SaveChanges() > 0)
{
messages.Add("Berjaya");
return usr.UserId;
}
messages.Add("Tidak Berjaya");
}
return 0;
}
partial void DeletetblUser(tblUser instance);
partial void UpdatetblUser(tblUser instance);
partial void InserttblUser(tblUser instance);
internal bool UserLogout(ReqLogOut objReq)
{
using (var db = new WizzDataContext())
{
tblUser tUser = new tblUser();
int fkuserid = Convert.ToInt32(objReq.userId);
tUser = db.tblUsers.Where(x => x.pkUserId == fkuserid).FirstOrDefault();
if (tUser == null)
return false;
else
{
tUser.deviceToken = null;
db.SubmitChanges();
return true;
}
}
}
//internal bool AcceptStudent(StudentTeacherMap objReq)
//{
// // var isTutor = Convert.ToBoolean(objReq.userId);
// using (var db = new WizzDataContext())
// {
// if (objReq.isAccept.ToLower() == "true")
// {
// tblRequest reqStudent = new tblRequest();
// var studentList = db.tblRequestStudents.Where(x => x.isAccepted != true && x.isDelete == false && x.uniqueRequestId == objReq.uniqueRequestId && x.fkUserId == Convert.ToInt32(objReq.tutorId)).ToList();
// studentList.ForEach(a => { a.isAccepted = true; a.updatedDate = DateTime.UtcNow; });
// db.SubmitChanges();//update student request
// var totalList = db.tblRequests.Where(x => x.isAccepted != true && x.uniqueRequestId == objReq.uniqueRequestId && x.fkStudentId==Convert.ToInt32(objReq.studentId)).ToList();
// var deleteList = totalList.Where(x => x.fkTutorId != Convert.ToInt32(objReq.tutorId)).ToList();
// //delete all tutors who recived the notiifcation except the tutor who is accepeting the notification
// reqStudent = totalList.Where(x => x.fkTutorId == Convert.ToInt32(objReq.tutorId)).FirstOrDefault();
// db.tblRequests.DeleteAllOnSubmit(deleteList);
// db.SubmitChanges();
// //accept the request
// if (reqStudent == null)//if request is not exist
// return false;
// reqStudent.isAccepted = true;
// reqStudent.updatedDate = DateTime.UtcNow;
// var userData = db.tblUsers.Where(x => x.pkUserId == Convert.ToInt32(objReq.studentId)&& x.isTeacher==false).FirstOrDefault();
// var teacherData = db.tblUsers.Where(x => x.pkUserId == Convert.ToInt32(objReq.tutorId)).FirstOrDefault();
// if (userData!=null &&!string.IsNullOrEmpty(userData.deviceToken))
// {
// // objPush.type = Convert.ToInt16(PushType.acceptRequest).ToString();
// PushData push = new PushData()
// {
// registration_ids = userData.deviceToken,
// //push.data = CommonMethod.ObjectToJson(objPush);
// message = PushMessages.FormatMessage(PushMessages.acceptRequest, teacherData.userName),
// type = Convert.ToInt16(PushType.acceptRequest).ToString(),
// badge = Convert.ToString(userData.badge)
// };
// if (userData.deviceType == Convert.ToInt16(DeviceType.ios))//ios
// {
// SendPush objIOS = new SendPush();
// objIOS.ConnectToAPNS(push);
// }
// else if (userData.deviceType == Convert.ToInt16(DeviceType.android))//android
// {
// Android objAndroid = new Android();
// objAndroid.send(push);
// }
// }
// // update tblrequest by isAccept=1 and delete rest of request
// }
// else
// {
// var objRequestData = db.tblRequests.Where(x => x.isAccepted == false && x.fkTutorId ==Convert.ToInt32(objReq.tutorId) && x.uniqueRequestId==objReq.uniqueRequestId).FirstOrDefault();
// if (objRequestData != null)
// {
// db.tblRequests.DeleteOnSubmit(objRequestData);
// db.SubmitChanges();
// }
// else {
// return false;
// }
// }
// db.SubmitChanges();
// return true;
// }
//}
#endregion
internal bool SendPushForIos(IosPushModel push)
{
tblUser receiverData = new tblUser();
using (var db = new WizzDataContext())
{
receiverData = db.tblUsers.Where(c => c.pkUserId == Convert.ToInt32(push.receiverId)).FirstOrDefault();
var sendor = db.tblUsers.Where(c => c.pkUserId == Convert.ToInt32(push.senderId)).FirstOrDefault();
// objPush.deviceToken = receiverData.deviceToken;
PushData objPush = new PushData()
{
message = sendor.userName + ": " + push.Message,
type = Convert.ToInt16(PushType.chatPush).ToString(),
messageType=push.Type,
userId=push.senderId,
subject=push.subjectName,
registration_ids = receiverData.deviceToken,
badge = Convert.ToString(receiverData.badge),
uniqueRequestid=push.requestId
};
// push.type = PushType.newRequest.ToString();
// push.data = CommonMethod.ObjectToJson(objPush);
// push.Type =push.Type;
// push.messageId = push.messageId;
// push.Message = push.Message;
// push.senderName=push
if (receiverData.deviceType == 1)//ios
{
SendPush objIOS = new SendPush();
objIOS.ConnectToAPNS(objPush);
}
else if (receiverData.deviceType == 2)//android
{
PushForIos objAndroid = new PushForIos();
objAndroid.SendPushForIos(push);
}
}
return true;
///throw new NotImplementedException();
}
