/// <summary> /// 得到一个对象实体 /// </summary> public Models.AspNetUsers GetModel(string Id, string UserName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,Email,EmailConfirmed,PasswordHash,SecurityStamp,PhoneNumber,PhoneNumberConfirmed,TwoFactorEnabled,LockoutEndDateUtc,LockoutEnabled,AccessFailedCount,UserName,FirstName,LastName,Birthday from AspNetUsers "); strSql.Append(" where Id=@Id and UserName=@UserName "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.NVarChar, 128), new SqlParameter("@UserName", SqlDbType.NVarChar, 256) }; parameters[0].Value = Id; parameters[1].Value = UserName; Models.AspNetUsers model = new Models.AspNetUsers(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Models.AspNetUsers model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AspNetUsers("); strSql.Append("Id,Email,EmailConfirmed,PasswordHash,SecurityStamp,PhoneNumber,PhoneNumberConfirmed,TwoFactorEnabled,LockoutEndDateUtc,LockoutEnabled,AccessFailedCount,UserName,FirstName,LastName,Birthday)"); strSql.Append(" values ("); strSql.Append("@Id,@Email,@EmailConfirmed,@PasswordHash,@SecurityStamp,@PhoneNumber,@PhoneNumberConfirmed,@TwoFactorEnabled,@LockoutEndDateUtc,@LockoutEnabled,@AccessFailedCount,@UserName,@FirstName,@LastName,@Birthday)"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.NVarChar, 128), new SqlParameter("@Email", SqlDbType.NVarChar, 256), new SqlParameter("@EmailConfirmed", SqlDbType.Bit, 1), new SqlParameter("@PasswordHash", SqlDbType.NVarChar, -1), new SqlParameter("@SecurityStamp", SqlDbType.NVarChar, -1), new SqlParameter("@PhoneNumber", SqlDbType.NVarChar, -1), new SqlParameter("@PhoneNumberConfirmed", SqlDbType.Bit, 1), new SqlParameter("@TwoFactorEnabled", SqlDbType.Bit, 1), new SqlParameter("@LockoutEndDateUtc", SqlDbType.DateTime), new SqlParameter("@LockoutEnabled", SqlDbType.Bit, 1), new SqlParameter("@AccessFailedCount", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.NVarChar, 256), new SqlParameter("@FirstName", SqlDbType.NVarChar, 100), new SqlParameter("@LastName", SqlDbType.NVarChar, 100), new SqlParameter("@Birthday", SqlDbType.Date, 3) }; parameters[0].Value = model.Id; parameters[1].Value = model.Email; parameters[2].Value = model.EmailConfirmed; parameters[3].Value = model.PasswordHash; parameters[4].Value = model.SecurityStamp; parameters[5].Value = model.PhoneNumber; parameters[6].Value = model.PhoneNumberConfirmed; parameters[7].Value = model.TwoFactorEnabled; parameters[8].Value = model.LockoutEndDateUtc; parameters[9].Value = model.LockoutEnabled; parameters[10].Value = model.AccessFailedCount; parameters[11].Value = model.UserName; parameters[12].Value = model.FirstName; parameters[13].Value = model.LastName; parameters[14].Value = model.Birthday; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public IHttpActionResult Add(Models.Request.UsuarioRequest model) { using (Models.CONTROLINGRESOEntities db = new Models.CONTROLINGRESOEntities()) { var nUsuario = new Models.AspNetUsers(); nUsuario.UserName = model.Nombre; nUsuario.Email = model.Email; db.AspNetUsers.Add(nUsuario); db.SaveChanges(); } return(Ok("Exito")); }
public async Task <IActionResult> OnGetAsync(string id) { if (id == null) { return(NotFound()); } AspNetUsers = await _context.AspNetUsers.FirstOrDefaultAsync(m => m.Id == id); if (AspNetUsers == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnPostAsync(string id) { if (id == null) { return(NotFound()); } AspNetUsers = await _context.AspNetUsers.FindAsync(id); if (AspNetUsers != null) { _context.AspNetUsers.Remove(AspNetUsers); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Models.AspNetUsers model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AspNetUsers set "); strSql.Append("Email=@Email,"); strSql.Append("EmailConfirmed=@EmailConfirmed,"); strSql.Append("PasswordHash=@PasswordHash,"); strSql.Append("SecurityStamp=@SecurityStamp,"); strSql.Append("PhoneNumber=@PhoneNumber,"); strSql.Append("PhoneNumberConfirmed=@PhoneNumberConfirmed,"); strSql.Append("TwoFactorEnabled=@TwoFactorEnabled,"); strSql.Append("LockoutEndDateUtc=@LockoutEndDateUtc,"); strSql.Append("LockoutEnabled=@LockoutEnabled,"); strSql.Append("AccessFailedCount=@AccessFailedCount,"); strSql.Append("FirstName=@FirstName,"); strSql.Append("LastName=@LastName,"); strSql.Append("Birthday=@Birthday"); strSql.Append(" where Id=@Id and UserName=@UserName "); SqlParameter[] parameters = { new SqlParameter("@Email", SqlDbType.NVarChar, 256), new SqlParameter("@EmailConfirmed", SqlDbType.Bit, 1), new SqlParameter("@PasswordHash", SqlDbType.NVarChar, -1), new SqlParameter("@SecurityStamp", SqlDbType.NVarChar, -1), new SqlParameter("@PhoneNumber", SqlDbType.NVarChar, -1), new SqlParameter("@PhoneNumberConfirmed", SqlDbType.Bit, 1), new SqlParameter("@TwoFactorEnabled", SqlDbType.Bit, 1), new SqlParameter("@LockoutEndDateUtc", SqlDbType.DateTime), new SqlParameter("@LockoutEnabled", SqlDbType.Bit, 1), new SqlParameter("@AccessFailedCount", SqlDbType.Int, 4), new SqlParameter("@FirstName", SqlDbType.NVarChar, 100), new SqlParameter("@LastName", SqlDbType.NVarChar, 100), new SqlParameter("@Birthday", SqlDbType.Date, 3), new SqlParameter("@Id", SqlDbType.NVarChar, 128), new SqlParameter("@UserName", SqlDbType.NVarChar, 256) }; parameters[0].Value = model.Email; parameters[1].Value = model.EmailConfirmed; parameters[2].Value = model.PasswordHash; parameters[3].Value = model.SecurityStamp; parameters[4].Value = model.PhoneNumber; parameters[5].Value = model.PhoneNumberConfirmed; parameters[6].Value = model.TwoFactorEnabled; parameters[7].Value = model.LockoutEndDateUtc; parameters[8].Value = model.LockoutEnabled; parameters[9].Value = model.AccessFailedCount; parameters[10].Value = model.FirstName; parameters[11].Value = model.LastName; parameters[12].Value = model.Birthday; parameters[13].Value = model.Id; parameters[14].Value = model.UserName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Models.AspNetUsers DataRowToModel(DataRow row) { Models.AspNetUsers model = new Models.AspNetUsers(); if (row != null) { if (row["Id"] != null) { model.Id = row["Id"].ToString(); } if (row["Email"] != null) { model.Email = row["Email"].ToString(); } if (row["EmailConfirmed"] != null && row["EmailConfirmed"].ToString() != "") { if ((row["EmailConfirmed"].ToString() == "1") || (row["EmailConfirmed"].ToString().ToLower() == "true")) { model.EmailConfirmed = true; } else { model.EmailConfirmed = false; } } if (row["PasswordHash"] != null) { model.PasswordHash = row["PasswordHash"].ToString(); } if (row["SecurityStamp"] != null) { model.SecurityStamp = row["SecurityStamp"].ToString(); } if (row["PhoneNumber"] != null) { model.PhoneNumber = row["PhoneNumber"].ToString(); } if (row["PhoneNumberConfirmed"] != null && row["PhoneNumberConfirmed"].ToString() != "") { if ((row["PhoneNumberConfirmed"].ToString() == "1") || (row["PhoneNumberConfirmed"].ToString().ToLower() == "true")) { model.PhoneNumberConfirmed = true; } else { model.PhoneNumberConfirmed = false; } } if (row["TwoFactorEnabled"] != null && row["TwoFactorEnabled"].ToString() != "") { if ((row["TwoFactorEnabled"].ToString() == "1") || (row["TwoFactorEnabled"].ToString().ToLower() == "true")) { model.TwoFactorEnabled = true; } else { model.TwoFactorEnabled = false; } } if (row["LockoutEndDateUtc"] != null && row["LockoutEndDateUtc"].ToString() != "") { model.LockoutEndDateUtc = DateTime.Parse(row["LockoutEndDateUtc"].ToString()); } if (row["LockoutEnabled"] != null && row["LockoutEnabled"].ToString() != "") { if ((row["LockoutEnabled"].ToString() == "1") || (row["LockoutEnabled"].ToString().ToLower() == "true")) { model.LockoutEnabled = true; } else { model.LockoutEnabled = false; } } if (row["AccessFailedCount"] != null && row["AccessFailedCount"].ToString() != "") { model.AccessFailedCount = int.Parse(row["AccessFailedCount"].ToString()); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["FirstName"] != null) { model.FirstName = row["FirstName"].ToString(); } if (row["LastName"] != null) { model.LastName = row["LastName"].ToString(); } if (row["Birthday"] != null && row["Birthday"].ToString() != "") { model.Birthday = DateTime.Parse(row["Birthday"].ToString()); } } return(model); }