protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); SetContentView(Resource.Layout.ProfilePage); InitializeMentorJProfileServiceClient(); session = GetSharedPreferences(userSessionPref, FileCreationMode.Private); ProfileInfo(); Bundle dataBundle = new Bundle(); dataBundle.PutString("UserProfile", JsonConvert.SerializeObject(loggedOnUser)); loggedOnUser = JsonConvert.DeserializeObject <tblUserProfile>(dataBundle.GetString("UserProfile")); //FragmentTransaction transaction = FragmentManager.BeginTransaction(); //SlidingTabsFragment fragment = new SlidingTabsFragment(); //fragment.Arguments = dataBundle; ////SlidingTabsFragmentProfile fragment2 = new SlidingTabsFragmentProfile(); ////transaction.Replace(Resource.Id.sample_content_fragment, fragment); //transaction.Commit(); }
internal static async Task <tblUserProfile> InsertUser(tblUserProfile model, string companyType, long Id) { try { using (db = new eMSPEntities()) { model = db.tblUserProfiles.Add(model); int x = await Task.Run(() => db.SaveChangesAsync()); switch (companyType) { case "MSP": db.tblMSPUsers.Add(ToCompanyUsers(model, companyType, Id)); break; case "Customer": db.tblCustomerUsers.Add(ToCompanyUsers(model, companyType, Id)); break; case "Supplier": db.tblSupplierUsers.Add(ToCompanyUsers(model, companyType, Id)); break; } x = await Task.Run(() => db.SaveChangesAsync()); return(GetUser(model.UserID).Result); } } catch (Exception e) { throw; } }
public override View OnCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) { //FragmentSample holds scrolling tab layout String stringData = Arguments.GetString("MyDataTag"); userProfile = JsonConvert.DeserializeObject <tblUserProfile>(stringData); return(inflater.Inflate(Resource.Layout.FragmentSample, container, false)); }
public BaseController() { if (CommonViewModel.uId != 0) { userData = db.tblUserProfiles.Where(e => e.userID == CommonViewModel.uId).SingleOrDefault(); CommonViewModel.profileViewModel = userData; CommonViewModel.configViewModel = db.tblSystemConfigs.FirstOrDefault(); } }
private async void ProfileInfo() { try { string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "user.db3"); //Call Database var db = new SQLiteConnection(dpPath); //Check if database exists if (tblUserProfile.TableExists <tblUserProfile>(db)) { var data = db.Table <tblUserProfile>(); //Call Table var query = data.Where(x => (x.UserID == session.GetLong("userid", -1))).FirstOrDefault(); //Linq Query if (query != null) { loggedOnUser = query; userProfile = await getUserProfile(); if (userProfile.Equals(loggedOnUser)) { Toast.MakeText(this, "User Profile Loaded!", ToastLength.Short).Show(); } else { Toast.MakeText(this, "User Profile MISMATCH!", ToastLength.Short).Show(); } msg = null; } else { //User ID not found, so create user profile userProfile = await getUserProfile(); string success = tblUserProfile.insertUpdateData(userProfile, dpPath); if (success == "Single data file inserted or updated") { loggedOnUser = userProfile; } else { Toast.MakeText(this, "User Profile Insertion Failed!", ToastLength.Short).Show(); } msg = null; } } //Create database and userprofile else { createuserProfileDatabase(); msg = null; } } catch (Exception ex) { Toast.MakeText(this, ex.ToString(), ToastLength.Short).Show(); } }
public ActionResult registrationform(tblUserProfile user) { using (uber_dbEntities3 dbmodel = new uber_dbEntities3()) { dbmodel.tblUserProfiles.Add(user); dbmodel.SaveChanges(); } ModelState.Clear(); ViewBag.Message = "Add succesfully"; return(View("myregistration", new tblUserProfile())); }
public async Task <UserCreateModel> GetUser(string Id) { try { tblUserProfile data = await Task.Run(() => UserOperations.GetUser(Id)); return(data.ConvertToUser()); } catch (Exception ex) { throw; } }
public async Task <UserCreateModel> UpdateUser(UserCreateModel model) { try { tblUserProfile data = await Task.Run(() => UserOperations.UpdateUser(model.ConvertTotblUser())); return(data.ConvertToUser()); } catch (Exception) { throw; } }
public ActionResult addAdmin(UserDetails model) { NotesMarketPlaceEntities entities = new NotesMarketPlaceEntities(); var CountryCode = entities.tblCountries.ToList(); SelectList list = new SelectList(CountryCode, "CountryCode", "CountryCode"); ViewBag.CountryCode = list; string name = User.Identity.Name; int u = (from user in _Context.tblUsers where user.EmailID == name select user.ID).Single(); if (User.Identity.IsAuthenticated) { NotesMarketPlaceEntities dbobj = new NotesMarketPlaceEntities(); tblUser obj = new tblUser(); obj.FirstName = model.FirstName; obj.LastName = model.LastName; obj.EmailID = model.EmailID; obj.Password = "******"; obj.CreatedDate = DateTime.Now; obj.CreatedBy = u; obj.IsActive = true; obj.IsEmailVerified = true; obj.RoleID = 102; dbobj.tblUsers.Add(obj); dbobj.SaveChanges(); int id = (from record in dbobj.tblUsers orderby record.ID descending select record.ID).First(); tblUserProfile userobj = new tblUserProfile(); userobj.UserID = id; userobj.PhoneNumber_CountryCode = model.CountryCode; userobj.PhoneNumber = model.PhnNo; userobj.AddressLine1 = "addressline1"; userobj.AddressLine2 = "addressline2"; userobj.City = "city"; userobj.State = "State"; userobj.ZipCode = "123321"; userobj.Country = "India"; dbobj.tblUserProfiles.Add(userobj); dbobj.SaveChanges(); ModelState.Clear(); return(RedirectToAction("ManageAdmin", "Admin")); } return(View()); }
private async void createuserProfileDatabase() { try { string dpPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "user.db3"); string test = tblUserProfile.createDatabase(dpPath); var db = new SQLiteConnection(dpPath); var data = db.Table <tblUserProfile>(); newProfile = new tblUserProfile(); newProfile.UserID = session.GetLong("userid", -1);; newProfile.About = null; newProfile.PictureURL = null; newProfile.PictureData = null; newProfile.SmallPictureURL = null; newProfile.BigPictureURL = null; newProfile.WebProfileLink = null; newProfile.WebPicturesOfLink = null; newProfile.Modified = DateTime.Now; _client.InsertRecord_UserProfileAsync(newProfile); while (msg == null || msg != "Add Updated UserProfile Successful!") { await delayTask(); if (msg != null && msg != "Add Updated UserProfile Successful!") { break; //Error } } if (msg == "Add Updated UserProfile Successful!") { string success = tblUserProfile.insertUpdateData(newProfile, dpPath); //Insert userInfo into SQLITE on phone ISharedPreferencesEditor session_editor = session.Edit(); session_editor.PutString("UserProfile", JsonConvert.SerializeObject(userProfile)); session_editor.Commit(); Toast.MakeText(this, "Create Database: " + test + "\nInsertUpdateData: " + success, ToastLength.Short).Show(); loggedOnUser = newProfile; } else { Toast.MakeText(this, "UserProfile Creation Failed", ToastLength.Long).Show(); //Add error message on UI code saying why it failed. } //loggedOnUser = JsonConvert.DeserializeObject<tblUserProfile>(session.GetString("UserProfile", "")); } catch (Exception ex) { Toast.MakeText(this, ex.ToString(), ToastLength.Short).Show(); } }
private void ClientOnReadRecord_UserProfileCompleted(object sender, ReadRecord_UserProfileCompletedEventArgs ReadRecord_UserProfileCompletedEventArgs) { if (ReadRecord_UserProfileCompletedEventArgs.Error != null) { msg = ReadRecord_UserProfileCompletedEventArgs.Error.Message; } else if (ReadRecord_UserProfileCompletedEventArgs.Cancelled) { msg = "Request was cancelled."; } else { userProfile = ReadRecord_UserProfileCompletedEventArgs.Result; msg = "Read UserProfile Successful!"; } RunOnUiThread(() => Toast.MakeText(this, msg, ToastLength.Short).Show()); }
internal static async Task DeleteUser(string Id) { try { using (db = new eMSPEntities()) { tblUserProfile obj = await db.tblUserProfiles.FindAsync(Id); db.tblUserProfiles.Remove(obj); int x = await Task.Run(() => db.SaveChangesAsync()); } } catch (Exception) { throw; } }
internal static async Task <tblUserProfile> UpdateUser(tblUserProfile model) { try { using (db = new eMSPEntities()) { db.Entry(model).State = EntityState.Modified; int x = await Task.Run(() => db.SaveChangesAsync()); return(model); } } catch (Exception) { throw; } }
public void MaptoModel(tblUser user, tblUserProfile details) { user.FirstName = FirstName; user.LastName = LastName; user.EmailID = EmailID; details.DOB = DOB; details.Gender = Gender; details.PhoneNumber_CountryCode = PhoneNumber_CountryCode; details.PhoneNumber = PhoneNumber; details.ProfilePicture = ProfilePicture; details.AddressLine1 = AddressLine1; details.AddressLine2 = AddressLine2; details.City = City; details.State = State; details.ZipCode = ZipCode; details.Country = Country; details.College = College; details.University = University; }
public async Task <UserModel> CreateUser(UserCreateModel model) { try { tblUserProfile data = await Task.Run(() => UserOperations.InsertUser(model.ConvertTotblUser(), model.companyType, model.companyId)); switch (model.companyType) { case "MSP": default: List <tblMSPUser> liMSP = await Task.Run(() => UserOperations.GetAllMSPUsers(model.companyId)); return(liMSP.SingleOrDefault(a => a.UserID == data.UserID).ConvertToUserModel()); break; case "Customer": List <tblCustomerUser> licust = await Task.Run(() => UserOperations.GetAllCustomerUsers(model.companyId)); return(licust.SingleOrDefault(a => a.UserID == data.UserID).ConvertToUserModel()); break; case "Supplier": List <tblSupplierUser> lisup = await Task.Run(() => UserOperations.GetAllSupplierUsers(model.companyId)); return(lisup.SingleOrDefault(a => a.UserID == data.UserID).ConvertToUserModel()); break; } } catch (Exception) { throw; } }
public static dynamic ToCompanyUsers(tblUserProfile data, string companyType, long Id) { switch (companyType) { case "MSP": return(new tblMSPUser() { MSPID = Id, UserID = data.UserID, IsActive = true, IsDeleted = false, CreatedUserID = data.CreatedUserID, CreatedTimestamp = data.CreatedTimestamp, UpdatedUserID = data.UpdatedUserID, UpdatedTimestamp = data.UpdatedTimestamp }); case "Customer": return(new tblCustomerUser() { CustomerID = Id, UserID = data.UserID, IsActive = true, IsDeleted = false, CreatedUserID = data.CreatedUserID, CreatedTimestamp = data.CreatedTimestamp, UpdatedUserID = data.UpdatedUserID, UpdatedTimestamp = data.UpdatedTimestamp }); case "Supplier": return(new tblSupplierUser() { SupplierID = Id, UserID = data.UserID, IsActive = true, IsDeleted = false, CreatedUserID = data.CreatedUserID, CreatedTimestamp = data.CreatedTimestamp, UpdatedUserID = data.UpdatedUserID, UpdatedTimestamp = data.UpdatedTimestamp }); } return(null); }
public static UserCreateModel ConvertToUser(this tblUserProfile data) { return(new UserCreateModel() { userId = data.UserID, firstName = data.FirstName, lastName = data.LastName, address = data.Address, emailAddress = data.EmailAddress, roleGroupId = data.RoleGroupId, timeZoneId = data.TimezoneID, city = data.City, countryId = data.CountryID, country = data.tblCountry?.Name, state = data.tblCountryState?.Name, stateId = data.StateID, userProfilePhotoPath = data.UserProfilePhotoPath, zipCode = data.ZipCode, createdUserID = data.CreatedUserID, updatedTimestamp = data.UpdatedTimestamp, createdTimestamp = data.CreatedTimestamp, updatedUserID = data.UpdatedUserID }); }
public ActionResult registrationform(int id = 0) { tblUserProfile user = new tblUserProfile(); return(View(user)); }
internal static async Task <UserRolesModel> GetUserRolesn(string UserID) { try { using (db = new eMSPEntities()) { UserRolesModel user = new UserRolesModel(); //user.roles = await Task.Run(() => db.tblUserProfiles.Where(x => x.AspNetUser.Id == UserID) // .Join(db.AspNetRoleGroups, // u => u.RoleGroupId, // rg => rg.Id, (u, rg) => new // { // RoleGroupId = rg.Id // }).Join(db.AspNetRoleGroupRoles, // r => r.RoleGroupId, // rgr => rgr.RoleGroupId, (r, rgr) => new // { // rolesId = rgr.RoleId // }).Join(db.AspNetRoles, // ro => ro.rolesId, // b => b.Id, (ro, b) => new RoleModel // { // id = b.Id, // Name = b.Name // }).ToList()); var objlist = db.AspNetUsers.Where(x => x.Id == UserID).SingleOrDefault(); user.roles = objlist.AspNetRoles.Select(X => new RoleModel() { Name = X.Name, id = X.Id }).ToList(); //user.roles = await (from profile in db.tblUserProfiles // join rolegrp in db.AspNetRoleGroups on profile.RoleGroupId equals rolegrp.Id // join grpRoles in db.AspNetRoleGroupRoles on rolegrp.Id equals grpRoles.RoleGroupId // join role in db.AspNetRoles on grpRoles.RoleId equals role.Id // select new RoleModel { id = role.Id, Name = role.Name }).ToListAsync(); //db.AspNetRoleGroupRoles.Where(x=>x.RoleGroupId==) tblUserProfile up = db.tblUserProfiles.Where(a => a.UserID == UserID) .Include(a => a.tblCountry) .Include(a => a.tblCountryState) .SingleOrDefault(); user.user = new UserModel(); user.user.user = up.ConvertToUser(); user.user.userId = UserID; long mspId = db.tblUserProfiles.Where(x => x.AspNetUser.Id == UserID).Join(db.tblMSPUsers, u => u.UserID, rg => rg.UserID, (l, r) => new { l, r }).Select(b => b.r.MSPID).FirstOrDefault(); long supId = db.tblUserProfiles.Where(x => x.AspNetUser.Id == UserID).Join(db.tblSupplierUsers, u => u.UserID, rg => rg.UserID, (l, r) => new { l, r }).Select(b => b.r.SupplierID).FirstOrDefault(); long cutId = db.tblUserProfiles.Where(x => x.AspNetUser.Id == UserID).Join(db.tblCustomerUsers, u => u.UserID, rg => rg.UserID, (l, r) => new { l, r }).Select(b => b.r.CustomerID).FirstOrDefault(); if (mspId != 0) { user.user.companyId = mspId; user.user.companyType = "MSP"; } else if (supId != 0) { user.user.companyId = supId; user.user.companyType = "Supplier"; } else if (supId != 0) { user.user.companyId = cutId; user.user.companyType = "Customer"; } return(user); } } catch (Exception ex) { throw ex; } }