protected void Page_Load(object sender, EventArgs e)
{
TUsers model = DbSession.Default.Get <TUsers>(TUsers._.UserName == UserLoginInfo.UserName);
if (model == null)
{
Response.Redirect("/");
}
string where = " where UserID=" + model.UserID;
anpPageIndex.RecordCount = DbSession.Default.Count <Web_vUserAlbumColumn>(new WhereClip(where.Replace("where", "")));
anpPageIndex.CurrentPageIndex = PageIndex;
anpPageIndex.PageSize = 6;
DataTable dt = DbSession.Default.FromProc("Bzw_GetPager")
.AddInputParameter("@QueryStr", DbType.String, "select * from Web_vUserAlbumColumn " + where)
.AddInputParameter("@PageSize", DbType.Int32, anpPageIndex.PageSize)
.AddInputParameter("@PageCurrent", DbType.Int32, PageIndex)
.AddInputParameter("@FdShow", DbType.String, "*")
.AddInputParameter("@FdOrder", DbType.String, "OrderID desc,InputTime desc")
.ToDataTable();
//DataTable dt = DbSession.Default.From<Web_UserAlbumColumn>().Where(Web_UserAlbumColumn._.UserID == model.UserID).OrderBy(Web_UserAlbumColumn._.InputTime.Desc).ToDataTable();
if (dt.Rows.Count > 0)
{
rptAlbumColumnList.DataSource = dt;
rptAlbumColumnList.DataBind();
}
}
/// <summary>
/// 用户添加
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public int AddUsers(TUsers users)
{
using (OracleConnection conn = DapperHelper.GetConnString())
{
conn.Open();
string sql1 = @"select * from T_Users where UserName=:UserName";
var Roles = conn.Query <TUsers>(sql1, users);
int result = -1;
if (Roles.Count() == 0)
{
//添加用户
string sql = @"insert into T_Users(UserName,PassWord,RoleId) values (:UserName,:PassWord,:RoleId)";
int result2 = conn.Execute(sql, users);
//获取用户id
string sql2 = ("select id from T_Users where UserName=:UserName");
var id = conn.Query <int>(sql2, users).FirstOrDefault();
var user = users.RoleId.Split(',');
for (int i = 0; i < user.Length; i++)
{
UserRole userRole = new UserRole();
userRole.User_Id = id;
userRole.Role_Id = Convert.ToInt32(user[i]);
string sql3 = @"insert into User_role (Role_Id,User_Id) values (:Role_Id,:User_Id) ";
result = conn.Execute(sql3, userRole);
}
}
return(result);
}
}
/// <summary>
/// 修改用户
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public int UpdateUsers(TUsers users)
{
using (OracleConnection conn = DapperHelper.GetConnString())
{
conn.Open();
string sql1 = @"select * from T_Users where UserName=:UserName";
var Roles = conn.Query <TUsers>(sql1, users);
int result = -1;
if (Roles.Count() == 0 || Roles.Count() == 1)
{
//修改角色
string sql = @"update T_Users set UserName=:UserName,PassWord=:PassWord,RoleId=:RoleId where id=:id";
int result2 = conn.Execute(sql, users);
//获取角色id
string sql2 = ("delete from user_role where user_id=:user_id");
conn.Execute(sql2, new { user_id = users.ID });
var roles = users.RoleId.Split(',');
for (int i = 0; i < roles.Length; i++)
{
UserRole userRole = new UserRole();
userRole.User_Id = users.ID;
userRole.Role_Id = Convert.ToInt32(roles[i]);
string sql3 = @"insert into user_role(user_id,role_id) values (:user_id,:role_id) ";
result = conn.Execute(sql3, userRole);
}
}
return(result);
}
}
/// <summary>
/// サーバーの情報で更新
/// </summary>
public void Set(TUsers tUsers)
{
this.name = tUsers.userName;
this.lv = tUsers.level;
this.exp = tUsers.exp;
this.coin = tUsers.coin;
}
public async Task <IActionResult> Put([FromRoute] int id, [FromBody] TUsers user)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != user.UserId)
{
return(BadRequest());
}
try
{
await _userRepository.Update(user);
}
catch (DbUpdateConcurrencyException ex)
{
if (!await _userRepository.Exist(Convert.ToInt32(user.UserId)))
{
return(NotFound());
}
else
{
log.WriteLog(ex.ToString(), "UsersController.txt");
return(BadRequest());
}
}
return(Ok(user));
}
protected void Page_Load(object sender, EventArgs e)
{
TUsers model = DbSession.Default.Get <TUsers>(TUsers._.UserName == UserLoginInfo.UserName);
if (model == null)
{
Response.Redirect("/");
}
string tmp = CommonManager.Web.Request("params", "");
if (!string.IsNullOrEmpty(tmp) && CommonManager.String.IsInteger(tmp))
{
pic = DbSession.Default.Get <Web_UserAlbum>(Web_UserAlbum._.ID == tmp);
}
if (!IsPostBack)
{
ColumnList = DbSession.Default.From <Web_UserAlbumColumn>().Select(Web_UserAlbumColumn._.ID, Web_UserAlbumColumn._.AlbumName).Where(Web_UserAlbumColumn._.UserID == model.UserID).OrderBy(Web_UserAlbumColumn._.OrderID.Desc && Web_UserAlbumColumn._.InputTime.Desc).ToDataTable();
if (ColumnList.Rows.Count <= 0)
{
Response.Write("<script>alert('您还没有创建相册！');location.href='AlbumWrite.aspx';</script>");
return;
}
}
}
/// <summary>
/// Generate the responses
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
private IActionResult AuthenticationResponse(TUsers user, string msg)
{
if (user == null)
{
return(NotFound(new { status = Constants.Failed, message = msg, user = "" }));
}
return(Ok(new { status = Constants.Success, message = msg, user = user }));
}
private void FormAddUsers_Load(object sender, EventArgs e)
{
if (users == null)
{
users = new TUsers();
}
bsUsers.DataSource = users;
}
/// <summary>
/// 删除一个相册
/// </summary>
private void DelAlbumColumn()
{
string aid = CommonManager.Web.Request("id", "");
#region 校验
if (!UserLoginInfo.IsLogin)
{
Response.Write("您尚未登录。");
return;
}
TUsers model = DbSession.Default.Get <TUsers>(TUsers._.UserName == UserLoginInfo.UserName);
if (model == null)
{
Response.Write("您尚未登录。");
return;
}
if (string.IsNullOrEmpty(aid) || !CommonManager.String.IsInteger(aid))
{
Response.Write("请不要尝试非法操作。");
return;
}
if (!DbSession.Default.Exists <Web_UserAlbumColumn>(Web_UserAlbumColumn._.ID == aid))
{
Response.Write("请不要尝试非法操作。");
return;
}
#endregion
//转移
//Web_UserAlbumColumn album = DbSession.Default.Get<Web_UserAlbumColumn>( Web_UserAlbumColumn._.ID == ( DbSession.Default.Max<Web_UserAlbumColumn>( Web_UserAlbumColumn._.ID, Web_UserAlbumColumn._.UserID == model.UserID ) ) );
DataTable dt = DbSession.Default.From <Web_UserAlbumColumn>().Where(Web_UserAlbumColumn._.UserID == UserLoginInfo.UserID).ToDataTable();
if (dt.Rows.Count > 1)
{
//仍有其他相册，则将当前相册下的照片转移
//DataRow[] rows = dt.Select( "ID=" + aid );
//if( rows.Length <= 0 )
// return;
//dt.Rows.Remove(rows[0]);
string maxid = dt.Compute("max(ID)", "ID<>" + aid).ToString();
DbSession.Default.Update <Web_UserAlbum>(Web_UserAlbum._.ColumnID, maxid, Web_UserAlbum._.ColumnID == aid && Web_UserAlbum._.UserID == UserLoginInfo.UserID);
}
else
{
//不存在相册了，则不删除，仅将相册改名
DbSession.Default.Update <Web_UserAlbumColumn>(Web_UserAlbumColumn._.AlbumName, "默认相册", Web_UserAlbumColumn._.ID == aid);
Response.Write("success");
return;
}
DbSession.Default.Delete <Web_UserAlbumColumn>(Web_UserAlbumColumn._.ID == aid);
Response.Write("success");
}
private async Task <bool> UpdateAsync()
{
var valor = false;
byte[] imageByte = null;
var strategy = _context.Database.CreateExecutionStrategy();
await strategy.ExecuteAsync(async() => {
using (var transaction = _context.Database.BeginTransaction())
{
try
{
var identityUser = _userManager.Users.Where(u => u.Id.Equals(_dataUser2.ID)).ToList().Last();
identityUser.UserName = Input.Email;
identityUser.Email = Input.Email;
identityUser.PhoneNumber = Input.PhoneNumber;
_context.Update(identityUser);
await _context.SaveChangesAsync();
if (Input.AvatarImage == null)
{
imageByte = _dataUser2.Image;
}
else
{
imageByte = await _uploadimage.ByteAvatarImageAsync(Input.AvatarImage, _environment, "");
}
var t_user = new TUsers
{
ID = _dataUser2.Id,
Name = Input.Name,
LastName = Input.LastName,
NID = Input.NID,
Email = Input.Email,
IdUser = _dataUser2.ID,
Image = imageByte,
};
_context.Update(t_user);
_context.SaveChanges();
if (_dataUser2.Role != Input.Role)
{
await _userManager.RemoveFromRoleAsync(identityUser, _dataUser2.Role);
await _userManager.AddToRoleAsync(identityUser, Input.Role);
}
transaction.Commit();
valor = true;
}
catch (Exception ex)
{
_dataInput.ErrorMessage = ex.Message;
transaction.Rollback();
valor = false;
}
}
});
return(valor);
}
public int AddTUsers(string userName, string passWord, string roleId)
{
TUsers users = new TUsers();
users.UserName = userName;
users.PassWord = passWord;
users.RoleId = roleId;
var result = Users.AddUsers(users);
return(result);
}
public int UpdateUsers(string userName, string passWord, string roleId, int id)
{
TUsers users = new TUsers();
users.UserName = userName;
users.PassWord = passWord;
users.RoleId = roleId;
users.ID = id;
var result = Users.UpdateUsers(users);
return(result);
}
/// <summary>
/// サーバーの情報で更新
/// </summary>
public void Set(TUsers tUsers)
{
this.name = tUsers.userName;
this.lv = tUsers.level;
this.exp = tUsers.exp;
//this.chargeGem = tUsers.gem;
this.freeGem = tUsers.freeGem;
this.coin = tUsers.coin;
this.fvPoint = tUsers.fv;
this.vipLevel = tUsers.vipLevel;
this.vipExp = tUsers.vipExp;
}
protected void Page_Load(object sender, EventArgs e)
{
if (IntParam == 0)
{
return;
}
SeoSetting(SeoConfig.Config.DefaultSeo);
Web_UserAlbumColumn album = DbSession.Default.Get <Web_UserAlbumColumn>(Web_UserAlbumColumn._.ID == IntParam);
if (album == null || album.IsPublic == Library.PublicState.隐藏.ToString())
{
return;
}
TUsers user = DbSession.Default.Get <TUsers>(TUsers._.UserID == album.UserID);
if (user == null)
{
return;
}
AlbumName = album.AlbumName;
UserName = user.NickName; //user.UserName;
uid = user.UserID.ToString();
WhereClip where = VUsersAlbum._.ColumnID == IntParam && VUsersAlbum._.Enable == Library.EnableState.通过.ToString();
anpPageIndex.RecordCount = DbSession.Default.Count <VUsersAlbum>(where);
anpPageIndex.CurrentPageIndex = PageIndex;
//anpPageIndex.PageSize = 4;
DataTable dt = DbSession.Default.FromProc("Bzw_GetPager")
.AddInputParameter("@QueryStr", DbType.String, "select * from VUsersAlbum where " + string.Format(where.ToString(), "", ""))
.AddInputParameter("@PageSize", DbType.Int32, anpPageIndex.PageSize)
.AddInputParameter("@PageCurrent", DbType.Int32, PageIndex)
.AddInputParameter("@FdShow", DbType.String, "*")
.AddInputParameter("@FdOrder", DbType.String, "ShortNum desc,InputTime desc")
.ToDataTable();
if (dt.Rows.Count > 0)
{
rptAlbumColumnList.Visible = true;
rptAlbumColumnList.DataSource = dt;
rptAlbumColumnList.DataBind();
ltNonData.Visible = false;
}
else
{
rptAlbumColumnList.Visible = false;
ltNonData.Visible = true;
}
}
public void LoadUser()
{
string error = string.Empty;
this.users = TUsers.LoadData(out error);
if (!string.IsNullOrEmpty(error))
{
MessageBox.Show("Грешка при зареждане от базата данни");
return;
}
bSUser.DataSource = users;
}
public async Task <TUsers> Update(TUsers user)
{
try
{
_unitofWork.UserRepository.Update(user);
await _unitofWork.Save();
return(user);
}
catch (DbUpdateConcurrencyException ex)
{
log.WriteLog(ex.ToString(), "UserRepository.txt");
return(null);
}
}
private void FormLoginRegistration_Load(object sender, EventArgs e)
{
cBoxAdmin.CheckedChanged -= new EventHandler(CBoxAdmin_CheckedChanged);
cBoxLecture.CheckedChanged -= new EventHandler(CBoxLecture_CheckedChanged);
cBoxStudent.CheckedChanged -= new EventHandler(CBoxStudent_CheckedChanged);
if (users == null)
{
users = new TUsers();
}
bsUser.DataSource = users;
cBoxAdmin.CheckedChanged += new EventHandler(CBoxAdmin_CheckedChanged);
cBoxLecture.CheckedChanged += new EventHandler(CBoxLecture_CheckedChanged);
cBoxStudent.CheckedChanged += new EventHandler(CBoxStudent_CheckedChanged);
}
/// <summary>
/// 删除一张照片
/// </summary>
private void DelPic()
{
string aid = CommonManager.Web.Request("id", "");
string type = CommonManager.Web.Request("type", "0");
#region 校验
if (string.IsNullOrEmpty(aid) || !CommonManager.String.IsInteger(aid))
{
Response.Write("请不要尝试非法操作。");
return;
}
if (!DbSession.Default.Exists <Web_UserAlbum>(Web_UserAlbum._.ID == aid))
{
Response.Write("请不要尝试非法操作。");
return;
}
if (!UserLoginInfo.IsLogin)
{
Response.Write("您尚未登录。");
return;
}
TUsers model = DbSession.Default.Get <TUsers>(TUsers._.UserName == UserLoginInfo.UserName);
if (model == null)
{
Response.Write("您尚未登录。");
return;
}
#endregion
Web_UserAlbum album = DbSession.Default.Get <Web_UserAlbum>(Web_UserAlbum._.ID == aid);
CommonManager.File.DeleteFile(album.PicPath);
if (type == "1")
{
DbSession.Default.Delete <Web_UserAlbum>(album);
}
else if (type == "0")
{
DbSession.Default.Update <Web_UserAlbum>(Web_UserAlbum._.PicPath, "", Web_UserAlbum._.ID == aid);
}
Response.Write("success");
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(un))
{
return;
}
SeoSetting(SeoConfig.Config.DefaultSeo);
//TUsers user = DbSession.Default.Get<TUsers>(TUsers._.UserName == un);
TUsers user = DbSession.Default.Get <TUsers>(TUsers._.UserID == un);
if (user == null)
{
return;
}
//绑定用户公开的相册列表
//string where = " where UserID=" + user.UserID;
usernickname = user.NickName;
WhereClip where = Web_vUserAlbumColumn._.UserID == user.UserID && Web_vUserAlbumColumn._.IsPublic == Library.PublicState.公开.ToString();
anpPageIndex.RecordCount = DbSession.Default.Count <Web_vUserAlbumColumn>(where);
anpPageIndex.CurrentPageIndex = PageIndex;
//anpPageIndex.PageSize = 4;
DataTable dt = DbSession.Default.FromProc("Bzw_GetPager")
.AddInputParameter("@QueryStr", DbType.String, "select * from Web_vUserAlbumColumn where " + string.Format(where.ToString(), "", ""))
.AddInputParameter("@PageSize", DbType.Int32, anpPageIndex.PageSize)
.AddInputParameter("@PageCurrent", DbType.Int32, PageIndex)
.AddInputParameter("@FdShow", DbType.String, "*")
.AddInputParameter("@FdOrder", DbType.String, "OrderID desc,InputTime desc")
.ToDataTable();
if (dt.Rows.Count > 0)
{
rptAlbumColumnList.Visible = true;
rptAlbumColumnList.DataSource = dt;
rptAlbumColumnList.DataBind();
ltNonData.Visible = false;
}
else
{
rptAlbumColumnList.Visible = false;
ltNonData.Visible = true;
}
}
public async Task <IActionResult> Post([FromBody] TUsers user)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
await _userRepository.Add(user);
return(Ok());
}
catch (DbUpdateConcurrencyException ex)
{
log.WriteLog(ex.ToString(), "UsersController.txt");
return(BadRequest());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!UserLoginInfo.IsLogin)
{
Response.Redirect("/");
}
TUsers model = DbSession.Default.Get <TUsers>(TUsers._.UserName == UserLoginInfo.UserName);
if (model == null)
{
Response.Redirect("/");
}
WhereClip where = VUsersAlbum._.UserID == model.UserID;
if (ColumnID != 0)
{
Web_UserAlbumColumn column = DbSession.Default.Get <Web_UserAlbumColumn>(Web_UserAlbumColumn._.ID == ColumnID);
if (column != null)
{
where &= VUsersAlbum._.ColumnID == ColumnID;
ColumnName = column.AlbumName;
}
}
anpPageIndex.RecordCount = DbSession.Default.Count <VUsersAlbum>(where);
anpPageIndex.CurrentPageIndex = PageIndex;
anpPageIndex.PageSize = anpPageIndex.PageSize;
DataTable dt = DbSession.Default.FromProc("Bzw_GetPager")
.AddInputParameter("@QueryStr", DbType.String, "select * from VUsersAlbum where " + string.Format(where.ToString(), "", ""))
.AddInputParameter("@PageSize", DbType.Int32, anpPageIndex.PageSize)
.AddInputParameter("@PageCurrent", DbType.Int32, PageIndex)
.AddInputParameter("@FdShow", DbType.String, "*")
.AddInputParameter("@FdOrder", DbType.String, "InputTime desc")
.ToDataTable();
//DataTable dt = DbSession.Default.From<Web_UserAlbumColumn>().Where(Web_UserAlbumColumn._.UserID == model.UserID).OrderBy(Web_UserAlbumColumn._.InputTime.Desc).ToDataTable();
if (dt.Rows.Count > 0)
{
rptAlbumColumnList.DataSource = dt;
rptAlbumColumnList.DataBind();
}
}
/// <summary>
/// 设置用户相册的公开状态
/// </summary>
private void SetAlbumPublic()
{
string state = CommonManager.Web.Request("public", "");
string aid = CommonManager.Web.Request("id", "");
#region 校验
if (string.IsNullOrEmpty(state) || string.IsNullOrEmpty(aid) || !CommonManager.String.IsInteger(state) || !CommonManager.String.IsInteger(aid))
{
Response.Write("请不要尝试非法操作。");
return;
}
if (!DbSession.Default.Exists <Web_UserAlbumColumn>(Web_UserAlbumColumn._.ID == aid))
{
Response.Write("请不要尝试非法操作。");
return;
}
//string UserName = uc.GetUserName.ToString();
if (!UserLoginInfo.IsLogin)
{
Response.Write("您尚未登录。");
return;
}
TUsers model = DbSession.Default.Get <TUsers>(TUsers._.UserName == UserLoginInfo.UserName);
if (model == null)
{
Response.Write("您尚未登录。");
return;
}
if (!DbSession.Default.Exists <Web_UserAlbumColumn>(Web_UserAlbumColumn._.ID == aid && Web_UserAlbumColumn._.UserID == model.UserID))
{
Response.Write("操作非法。");
return;
}
#endregion
DbSession.Default.Update <Web_UserAlbumColumn>(Web_UserAlbumColumn._.IsPublic, ((Library.PublicState) int.Parse(state)).ToString(), Web_UserAlbumColumn._.UserID == model.UserID && Web_UserAlbumColumn._.ID == aid);
Response.Write("success");
}
/// <summary>
/// 删除一个相册封面
/// </summary>
private void DelAlbumCover()
{
if (!UserLoginInfo.IsLogin)
{
Response.Write("您尚未登录。");
return;
}
TUsers model = DbSession.Default.Get <TUsers>(TUsers._.UserName == UserLoginInfo.UserName);
if (model == null)
{
Response.Write("您尚未登录。");
return;
}
string tmp = CommonManager.Web.Request("id", "");
if (string.IsNullOrEmpty(tmp) || !CommonManager.String.IsInteger(tmp) || !DbSession.Default.Exists <Web_UserAlbumColumn>(Web_UserAlbumColumn._.ID == tmp))
{
Response.Write("非法操作。");
return;
}
Web_UserAlbumColumn album = DbSession.Default.Get <Web_UserAlbumColumn>(Web_UserAlbumColumn._.ID == tmp);
if (album == null)
{
Response.Write("非法操作。");
return;
}
CommonManager.File.DeleteFile(album.Cover);
DbSession.Default.Update <Web_UserAlbumColumn>(Web_UserAlbumColumn._.Cover, "", Web_UserAlbumColumn._.ID == tmp);
Response.Write("success");
}
/// <summary>
/// 设置某个相册排序数字最大
/// </summary>
private void SetAlbumTop()
{
if (!UserLoginInfo.IsLogin)
{
Response.Write("请先登录。");
return;
}
TUsers user = DbSession.Default.Get <TUsers>(TUsers._.UserID == UserLoginInfo.UserID);
if (user == null)
{
Response.Write("请先登录。");
return;
}
string aid = CommonManager.Web.Request("id", "");
if (string.IsNullOrEmpty(aid) || !CommonManager.String.IsInteger(aid))
{
Response.Write("请不要尝试非法操作。");
return;
}
Web_UserAlbumColumn column = DbSession.Default.Get <Web_UserAlbumColumn>(Web_UserAlbumColumn._.ID == aid && Web_UserAlbumColumn._.UserID == user.UserID);
if (column == null)
{
Response.Write("请不要尝试非法操作。");
return;
}
int max = (int)DbSession.Default.Max <Web_UserAlbumColumn>(Web_UserAlbumColumn._.OrderID, Web_UserAlbumColumn._.UserID == UserLoginInfo.UserID);
column.OrderID = max + 1;
column.Attach();
DbSession.Default.Save <Web_UserAlbumColumn>(column);
Response.Write("success");
}
/// <summary>
/// 设置某张照片为相册封面
/// </summary>
private void SetToCover()
{
if (!UserLoginInfo.IsLogin)
{
Response.Write("请先登录。");
return;
}
TUsers user = DbSession.Default.Get <TUsers>(TUsers._.UserID == UserLoginInfo.UserID);
if (user == null)
{
Response.Write("请先登录。");
return;
}
string aid = CommonManager.Web.Request("id", "");
if (string.IsNullOrEmpty(aid) || !CommonManager.String.IsInteger(aid))
{
Response.Write("请不要尝试非法操作。");
return;
}
Web_UserAlbum pic = DbSession.Default.Get <Web_UserAlbum>(Web_UserAlbum._.ID == aid && Web_UserAlbum._.UserID == user.UserID);
if (pic == null)
{
Response.Write("请不要尝试非法操作。");
return;
}
Web_UserAlbumColumn column = DbSession.Default.Get <Web_UserAlbumColumn>(Web_UserAlbumColumn._.ID == pic.ColumnID);
column.Cover = pic.PicPath;
column.Attach();
DbSession.Default.Save <Web_UserAlbumColumn>(column);
Response.Write("success");
}
private void BtnLoginSignin_Click(object sender, EventArgs e)
{
string err = TUsers.CheckValidPassword(tBoxLogin.Text, tBoxPassword.Text);
if (string.IsNullOrEmpty(err))
{
this.Visible = false;
this.Close();
FormStudentInformation formStudent = new FormStudentInformation();
formStudent.ShowDialog();
return;
}
// if (tBoxLogin.Text == "" && tBoxPassword.Text == "")
//{
// MessageBox.Show("Unable to fill Username and Password", "Error Message!", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
//else if (tBoxLogin.Text == "")
//{
// MessageBox.Show("Unable to fill Username", "Error Message!", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
//else if (tBoxLogin.Text == "")
//{
// MessageBox.Show("Unable to fill Username", "Error Message!", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
MessageBox.Show("Грешен потребител или парола");
// DialogResult result1 = MessageBox.Show("Грешен потребител или парола?",
//"Important Question",
//MessageBoxButtons.YesNo);
//this.Close();
}
public FormAddUsers(TUsers u)
{
InitializeComponent();
users = u;
}
private async Task <bool> SaveAsync()
{
_dataInput = Input;
var valor = false;
if (ModelState.IsValid)
{
var userList = _userManager.Users.Where(u => u.Email.Equals(Input.Email)).ToList();
if (userList.Count.Equals(0))
{
var strategy = _context.Database.CreateExecutionStrategy();
await strategy.ExecuteAsync(async() => {
using (var transaction = _context.Database.BeginTransaction())
{
try
{
var user = new IdentityUser
{
UserName = Input.Email,
Email = Input.Email,
PhoneNumber = Input.PhoneNumber
};
var result = await _userManager.CreateAsync(user, Input.Password);
if (result.Succeeded)
{
await _userManager.AddToRoleAsync(user, Input.Role);
var dataUser = _userManager.Users.Where(u => u.Email.Equals(Input.Email)).ToList().Last();
var imageByte = await _uploadimage.ByteAvatarImageAsync(
Input.AvatarImage, _environment, "images/images/default.png");
var t_user = new TUsers
{
Name = Input.Name,
LastName = Input.LastName,
NID = Input.NID,
Email = Input.Email,
IdUser = dataUser.Id,
Image = imageByte,
};
await _context.AddAsync(t_user);
_context.SaveChanges();
transaction.Commit();
_dataInput = null;
valor = true;
}
else
{
foreach (var item in result.Errors)
{
_dataInput.ErrorMessage = item.Description;
}
valor = false;
transaction.Rollback();
}
}
catch (Exception ex)
{
_dataInput.ErrorMessage = ex.Message;
transaction.Rollback();
valor = false;
}
}
});
}
else
{
_dataInput.ErrorMessage = $"El {Input.Email} ya esta registrado";
valor = false;
}
}
else
{
foreach (var modelState in ModelState.Values)
{
foreach (var error in modelState.Errors)
{
_dataInput.ErrorMessage += error.ErrorMessage;
}
}
valor = false;
}
return(valor);
}
/// <summary>
/// 添加或修改一张照片
/// </summary>
private void AddPic()
{
if (!UserLoginInfo.IsLogin)
{
Response.Write("您尚未登录。<a href='javascript:history.back();'>点此返回上一页</a>");
return;
}
TUsers model = DbSession.Default.Get <TUsers>(TUsers._.UserName == UserLoginInfo.UserName);
if (model == null)
{
Response.Write("您尚未登录。<a href='javascript:history.back();'>点此返回上一页</a>");
return;
}
//获取表单值
string lcover = "";
//判断是否有相册
string columnid = CommonManager.Web.RequestForm("selColumnId", "");
if (string.IsNullOrEmpty(columnid) || !CommonManager.String.IsInteger(columnid))
{
Response.Write("没有相册，请先创建相册。<a href='/Manage/AlbumWrite.aspx'>点击创建相册</a>");
return;
}
if (Request.Files.Count > 0)
{
try
{
if (!CommonManager.File.UploadFile(Request.Files["filePicPath"], 100 * 1024, new string[] { "jpg", "jpeg", "gif", "bmp", "png" }, "/Upload/Photo/" + model.UserID.ToString(), FileOperator.RenameType.流水号, out lcover))
{
lcover = "";
}
}
catch (Exception ex)
{
Response.Write("文件上传错误：" + ex.Message + "<a href='javascript:history.back();'>点此返回上一页</a>");
return;
}
}
string pname = Server.HtmlEncode(CommonManager.Web.RequestForm("txtPicName", ""));
string pdes = Server.HtmlEncode(CommonManager.Web.RequestForm("txtPicDescription", ""));
string shortnum = CommonManager.Web.RequestForm("txtShortNum", "1");
string id = CommonManager.Web.Request("id", "");
//校验
if (string.IsNullOrEmpty(id) || !CommonManager.String.IsInteger(id))
{
if (string.IsNullOrEmpty(lcover))
{
Response.Write("请上传您的照片。<a href='javascript:history.back();'>点此返回上一页</a>");
return;
}
}
if (string.IsNullOrEmpty(pname) && !string.IsNullOrEmpty(lcover))
{
pname = lcover.Substring(lcover.LastIndexOf('/') + 1);
}
//存入数据库
Web_UserAlbum pic;
if (string.IsNullOrEmpty(id) || !CommonManager.String.IsInteger(id))
{
pic = new Web_UserAlbum();
pic.InputTime = DateTime.Now;
pic.UserID = model.UserID;
pic.Enable = Library.EnableState.未处理.ToString();
}
else
{
pic = DbSession.Default.Get <Web_UserAlbum>(Web_UserAlbum._.ID == id);
pic.Attach();
}
pic.ColumnID = int.Parse(columnid);
pic.PicDescription = pdes;
pic.PicName = pname;
pic.PicPath = string.IsNullOrEmpty(pic.PicPath) ? lcover : pic.PicPath;
pic.ShortNum = (string.IsNullOrEmpty(shortnum) || !CommonManager.String.IsInteger(shortnum)) ? 1 : int.Parse(shortnum);
DbSession.Default.Save <Web_UserAlbum>(pic);
//反馈
Response.Write("<script>location.href='PicList.aspx';</script>");
}
/// <summary>
/// 添加或修改一个相册
/// </summary>
private void AddAlbumColumn()
{
if (!UserLoginInfo.IsLogin)
{
Response.Write("您尚未登录。<a href='javascript:history.back();'>点此返回上一页</a>");
return;
}
TUsers model = DbSession.Default.Get <TUsers>(TUsers._.UserName == UserLoginInfo.UserName);
if (model == null)
{
Response.Write("您尚未登录。<a href='javascript:history.back();'>点此返回上一页</a>");
return;
}
//获取表单数据
string name = CommonManager.Web.RequestForm("txtAlbumName", "");
string ucover = CommonManager.Web.RequestForm("txtCover", "");
string lcover = "";
if (Request.Files.Count > 0)
{
try
{
if (!CommonManager.File.UploadFile(Request.Files["fileCover"], 100 * 1024, new string[] { "jpg", "jpeg", "gif", "bmp", "png" }, "/Upload/UserAlbum", FileOperator.RenameType.流水号, out lcover))
{
lcover = "";
}
}
catch (Exception ex)
{
Response.Write("文件上传错误：" + ex.Message + "<a href='javascript:history.back();'>点此返回上一页</a>");
return;
}
}
string ispublic = CommonManager.Web.RequestForm("rdoIsPublic", Library.PublicState.公开.ToString());
//校验
if (string.IsNullOrEmpty(name))
{
Response.Write("请填写相册名称。<a href='javascript:history.back();'>点此返回上一页</a>");
return;
}
//填充数据库
string cur = CommonManager.Web.Request("cur", "");
Web_UserAlbumColumn album;
if (string.IsNullOrEmpty(cur))
{
album = new Web_UserAlbumColumn();
album.InputTime = DateTime.Now;
album.UserID = model.UserID;
}
else
{
album = DbSession.Default.Get <Web_UserAlbumColumn>(Web_UserAlbumColumn._.ID == cur);
album.Attach();
}
album.AlbumName = name;
album.Cover = string.IsNullOrEmpty(album.Cover) ? (string.IsNullOrEmpty(lcover) ? ucover : lcover) : album.Cover;
album.IsPublic = ispublic;
DbSession.Default.Save <Web_UserAlbumColumn>(album);
//返回信息
Response.Write("<script>location.href='Album.aspx';</script>");
}
