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