//Get Profile Data such as First Name , Last Name, Date Of Birth and Language by this get method of Profile controller.
public HttpResponseMessage ProfileDetails()
{
// Fetch User ID from Basic Authentication
string ID = Thread.CurrentPrincipal.Identity.Name;
//Check Whether model is valid or not.
//IF yes then pass the data from entity model(database) to Model class.
if (ModelState.IsValid)
{
// Create getProfileModel object of GetProfileModel class
ProfileModel getProfileModel = new ProfileModel();
//Query statement for specific ID.
var context = new WebApiEntities();
var query = from user in context.ProfileTables where ID == user.UserID.ToString() select user;
// Profile is the Class of
ProfileTable profile = query.FirstOrDefault();
// get profile Values
getProfileModel.Fname = profile.FirstName;
getProfileModel.Lname = profile.LastName;
getProfileModel.Language = profile.Language;
getProfileModel.DOB = profile.DOB.ToString();
// Return getProfileModel class data with Ok status of HttpMessageResponse.
return(Request.CreateResponse(HttpStatusCode.OK, getProfileModel));
}
//Create Error Response if Model State is not valid and Send Message to user Please login again.
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "please login again"));
}
public static ProfileTable GetProfileTable()
{
if (profileTable == null)
{
profileTable = new ProfileTable();
}
return(profileTable);
}
public InventoryController()
{
this._inventoryTable = new InventoryTable();
this._userTable = new UserTable();
this._locationTable = new LocationTable();
this._profileTable = new ProfileTable();
this._hardwareTable = new HardwareTable();
this._logTable = new LogBook.Controllers.LogBookController();
}
/// <summary>
/// Initializes the models
/// </summary>
/// <author>
/// Juan Bautista
/// </author>
public MovementController()
{
this._profileTable = new ProfileTable("MovementProfiles");
this._movementTable = new MovementTable();
this._processTable = new ProcessesTable();
this._processDiagram = new ProcessDiagram();
this._authorizationTable = new AuthorizationTable();
this._userTable = new UserTable();
this._demandTable = new DemandTable();
}
public MovementProfileController()
{
this._profileTable = new ProfileTable("MovementProfiles");
this._movementTable = new MovementTable();
this._userTeble = new UserTable();
this._authorizationTable = new AuthorizationTable();
this._categoryTable = new CategoryTable();
validatepermissions = new validatePermissions();
this._processesTable = new ProcessesTable();
_logTable = new LogBook.Controllers.LogBookController();
}
protected void button1_Click(object sender, EventArgs e)
{
ProfileTable pf = new ProfileTable();
pf.Name = TextBox1.Text;
pf.MobNo = TextBox2.Text;
pf.Email = TextBox3.Text;
pf.Password = TextBox4.Text;
pf.CPassword = TextBox5.Text;
dl.da.ProfileTables.InsertOnSubmit(pf);
dl.da.SubmitChanges();
Response.Write("<script>alert('Thanks For SignUp!!')</script>");
}
public EmployeeController()
{
// validatelim = new ValidateLimits();
validatepermissions = new validatePermissions();
employeeprofileTable = new EmployeeProfileTable();
witnessesModel = new MongoModel("witnesses");
_listTable = new ListTable();
employeetable = new EmployeeTable();
Notificate = new Notifications();
_logTable = new LogBook.Controllers.LogBookController();
userTable = new UserTable();
profileTable = new ProfileTable();
listTable = new ListTable();
}
protected void Page_Load(object sender, EventArgs e)
{
int cust_id = Convert.ToInt32(Session["cid"]);
string profQ = "SELECT * FROM CUSTOMER WHERE \"customer_id\" =" + cust_id;
ProfileProtocol.SelectCommand = profQ;
ProfileProtocol.SelectCommandType = SqlDataSourceCommandType.Text;
DataView dv = ProfileProtocol.Select(DataSourceSelectArguments.Empty) as DataView;
ProfileTable.DataSource = dv;
ProfileTable.DataSourceID = null;
ProfileTable.DataBind();
}
public void Save(ProfileView viewTable)
{
if (viewTable.Id == null)
{
var domainTable = new ProfileTable();
Mapper.Map(viewTable, domainTable);
SaveDomain(domainTable);
}
else
{
var domainTable = Find(viewTable.Id);
Mapper.Map(viewTable, domainTable);
SaveDomain(domainTable);
}
}
public static void ProfileClickEvent(object obj, EventArgs args)
{
ProtoPlayerCharacter player = playerOps.Profile(client);
if (profileTable == null)
{
profileTable = new ProfileTable(player.playerID, player.firstName + " " + player.familyName, player.ownedFiefs, player.location, player.armyID, Convert.ToString(player.purse));
}
else
{
profileTable.DestroyTable();
profileTable = new ProfileTable(player.playerID, player.firstName + " " + player.familyName, player.ownedFiefs, player.location, player.armyID, Convert.ToString(player.purse));
}
tableLayout.Attach(profileTable.getProfileLayout(), 1, 2, 4, 5);
myWin.ShowAll();
}
private void LoadStoredProfiles()
{
try
{
storedProfiles = new ProfileTable();
if (System.IO.File.Exists(ProfileStoragePath))
{
ConfigNode stored = ConfigNode.Load(ProfileStoragePath);
if (stored != null && stored.HasNode(STORED_NODE_NAME))
{
stored = stored.GetNode(STORED_NODE_NAME); // to avoid having an empty cfg, which will cause KSP to hang at load
var profiles = stored.GetNodes("PROFILE");
foreach (var profileNode in profiles)
{
try
{
Profile p = new Profile(profileNode);
p.modified = false; // by definition, stored profiles haven't been modified
storedProfiles.Add(p.name, p);
Log.Normal("[ScienceAlert]Loaded profile '{0}' successfully!", p.name);
}
catch (Exception e)
{
Log.Error("ProfileManager: profile '{0}' failed to parse; {1}", name, e);
}
}
}
}
if (DefaultProfile == null)
{
storedProfiles.Add("default", Profile.MakeDefault());
}
}
catch (Exception e)
{
Log.Error("ProfileManager: Exception loading stored profiles: {0}", e);
storedProfiles = new ProfileTable();
}
}
public void SaveDomain(ProfileTable domainTable, string currentUserName = "")
{
string localUserName = getCurrentUserName(currentUserName);
ApplicationUser user = _AccountService.FirstOrDefault(x => x.UserName == localUserName);
if (domainTable.Id == Guid.Empty)
{
domainTable.Id = Guid.NewGuid();
domainTable.CreatedDate = DateTime.UtcNow;
domainTable.ModifiedDate = domainTable.CreatedDate;
domainTable.ApplicationUserCreatedId = user.Id;
domainTable.ApplicationUserModifiedId = user.Id;
repo.Add(domainTable);
}
else
{
domainTable.ModifiedDate = DateTime.UtcNow;
domainTable.ApplicationUserModifiedId = user.Id;
repo.Update(domainTable);
}
_uow.Save();
}
/// <summary>
/// Check if username and password is valid, if it is, sets sessions and formauth to true
/// </summary>
/// <param name="username">The user name</param>
/// <param name="password">The User password</param>
/// <returns>Index View if valid user, Login view if invalid user</returns>
/// <author>Galaviz Alejos Luis Angel</author>
public ActionResult Login(string username, string password)
{
if (username == "" || password == "")
{
this.Redirect("/Login");
}
//Check the user on the database
//usertable = new UserTable();
BsonDocument doc = usertable.Login(username, password);
ProfileTable profiletable = new ProfileTable();
//If the return is null, is an invalid user
if (doc != null)
{
//User Password time validation
if (doc["_id"].AsObjectId.ToString() != "52e95ab907719e0d40637d96")
{
JObject userInformation = JsonConvert.DeserializeObject <JObject>(usertable.GetRow(doc["_id"].AsObjectId.ToString()));
if (userInformation["lastChgPassword"] != null)
{
try
{
DateTime d1 = DateTime.ParseExact(userInformation["lastChgPassword"].ToString(), "dd/MM/yyyy HH:mm:ss", null);
DateTime d2 = DateTime.Now;
systemSettingsTable = new SystemSettingsTable();
JArray cantDays = JsonConvert.DeserializeObject <JArray>(systemSettingsTable.Get("name", "daysChangePassword"));
string days = (from mov in cantDays select(string) mov["days"]).First().ToString();
TimeSpan time = d2 - d1;
int NrOfDays = time.Days;
if (int.Parse(days) <= NrOfDays)
{
ViewBag.Message = "Timeout";
ViewData["timeout"] = "Timeout";
List <string> backgrounds = Design.getBackgrounds();
return(View("Index", backgrounds));
}
}
catch (Exception ex)
{
ViewBag.Error = true;
ViewBag.Message = ex.ToString();
ViewData["timeout"] = ex.ToString();
List <string> backgrounds = Design.getBackgrounds();
return(View("Index", backgrounds));
}
}
else
{
try
{
JObject user = JsonConvert.DeserializeObject <JObject>(usertable.GetRow(doc["_id"].AsObjectId.ToString()));
user["lastChgPassword"] = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
usertable.saveRow(JsonConvert.SerializeObject(user), user["_id"].ToString());
}
catch (Exception ex)
{
// throw new Exception(ex.ToString());
//return Redirect("~/Home");
}
//END - User Password time validation
}
}
DataFileManager Filelimits;
string filepath = "/App_Data/system.conf";
string absolutedpath = Server.MapPath(filepath);
Filelimits = new DataFileManager(absolutedpath, "juanin");
if (!Filelimits.empty())
{
//Set user name (to show on the upper right corner of the system)
this.Session["LoggedUser"] = "";
try
{
this.Session["Semaphores"] = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
HttpCookie aCookiesem = new HttpCookie("semaphores");
aCookiesem.Value = Session["Semaphores"].ToString();
aCookiesem.Expires = DateTime.Now.AddDays(10);
Response.Cookies.Add(aCookiesem);
}
catch (Exception ex)
{
}
this.Session["Username"] = "";
try
{
this.Session["Username"] = doc["name"].AsString;
this.Session["LoggedUser"] += doc["name"].AsString;
try
{
this.Session["LoggedUser"] += " " + doc["lastname"].AsString;
}
catch (Exception e) { /*Ignored*/ }
}
catch (Exception e) { /*Ignored*/ }
//If needed for user transactions
this.Session["_id"] = doc["_id"].AsObjectId;
HttpCookie aCookie2 = new HttpCookie("_id2");
aCookie2.Value = doc["_id"].AsObjectId.ToString();
aCookie2.Expires = DateTime.Now.AddDays(10);
Response.Cookies.Add(aCookie2);
//Check if there exist the image extension registry on database, if it exist, sets the relative
//path
try
{
if (!string.IsNullOrEmpty(doc["imgext"].ToString()))
{
//Relative path to save images
string relativepath = string.Format("\\Uploads\\Images\\{0}.{1}",
Session["_id"].ToString(), doc["imgext"].ToString());
//Check if profile picture file exists on the server
if (System.IO.File.Exists(Server.MapPath(relativepath)))
{
//if it exist, sets the profile picture url
this.Session["ProfilePicture"] = Url.Content(relativepath);
HttpCookie aCookie4 = new HttpCookie("_picture");
aCookie4.Value = Url.Content(relativepath);
aCookie4.Expires = DateTime.Now.AddDays(10);
Response.Cookies.Add(aCookie4);
}
else
{
//Set picture to default
this.Session["ProfilePicture"] = null;
}
}
}
catch (Exception e) { /*Ignored*/ }
string usuarioid = Session["_id"].ToString();
String profileid = usertable.getRowString(usuarioid);
JObject rowArray = JsonConvert.DeserializeObject <JObject>(profileid);
var jdatos = "";
if (rowArray["permissionsHTK"] != null)
{
string arraypermisos = rowArray["permissionsHTK"].ToString();
JObject allp = JsonConvert.DeserializeObject <JObject>(arraypermisos);
jdatos = JsonConvert.SerializeObject(allp);
this.Session["Permissions"] = jdatos.ToString();
}
else
{
string idpro = rowArray["profileId"].ToString();
String profiles = profiletable.GetRow(idpro);
JObject rowArraypro = JsonConvert.DeserializeObject <JObject>(profiles);
string arraypermisos = rowArraypro["permissionsHTK"].ToString();
JObject allp = JsonConvert.DeserializeObject <JObject>(arraypermisos);
jdatos = JsonConvert.SerializeObject(allp);
this.Session["Permissions"] = jdatos.ToString();
}
try
{
this.Session["PermissionsClient"] = Filelimits["scenario"]["modules"].ToString();
string filedata = Filelimits["scenario"]["modules"].ToString();
HttpCookie aCookiep = new HttpCookie("permissionsclient");
aCookiep.Value = Filelimits["scenario"]["modules"].ToString();
aCookiep.Expires = DateTime.Now.AddDays(10);
Response.Cookies.Add(aCookiep);
}
catch (Exception ex)
{
this.Session["PermissionsClient"] = "";
}
HttpCookie aCookie = new HttpCookie("permissions");
aCookie.Value = jdatos.ToString();
aCookie.Expires = DateTime.Now.AddDays(10);
Response.Cookies.Add(aCookie);
HttpCookie aCookie1 = new HttpCookie("_loggeduser");
aCookie1.Value = Session["LoggedUser"].ToString();
aCookie1.Expires = DateTime.Now.AddDays(10);
Response.Cookies.Add(aCookie1);
HttpCookie aCookie3 = new HttpCookie("_username");
aCookie3.Value = Session["Username"].ToString();
aCookie3.Expires = DateTime.Now.AddDays(10);
Response.Cookies.Add(aCookie3);
//Sets the login authorization
FormsAuthentication.SetAuthCookie("User", false);
TimeSpan time = FormsAuthentication.Timeout;
// FormsAuthentication.Timeout.Subtract(time);
//Redirect Index
FormsAuthentication.Timeout.Subtract(time);
/* TimeSpan time2= TimeSpan.Parse("00:04:00");
* FormsAuthentication.Timeout.Add(time2);
* string horasuma2 = DateTime.Now.ToString("HH:mm:ss");
* TimeSpan timenow = TimeSpan.Parse(horasuma2);
* int total = time2.Minutes - timenow.Minutes;*/
return(Redirect("~/Home"));
}
else
{
ViewBag.Error = true;
ViewBag.Message = "Error de Permisos";
List <string> backgrounds = Design.getBackgrounds();
return(View("Index", backgrounds));
}
}
else
{
//Set error and return to login page
ViewBag.Error = true;
ViewBag.Message = "Error de Login";
List <string> backgrounds = Design.getBackgrounds();
return(View("Index", backgrounds));
}
}
private async void Button_Clicked(object sender, EventArgs e)
{
if (EntryUserName.Text == null)
{
//await this.DisplayAlert(null, "กรุณาระบุชื่อผู้ใช้งาน", null, "ตกลง");
EntryUserName.PlaceholderColor = Color.FromHex("#ffb3ba");
EntryUserName.Placeholder = "กรุณาระบุชื่อผู้ใช้งาน";
EntryUserName.Focus();
return;
}
if (EntryUserPassword.Text == null)
{
//await this.DisplayAlert(null, "กรุณาระบุรหัสผ่าน", null, "ตกลง");
EntryUserPassword.PlaceholderColor = Color.FromHex("#ffb3ba");
EntryUserPassword.Placeholder = "กรุณาระบุรหัสผ่าน";
EntryUserPassword.Focus();
return;
}
if (EntryUserEmail.Text == null)
{
//await this.DisplayAlert(null, "กรุณาระบุรหัสผ่าน", null, "ตกลง");
EntryUserEmail.PlaceholderColor = Color.FromHex("#ffb3ba");
EntryUserEmail.Placeholder = "กรุณาระบุอีเมล์";
EntryUserEmail.Focus();
return;
}
if (EntryUserPhoneNumber.Text == null)
{
//await this.DisplayAlert(null, "กรุณาระบุรหัสผ่าน", null, "ตกลง");
EntryUserPhoneNumber.PlaceholderColor = Color.FromHex("#ffb3ba");
EntryUserPhoneNumber.Placeholder = "กรุณาระบุเบอร์โทรศัพท์";
EntryUserPhoneNumber.Focus();
return;
}
Device.BeginInvokeOnMainThread(async() => {
//Register data to firebase also
var isExist = await apiRequestHelper.RequestCheckUserExistAsync(EntryUserName.Text);
if (isExist == "true")
{
Toast.MakeText(this.context, "ชื่อผู้ใช้งานซ้ำ", ToastLength.Short).Show();
EntryUserName.PlaceholderColor = Color.FromHex("#ffb3ba");
EntryUserName.Placeholder = "กรุณาระบุชื่อผู้ใช้งานใหม่";
EntryUserName.Focus();
return;
}
var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db");
var db = new SQLiteConnection(dbpath);
db.CreateTable <RegUserTable>();
var item = new RegUserTable()
{
UserName = EntryUserName.Text,
Password = EntryUserPassword.Text,
Email = EntryUserEmail.Text,
PhoneNumber = EntryUserPhoneNumber.Text,
};
db.Insert(item);
var profile = new ProfileTable()
{
UserName = EntryUserName.Text,
Email = EntryUserEmail.Text,
PhoneNumber = EntryUserPhoneNumber.Text,
};
db.CreateTable <ProfileTable>();
db.Insert(profile);
//Register data to firebase also
await apiRequestHelper.RequestRegisterUserAsync(EntryUserName.Text, EntryUserPassword.Text, EntryUserEmail.Text, EntryUserPhoneNumber.Text);
ProfileJson json = new ProfileJson();
json.UserName = EntryUserName.Text;
json.Email = EntryUserEmail.Text;
json.PhoneNumber = EntryUserPhoneNumber.Text;
json.CreateDate = DateTime.Now.ToString("dd/MM/yyyy hh:mm tt");
await apiRequestHelper.RequestAddProfileAsync(json);
var result = await this.DisplayAlert(null, "สมัครสมาชิกสำเร็จ!", null, "ตกลง");
if (!result)
{
await Navigation.PushAsync(new LoginPage());
}
});
}
//private async void SaveProfile(string username, string email)
private async void SaveProfile(string username)
{
RootProfileObject profileData = await apiRequestHelper.RequestProfileAsync(username);
if (profileData != null && profileData.Data != null && profileData.Data.Count > 0)
{
List <ProfileJson> Data = profileData.Data;
if (Data.Count > 0)
{
ProfileJson json = Data.First <ProfileJson>();
var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db");
var db = new SQLiteConnection(dbpath);
var userprofile = db.GetTableInfo("ProfileTable");
if (userprofile.Count == 0)
{
//TODO เอาข้อมูลจาก Cloud มาอัพเดท Local DB
var item = new ProfileTable()
{
UserName = username,
FirstName = EntryFirstName.Text,
LastName = EntryLastName.Text,
Gender = ((SelectGender == null || SelectGender.SelectedItem == null)? "" : SelectGender.SelectedItem.ToString()),
DateOfBirth = ((SelectDateOfBirth == null || SelectDateOfBirth.Date == null)? "" : SelectDateOfBirth.Date.ToString("dd/MM/yyyy")),
Address1 = EntryAddress1.Text,
Address2 = EntryAddress2.Text,
Address3 = EntryAddress3.Text,
Email = json.Email,
PhoneNumber = json.PhoneNumber,
Content = tmpImageBytesNew,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
};
db.CreateTable <ProfileTable>();
db.Insert(item);
//json.UserName = username;
json.FirstName = EntryFirstName.Text;
json.LastName = EntryLastName.Text;
if (SelectGender != null && SelectGender.SelectedItem != null)
{
json.Gender = SelectGender.SelectedItem.ToString();
}
if (SelectDateOfBirth != null && SelectDateOfBirth.Date != null)
{
json.DateOfBirth = SelectDateOfBirth.Date.ToString("dd/MM/yyyy");
}
json.Address1 = EntryAddress1.Text;
json.Address2 = EntryAddress2.Text;
json.Address3 = EntryAddress3.Text;
//json.Email = email;
//json.PhoneNumber = EntryUserPhoneNumber.Text;
//json.CreateDate = DateTime.Now.ToString("dd/MM/yyyy hh:mm tt");
json.UpdateDate = DateTime.Now.ToString("dd/MM/yyyy hh:mm tt");
await apiRequestHelper.RequestUpdateProfileAsync(json);
Device.BeginInvokeOnMainThread(async() =>
{
Toast.MakeText(context, "บันทึกข้อมูลสำเร็จ", ToastLength.Short).Show();
});
}
else
{
var item = db.Table <ProfileTable>().Where(u => u.UserName.Equals(username)).FirstOrDefault();
if (item != null)
{
item.FirstName = EntryFirstName.Text;
item.LastName = EntryLastName.Text;
if (SelectGender != null && SelectGender.SelectedItem != null)
{
item.Gender = SelectGender.SelectedItem.ToString();
}
if (SelectDateOfBirth != null && SelectDateOfBirth.Date != null)
{
item.DateOfBirth = SelectDateOfBirth.Date.ToString("dd/MM/yyyy");
}
item.Address1 = EntryAddress1.Text;
item.Address2 = EntryAddress2.Text;
item.Address3 = EntryAddress3.Text;
//item.Email = email;
item.PhoneNumber = EntryUserPhoneNumber.Text;
if (tmpImageBytesNew != null)
{
item.Content = tmpImageBytesNew;
}
item.UpdateDate = DateTime.Now;
db.RunInTransaction(() =>
{
db.Update(item);
});
json.UserName = username;
json.ProfileId = item.ProfileId.ToString();
json.FirstName = EntryFirstName.Text;
json.LastName = EntryLastName.Text;
if (SelectGender != null && SelectGender.SelectedItem != null)
{
json.Gender = SelectGender.SelectedItem.ToString();
}
if (SelectDateOfBirth != null && SelectDateOfBirth.Date != null)
{
json.DateOfBirth = SelectDateOfBirth.Date.ToString("dd/MM/yyyy");
}
json.Address1 = EntryAddress1.Text;
json.Address2 = EntryAddress2.Text;
json.Address3 = EntryAddress3.Text;
//json.Email = email;
//json.PhoneNumber = EntryUserPhoneNumber.Text;
json.UpdateDate = DateTime.Now.ToString("dd/MM/yyyy hh:mm tt");
var result = await apiRequestHelper.RequestUpdateProfileAsync(json);
Console.WriteLine("SaveProfile result:", result);
Device.BeginInvokeOnMainThread(async() =>
{
Toast.MakeText(context, "บันทึกข้อมูลสำเร็จ", ToastLength.Short).Show();
});
}
else
{
//TODO เอาข้อมูลจาก Cloud มาอัพเดท Local DB
item = new ProfileTable()
{
UserName = username,
FirstName = EntryFirstName.Text,
LastName = EntryLastName.Text,
Gender = ((SelectGender == null || SelectGender.SelectedItem == null) ? "" : SelectGender.SelectedItem.ToString()),
DateOfBirth = ((SelectDateOfBirth == null || SelectDateOfBirth.Date == null) ? "" : SelectDateOfBirth.Date.ToString("dd/MM/yyyy")),
Address1 = EntryAddress1.Text,
Address2 = EntryAddress2.Text,
Address3 = EntryAddress3.Text,
Email = json.Email,
PhoneNumber = json.PhoneNumber,
Content = tmpImageBytesNew,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
};
db.CreateTable <ProfileTable>();
db.Insert(item);
//json.UserName = username;
json.FirstName = EntryFirstName.Text;
json.LastName = EntryLastName.Text;
if (SelectGender != null && SelectGender.SelectedItem != null)
{
json.Gender = SelectGender.SelectedItem.ToString();
}
if (SelectDateOfBirth != null && SelectDateOfBirth.Date != null)
{
json.DateOfBirth = SelectDateOfBirth.Date.ToString("dd/MM/yyyy");
}
json.Address1 = EntryAddress1.Text;
json.Address2 = EntryAddress2.Text;
json.Address3 = EntryAddress3.Text;
//json.Email = email;
//json.PhoneNumber = EntryUserPhoneNumber.Text;
//json.CreateDate = DateTime.Now.ToString("dd/MM/yyyy hh:mm tt");
json.UpdateDate = DateTime.Now.ToString("dd/MM/yyyy hh:mm tt");
await apiRequestHelper.RequestUpdateProfileAsync(json);
Device.BeginInvokeOnMainThread(async() =>
{
Toast.MakeText(context, "บันทึกข้อมูลสำเร็จ", ToastLength.Short).Show();
});
}
//Refresh Profile Image
var md = (MasterDetailPage)Application.Current.MainPage;
var menu = (MainPageMaster)md.Master;
menu.LoadProfile();
return;
}
}
}
}
partial void InsertProfileTable(ProfileTable instance);
partial void UpdateProfileTable(ProfileTable instance);
public async void LoadProfile()
{
if (Application.Current.Properties.ContainsKey("USER_NAME"))
{
var username = Application.Current.Properties["USER_NAME"] as string;
//Remove codes for retreiving data from local database
/*
* var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db");
* var db = new SQLiteConnection(dbpath);
* var myquery = db.Table<RegUserTable>().Where(u => u.UserName.Equals(username)).FirstOrDefault();
*
* if (myquery != null)
* {
*
* }
*/
//End of local database
RootProfileObject profileData = await apiRequestHelper.RequestProfileAsync(username);
if (profileData != null && profileData.Data != null && profileData.Data.Count > 0)
{
var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db");
var db = new SQLiteConnection(dbpath);
var profileTable = db.GetTableInfo("ProfileTable");
if (profileTable.Count == 0)
{
List <ProfileJson> Data = profileData.Data;
ProfileJson json = Data.First <ProfileJson>();
db.CreateTable <ProfileTable>();
ProfileTable item = new ProfileTable()
{
UserName = username,
FirstName = json.FirstName,
LastName = json.LastName,
Gender = json.Gender,
DateOfBirth = json.DateOfBirth,
Address1 = json.Address1,
Address2 = json.Address2,
Address3 = json.Address3,
Email = json.Email,
PhoneNumber = json.PhoneNumber,
CreateDate = DateTime.Now,
};
db.Insert(item);
//
string fullName = "";
if (item.FirstName != null)
{
fullName = item.FirstName;
}
if (item.LastName != null)
{
fullName += " " + item.LastName;
}
AccountName.Text = fullName;
}
else
{
var profile = db.Table <ProfileTable>().Where(u => u.UserName.Equals(username)).FirstOrDefault();
if (profile != null)
{
string fullName = "";
if (profile.FirstName != null)
{
fullName = profile.FirstName;
}
if (profile.LastName != null)
{
fullName += " " + profile.LastName;
}
AccountName.Text = fullName;
if (profile.Content != null)
{
ImageBytes = profile.Content;
Stream sm = BytesToStream(ImageBytes);
selectedImage.Source = ImageSource.FromStream(() => sm);
}
}
}
}
}
}
partial void DeleteProfileTable(ProfileTable instance);
public UserProfileController()
{
this._profileTable = new ProfileTable();
this._userTable = new UserTable();
validatepermissions = new validatePermissions();
}
/// <summary>
/// Load stored profiles from a ConfigNode in the ScienceAlert
/// directory
/// </summary>
private void LoadStoredProfiles()
{
try
{
storedProfiles = new ProfileTable();
if (!System.IO.File.Exists(ProfileStoragePath))
{
Log.Warning("ProfileManager: Profile config not found at '{0}'", ProfileStoragePath);
}
else
{
Log.Debug("ProfileManager: Loading profile config from '{0}'", ProfileStoragePath);
ConfigNode stored = ConfigNode.Load(ProfileStoragePath);
if (stored == null || !stored.HasNode(STORED_NODE_NAME))
{
Log.Error("ProfileManager: Failed to load config");
}
else
{
stored = stored.GetNode(STORED_NODE_NAME); // to avoid having an empty cfg, which will
// cause KSP to hang at load
var profiles = stored.GetNodes("PROFILE");
Log.Verbose("Found {0} stored profiles to load", profiles.Length);
foreach (var profileNode in profiles)
{
try
{
Profile p = new Profile(profileNode);
p.modified = false; // by definition, stored profiles haven't been modified
storedProfiles.Add(p.name, p);
Log.Verbose("Loaded profile '{0}' successfully!", p.name);
}
catch (Exception e)
{
Log.Error("ProfileManager: profile '{0}' failed to parse; {1}", name, e);
}
}
}
}
// make sure there's a "default" config in there. Ideally the
// user has created and saved over one but if not, we need
// at least a default to give to vessels that are missing their
// profiles
if (DefaultProfile == null)
{
storedProfiles.Add("default", Profile.MakeDefault());
}
} catch (Exception e)
{
Log.Error("ProfileManager: Exception loading stored profiles: {0}", e);
// don't keep anything that might have been loaded; something's
// gone seriously wrong but we might manage to salvage things if
// we accept the loss of stored data and use the vessel-specific
// profiles instead
storedProfiles = new ProfileTable();
}
}
//Update or Save Profile Values Field in database
public HttpResponseMessage ProfileDetails(ProfileModel model)
{
//Check Whether Model state is valid or not.
if (ModelState.IsValid)
{
var context = new WebApiEntities();
//Create object of database Profile Table
ProfileTable profile = new ProfileTable();
// Split Token by - sign
string[] tokenArray = model.GenToken.Split('-');
// Get ID value by third element of tokenArray
string ID = tokenArray[3];
//convert string DOB into DateTime
string inString = model.DOB;
DateTime dateValue;
if (!DateTime.TryParse(inString, out dateValue))
{
Request.CreateErrorResponse(HttpStatusCode.PartialContent, "Please fill correct date of birth");
}
//Update profile Data for Existing User
if (context.ProfileTables.Any(user => user.UserID.ToString() == ID))
{
//Query Statement for Specific ID
var query = from user in context.ProfileTables where ID == user.UserID.ToString() select user.ID;
//Update Values
profile.FirstName = model.Fname;
profile.LastName = model.Lname;
profile.DOB = dateValue;
profile.UserID = Convert.ToInt32(ID);
profile.Language = model.Language;
profile.ID = query.First();
context.ProfileTables.Attach(profile);
context.Entry(profile).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
//Return Message Profile Update with Ok status
return(Request.CreateResponse(HttpStatusCode.OK, "Profile Updated"));
}
// Create New Profile data for New User
else
{
//Save new user value into database
profile.UserID = Convert.ToInt32(ID);
profile.FirstName = model.Fname;
profile.LastName = model.Lname;
profile.DOB = dateValue;
profile.Language = model.Language;
context.ProfileTables.Add(profile);
context.SaveChanges();
//Return Message Profile Save with Ok status
return(Request.CreateResponse(HttpStatusCode.OK, "Profile Save"));
}
}
// Create Error Response with Bad Request. and send message please fill again to client
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "please Fill again"));
}
async void Login_Clicked(object sender, EventArgs e)
{
if (EntryUser.Text == null)
{
//await this.DisplayAlert(null, "กรุณาระบุชื่อผู้ใช้งาน", null, "ตกลง");
EntryUser.PlaceholderColor = Color.FromHex("#ffb3ba");
EntryUser.Placeholder = "กรุณาระบุชื่อผู้ใช้งาน";
EntryUser.Focus();
return;
}
if (EntryPassword.Text == null)
{
//await this.DisplayAlert(null, "กรุณาระบุรหัสผ่าน", null, "ตกลง");
EntryPassword.PlaceholderColor = Color.FromHex("#ffb3ba");
EntryPassword.Placeholder = "กรุณาระบุรหัสผ่าน";
EntryPassword.Focus();
return;
}
btnLogin.IsEnabled = false;
//Cloud database
//Register data to firebase also
RegUserJson user = await apiRequestHelper.RequestLoginUserAsync(EntryUser.Text, EntryPassword.Text);
if (user != null & user.UserName == EntryUser.Text)
{
var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db");
var db = new SQLiteConnection(dbpath);
var reguser = db.GetTableInfo("RegUserTable");
if (reguser.Count == 0)
{
db.CreateTable <RegUserTable>();
var item = new RegUserTable()
{
UserName = user.UserName,
Password = user.Password,
Email = user.Email,
PhoneNumber = user.PhoneNumber,
};
db.Insert(item);
}
else
{
var item = db.Table <RegUserTable>().Where(u => u.UserName.Equals(user.UserName)).FirstOrDefault();
if (item == null)
{
var data = new RegUserTable()
{
UserName = user.UserName,
Password = user.Password,
Email = user.Email,
PhoneNumber = user.PhoneNumber,
};
db.Insert(data);
}
}
RootProfileObject profileData = await apiRequestHelper.RequestProfileAsync(user.UserName);
if (profileData != null && profileData.Data != null && profileData.Data.Count > 0)
{
List <ProfileJson> Data = profileData.Data;
if (Data.Count > 0)
{
ProfileJson json = Data.First <ProfileJson>();
var userprofile = db.GetTableInfo("ProfileTable");
if (userprofile.Count == 0)
{
db.CreateTable <ProfileTable>();
var profile = new ProfileTable()
{
UserName = json.UserName,
FirstName = json.FirstName,
LastName = json.LastName,
Gender = (json.Gender == null ? "" : json.Gender),
DateOfBirth = (json.DateOfBirth == null ? "" : json.DateOfBirth),
Address1 = json.Address1 == null? "" : json.Address1,
Address2 = json.Address2 == null ? "" : json.Address2,
Address3 = json.Address3 == null ? "" : json.Address3,
Email = json.Email,
PhoneNumber = json.PhoneNumber,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
};
db.Insert(profile);
}
else
{
var item = db.Table <ProfileTable>().Where(u => u.UserName.Equals(user.UserName)).FirstOrDefault();
if (item == null)
{
var profile = new ProfileTable()
{
UserName = json.UserName,
FirstName = json.FirstName,
LastName = json.LastName,
Gender = (json.Gender == null ? "" : json.Gender),
DateOfBirth = (json.DateOfBirth == null ? "" : json.DateOfBirth),
Address1 = json.Address1 == null ? "" : json.Address1,
Address2 = json.Address2 == null ? "" : json.Address2,
Address3 = json.Address3 == null ? "" : json.Address3,
Email = json.Email,
PhoneNumber = json.PhoneNumber,
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now,
};
db.Insert(profile);
}
}
}
}
///////////////////
Device.StartTimer(TimeSpan.FromSeconds(0.1), () => {
btnLogin.IsEnabled = true;
Toast.MakeText(context, "Login Successfull", ToastLength.Short).Show();
Application.Current.Properties.Add("USER_NAME", EntryUser.Text);
App.Current.MainPage = new MainPage();
return(false);
});
}
else
{
Device.BeginInvokeOnMainThread(async() =>
{
var result2 = await this.DisplayAlert(null, "ข้อผิดพลาด! ไม่พบข้อมูลผู้ใช้งาน\nกรุณาตรวจสอบชื่อผู้ใช้งานและรหัสผ่าน", null, "ตกลง");
if (!result2)
{
btnLogin.IsEnabled = true;
EntryUser.Focus();
}
});
}
//End of Cloud database
//Local database
/*
* var dbpath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "UserDatabase.db");
* var db = new SQLiteConnection(dbpath);
* db.CreateTable<RegUserTable>();
* var myquery = db.Table<RegUserTable>().Where(u => u.UserName.Equals(EntryUser.Text) && u.Password.Equals(EntryPassword.Text)).FirstOrDefault();
*
* if (myquery != null)
* {
* Application.Current.Properties.Add("USER_NAME", myquery.UserName);
* App.Current.MainPage = new MainPage();
* }
* else
* {
* Device.BeginInvokeOnMainThread(async () => {
* if(EntryUser.Text == null)
* {
* //await this.DisplayAlert(null, "กรุณาระบุชื่อผู้ใช้งาน", null, "ตกลง");
* EntryUser.PlaceholderColor = Color.FromHex("#ffb3ba");
* EntryUser.Placeholder = "กรุณาระบุชื่อผู้ใช้งาน";
* EntryUser.Focus();
* return;
* }
*
* if (EntryPassword.Text == null)
* {
* //await this.DisplayAlert(null, "กรุณาระบุรหัสผ่าน", null, "ตกลง");
* EntryPassword.PlaceholderColor = Color.FromHex("#ffb3ba");
* EntryPassword.Placeholder = "กรุณาระบุรหัสผ่าน";
* EntryPassword.Focus();
* return;
* }
*
* var result = await this.DisplayAlert(null, "ข้อผิดพลาด! ไม่พบข้อมูลผู้ใช้งาน\nกรุณาตรวจสอบชื่อผู้ใช้งานและรหัสผ่าน", null, "ตกลง");
*
* if (!result)
* {
* EntryUser.Focus();
* }
* });
*
* }
*/
//End of Local database
}
