public static string LoginBox()
{
string str = "";
if (CKUser.IsLogin)
{
str = @"<div class='loginhead'>欢迎回来 {0}</div>
<div class='loginbody'>
<div style='float:left;width:90px;'><a href='/{0}{1}'><img src='/upload/photo/{0}.jpg' class='loginphoto' {3} /></a>
</div><div style='float:right;width:140px;line-height:150%;'>
<a href='/{0}{1}'>我的博客</a><br /><a href='/group/{0}{1}'>我的群组</a><br /><span>博客访问量：{2}</span>
</div><div class='clear'></div>
<p class='loginline'><a class='edit' href='/baseinfo.aspx'>修改个人资料</a>
<br /><a class='publish' href='/write.aspx'>发表文章</a></p></div>";
DBUser u = new DBUser(CKUser.Username);
str = String.Format(str, u.Username, Settings.Ext, u.ViewCount, Strings.UserBigImageError);
}
else
{
str = @"<div class='loginhead'>用 户 登 陆</div>
<div class='loginbody'>
<p>用户名 <input id='txtName' type='text' class='put' style='width:160px;' /><span></span></p>
<p>密<span style='padding-left:12px;'></span>码 <input id='txtPassword' type='password' class='put' style='width:160px;' onkeydown='if(isEnter(event))login();' /><span></span></p>
<p style='padding-left:46px;'><label id='chkRe' class='chkRe' onclick='javascript:checkRemember(this);'>下次自动登录</label></p>
<p style='padding:10px 0px 10px 46px;'><a class='btns' href='javascript:void(0);' onclick='javascript:login();return false;'>登 录</a> <a href='/resetpwd.aspx'>忘记密码?</a></p>
</div>";
}
return str;
}
/*
* ARE YOU LOST? Usuarios y contraseñas se deben configurar
* desde la funcion GetDBUser(). Recuerda que cada nivel de
* usuario tiene su propio usuario en base de datos y si no
* se establece uno se utiliza uno la clase arrojará un error
* cuando aun no has autenticado al usuario utiliza el permiso
* de Visor
*/
/// <summary>
/// Devuelve una conexion a SQL Server con los parametos preconfigurados
/// de la clase <see cref="ConexionSQL"/>
/// </summary>
/// <returns>Conexión nueva SIN ABRIR</returns>
/// <remarks>
/// El usuario de esta clase será el responsable de abrir y cerrar las
/// conexiones devueltas. Esta clase solo ayuda a mantener los parametros
/// de conexion juntos para facilitar el mantenimiento.
/// </remarks>
public SqlConnection GetConnection()
{
DBUser user = GetDBUser();
string conString = @"DATA SOURCE = " + Server + " ; USER ID = " + user.Username + "; PASSWORD = "******"; INITIAL CATALOG = " + DBName + "; TIMEOUT = 10;";
//string conString = @"DATA SOURCE = DESKTOP-PQOR5LH\SQLEXPRESS ; USER ID = " + user.Username + "; PASSWORD = "******"; INITIAL CATALOG = " + DBName + "; TIMEOUT = 10;";
SqlConnection conn = new SqlConnection(conString);
return(conn);
}
private void bindFormPatientAndSurgeonUUID()
{
DBPatientInfo patient = new DBPatientInfo(selectedPatientuuid);
lb_PatientInfo.Text = String.Format("Name: {0}\r\rBirth: {1}", patient.fullName, patient.birthdayDBString);
DBUser surgeon = new DBUser(selectedBookedsurgeonuuid);
lb_BookedInfo.Text = String.Format("Surgeon: {0}", surgeon.displayName);
}
public void AddAccount()
{
//if(SecureStringToString())
//byte[] salt;
//new RNGCryptoServiceProvider().GetBytes(salt = new byte[16]);
//var pbkdf2 = new Rfc2898DeriveBytes(SecureStringToString(SecurePassword), salt, 10000);
//byte[] hash = pbkdf2.GetBytes(20);
//byte[] hashBytes = new byte[36];
//Array.Copy(salt, 0, hashBytes, 0, 16);
//Array.Copy(hash, 0, hashBytes, 16, 20);
if (!String.IsNullOrEmpty(NewUser))
{
bool flaga = false;
using (var context = new StudentAppContext())
{
var users = context.DBUsers.ToList();
for (int i = 0; i < users.Count; i++)
{
if (NewUser.Equals(users[i].Login))
{
flaga = true;
break;
}
}
}
if (NewPassword1.Equals(NewPassword2) && flaga == false)
{
//test_haslo = CreatePasswordHash(NewPassword1);
var dbuser = new DBUser {
Login = newUser, Password = CreatePasswordHash(NewPassword1)
};
int userId;
using (var context = new StudentAppContext())
{
context.DBUsers.Add(dbuser);
context.SaveChanges();
var obiektChwilowy = context.DBUsers.OrderByDescending(x => x.DBUserId).FirstOrDefault();
userId = obiektChwilowy.DBUserId;
}
IsDialogOpen = false;
}
}
//trzeba zapisać savedPasswordHash do bazy
}
private void BindAuthorData()
{
DBUser dbuser = new DBUser(who);
if (!dbuser.Exist)
{
Server.Transfer("~/note.aspx?q=Notfound");
}
title = dbuser.Fullname + "的迷你博客";
Page.Title = title + " - cnOpenBlog";
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<p style='text-align:center;'><a href='/{0}{1}'><img id='author_img' src='/upload/photo/{0}.jpg' {2} alt='{0}' class='photo' /></a></p>", dbuser.Username, Settings.Ext, Strings.UserBigImageError);
string age = "";
if (dbuser.ShowBirthday) age = "，" + Convert.ToString(DateTime.Now.Year - dbuser.Birthday.Year);
string editstr = "";
if (CKUser.Username == dbuser.Username)
{
editstr = " <a class='edit' href='/baseinfo.aspx'>[编辑资料]</a>";
}
else
{
editstr = String.Format(" <a class='addf' href='{0}' onclick='javascript:addFriend(this,\"{1}\");return false;'>[加为好友]</a>", Strings.JSVoid, dbuser.Username);
}
sb.AppendFormat("<p><a href='/{0}{5}'>{1}</a>，{2}{3}{4}</p>", dbuser.Username, dbuser.Fullname, dbuser.Sex, age, editstr, Settings.Ext);
sb.AppendFormat("<p>访问次数：{0}</p>", dbuser.ViewCount);
if (dbuser.State != "")
{
sb.Append("<p>城市：");
if (dbuser.City.Length == 2 || dbuser.State.Substring(0, 2) == dbuser.City.Substring(0, 2))
{
sb.AppendFormat("<a href='/city/{0}{1}'>{0}</a>", dbuser.City, Settings.Ext);
}
else
{
sb.AppendFormat("<a href='/city/{2}{1}'>{2}</a>，<a href='/city/{0}{1}'>{0}</a>", dbuser.City, Settings.Ext, dbuser.State);
}
sb.Append("</p>");
}
if (dbuser.Hangye != "") sb.AppendFormat("<p>行业：<a href='/industry/{0}{1}'>{0}</a></p>", dbuser.Hangye, Settings.Ext);
if (dbuser.ShowEmail) sb.AppendFormat("<p>Email：<a href='mailto:{0}'>{0}</a></p>", dbuser.Email);
if (dbuser.ShowQQ && dbuser.QQ != "") sb.AppendFormat("<p>QQ：<a href='http://wpa.qq.com/msgrd?V=1&Uin={0}&Site=cnopenblog.com&Menu=yes'>{0}</a></p>", dbuser.QQ);
if (dbuser.ShowMSN && dbuser.MSN != "") sb.AppendFormat("<p>MSN：<a href='mailto:{0}'>{0}</a></p>", dbuser.MSN);
if (dbuser.Url != "")
{
sb.AppendFormat("<p>主页：<a href='{0}'>", dbuser.Url);
if (dbuser.Url.Length > 24) sb.AppendFormat("{0}<br />{1}", dbuser.Url.Substring(0, 22), dbuser.Url.Substring(22));
else sb.Append(dbuser.Url);
sb.Append("</a></p>");
}
sb.AppendFormat("<br /><p>个人简介：</p><p style='text-indent:2em;'>{0}</p>", Tools.HtmlEncode(dbuser.Jianjie));
if (dbuser.Xingqu != "") sb.AppendFormat("<br /><p>兴趣爱好：</p><p style='text-indent:2em;'>{0}</p>", Tools.HtmlEncode(dbuser.Xingqu));
lblAuthorData.Text = sb.ToString();
}
public static IdentityDBUser Create(DBUser dBUser)
{
dBUser.Id = Guid.NewGuid().ToString().Replace("-", "");
return(new IdentityDBUser()
{
Email = dBUser.Email,
PhoneNumber = dBUser.PhoneNumber,
UserName = dBUser.UserName,
DBUser = dBUser
});
}
public void PasswordHashHasCorrectLength()
{
var u = new DBUser();
u.Username = "******";
var password = "******";
u.CreateCryptoFields(password);
Assert.AreEqual(64, u.PasswordHash.Length);
}
private void AddUserToDatabaseIfNonExisting(string userID)
{
DBUserProcessor userProcessor = new DBUserProcessor();
DBUser userData = userProcessor.getByKey(userID);
// if userData null, add user
if (userData == null)
{
userProcessor.AddUser(userID);
}
}
public static bool Register()
{
ICollection <User> users = DBUser.ReadUsers();
ConsoleUI.ShowLine("press 0 anytime to exit");
bool exit;
exit = ConsoleUI.GetString(out string username, "give username: "******"give password: "******"repeat password: "******"passwords are not the same!!");
return(false);
}
string encryptedPassword = CryptoManager.EncryptPassword(password1, out string encryptedSalt);
try
{
int headMasterSaved = DBUser.CreateUser(username, encryptedPassword, encryptedSalt, "headmaster", out int id);
if (headMasterSaved == 0)
{
throw new Exception("head master NOT saved");
}
}
catch (Exception e)
{
ConsoleUI.ShowLine(e.Message);
ConsoleUI.ReadKey();
return(false);
}
ConsoleUI.ShowLine("head master created");
ConsoleUI.ReadKey();
return(true);
}
public bool Authorize(ClientAuthStruct auth, IMWRObject request)
{
DBUser dbUser = new DBUser(dataProvider);
dbUser.Connection = connection;
dbUser.Load(auth.UserName, auth.Password);
if (dbUser.BusinessObject == null)
{
return false;
}
return true;
}
public MockData(SQLiteConnection database)
{
var users = from p in database.Table <DBUser>() select p;
if (users.Count() == 0)
{
List <DBClock> dBClocksList1 = new List <DBClock>()
{
new DBClock()
{
ClockHeadColor = ColorConverter.ColorToHex(Color.Red),
ClockFaceColor = ColorConverter.ColorToHex(Color.Black),
ClockTimeZoneId = TimeZoneInfo.Local.Id
},
new DBClock()
{
ClockHeadColor = ColorConverter.ColorToHex(Color.Green),
ClockFaceColor = ColorConverter.ColorToHex(Color.Yellow),
ClockTimeZoneId = TimeZoneInfo.Local.Id
}
};
List <DBClock> dBClocksList2 = new List <DBClock>()
{
new DBClock()
{
ClockHeadColor = ColorConverter.ColorToHex(Color.Purple),
ClockFaceColor = ColorConverter.ColorToHex(Color.Blue),
ClockTimeZoneId = TimeZoneInfo.Local.Id
}
};
DBUser user1 = new DBUser()
{
Login = "******",
Password = "******",
};
DBUser user2 = new DBUser()
{
Login = "******",
Password = "******"
};
database.Insert(user1);
database.InsertAll(dBClocksList1);
user1.Clocks = dBClocksList1;
database.UpdateWithChildren(user1);
database.Insert(user2);
database.InsertAll(dBClocksList2);
user2.Clocks = dBClocksList2;
database.UpdateWithChildren(user2);
}
}
public void AddUser(VMUser user)
{
if (user.UserID != null)
{
var newUser = new DBUser {
UserID = user.UserID, UserName = user.UserName
};
db.Users.Add(newUser);
db.SaveChanges();
}
}
public UserDTOOut GetById(int Id)
{
DBUser user = _context.Users.SingleOrDefault(x => x.Id == Id);
return(new UserDTOOut
{
Firstname = user.Firstname,
Id = user.Id,
Lastname = user.Lastname,
Username = user.Username
});
}
private void BindData()
{
DBUser u = new DBUser(username);
StringBuilder sb = new StringBuilder();
sb.Append("<table id='box-1'><tr><td style='vertical-align:top;'>");
sb.AppendFormat("<img id='uph' class='photo' alt='{0}' src='/upload/photo/{0}.jpg' onerror='this.src=\"/upload/photo/nophoto.jpg\";' />", username);
sb.Append("<p style='text-align:center;'><a class='upphoto' href='#photo' onclick=\"javascript:show('photo');\">更改头像</a></p>");
sb.AppendFormat("<p>姓名：{0}<br />性别：{1}<br />年龄：{2}岁（<i>{3}</i>）</p>", u.Fullname, u.Sex, DateTime.Now.Year - u.Birthday.Year, u.ShowBirthday ? "公开" : "未公开");
sb.Append("</td><td style='vertical-align:top; padding-left:20px;'>");
sb.Append("<p><a class='edit' href='#edit' onclick=\"javascript:show('edit');\">编辑我的资料</a></p>");
sb.AppendFormat("<p>行业：{0}</p>", u.Hangye);
sb.AppendFormat("<p>QQ：{0}（<i>{1}</i>）</p>", u.QQ,u.ShowQQ?"公开":"未公开");
sb.AppendFormat("<p>MSN：{0}（<i>{1}</i>）</p>", u.MSN, u.ShowMSN ? "公开" : "未公开");
sb.AppendFormat("<p>E-mail：<a href='mailto:{0}'>{0}</a>（<i>{1}</i>）</p>", u.Email, u.ShowEmail ? "公开" : "未公开");
sb.AppendFormat("<p>个人网站：<a href='{0}'>{0}</a></p>", u.Url);
sb.AppendFormat("<p>所在城市：{0}，{1}</p>", u.City, u.State);
sb.AppendFormat("<p>博客标题：{0}</p>",Tools.HtmlEncode(u.BlogTitle));
sb.AppendFormat("<p>博客副标题：{0}</p>", Tools.HtmlEncode(u.BlogSubtitle));
sb.AppendFormat("<p>个人简介：{0}</p>", Tools.HtmlEncode(u.Jianjie));
sb.AppendFormat("<p>兴趣爱好：{0}</p>", Tools.HtmlEncode(u.Xingqu));
sb.AppendFormat("<p>个性签名：{0}</p>", Tools.HtmlEncode(u.Qianming));
sb.Append("</td></tr></table>");
lblBox1.Text = sb.ToString();
sb = new StringBuilder();
sb.Append("setValue = function(){");
sb.AppendFormat("el('txtFullname').value='{0}';", u.Fullname);
sb.AppendFormat("el('txtEmail').value='{0}';", u.Email);
if (u.Sex == "男") sb.Append("el('radsex1').checked=true;");
else sb.Append("el('radsex2').checked=true;");
sb.AppendFormat("el('selYear').value='{0}';", u.Birthday.Year);
sb.AppendFormat("el('selMonth').value='{0}';", u.Birthday.Month);
sb.AppendFormat("el('selHangye').value='{0}';", u.Hangye);
sb.AppendFormat("el('txtUrl').value='{0}';", u.Url);
sb.AppendFormat("el('txtQQ').value='{0}';", u.QQ);
sb.AppendFormat("el('txtMSN').value='{0}';", u.MSN);
sb.AppendFormat("el('txtJianjie').value='{0}';", u.Jianjie.Replace("'","\\'"));
sb.AppendFormat("el('txtXingqu').value='{0}';", u.Xingqu.Replace("'", "\\'"));
sb.AppendFormat("el('txtQianming').value='{0}';", u.Qianming.Replace("'", "\\'"));
sb.AppendFormat("el('txtBlogtitle').value='{0}';", u.BlogTitle.Replace("'", "\\'"));
sb.AppendFormat("el('txtBlogsubtitle').value='{0}';", u.BlogSubtitle.Replace("'", "\\'"));
if (u.ShowBirthday) sb.Append("el('chkBirthday').checked=true;");
if (u.ShowEmail) sb.Append("el('chkEmail').checked=true;");
if (u.ShowQQ) sb.Append("el('chkQQ').checked=true;");
if (u.ShowMSN) sb.Append("el('chkMSN').checked=true;");
sb.AppendFormat("_init_state('{0}');_init_city('{0}','{1}');", u.State, u.City);
sb.Append("};");
script = sb.ToString();
}
/// <summary>
/// Takes a username and an un-hashed password from the WCF, and returns a the corrosponding user, if there is a user with that username and password in the Database. Otherwise, returns null.
/// </summary>
public User ValidateUser(String username, string unHashedPassword)
{
DBUser dbUser = new DBUser();
User user = dbUser.GetByName(username);
//Salt added to unHashedPassword
if (user != null && user.Password != User.HashThisPassword(user.Salt + unHashedPassword))
{
user = null;
}
return(user);
}
public void GetPlaintextMasterKeyReturns256Bit()
{
var u = new DBUser();
u.Username = "******";
var password = "******";
u.CreateCryptoFields(password);
var master_key = u.GetPlaintextMasterKey(password);
Assert.AreEqual(32, master_key.Length);
}
// private UserRepository userRepository;
public FormUsers()
{
InitializeComponent();
dBUserContext = new DBUser();
var types = dBUserContext.UserTypes.ToList();
foreach (UserType item in types)
{
comboBoxTip.Items.Add(item);
}
refreshGrid();
}
public static void getUser()
{
DBUser user = new DBUser();
sortPaging sr = new sortPaging();
sr.pageNumber = 1;
sr.pageSize = 10;
sr.sortColumn = "Firstname";
sr.sortDirection = "asc";
user.getUser(sr);
}
internal static List <DBNews> GetNewsAuthor(DBUser author)
{
using (SampleContext context = new SampleContext())
{
var tmp = context.news.Where(u => u.userId == author.userId).Select(u => u).ToList();
if (tmp != null)
{
return(tmp);
}
}
return(new List <DBNews>());
}
public async Task <ActionResult <DBUser> > updateregistration([FromBody] DBUser user)
{
var _user = await _context.DBUser.FirstOrDefaultAsync(e => e.UUID == user.UUID);
//ocaisonaly notification hub tokens will expire and when they do the backeend database will need the new device id they registered
// _user.
// _context.Update()
await _context.SaveChangesAsync();
return(CreatedAtAction("GetUser", user));//new { id = user.ID },
}
public static int SaveUser(DBUser user)
{
int userId = user.Id;
using (ApplicationContext db = new ApplicationContext())
{
DBUser usr;
if (userId < 1)
{
userId = db.Users.OrderBy(x => x.Id).LastOrDefault()?.Id ?? 1;
user.Id = ++userId;
db.Users.Add(user);
usr = user;
}
else
{
usr = db.Users.FirstOrDefault(x => x.Id == userId);
if (usr == null)
{
throw new Exception($"Нет записи user с таким Id = {userId}");
}
user.CityId = usr.CityId;
db.Entry(usr).CurrentValues.SetValues(user);
//db.Update(usr);
}
db.SaveChanges();
usr = db.Users.FirstOrDefault(x => x.Id == userId);
foreach (var login in user.Logins)
{
DBLogin lgn = db.Logins
.FirstOrDefault(x => x.Login == login.Login);
if (lgn == null)
{
lgn = login;
lgn.UserId = userId;
db.Logins.Add(lgn);
}
else
{
lgn = login;
}
}
db.SaveChanges();
}
return(userId);
}
internal User Map(DBUser dbUser)
{
if (dbUser == null)
{
return(null);
}
return(new User()
{
Id = dbUser.Id,
Email = dbUser.Email,
Password = dbUser.PassHash
});
}
public DatabaseNoteRepository(string username)
{
dbConnection = DbConfig.GetConnection();
dbUser = dbConnection.First <DBUser> (u => u.Username == username);
storage = new DbStorage(dbUser);
engine = new Engine(storage);
if (dbUser.Manifest == null || string.IsNullOrEmpty(dbUser.Manifest.ServerId))
{
// the user may not yet have synced
dbUser.Manifest.ServerId = Guid.NewGuid().ToString();
}
}
public static DBUser GetUser(int Id)
{
var filter = new FilterUser()
{
Id = Id
}.ToFilter();
var user = new DBUser();
using (ApplicationContext db = new ApplicationContext())
{
user = db.Users.Include(x => x.City).Where(filter).FirstOrDefault();
}
return(user);
}
public bool Update(User m_User, string oldUserName)
{
if (m_User.UserName != oldUserName)
{
if (!DBUser.isUserNameAvailable(m_User.UserName))
{
return(false);
}
}
DBUser.userUpdate(m_User);
return(true);
}
public void GetPlaintextMasterKeyReturnsSameKeyForSamePassword()
{
var u = new DBUser();
u.Username = "******";
var password = "******";
u.CreateCryptoFields(password);
var key1 = u.GetPlaintextMasterKey(password);
var key2 = u.GetPlaintextMasterKey(password);
Assert.AreEqual(key1, key2);
Assert.AreEqual(key1.ToHexString(), key2.ToHexString());
}
public void InsertUser()
{
User user = new User("ThureKasperJesperHenrikOle1234", User.HashThisPassword("4321"));
var dbUser = new DBUser();
//var userCtr = new UserCtr();
//userCtr.InsertUser("ThureKasperJesperHenrikOle1234", user.Password);
dbUser.InsertUser(user);
User extractedUser = dbUser.GetByName(user.Username);
//Assert.IsTrue(extractedUser.Password.Equals(user.Password));
Assert.IsTrue(extractedUser.Username.Equals(user.Username));
}
/// <summary>
/// POST /admin/user
///
/// creates a new user.
///
/// returns HTTP Response =>
/// 201 Created
/// Location: http://localhost/admin/user/{Username}
/// </summary>
public object Post(UserRequest user)
{
var new_user = new DBUser();
// TODO explicit mapping
new_user.PopulateWith(user);
// TODO move into RequestFilter
if (string.IsNullOrEmpty(user.Username))
{
throw new ArgumentNullException("user.Username");
}
// TODO move into RequestFilter
if (!(user.Username.IsOnlySafeChars() &&
user.Password.IsOnlySafeChars() &&
user.EmailAddress.Replace("@", "").IsOnlySafeChars()))
{
throw new ArgumentException("found unsafe/unallowed characters");
}
// TODO move into RequestFilter
// lowercase the username
new_user.Username = new_user.Username.ToLower();
using (var conn = DbConfig.GetConnection()) {
var existing_user = conn.FirstOrDefault <DBUser> ("Username = {0}", new_user.Username);
if (existing_user != null)
{
throw new ConflictException()
{
ErrorMessage = "A user by that name already exists"
}
}
;
conn.Insert <DBUser> (new_user);
}
return(new HttpResult(new_user)
{
StatusCode = HttpStatusCode.Created,
StatusDescription = "Sucessfully created user " + new_user.Username,
Headers =
{
{ HttpHeaders.Location, base.Request.AbsoluteUri.CombineWith(new_user.Username) }
}
});
}
private void BindFriend()
{
string fields = "[f_id],[_name],[fullname],[hangye],[state],[city],[jianjie]";
string where = "[f_friend_name]=[_name] and [f_user_name]='" + username + "'";
string sql = "select {0} from [friends],[users] where {1}";
sql = String.Format(sql, fields, where);
DataTable dt = DB.GetTable(sql);
StringBuilder sb = new StringBuilder();
int i = 0;
foreach (DataRow row in dt.Rows)
{
sb.AppendFormat("<div class='gitem{0}'>", i % 2 == 1 ? " gitem2" : "");
sb.AppendFormat("<div class='col1'><a href='/{0}{1}'><img src='/upload/photo/{0}-s.jpg' {2} alt='{0}' /></a></div>", row["_name"], Settings.Ext, Strings.UserSmallImageError);
sb.AppendFormat("<div class='col2'><a href='/{0}{1}'>{0}</a> ({2})", row["_name"], Settings.Ext, row["fullname"]);
if (row["state"].ToString() != "")
{
if (row["state"].ToString().Substring(0, 2) == row["city"].ToString().Substring(0, 2))
{
sb.AppendFormat(" <a href='/city/{0}{1}'>{0}</a>", row["city"], Settings.Ext);
}
else
{
sb.AppendFormat(" <a href='/city/{0}{1}'>{0}</a>，<a href='/city/{2}{1}'>{2}</a>", row["state"], Settings.Ext, row["city"]);
}
}
if (row["hangye"].ToString() != "")
{
sb.AppendFormat(" <span class='hui'>行业：</span><a href='/industry/{0}{1}'>{0}</a>", row["hangye"], Settings.Ext);
}
sb.AppendFormat("<p><span class='hui'>简介：</span>{0}</p></div>", Tools.HtmlEncode(Tools.CutString(row["jianjie"].ToString(), 60)));
sb.AppendFormat("<div class='col3'><a href='{0}' onclick='javascript:sendMsg(this,\"{1}\");return false;'>发送消息</a><a href='{0}' onclick='javascript:deleteFriend(this,\"{1}\");return false;'>删除好友</a></div>", Strings.JSVoid, row["_name"]);
sb.Append("<div class='clear'></div></div>");
i++;
}
if (i == 0)
{
sb.Append("<p>您还没有添加任何好友。</p>");
DBUser u = new DBUser(username);
sb.Append("<ul>");
if (u.City != "") sb.AppendFormat("<li><a href='/city/{0}{1}'>查看<b>{0}</b>的所有用户</a></li>", u.City, Settings.Ext);
if (u.Hangye != "") sb.AppendFormat("<li><a href='/industry/{0}{1}'>查看<b>{0}</b>行业的所有用户</a></li>", u.Hangye, Settings.Ext);
sb.Append("</ul>");
}
lblFriend.Text = sb.ToString();
}
public int SaveUser(User user)
{
try
{
DBUser newUser = Mapper.Map <User, DBUser>(user);
uow.Users.Create(newUser);
uow.Save();
int id = CheckUser(user.Login, user.Password);
return(id);
}
catch (Exception)
{
return(0);
}
}
public Models.User Create(string name, string paasword, string email, bool enabled)
{
if ((DBUser.name == name).Count <DBUser>(DB) > 0)
{
return(null);
}
DBUser user = new DBUser();
user.Name = name;
user.Password = paasword;
user.Email = email;
user.Enabled = enabled;
user.Save(DB);
return(user.MemberCopyTo <Models.User>());
}
private void NewPasswordUserClick(object sender, ItemClickEventArgs e)
{
try
{
var user = DBUser.Users_Select_Id(CurrentUser.Id);
if (user.UpdatePassword(new ChangePasswordForm().ChangePassword(user.UserPassword, true)))
{
MessageWindow.GetInstance("Пароль успешно изменён.", MessageType.Info);
}
}
catch (Exception)
{
MessageWindow.GetInstance("Пожалуйста, сохраните изменения!", MessageType.Attention);
}
}
public DatabaseNoteRepository(IDbConnectionFactory factory, DbStorageFactory storageFactory, IUser user) : base(factory)
{
this.storage = storageFactory.GetDbStorage(user);
engine = new Engine(storage);
using (var db = connFactory.OpenDbConnection()) {
this.dbUser = db.Select <DBUser> (u => u.Username == user.Username)[0];
}
if (dbUser.Manifest == null || string.IsNullOrEmpty(dbUser.Manifest.ServerId))
{
// the user may not yet have synced
dbUser.Manifest.ServerId = Guid.NewGuid().ToString();
}
}
public void AddClock(ClockModel clockModel, int id)
{
DBUser user = GetUser(id);
DBClock dBClock = new DBClock()
{
ClockHeadColor = ColorConverter.ColorToHex(clockModel.HeadColor),
ClockFaceColor = ColorConverter.ColorToHex(clockModel.FaceColor),
ClockTimeZoneId = clockModel.ClockTimeZone.Id
};
database.Insert(dBClock);
user.Clocks.Add(dBClock);
database.UpdateWithChildren(user);
}
public async Task <ActionResult <DBUser> > AddDevice([FromBody] DBUser user)
{
//
if (user.UUID == null || user.devices == null || user == null)
{
return(BadRequest());
}
Console.WriteLine(user.devices);
var result = _context.DBUser.FirstOrDefault(x => x.UUID == user.UUID);
user.pingAll();
if (result != null)
{
if (result.devices == null)
{
result.devices = user.devices;
}
else
{
result.devices.AddRange(user.devices);
}
/*
* Console.WriteLine(result.devices.GetType());
* Console.WriteLine(typeof(List<device>));
* if (result.devices.GetType()== typeof(List<device>)) {
* result.devices.AddRange(user.devices);
* } else {
* result.devices = user.devices;
* }//*/
}
else
{
return(NotFound());
}
try {
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException) {
throw;
}
return(NoContent());
}
private void SignIn(string u, string p, bool remember)
{
DBUser user = new DBUser(u);
bool ok = false;
if (user.Username != "")
{
ok = p.ToLower() == user.Password.ToLower();
}
if (ok)
{
CKUser.Login(user.Username, user.Fullname, user.Email, remember);
if (redirect == "null") redirect = "";
if (redirect != "") Response.Redirect(redirect);
else Response.Redirect(CKUser.Username + Settings.Ext);
}
else
{
Response.Redirect("login.aspx?er=1");
}
}
public void DeleteUserTest()
{
using (DBUser dbUser = new DBUser())
{
User user = new User();
dbUser.Connection = new MySqlConnection(connString);
dbUser.Connection.Open();
user.Name = "TestDelete";
user.Password = "******";
user.Group = 1;
Assert.IsTrue(dbUser.Save(user));
int lastID = (int)dbUser.LastID;
dbUser.Load(lastID);
Assert.IsNotNull(dbUser.BusinessObject);
dbUser.Delete();
dbUser.Load(lastID);
Assert.IsNull(dbUser.BusinessObject);
Assert.IsTrue(dbUser.Save(user));
lastID = (int)dbUser.LastID;
dbUser.Delete(lastID);
dbUser.Load(lastID);
Assert.IsNull(dbUser.BusinessObject);
}
}
public void GetUserData(string userName, string password, out MachineWithPrivilleges [] machines, out User user)
{
DBUser dbUser = new DBUser(dataProvider);
dbUser.Connection = connection;
dbUser.Load(userName, password);
user = dbUser.BusinessObject;
DBMachineToPrivCollection dbMachineCol = new DBMachineToPrivCollection(dataProvider);
dbMachineCol.Connection = connection;
machines = dbMachineCol.Load(dbUser.BusinessObject.Group);
}
public void LoadUserTest()
{
DBUser user = new DBUser();
User bUser = new User();
user.Connection = new MySqlConnection(connString);
user.Connection.Open();
user.Load(1);
Assert.IsNotNull(user.BusinessObject);
Assert.IsTrue(user.BusinessObject.Name == "Tester");
}
public void LoadUser2Test()
{
using (DBUser dbUser = new DBUser())
{
User user = new User();
dbUser.Connection = new MySqlConnection(connString);
dbUser.Connection.Open();
dbUser.Load("Tester", "test");
Assert.IsNotNull(dbUser.BusinessObject);
}
}
public static IEnumerator CheckAndCreateGameUser(string facebookID, int globalID)
{
Debug.Log("Checking if Game User exists...");
dbUser = null;
yield return Instance.StartCoroutine(GetGameUser(facebookID));
if(dbUser == null)
{
yield return Instance.StartCoroutine(CreateGameUser(facebookID, globalID));
yield return Instance.StartCoroutine(GetGameUser(facebookID));
}
else
Debug.Log("Game user already exists");
}
private static IEnumerator GetGameUser(string facebookID)
{
Debug.Log("DBHandler.GetGameUser()");
string post_url = getGameUserURL + "facebookID=" + facebookID;
Debug.Log(string.Format("GetGameUser URL: {0}", post_url));
// Post the URL to the site and create a download object to get the result.
WWW getUser_post = new WWW(post_url);
yield return getUser_post; // Wait until the download is done
if (getUser_post.error != null)
Debug.Log("There was an error posting the GetUser : "******"WWW post: {0}", getUser_post.text));
if(!string.IsNullOrEmpty(getUser_post.text))
{
Dictionary<string, object> data = Json.Deserialize(getUser_post.text) as Dictionary<string, object>;
dbUser = new DBUser(int.Parse(data["id"].ToString()),
data["facebookID"].ToString(),
int.Parse(data["score"].ToString()));
}
}
