public bool UpdateProfileImage(Profile objModel)
{
PetaPoco.Database db = new PetaPoco.Database("DBConnectionString");
DBConnectionString.User user = DBConnectionString.User.SingleOrDefault(objModel.UserId);
DBConnectionString.Profile profile = db.Query <DBConnectionString.Profile>("Select * from profile where UserId = @0", objModel.UserId).SingleOrDefault();
try
{
if (profile != null)
{
profile.ProfileImageUrl = objModel.ProfileImageUrl;
profile.Update();
}
else
{
profile.UserId = objModel.UserId;
profile.ProfileImageUrl = objModel.ProfileImageUrl;
profile.Insert();
}
return(true);
}
catch (Exception)
{
throw;
}
}
public void UpdateStaff(StaffViewModel objVM)
{
DBConnectionString.Profile profile = DBConnectionString.Profile.Fetch("select * from profile where userId=@0", objVM.UserId).SingleOrDefault();
DBConnectionString.Staff staff = DBConnectionString.Staff.Fetch("select * from staff where userId=@0", objVM.UserId).SingleOrDefault();
DBConnectionString.User user = DBConnectionString.User.Fetch("select * from Users where userId=@0", objVM.UserId).SingleOrDefault();
if (profile != null)
{
profile.Title = objVM.Title;
profile.DateOfBirth = objVM.DateOfBirth;
profile.MobileNumber = objVM.MobileNumber;
profile.HomeTelephoneNumber = objVM.HomeTelephoneNumber;
profile.EmailAddress1 = objVM.Email;
profile.Update();
}
if (staff != null)
{
staff.StaffTypeId = objVM.StaffTypeId;
staff.Email = objVM.Email;
staff.Update();
}
if (user != null)
{
user.FirstName = objVM.FirstName;
user.LastName = objVM.LastName;
user.Email = objVM.Email;
user.Update();
}
objVM.StaffPermission.UserId = objVM.UserId;
this.UpdateStaffPermissions(objVM.StaffPermission);
}
public JsonResult IsEmailAvailable(string email)
{
DBConnectionString.User user = DBConnectionString.User.SingleOrDefault("select * from users where email=@0", email);
if (user != null)
{
return(Json("Email already taken!", JsonRequestBehavior.AllowGet));
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
public bool UpdateUserProfile(Profile objModel)
{
PetaPoco.Database db = new PetaPoco.Database("DBConnectionString");
DBConnectionString.User user = DBConnectionString.User.SingleOrDefault(objModel.UserId);
DBConnectionString.Profile profile = db.Query <DBConnectionString.Profile>("Select * from profile where UserId = @0", objModel.UserId).SingleOrDefault();
try
{
if (user != null)
{
user.FirstName = objModel.FirstName;
user.LastName = objModel.LastName;
user.Update();
}
if (profile != null)
{
profile.Title = objModel.Title;
profile.DateOfBirth = objModel.DateOfBirth;
profile.MobileNumber = objModel.MobileNumber;
profile.HomeTelephoneNumber = objModel.HomeTelephoneNumber;
profile.EmailAddress1 = objModel.EmailAddress1;
profile.EmailAddress2 = objModel.EmailAddress2;
profile.Phone1 = objModel.Phone1;
profile.Phone2 = objModel.Phone2;
profile.Address1 = objModel.Address1;
profile.Address2 = objModel.Address2;
profile.ModifiedOn = objModel.ModifiedOn;
profile.Update();
}
else
{
profile = new DBConnectionString.Profile();
profile.UserId = objModel.UserId;
profile.Title = objModel.Title;
profile.DateOfBirth = objModel.DateOfBirth;
profile.MobileNumber = objModel.MobileNumber;
profile.HomeTelephoneNumber = objModel.HomeTelephoneNumber;
profile.EmailAddress1 = objModel.EmailAddress1;
profile.EmailAddress2 = objModel.EmailAddress2;
profile.Phone1 = objModel.Phone1;
profile.Phone2 = objModel.Phone2;
profile.Address1 = objModel.Address1;
profile.Address2 = objModel.Address2;
profile.InsertedOn = DateTime.Now;
profile.SecurityAnswer = "None";
profile.Insert();
}
return(true);
}
catch
{
return(false);
}
}
public ActionResult RegisterUserStep7(long userId)
{
DBConnectionString.User User = DBConnectionString.User.SingleOrDefault(userId);
User objUser = new User();
Utilities.SendConfirmationEmail(User.Username);
objUser.UserId = userId;
return(View(objUser));
}
public ActionResult RegisterUserStep8(User objUser)
{
DBConnectionString.User User = DBConnectionString.User.SingleOrDefault(objUser.UserId);
if (WebSecurity.Login(User.Username, objUser.Password))
{
Session["UserId"] = Convert.ToInt32(WebSecurity.GetUser(User.Username).ProviderUserKey);
string returnUrl = "/";
return(RedirectToAction(returnUrl));
}
ViewBag.Error = true;
return(View());
}
public ActionResult RegisterUserStep5(Profile objProfile)
{
DBConnectionString.User User = DBConnectionString.User.FirstOrDefault("select * from Users where UserId=@0", objProfile.UserId);
DBConnectionString.Profile Profile = DBConnectionString.Profile.FirstOrDefault("select * from Profile where UserId=@0", objProfile.UserId);
// User.Password = objUser.Password;
WebSecurity.ResetPassword(User.Username, objProfile.Password);
User = DBConnectionString.User.FirstOrDefault("select * from Users where UserId=@0", objProfile.UserId);
Profile.SecurityQuestionId = objProfile.SecurityQuestionId;
Profile.SecurityAnswer = objProfile.SecurityAnswer;
if (User.Update() > 0 && Profile.Update() > 0)
{
return(RedirectToAction("RegisterUserStep6", new { userId = User.UserId }));
}
return(View(objProfile));
}
public ActionResult RegisterUserStep4(Profile objProfile)
{
DBConnectionString.User User = DBConnectionString.User.FirstOrDefault("select * from Users where UserId=@0", objProfile.UserId);
DBConnectionString.Profile Profile = DBConnectionString.Profile.FirstOrDefault("select * from Profile where UserId=@0", objProfile.UserId);
User.Email = objProfile.EmailAddress1;
Profile.MobileNumber = objProfile.MobileNumber;
Profile.HomeTelephoneNumber = objProfile.HomeTelephoneNumber;
Profile.EmailAddress1 = objProfile.EmailAddress1;
Profile.HomeTelephoneNumber = objProfile.HomeTelephoneNumber;
if (User.Update() > 0 && Profile.Update() > 0)
{
return(RedirectToAction("RegisterUserStep5", new { userId = User.UserId }));
}
return(View(objProfile));
}
public bool UpdateStudent(StudentViewModel objViewModel)
{
PetaPoco.Database db = new PetaPoco.Database("DBConnectionString");
DBConnectionString.User user = DBConnectionString.User.SingleOrDefault(objViewModel.UserId);
DBConnectionString.Student student = DBConnectionString.Student.SingleOrDefault(objViewModel.StudentId);
DBConnectionString.Profile profile = db.Query <DBConnectionString.Profile>("Select * from profile where UserId = @0", student.UserId).SingleOrDefault();
db.BeginTransaction();
try
{
if (user != null)
{
user.FirstName = objViewModel.FirstName;
user.LastName = objViewModel.LastName;
user.Update();
}
if (student != null)
{
student.ClassId = objViewModel.ClassId;
student.CourseId = objViewModel.CourseId;
student.DepartmentId = objViewModel.DepartmentId;
student.Email = objViewModel.Email;
student.FullName = objViewModel.FirstName + " " + objViewModel.LastName;
student.ModifiedBy = objViewModel.ModifiedBy;
student.ModifiedOn = objViewModel.ModifiedOn;
student.SectionId = objViewModel.SectionId;
student.Update();
}
if (profile != null)
{
profile.Title = objViewModel.Title;
profile.DateOfBirth = objViewModel.DateOfBirth;
profile.MobileNumber = objViewModel.MobileNumber;
profile.HomeTelephoneNumber = objViewModel.HomeTelephoneNumber;
profile.EmailAddress1 = objViewModel.Email;
profile.Update();
}
//var subjectIdArray = objViewModel.SubjectIds.Split(',');
//foreach (var subjectId in subjectIdArray)
//{
// DBConnectionString.UserSubject userSubject = db.Query<DBConnectionString.UserSubject>("select * from UserSubjects where UserId = @0 and SubjectId = @1", objViewModel.UserId, subjectId).SingleOrDefault();
// if (userSubject == null)
// {
// userSubject.UserId = objViewModel.UserId.Value;
// userSubject.SubjectId = Convert.ToInt64(subjectId);
// userSubject.InsertedOn = DateTime.Now;
// userSubject.InsertedBy = objViewModel.InsertedBy;
// userSubject.Update();
// }
//}
db.CompleteTransaction();
return(true);
}
catch
{
db.AbortTransaction();
return(false);
}
}
