//[ValidateAntiForgeryToken]
public async Task<ActionResult> Login(LoginViewModel model, string returnUrl)
{
ResponseJson response = new ResponseJson();
try
{
if (ModelState.IsValid)
{
using (UserDB db = new UserDB())
{
var user = db.LogIn(model.UserName, Globals.Encrypt(model.Password)).SingleOrDefault();
if (user != null)
{
await SignInAsync(new ApplicationUser() { UserName = model.UserName }, model.RememberMe);
//return RedirectToLocal(returnUrl);
}
else
{
response.IsError = true;
response.Id = -3;
}
}
}
}
catch (Exception ex)
{
response.IsError = true;
response.Id = -6;
}
return Json(response, JsonRequestBehavior.AllowGet);
}
public void loadUser()
{
UserDB udb = new UserDB();
User u= udb.loadUser(1);
Assert.IsNotNull(u);
}
public MessageInfo(MessageDB message, UserDB msgFrom)
{
this.Message = message;
this.MessageUser = msgFrom;
pStepTypesForStrip = new List<MessageStep.StepTypes> ();
IsTextOnlyChecked = false;
}
public void loadUsers()
{
UserDB udb = new UserDB();
List<User> ul = udb.loadAllUsers();
int result = ul.Count;
Assert.IsNotNull(ul);
}
public void updatePostal()
{
UserDB udb = new UserDB();
int result = udb.updatePostal("user", "pass", "4500");
Assert.AreEqual(1, result);
}
public void deleteUser()
{
UserDB udb = new UserDB();
User u = udb.findUser("user");
int id = u.id;
int result = udb.deleteUser(id);
Assert.AreEqual(1,result);
}
public void updateUser()
{
UserDB udb = new UserDB();
int result= udb.updateUser(1, "name", "user", "pass","email", " ", "address", "phone", "asd", "asd");
Assert.AreEqual(1,result);
}
public void RegisterUser()
{
//arrange
UserDB udb = new UserDB();
// act
udb.RegisterUser("slimshady","shady","secret","*****@*****.**","sesamestr","55555","USA","35000","salt");
//assert
//Assert.Inconclusive();
}
public int SaveUser(UserUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
{
int UserID = 0;
bool flagTransation = true;
UserDB objDB = new UserDB();
objDB.FullName = objUI.FullName;
objDB.EmployeeCode = objUI.EmployeeCode;
objDB.EmailID = objUI.EmailID;
objDB.RoleID = objUI.RoleID;
objDB.LoginID = objUI.LoginID;
objDB.Password = objUI.Password;
objDB.PhoneNo = objUI.PhoneNo;
objDB.MobileNo = objUI.MobileNo;
objDB.PermanentAddress = objUI.PermanentAddress;
objDB.CurrentAddress= objUI.CurrentAddress;
objDB.DateOfJoing = objUI.DateOfJoing;
objDB.CheckID = objUI.CheckID;
objDB.Id = objUI.Id;
objDB.UserTypeID = objUI.UserTypeID;
objDB.LevelID = objUI.LevelID;
objDB.IsActive = objUI.IsActive;
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
UserManager objManager = new UserManager();
UserID = objManager.SaveUser(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
return UserID;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
internal LogIn_Result GetCurrentUser()
{
LogIn_Result user = httpContext.Session["login"] as LogIn_Result;
if (user == null && httpContext.Request.IsAuthenticated)
{
using (UserDB db = new UserDB())
{
user = db.LogIn(httpContext.User.Identity.GetUserName(),null).SingleOrDefault();
httpContext.Session["login"] = user;
}
}
return user;
}
/// <summary>
/// Get User info from session
/// </summary>
/// <param name="info">Session row about User</param>
public static UserDB GetUser(DataRow info)
{
UserDB result = new UserDB();
try
{
result.userID = info["userID"].ToString();
result.password = info["password"].ToString();
result.fullname = info["fullname"].ToString();
result.lastLogin = (DateTime)info["lastLogin"];
result.departID = (int)info["departID"];
result.userType = (int)info["userType"];
}
catch { }
return result;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable datatable = (DataTable)Session["ThanhVien"];
if (datatable != null)
{
user = UserDB.GetUser(datatable.Rows[0]);
//Fill to customer order session
if (Session["Order"] == null) InitOrderSession();
}
//DisplayOrderForm();
}
else {
//InitOrder
}
}
public void Message_GetByListCompleted(object s, MessageGetByListCompletedEventArgs e)
{
LOLMessageClient client = (LOLMessageClient)s;
client.MessageGetByListCompleted -= Message_GetByListCompleted;
if (e.Error == null)
{
MessageDB msgDB = new MessageDB();
foreach (LOLMessageDelivery.Message message in e.Result)
{
msgDB = MessageDB.ConvertFromMessage(message);
MessageConversations.initialMessages.Add(msgDB);
}
List<MessageDB> sortedList = new List<MessageDB>();
sortedList = MessageConversations.initialMessages.OrderBy(t => t.MessageSent).ToList();
MessageConversations.initialMessages = sortedList;
dbm.InsertOrUpdateMessages(sortedList);
List<Guid> users = new List<Guid>();
for (int i = 0; i < MessageConversations.initialMessages.Count; ++i)
{
foreach (MessageRecipientDB guid in MessageConversations.initialMessages[i].MessageRecipientDBList)
{
UserDB user = new UserDB();
user = dbm.GetUserWithAccountID(guid.AccountGuid);
if (user == null && (guid.AccountGuid != AndroidData.CurrentUser.AccountID.ToString()))
users.Add(new Guid(guid.AccountGuid));
}
}
if (users.Count == 0)
{
RunOnUiThread(delegate
{
if (progress != null)
progress.Dismiss();
CreateUI();
});
} else
{
createIt = true;
Contacts.AddUnknownUser auu = new Contacts.AddUnknownUser(users, context);
//createNewUsers (users);
}
}
}
async public void SaveToParse ()
{
ParseObject user;
if (this.ParseId == null || this.ParseId == "") {
user = new ParseObject ("Usuario");
} else {
ParseQuery<ParseObject> query = ParseObject.GetQuery ("Usuario");
user = await query.GetAsync (this.ParseId);
}
user ["Usuario_facebook"] = this.Facebook;
user ["Usuario_twitter"] = this.Twitter;
await user.SaveAsync ().ContinueWith (t => {
this.ParseId = user.ObjectId;
Console.WriteLine("Saved User in Parse: " + this.ParseId);
UserDB userDB = new UserDB ();
userDB.Update (this);
});
}
public void Register(UserAccount user)
{
user.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(user.Password, "sha1");
UserDB.Add(user);
SaveChanges();
}
public IEnumerable <User> GetUsers([FromUri] string userType = null, [FromUri] string userName = null, [FromUri] ActiveStatusEnum active = ActiveStatusEnum.Active,
[FromUri] UserOrderEnum order = UserOrderEnum.Id,
[FromUri] OrderEnum orderDirection = OrderEnum.Asc)
{
return(UserDB.GetUsers(userType, userName, active, order, orderDirection));
}
public User CreateUser([FromBody] User user)
{
return(UserDB.CreateUser(user));
}
public async Task <bool> AddNewCardToUserCollection(DefaultCollectionDataDB dfCollCardToAdd, UserDB pUser)
{
bool isLoaded = await fbUserCardCollection.SetNewCardToUserCardCollection(dfCollCardToAdd, pUser);
return(isLoaded);
}
public async Task <long> GetLastUserCollectionModificationByUser(UserDB pUser)
{
long bdLastUserCollectionModification = await fbUserCardCollectionUpdater.GetLastUserCardCollectioModificationTimestampUser(pUser.Name.ToLower());
return(bdLastUserCollectionModification);
}
private void LoadUserImage(UserDB user, ImageView profilePic)
{
if (user.Picture.Length == 0)
RunOnUiThread(() => profilePic.SetImageResource(Resource.Drawable.defaultuserimage));
else
using (Bitmap img = ImageHelper.CreateUserProfileImageForDisplay(user.Picture, (int)imageSize[0], (int)imageSize[0], this.Resources))
{
RunOnUiThread(() => profilePic.SetImageBitmap(img));
}//end using
}
public void 進行描画する(DeviceContext1 dc)
{
var 描画領域 = new RectangleF(10f, 340f, 275f, 98f);
if (App.曲ツリー.フォーカス曲ノード != this._現在表示しているノード)
{
#region " フォーカスノードが変更されたので情報を更新する。"
//----------------
this._現在表示しているノード = App.曲ツリー.フォーカス曲ノード; // MusicNode 以外は null が返される
this._スキル値文字列 = null;
if (null != this._現在表示しているノード)
{
using (var userdb = new UserDB())
{
var record = userdb.Records.Where((r) => (r.UserId == App.ユーザ管理.ログオン中のユーザ.ユーザID && r.SongHashId == this._現在表示しているノード.曲ファイルハッシュ)).SingleOrDefault();
if (null != record)
{
this._スキル値文字列 = record.Skill.ToString("0.00").PadLeft(6); // 右詰め、余白は' '。
}
}
}
//----------------
#endregion
}
if (this._スキル値文字列.Nullまたは空である())
{
return;
}
bool 表示可能ノードである = (this._現在表示しているノード is MusicNode);
if (表示可能ノードである)
{
グラフィックデバイス.Instance.D2DBatchDraw(dc, () => {
var pretrans = dc.Transform;
// 曲別SKILLアイコンを描画する。
dc.Transform =
Matrix3x2.Scaling(0.5f, 0.4f) *
Matrix3x2.Translation(描画領域.X, 描画領域.Y + 10f) *
pretrans;
this._ロゴ画像.描画する(dc, 0f, 0f);
// 小数部を描画する。
dc.Transform =
Matrix3x2.Scaling(0.8f, 0.8f) *
Matrix3x2.Translation(描画領域.X + 130f + 175f, 描画領域.Y + (描画領域.Height * 0.2f)) *
pretrans;
this._数字画像.描画する(dc, 0f, 0f, _スキル値文字列.Substring(4));
// 整数部を描画する（'.'含む）。
dc.Transform =
Matrix3x2.Scaling(1f, 1.0f) *
Matrix3x2.Translation(描画領域.X + 130f, 描画領域.Y) *
pretrans;
this._数字画像.描画する(dc, 0f, 0f, _スキル値文字列.Substring(0, 4));
});
}
}
private void loadProfilePicture(UserDB user, ImageView image)
{
RunOnUiThread(delegate
{
using (Bitmap img = ImageHelper.CreateUserProfileImageForDisplay(user.Picture, this.thumbImageWidth, this.thumbImageHeight, this.Resources))
{
image.SetImageBitmap(img);
}//end using
});
}
public User GetUserByID(int userID)
{
UserDB userDB = new UserDB();
return userDB.GetById(userID);
}
public async Task <bool> CanUserBuyAPackANormalPack(UserDB user)
{
bool canOpen = await fbUserResourcesPacks.IsUserAllowToBuyAPack(user, CARDPACKTYPE.NORMAL);
return(canOpen);
}
public void RestOneOpenPackFromFirebase(UserDB pUser)
{
fbUserResourcesPacks.SetNewUnopenPackAmountToUser(pUser, -1);
}
public void BuyPackDB(UserDB user)
{
fbUserResourcesPacks.BuyNewPack(user, CARDPACKTYPE.NORMAL);
}
public void CreateNewUserResources(UserDB pUser)
{
fbUserResources.CreateNewUserResources(pUser);
}
public static IDAO <User> getUserDAO()
{
UserDB userDB = new UserDB();
return(userDB);
}
public int SaveUserDetail(UserUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
{
int UserID = 0;
bool flagTransation = true;
UserDB objDB = new UserDB();
objDB.UserID = objUI.UserID;
//objDB.LevelID = objUI.LevelID;
objDB.dRegionID = objUI.dRegionID;
objDB.ReportsToID = objUI.ReportsToID;
objDB.CheckID = objUI.CheckID;
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
UserManager objManager = new UserManager();
UserID = objManager.SaveUserDetail(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
return UserID;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
public void isUsernameAvaiable()
{
UserDB udb = new UserDB();
int result= udb.isUsernameAvailable("user");
Assert.AreEqual(1,result);
}
private void CreateUI()
{
if (MessageConversations.clearView)
{
RunOnUiThread(() => listWrapper.RemoveAllViewsInLayout());
MessageConversations.clearView = false;
}
int c = 0;
List<int> unreadMessages = new List<int>();
int numberInConversation = 0;
foreach (LOLMessageConversation conversation in MessageConversations.conversationsList)
{
unreadMessages.Add(conversation.MessageIDs.Count - conversation.ReadMessageIDs.Count);
int t = 0;
}
if (unknownUsers == null)
unknownUsers = new List<Guid>();
else
unknownUsers.Clear();
myView = null;
LayoutInflater factory = LayoutInflater.From(this);
List<Guid> unknownMessages = new List<Guid>();
foreach (MessageDB latestMessage in MessageConversations.initialMessages)
{
UserDB whoFrom = new UserDB();
whoFrom = dbm.GetUserWithAccountID(MessageConversations.conversationsList [c].Recipients [0].ToString());
if (latestMessage.MessageRecipientDBList.Count != 0)
{
if (whoFrom == null && latestMessage.MessageRecipientDBList [0].AccountGuid == AndroidData.CurrentUser.AccountID.ToString())
whoFrom = UserDB.ConvertFromUser(AndroidData.CurrentUser);
if (whoFrom != null)
{
#if DEBUG
System.Diagnostics.Debug.WriteLine("c = {0}, Recipient[0] Guid = {1}, whoFrom name = {2} {3}", c, MessageConversations.conversationsList [c].Recipients [0],
whoFrom.FirstName, whoFrom.LastName);
#endif
List<UserDB> users = new List<UserDB>();
numberInConversation = latestMessage.MessageRecipientDBList.Count;
for (int i = 0; i < (numberInConversation > 3 ? 3 : numberInConversation); ++i)
{
if (latestMessage.MessageRecipientDBList [i] != null)
{
UserDB current = dbm.GetUserWithAccountID(latestMessage.MessageRecipientDBList [i].AccountGuid.ToString());
if (current == null && latestMessage.MessageRecipientDBList [i].AccountGuid != AndroidData.CurrentUser.AccountID.ToString())
unknownUsers.Add(new Guid(latestMessage.MessageRecipientDBList [i].AccountGuid));
else
{
//users.Add (current);
if (current == null && latestMessage.MessageRecipientDBList [i].AccountGuid == AndroidData.CurrentUser.AccountID.ToString())
users.Add(UserDB.ConvertFromUser(AndroidData.CurrentUser));
else
users.Add(current);
}
}
}
UserDB sender = new UserDB();
sender = dbm.GetUserWithAccountID(latestMessage.FromAccountGuid);
if (sender == null)
sender = UserDB.ConvertFromUser(AndroidData.CurrentUser);
if (numberInConversation == 1)
myView = factory.Inflate(Resource.Layout.lstConversation, null);
else
myView = factory.Inflate(Resource.Layout.lstConversationMulti, null);
int leftOver = (int)wowZapp.LaffOutOut.Singleton.ScreenXWidth - (int)ImageHelper.convertDpToPixel(imageSize [0] + 30f, context);
LinearLayout shell = new LinearLayout(context);
shell.Orientation = Orientation.Horizontal;
shell.SetGravity(GravityFlags.CenterVertical);
shell.LayoutParameters = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.FillParent, LinearLayout.LayoutParams.WrapContent);
shell.SetPadding(0, 0, 0, (int)ImageHelper.convertDpToPixel(5f, context));
RunOnUiThread(() => shell.AddView(myView));
if (users.Count != 0)
generateUserImage(users, shell);
TextView whoAmI = shell.FindViewById<TextView>(Resource.Id.textNames);
string myName = sender.FirstName + " " + sender.LastName;
if (numberInConversation != 1)
{
myName += string.Format(" and {0} other{1}", numberInConversation == 2 ? "1" :
(numberInConversation - 1).ToString(), numberInConversation == 2 ? "." : "s.");
}
whoAmI.Text = myName;
whoAmI.SetTextSize(Android.Util.ComplexUnitType.Dip, 12f);
TextView txtMessage = shell.FindViewById<TextView>(Resource.Id.textMessageBubble);
if (latestMessage.MessageStepDBList.Count == 1 && latestMessage.MessageStepDBList [0].StepType == MessageStep.StepTypes.Text)
{
txtMessage = messageTextBox(txtMessage, latestMessage, 0, leftOver);
} else
{
for (int n = 0; n < latestMessage.MessageStepDBList.Count; ++n)
{
if (latestMessage.MessageStepDBList [n].StepType == MessageStep.StepTypes.Text)
{
txtMessage = messageTextBox(txtMessage, latestMessage, n, leftOver);
break;
}
}
}
txtMessage.ContentDescription = latestMessage.MessageID.ToString();
#if DEBUG
System.Diagnostics.Debug.WriteLine("ContentDesctription = {0}, ID = {1}", txtMessage.ContentDescription, latestMessage.ID);
#endif
txtMessage.Click += textMessage_Click;
TextView txtDateSent = shell.FindViewById<TextView>(Resource.Id.textDateSent);
txtDateSent.Text = latestMessage.MessageSent.ToShortDateString();
TextView txtMessageUnread = shell.FindViewById<TextView>(Resource.Id.txtMessageUnread);
txtMessageUnread.SetTextSize(Android.Util.ComplexUnitType.Dip, 10f);
if (unreadMessages [c] == 0)
txtMessageUnread.Text = context.Resources.GetString(Resource.String.conversationUINoUnreadMessages);
else
txtMessageUnread.Text = string.Format("({0}) {1}{2}", unreadMessages [c],
context.Resources.GetString(Resource.String.conversationUIUnreadMessages),
unreadMessages [c] == 1 ? "." : "s.");
LinearLayout messageItems = shell.FindViewById<LinearLayout>(Resource.Id.linearLayout7);
if (latestMessage.MessageStepDBList.Count > 0)
{
createMessageBar(messageItems, latestMessage, leftOver);
messageItems.ContentDescription = latestMessage.MessageGuid;
messageItems.Click += messageBar_Click;
}
RunOnUiThread(delegate
{
listWrapper.AddView(shell);
shell = null;
});
#if DEBUG
System.Diagnostics.Debug.WriteLine("done a loop");
#endif
}
}
if (c < MessageConversations.initialMessages.Count - 2)
c++;
}
//});
if (unknownUsers.Count != 0)
{
Contacts.AddUnknownUser auu = new Contacts.AddUnknownUser(unknownUsers, context);
}
if (progress != null)
RunOnUiThread(() => progress.Dismiss());
}
public HttpResponseMessage Post([FromBody] TblUser value)
{
UserDB.TblUsers.Add(value);
return(ToJson(UserDB.SaveChanges()));
}
public bool UpdatePhoneNumber(int userID, string phoneNumber)
{
/*
UserDB userDB = new UserDB();
User user = userDB.GetById(userID);
user.PhoneNumber = phoneNumber;
Response<User> response = user.Update();
return response.Success;*/
UserDB userDB = new UserDB();
User user = userDB.GetById(userID);
user.PhoneNumber = phoneNumber;
Response<User> response = user.Update();
if (!response.Success) {
User updatedUser = userDB.GetById(userID);
if (updatedUser.PhoneNumber == phoneNumber) {
response.Success = true;
}
}
return response.Success;
}
public HttpResponseMessage Put(int id, [FromBody] TblUser value)
{
UserDB.Entry(value).State = EntityState.Modified;
return(ToJson(UserDB.SaveChanges()));
}
/// <summary>
/// Invoked when the application is launched normally by the end user. Other entry points
/// will be used such as when the application is launched to open a specific file.
/// </summary>
/// <param name="e">Details about the launch request and process.</param>
protected override void OnLaunched(LaunchActivatedEventArgs e)
{
if (localSettings.Values["IsAppFirstTimeLaunch"] == null || (bool)value == true)
{
localSettings.Values["IsAppFirstTimeLaunch"] = false;
var vault = new Windows.Security.Credentials.PasswordVault();
vault.Add(new Windows.Security.Credentials.PasswordCredential("TaskManagerApp", "Sabi", "123"));
vault.Add(new Windows.Security.Credentials.PasswordCredential("TaskManagerApp", "Sabitha", "123"));
UserDB.AddUser("Sabi", "/Assets/avatar1.PNG");
UserDB.AddUser("Sabitha", "/Assets/avatar4.PNG");
TaskDB.AddTask(new Model.TaskModel()
{
TaskName = "Cliq Login Page",
TaskId = 1223334444112,
AssignedByUser = "******",
AssignedToUser = "******",
Priority = 1,
StartDate = (DateTimeOffset)DateTime.Today,
EndDate = (DateTimeOffset)DateTime.Today,
Description = "lopoioiui wtyetyuiyruiewo"
});
TaskDB.AddTask(new Model.TaskModel()
{
TaskName = "Cliq SignIn Page",
TaskId = 987654321112,
AssignedByUser = "******",
AssignedToUser = "******",
Priority = 2,
StartDate = (DateTimeOffset)DateTime.Today,
EndDate = (DateTimeOffset)DateTime.Today,
Description = "Associated with an existing code-behind file using a qualifier that's part of the file or folder name"
});
TaskDB.AddTask(new Model.TaskModel()
{
TaskName = "Content Writing",
TaskId = 123456789112,
AssignedByUser = "******",
AssignedToUser = "******",
Priority = 1,
StartDate = (DateTimeOffset)DateTime.Today,
EndDate = (DateTimeOffset)DateTime.Today,
Description = "lopoioiui wtyetyuiyruiewo yuwiyeueiytiu"
});
TaskDB.AddTask(new Model.TaskModel()
{
TaskName = "Cliq List Tasks",
TaskId = 123456789113,
AssignedByUser = "******",
AssignedToUser = "******",
Priority = 2,
StartDate = (DateTimeOffset)DateTime.Today,
EndDate = (DateTimeOffset)DateTime.Today,
Description = "name the XAML view MainPage.DeviceFamily-Tablet.xaml. To create a view for PC devices, name the view MainPage.DeviceFamily-Desktop.xaml"
});
TaskDB.AddTask(new Model.TaskModel()
{
TaskName = "Fix Bugs in List Tasks",
TaskId = 123456789115,
AssignedByUser = "******",
AssignedToUser = "******",
Priority = 0,
StartDate = (DateTimeOffset)DateTime.Today,
EndDate = (DateTimeOffset)DateTime.Today,
});
TaskDB.AddTask(new Model.TaskModel()
{
TaskName = "Fix Bugs in List Tasks",
TaskId = 123456789116,
AssignedByUser = "******",
AssignedToUser = "******",
Priority = 2,
StartDate = (DateTimeOffset)DateTime.Today,
EndDate = (DateTimeOffset)DateTime.Today,
Description = "Load task module"
});
CommentDB.AddComment(new Model.Comment()
{
AuthorName = "Sabi",
CommentToTaskId = 123456789112,
Content = " If you cannot find a way to fit supporting evidence in just one or two sentences, use a different example altogether. There are certain topics that require a lot of room for explanation, so be careful not to choose a topic for your essay that will require too much evidence to support.",
CommentId = 99988660111,
Date = DateTime.Now,
Heart = 0,
Happy = 0,
Sad = 0,
Like = 0
});
CommentDB.AddComment(new Model.Comment()
{
AuthorName = "Sabitha", CommentToTaskId = 123456789112, Content = "Okay Done!", CommentId = 99988661111, Date = DateTime.Now, Heart = 0, Happy = 0, Sad = 0, Like = 0
});
CommentDB.AddComment(new Model.Comment()
{
AuthorName = "Sabi", CommentToTaskId = 987654321112, Content = " Only by examining how you reflect on your qualities can college admissions officers gain an understanding", CommentId = 9998866211, Date = DateTime.Now, Heart = 0, Happy = 0, Sad = 0, Like = 0
});
CommentDB.AddComment(new Model.Comment()
{
AuthorName = "Sabitha", CommentToTaskId = 1223334444112, Content = " Present, support, and introspect.", CommentId = 9998866311, Date = DateTime.Now, Heart = 0, Happy = 0, Sad = 0, Like = 0
});
CommentDB.AddComment(new Model.Comment()
{
AuthorName = "Sabitha", CommentToTaskId = 123456789116, Content = " Make sure a folder or the project, and not the solution, is selected in Solution Explorer.", CommentId = 999886631121, Date = DateTime.Now, Heart = 0, Happy = 0, Sad = 0, Like = 0
});
}
Frame rootFrame = Window.Current.Content as Frame;
// Do not repeat app initialization when the Window already has content,
// just ensure that the window is active
if (rootFrame == null)
{
// Create a Frame to act as the navigation context and navigate to the first page
rootFrame = new Frame();
rootFrame.NavigationFailed += OnNavigationFailed;
if (e.PreviousExecutionState == ApplicationExecutionState.Terminated)
{
//TODO: Load state from previously suspended application
}
// Place the frame in the current Window
Window.Current.Content = rootFrame;
}
if (e.PrelaunchActivated == false)
{
if (rootFrame.Content == null)
{
// When the navigation stack isn't restored navigate to the first page,
// configuring the new page by passing required information as a navigation
// parameter
rootFrame.Navigate(typeof(MainPage), e.Arguments);
}
// Ensure the current window is active
Window.Current.Activate();
}
}
public HttpResponseMessage Delete(int id)
{
UserDB.TblUsers.Remove(UserDB.TblUsers.FirstOrDefault(x => x.Id == id));
return(ToJson(UserDB.SaveChanges()));
}
public ActionResult Edit(int id)
{
var acc = new UserDB().ViewDetail(id);
return(View(acc));
}
public ActionResult ModifyPassword(int user_id, string pwd)
{
bool result = UserDB.UpdatePassword(user_id, pwd);
return(Json(result));
}
public async Task <long> GetLastUserCollectionDownloadByUser(UserDB pUser)
{
long bdLastUserCollectionDownloadByUser = await fbUserCardCollectionUpdater.GetLastUserCardCollectionDownloadTimestampUser(pUser.Name.ToLower());
return(bdLastUserCollectionDownloadByUser);
}
public ActionResult ModifyName(int user_id, string name)
{
bool result = UserDB.UpdateName(user_id, name);
return(Json(result));
}
public void RestCardAmountFromCardCollection(DefaultCollectionDataDB pCardData, UserDB pUserDB)
{
DefaultCollectionDataDB dfColl = new DefaultCollectionDataDB(pCardData.ID, 1);
fbUserCardCollection.RestCardAmountFromCardCollection(dfColl, pUserDB);
}
//for delate
public void DeleteInUser(int userId)
{
UserDB.DeleteInUserDetail(userId);
}
public User GetUser(int id)
{
return(UserDB.GetUser(id));
}
private void Message_ConversationsListComplete(object s, MessageGetConversationListCompletedEventArgs e)
{
LOLMessageClient client = (LOLMessageClient)s;
client.MessageGetConversationListCompleted -= Message_ConversationsListComplete;
if (e.Error == null)
{
if (MessageConversations.conversationsList.Count > 0)
MessageConversations.conversationsList.Clear();
MessageConversations.conversationsList = e.Result;
AndroidData.LastConvChecked = DateTime.Now;
if (MessageConversations.initialMessages == null)
MessageConversations.initialMessages = new List<MessageDB>();
else
MessageConversations.initialMessages.Clear();
List<Guid> messagesToGet = new List<Guid>();
for (int i = 0; i < MessageConversations.conversationsList.Count; ++i)
{
MessageDB message = new MessageDB();
message = dbm.GetMessage(MessageConversations.conversationsList [i].MessageIDs [0].ToString());
if (message == null)
{
messagesToGet.Add(MessageConversations.conversationsList [i].MessageIDs [0]);
#if DEBUG
System.Diagnostics.Debug.WriteLine("MessageID (being sucked) = {0}", MessageConversations.conversationsList [i].MessageIDs [0]);
#endif
} else
{
MessageConversations.initialMessages.Add(message);
#if DEBUG
System.Diagnostics.Debug.WriteLine("MessageID (already stored) = {0}", message.MessageGuid);
#endif
}
}
if (messagesToGet.Count != 0)
{
client.MessageGetByListCompleted += Message_GetByListCompleted;
client.MessageGetByListAsync(AndroidData.CurrentUser.AccountID, messagesToGet, AndroidData.CurrentUser.AccountID,
new Guid(AndroidData.ServiceAuthToken));
} else
{
List<Guid> users = new List<Guid>();
for (int i = 0; i < MessageConversations.initialMessages.Count; ++i)
{
foreach (MessageRecipientDB guid in MessageConversations.initialMessages[i].MessageRecipientDBList)
{
UserDB user = new UserDB();
user = dbm.GetUserWithAccountID(guid.AccountGuid);
if (user == null && (guid.AccountGuid != AndroidData.CurrentUser.AccountID.ToString()))
users.Add(new Guid(guid.AccountGuid));
}
}
if (users.Count == 0)
{
RunOnUiThread(delegate
{
if (progress != null)
progress.Dismiss();
CreateUI();
});
} else
{
createIt = true;
Contacts.AddUnknownUser auu = new Contacts.AddUnknownUser(users, context);
}
}
} else
{
int threadCount = waitThreadCount;
for (int i = 0; i < threadCount; i++)
{
signal.Set();
}//end for
isRefreshing = false;
RunOnUiThread(() => GeneralUtils.Alert(context, Application.Context.GetString(Resource.String.errorConversationGrabTitle),
Application.Context.GetString(Resource.String.errorConversationGrabMessage)));
}
}
public User UpdateUser([FromBody] User user)
{
return(UserDB.UpdateUser(user));
}
/*
private void MakeTempUsers()
{
UserInfo info = new UserInfo();
info.alias = "spox";
info.username = "******";
info.password = "******";
this._user_database.AddUser(info);
info = new UserInfo();
info.alias = "james";
info.username = "******";
info.password = "******";
this._user_database.AddUser(info);
info = new UserInfo();
info.alias = "cj";
info.username = "******";
info.password = "******";
this._user_database.AddUser(info);
}
*/
public void initialize()
{
this._user_database = new UserDB(this._controller.configuration);
this._hash_code = this.GetHashCode().ToString();
}
public void findUser()
{
UserDB udb = new UserDB();
User u = udb.findUser("user");
Assert.IsNotNull(u);
}
public DeleteVM(List <UserDB> userList, int id)
{
User = userList.Find(x => x.Identifier == id);
}
public void checkUser()
{
UserDB udb = new UserDB();
int result = udb.checkUser("name","pass");
Assert.AreEqual(1, result);
}
/// <summary>
/// 通过ID删除
/// </summary>
/// <param name="ID">用户ID</param>
/// <returns></returns>
public bool DeleteById(int ID)
{
return(UserDB.DeleteById(ID));
}
/// <summary>
/// Initializes a new instance of the <see cref="UserSql"/> class.
/// </summary>
public UserSql()
{
userDb = new UserDB();
userDb.DbClient = new SqlServerClient();
}
public List <BK_Users> GetUsers()
{
return(UserDB.GetList());
}
public bool ProcessOrder(List<PartOrder> partOrders, string phoneNr, string address)
{
//Create the user to be inserted into the database.
UserDB userDB = new UserDB();
User user = userDB.GetUserByPhone(phoneNr);
//if the user does not exist already, create one.
if (user == null)
{
user = new User();
user.PhoneNumber = phoneNr;
user.RankID = 0;
user.Create();
}
//Create the address to be inserted into the database.
AddressDB addressDB = new AddressDB();
Address userAddress = addressDB.GetByAddress(address);
//if the address does not exist already, create one.
if (userAddress == null)
{
userAddress = new Address();
userAddress.UserAddress = address;
userAddress.UserID = user.ID;
userAddress.Create();
}
//Create the order to be inserted to the database
Order order = new Order();
order.AddressID = userAddress.ID;
order.UserID = user.ID;
order.StatusID = OrderStatus.WAITING;
order.Create();
//The partorders are inserted to the database
PartOrderDB poDB = new PartOrderDB();
//For debugging Part Orders when something happens.
CustomHandlers.DatabaseLibrary.Response<PartOrder> r = poDB.CreateBatch(order.ID, partOrders);
foreach (string s in r.Messages)
{
Console.WriteLine(s);
}
return r.Success;
}
/// <summary>
/// 通过用户id获取用户数据
/// </summary>
/// <param name="id">用户id</param>
/// <returns></returns>
internal BK_Users GetUserByID(decimal id)
{
return(UserDB.GetById(id));
}
//get the filtered list of the user
public static object FilteredResultUser(bool status)
{
return(UserDB.FilterReseultUser(status));
}
private void CreateMessagesUI()
{
List<UserDB> participants = new List<UserDB>();
bool moreThanOne = false, isCurrentMe = false;
if (MessageConversations.clearView)
{
listWrapper.RemoveAllViewsInLayout();
MessageConversations.clearView = false;
}
if (Contacts.SelectContactsUtil.selectedContacts.Count != 0)
Contacts.SelectContactsUtil.selectedContacts.Clear();
if (MessageConversations.currentConversationMessages [0].MessageRecipientDBList.Count > 1)
{
moreThanOne = true;
for (int m = 0; m < MessageConversations.currentConversationMessages[0].MessageRecipientDBList.Count; ++m)
{
if (MessageConversations.currentConversationMessages [0].MessageRecipientDBList [m].AccountGuid != AndroidData.CurrentUser.AccountID.ToString())
{
UserDB userDetails = dbm.GetUserWithAccountID(MessageConversations.currentConversationMessages [0].MessageRecipientDBList [m].AccountGuid);
participants.Add(userDetails);
ContactDB contact = new ContactDB();
contact.ContactUser = new LOLAccountManagement.User();
contact.ContactUser.AccountID = userDetails.AccountID;
Contacts.SelectContactsUtil.selectedContacts.Add(contact);
} else
{
UserDB userDetails = UserDB.ConvertFromUser(AndroidData.CurrentUser);
participants.Add(userDetails);
}
}
}
if (moreThanOne)
{
string toReturn = "";
List<UserDB> sortedList = new List<UserDB>();
sortedList = participants.OrderBy(s => s.LastName).OrderBy(s => s.FirstName).ToList();
foreach (UserDB eachItem in sortedList)
toReturn += string.Format("{0} {1}, ", eachItem.FirstName, eachItem.LastName);
int last = toReturn.LastIndexOf(", ");
toReturn = toReturn.Remove(last);
using (LinearLayout btnlayout = new LinearLayout (context))
{
btnlayout.Orientation = Android.Widget.Orientation.Vertical;
btnlayout.SetGravity(GravityFlags.Center);
btnlayout.LayoutParameters = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.FillParent, LinearLayout.LayoutParams.WrapContent);
btnlayout.SetPadding((int)ImageHelper.convertDpToPixel(5f, context), 0, (int)ImageHelper.convertDpToPixel(5f, context), (int)ImageHelper.convertDpToPixel(10f, context));
using (TextView name = new TextView(context))
{
name.Text = toReturn;
name.SetTextSize(Android.Util.ComplexUnitType.Dip, 18f);
name.SetTextColor(Color.Black);
RunOnUiThread(() => btnlayout.AddView(name));
}
using (Button showAll = new Button (context))
{
showAll.Gravity = GravityFlags.CenterVertical;
showAll.Text = Application.Context.Resources.GetString(Resource.String.messageShowAllInConversation);
showAll.Click += (object sender, EventArgs e) => {
showParticipants(sender, e, participants); };
showAll.SetWidth((int)ImageHelper.convertDpToPixel(180f, context));
showAll.SetHeight((int)ImageHelper.convertDpToPixel(30f, context));
showAll.SetBackgroundResource(Resource.Drawable.button);
RunOnUiThread(() => btnlayout.AddView(showAll));
}
RunOnUiThread(() => listWrapper.AddView(btnlayout));
}
}
myView = null;
LayoutInflater factory = LayoutInflater.From(this);
foreach (MessageDB message in MessageConversations.currentConversationMessages)
{
if (message != null)
{
if (!moreThanOne)
myView = factory.Inflate(Resource.Layout.lstConversation, null);
else
myView = factory.Inflate(Resource.Layout.lstConversationMulti, null);
isCurrentMe = message.FromAccountID != AndroidData.CurrentUser.AccountID ? false : true;
LinearLayout shell = new LinearLayout(context);
shell.Orientation = Orientation.Horizontal;
shell.SetGravity(GravityFlags.CenterVertical);
shell.LayoutParameters = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.FillParent, LinearLayout.LayoutParams.WrapContent);
shell.SetPadding(0, 0, 0, (int)ImageHelper.convertDpToPixel(5f, context));
RunOnUiThread(() => shell.AddView(myView));
UserDB whoAmI = new UserDB();
whoAmI = message.FromAccountID != AndroidData.CurrentUser.AccountID ? dbm.GetUserWithAccountID(message.FromAccountGuid) : UserDB.ConvertFromUser(AndroidData.CurrentUser);
ImageView userImage = shell.FindViewById<ImageView>(Resource.Id.imgProfile1);
if (Contacts.ContactsUtil.contactFilenames.Contains(message.FromAccountGuid))
{
using (Bitmap bm = BitmapFactory.DecodeFile (System.IO.Path.Combine (wowZapp.LaffOutOut.Singleton.ImageDirectory, message.FromAccountGuid)))
{
using (MemoryStream ms = new MemoryStream ())
{
bm.Compress(Bitmap.CompressFormat.Jpeg, 80, ms);
byte[] image = ms.ToArray();
using (Bitmap myBitmap = ImageHelper.CreateUserProfileImageForDisplay(image, (int)imageSize[0], (int)imageSize[1], this.Resources))
{
RunOnUiThread(delegate
{
userImage.SetImageBitmap(myBitmap);
});
}
}
}
} else
{
userImage.LayoutParameters = new LinearLayout.LayoutParams((int)ImageHelper.convertDpToPixel(imageSize [0], context), (int)ImageHelper.convertDpToPixel(imageSize [1], context));
userImage.SetScaleType(ImageView.ScaleType.FitXy);
userImage.SetImageResource(Resource.Drawable.defaultuserimage);
}
int left = (int)wowZapp.LaffOutOut.Singleton.ScreenXWidth - (int)ImageHelper.convertDpToPixel(imageSize [0] + 20f, context);
int leftOver = (int)wowZapp.LaffOutOut.Singleton.ScreenXWidth - (int)ImageHelper.convertDpToPixel(imageSize [0] + 40f, context);
TextView whoIsIt = shell.FindViewById<TextView>(Resource.Id.textNames);
whoIsIt.Gravity = !isCurrentMe ? GravityFlags.Left : GravityFlags.Right;
whoIsIt.Text = whoAmI.FirstName + " " + whoAmI.LastName;
for (int m = 0; m < message.MessageStepDBList.Count; ++m)
{
if (message.MessageStepDBList [m].StepType == LOLMessageDelivery.MessageStep.StepTypes.Text)
{
TextView messageText = shell.FindViewById<TextView>(Resource.Id.textMessageBubble);
messageText.SetBackgroundResource(message.FromAccountID != AndroidData.CurrentUser.AccountID ? Resource.Drawable.bubblesolidleft :
Resource.Drawable.bubblesolidright);
int lr = (int)ImageHelper.convertDpToPixel(20f, context);
int tb = lr / 2;
messageText.SetPadding(lr, tb, lr, tb);
messageText.SetTextColor(Color.White);
messageText.SetTextSize(Android.Util.ComplexUnitType.Dip, 14f);
string messager = message.MessageStepDBList [m].MessageText;
if (messager.Length > 40)
messager = messager.Substring(0, 40) + "...";
messageText.Text = messager;
messageText.ContentDescription = message.MessageGuid;
break;
}
}
TextView messageDate = shell.FindViewById<TextView>(Resource.Id.textDateSent);
messageDate.SetTextColor(Color.Black);
messageDate.SetTextSize(Android.Util.ComplexUnitType.Dip, 10f);
messageDate.Gravity = message.FromAccountID != AndroidData.CurrentUser.AccountID ? GravityFlags.Left : GravityFlags.Right;
messageDate.Text = message.MessageSent.ToShortTimeString() + ", " + message.MessageSent.ToShortDateString();
TextView txtMessageUnread = shell.FindViewById<TextView>(Resource.Id.txtMessageUnread);
txtMessageUnread.Visibility = ViewStates.Gone;
LinearLayout messageItems = shell.FindViewById<LinearLayout>(Resource.Id.linearLayout7);
messageItems = createMessageBar(messageItems, message, leftOver);
RunOnUiThread(delegate
{
listWrapper.AddView(shell);
shell = null;
});
}
}
if (progress != null)
RunOnUiThread(() => progress.Dismiss());
}
private void Message_GetConversationMessages(object s, MessageGetConversationMessageCompletedEventArgs e)
{
LOLMessageClient client = (LOLMessageClient)s;
if (e.Error == null)
{
if (MessageConversations.currentConversationMessages.Count != 0)
MessageConversations.currentConversationMessages.Clear();
LOLMessageConversation conversation = e.Result;
List<Guid> notFound = new List<Guid>();
foreach (Guid guid in conversation.MessageIDs)
{
MessageDB message = new MessageDB();
message = dbm.GetMessage(guid.ToString());
if (message == null)
notFound.Add(guid);
else
MessageConversations.currentConversationMessages.Add(message);
}
if (notFound.Count != 0)
{
client.MessageGetByListCompleted += MessageListComplete;
client.MessageGetByListAsync(AndroidData.CurrentUser.AccountID, notFound, AndroidData.CurrentUser.AccountID,
new Guid(AndroidData.ServiceAuthToken));
} else
{
UserDB user = new UserDB();
if (MessageConversations.currentConversationMessages [0].FromAccountGuid == AndroidData.CurrentUser.AccountID.ToString())
user = UserDB.ConvertFromUser(AndroidData.CurrentUser);
else
user = dbm.GetUserWithAccountID(MessageConversations.currentConversationMessages [0].FromAccountGuid);
if (user != null)
{
MessageConversations.firstUserName = user.FirstName + " " + user.LastName;
List<MessageDB> sortedList = new List<MessageDB>();
sortedList = MessageConversations.currentConversationMessages.OrderBy(t => t.MessageSent).ToList();
MessageConversations.currentConversationMessages = sortedList;
if (sortedList.Count > 0)
{
LaffOutOut.Singleton.mmg.MessageSendConfirmCompleted -= MessageManager_MessageSendConfirm;
Intent g = new Intent(this, typeof(MessageList));
StartActivity(g);
}
}
}
}
#if DEBUG
/*else
System.Diagnostics.Debug.WriteLine ("Unable to get the conversation messages");*/
#endif
}
//for get the details only
public static IList <UserDetail> GetUser()
{
return(UserDB.GetUserDetails());
}
public void LoadCardLimitData(UserDB pUser)
{
CheckCardLimitDataUpdate(pUser);
}
private void loadProfilePicture(UserDB user, ImageView image)
{
if (user.Picture.Length == 0)
RunOnUiThread (() => image.SetImageResource (Resource.Drawable.defaultuserimage));
else
using (Bitmap img = ImageHelper.CreateUserProfileImageForDisplay(user.Picture, picSize, picSize, this.Resources)) {
RunOnUiThread (() => image.SetImageBitmap (img));
}
GC.Collect ();
}