public static async Task <int> Change(ResumeEntity resume) { var query = "UPDATE resume SET age=@age,name=@name,city=@city,education=@education,community=@community,project=@project,academic=@academic,skill=@skill,introduction=@introduction where user_id=@id"; using var connection = DatabaseConnector.Connect(); await connection.OpenAsync(); using var command = connection.CreateCommand(); command.CommandText = query; command.Parameters.AddWithValue("@id", resume.student_id); command.Parameters.AddWithValue("@age", resume.age); command.Parameters.AddWithValue("@name", resume.student_name); command.Parameters.AddWithValue("@city", resume.city); command.Parameters.AddWithValue("@education", resume.education); command.Parameters.AddWithValue("@community", resume.community); command.Parameters.AddWithValue("@project", resume.project); command.Parameters.AddWithValue("@academic", resume.academic); command.Parameters.AddWithValue("@skill", resume.skill); command.Parameters.AddWithValue("@introduction", resume.introduction); var row = await command.ExecuteNonQueryAsync(); if (row > 0) { return(resume.student_id); } return(0); }
public static async Task <int> Create(ResumeEntity resume) { var query = "INSERT INTO resume(student_id,age,name,city,education,community,project,academic,skill,introduction) VALUES(@id,@age,@name,@city,@education,@community,@project,@academic,@skill,@introduction)"; using var connection = DatabaseConnector.Connect(); await connection.OpenAsync(); using var command = connection.CreateCommand(); command.CommandText = query; command.Parameters.AddWithValue("@id", resume.student_id); command.Parameters.AddWithValue("@age", resume.age); command.Parameters.AddWithValue("@name", resume.student_name); command.Parameters.AddWithValue("@city", resume.city); command.Parameters.AddWithValue("@education", resume.education); command.Parameters.AddWithValue("@community", resume.community); command.Parameters.AddWithValue("@project", resume.project); command.Parameters.AddWithValue("@academic", resume.academic); command.Parameters.AddWithValue("@skill", resume.skill); command.Parameters.AddWithValue("@introduction", resume.introduction); await command.ExecuteNonQueryAsync(); return((int)command.LastInsertedId); }
public static void MapTo(this Resume resume, ResumeEntity entity) { entity.createdTime = resume.CreatedTime; entity.lastEditedTime = resume.LastUpdatedTime; entity.affiliations = resume.Affiliations; entity.citizenship = resume.Citizenship; entity.interests = resume.Interests; entity.objective = resume.Objective; entity.other = resume.Other; entity.professional = resume.Professional; entity.referees = resume.Referees; entity.skills = resume.Skills; entity.summary = resume.Summary; entity.ResumeJobEntities = resume.Jobs.Map(resume.Id); entity.ResumeSchoolEntities = resume.Schools.Map(resume.Id); var awards = resume.Awards == null ? null : (from a in resume.Awards where a != null && !string.IsNullOrEmpty(a.Trim()) select a).ToArray(); entity.awards = awards == null || awards.Length == 0 ? null : string.Join("\n", awards); var courses = resume.Courses == null ? null : (from c in resume.Courses where c != null && !string.IsNullOrEmpty(c.Trim()) select c).ToArray(); entity.courses = courses == null || courses.Length == 0 ? null : string.Join("\n", courses); }
/// <summary> /// 修改简历 /// </summary> public bool EditResumeInfo(ResumeEntity entity, List <ResumeExpEntity> reEntityList) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Resume_Base set "); strSql.Append("RealName=@RealName,Sex=@Sex,Nation=@Nation,IdCard=@IdCard,PoliticalAffiliation=@PoliticalAffiliation,"); strSql.Append("Education=@Education,Major=@Major,IsMarry=@IsMarry,IsBred=@IsBred,Residence=@Residence,ResidenceType=@ResidenceType,Address=@Address,FillingDate=@FillingDate"); strSql.Append(" where Id=@Id"); SqlParameter[] paras = { new SqlParameter("@Id", entity.Id), new SqlParameter("@RealName", entity.RealName), new SqlParameter("@Sex", entity.Sex), new SqlParameter("@Nation", entity.Nation), new SqlParameter("@IdCard", entity.IdCard), new SqlParameter("@PoliticalAffiliation", entity.PoliticalAffiliation), new SqlParameter("@Education", entity.Education), new SqlParameter("@Major", entity.Major), new SqlParameter("@IsMarry", entity.IsMarry), new SqlParameter("@IsBred", entity.IsBred), new SqlParameter("@Residence", entity.Residence), new SqlParameter("@ResidenceType", entity.ResidenceType), new SqlParameter("@Address", entity.Address), new SqlParameter("@FillingDate", DateTime.Now.ToString("yyyy-MM-dd")), }; object obj = SqlHelper.ExecuteNonQuery(SqlHelper.connStr, CommandType.Text, strSql.ToString(), paras); StringBuilder strSql2 = new StringBuilder(); strSql2.Append("update Resume_EducationExp set "); strSql2.Append("EducationalServices=@EducationalServices,Major=@Major,StartTime=@StartTime,Mode=@Mode,Diploma=@Diploma"); strSql2.Append(" where Id=@Id "); foreach (ResumeExpEntity reEntity in reEntityList) { SqlParameter[] paras2 = { new SqlParameter("@Id", reEntity.Id), new SqlParameter("@EducationalServices", reEntity.EducationalServices), new SqlParameter("@Major", reEntity.Major), new SqlParameter("@StartTime", reEntity.StartTime), new SqlParameter("@Mode", reEntity.Mode), new SqlParameter("@Diploma", reEntity.Diploma), }; object obj2 = SqlHelper.ExecuteNonQuery(SqlHelper.connStr, CommandType.Text, strSql2.ToString(), paras2); } if (Convert.ToInt32(obj) > 0) { return(true); } else { return(false); } }
public static ResumeEntity Map(this Resume resume) { var entity = new ResumeEntity { id = resume.Id }; resume.MapTo(entity); return(entity); }
/// <summary> /// 添加简历 /// </summary> public int AddResume(ResumeEntity entity, List <ResumeExpEntity> reEntityList) { int iResut = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Resume_Base(RealName,Sex,Nation,IdCard,PoliticalAffiliation,Education,Major,IsMarry,IsBred,Residence,ResidenceType,Address,FillingDate)"); strSql.Append(" values "); strSql.Append("(@RealName,@Sex,@Nation,@IdCard,@PoliticalAffiliation,@Education,@Major,@IsMarry,@IsBred,@Residence,@ResidenceType,@Address,@FillingDate)"); strSql.Append(";SELECT @@IDENTITY"); //返回插入用户的主键 SqlParameter[] paras = { //new SqlParameter("@Id",entity.Id), new SqlParameter("@RealName", entity.RealName), new SqlParameter("@Sex", entity.Sex), new SqlParameter("@Nation", entity.Nation), new SqlParameter("@IdCard", entity.IdCard), new SqlParameter("@PoliticalAffiliation", entity.PoliticalAffiliation), new SqlParameter("@Education", entity.Education), new SqlParameter("@Major", entity.Major), new SqlParameter("@IsMarry", entity.IsMarry), new SqlParameter("@IsBred", entity.IsBred), new SqlParameter("@Residence", entity.Residence), new SqlParameter("@ResidenceType", entity.ResidenceType), new SqlParameter("@Address", entity.Address), new SqlParameter("@FillingDate", DateTime.Now.ToString("yyyy-MM-dd")), }; iResut = Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.connStr, CommandType.Text, strSql.ToString(), paras)); StringBuilder strSql2 = new StringBuilder(); strSql2.Append("insert into Resume_EducationExp(Id,ResumeId,EducationalServices,Major,StartTime,Mode,Diploma)"); strSql2.Append(" values "); strSql2.Append("(@Id,@ResumeId,@EducationalServices,@Major,@StartTime,@Mode,@Diploma)"); foreach (ResumeExpEntity reEntity in reEntityList) { SqlParameter[] paras2 = { new SqlParameter("@Id", reEntity.Id), new SqlParameter("@ResumeId", iResut), new SqlParameter("@EducationalServices", reEntity.EducationalServices), new SqlParameter("@Major", reEntity.Major), new SqlParameter("@StartTime", reEntity.StartTime), new SqlParameter("@Mode", reEntity.Mode), new SqlParameter("@Diploma", reEntity.Diploma), }; Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.connStr, CommandType.Text, strSql2.ToString(), paras2)); } return(iResut); }
private static void DeleteJobsSchools(ResumesDataContext dc, ResumeEntity entity) { if (entity.ResumeJobEntities != null && entity.ResumeJobEntities.Count > 0) { dc.ResumeJobEntities.DeleteAllOnSubmit(entity.ResumeJobEntities); entity.ResumeJobEntities = null; } if (entity.ResumeSchoolEntities != null && entity.ResumeSchoolEntities.Count > 0) { dc.ResumeSchoolEntities.DeleteAllOnSubmit(entity.ResumeSchoolEntities); entity.ResumeSchoolEntities = null; } }
public static async Task <int> Create(ResumeEntity resume) { var query = "INSERT INTO resume(user_id) VALUES(@id)"; using var connection = DatabaseConnector.Connect(); await connection.OpenAsync(); using var command = connection.CreateCommand(); command.CommandText = query; command.Parameters.AddWithValue("@id", resume.student_id); await command.ExecuteNonQueryAsync(); return((int)command.LastInsertedId); }
public static Resume Map(this ResumeEntity entity) { return(new Resume { Id = entity.id, CreatedTime = entity.createdTime, LastUpdatedTime = entity.lastEditedTime, Affiliations = entity.affiliations, Citizenship = entity.citizenship, Interests = entity.interests, Objective = entity.objective, Other = entity.other, Professional = entity.professional, Referees = entity.referees, Skills = entity.skills, Summary = entity.summary, Awards = entity.awards == null ? null : entity.awards.Split(new[] { "\n" }, StringSplitOptions.RemoveEmptyEntries), Courses = entity.courses == null ? null : entity.courses.Split(new[] { "\n" }, StringSplitOptions.RemoveEmptyEntries), }); }
public async Task <ActionResult <AccountResponse> > PostRegister([FromBody] RegisterRequest request) { if (!ModelState.IsValid) { return(BadRequest()); } var account = _mapper.Map <AccountEntity>(request); account.Password = BCrypt.Net.BCrypt.HashPassword(Sha512Hmac.HashPassword(request.Password), 10); account.Id = await AccountAccessor.Create(account); await UserAccessor.Create(account); // Create user at the same time if (request.Role == Constants.Role.Student) { var resume = new ResumeEntity(); resume.student_id = account.Id; await ResumeAccessor.Create(resume); } await AnnounceAccessor.SetNewSend(account.Id);//create user's announce // issue cookie var claims = new Claim[] { new Claim(ClaimTypes.Name, account.Id.ToString()), new Claim(ClaimTypes.Role, account.Role.ToString()), }; var claimsIdentity = new ClaimsIdentity(claims, CookieAuthenticationDefaults.AuthenticationScheme); await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(claimsIdentity), authProperties); return(Ok(_mapper.Map <AccountResponse>(account))); }
public static Resume ToObject(this ResumeEntity entity) { return(new Resume(entity.Person.ToObject(), entity.Higher_education, entity.Eng_knowledge, entity.Experience, entity.About_person, entity.Sphere, entity.Expected_sallary)); }
public bool EditResumeInfo(ResumeEntity entity, List <ResumeExpEntity> reEntityList) { return(dal.EditResumeInfo(entity, reEntityList)); }
public int AddResume(ResumeEntity entity, List <ResumeExpEntity> reEntityList) { return(dal.AddResume(entity, reEntityList)); }
public ActionResult EditResumeInfo() { try { #region 实体信息 ResumeEntity rEntity = new ResumeEntity(); List <ResumeExpEntity> reEntityList = new List <ResumeExpEntity>(); rEntity.Id = Request["rId"]; rEntity.RealName = Request["txtRealName"]; rEntity.Sex = Request["txtSex"]; rEntity.Nation = Request["txtNation"]; rEntity.IdCard = Request["txtIdCard"]; rEntity.PoliticalAffiliation = Request["txtPoliticalAffiliation"]; rEntity.Education = Request["txtEducation"]; rEntity.Major = Request["txtMajor"]; rEntity.IsMarry = Request["txtIsMarry"]; rEntity.IsBred = Request["txtIsBred"]; rEntity.Residence = Request["txtResidence"]; rEntity.ResidenceType = Request["txtResidenceType"]; rEntity.Address = Request["txtAddress"]; if (Request["txtEducationalServices1"] != "") { ResumeExpEntity reEntity1 = new ResumeExpEntity(); reEntity1.Id = Request["rExpId1"]; reEntity1.EducationalServices = Request["txtEducationalServices1"]; reEntity1.Major = Request["txtMajor1"]; reEntity1.StartTime = Request["txtStartTime1"]; reEntity1.Mode = Request["txtMode1"]; reEntity1.Diploma = Request["txtDiploma1"]; reEntityList.Add(reEntity1); } if (Request["txtEducationalServices2"] != "") { ResumeExpEntity reEntity2 = new ResumeExpEntity(); reEntity2.Id = Request["rExpId2"]; //reEntity2.ResumeId = rEntity.Id; reEntity2.EducationalServices = Request["txtEducationalServices2"]; reEntity2.Major = Request["txtMajor2"]; reEntity2.StartTime = Request["txtStartTime2"]; reEntity2.Mode = Request["txtMode2"]; reEntity2.Diploma = Request["txtDiploma2"]; reEntityList.Add(reEntity2); } if (Request["txtEducationalServices2"] != "") { ResumeExpEntity reEntity3 = new ResumeExpEntity(); reEntity3.Id = Request["rExpId3"]; //reEntity3.ResumeId = rEntity.Id; reEntity3.EducationalServices = Request["txtEducationalServices3"]; reEntity3.Major = Request["txtMajor3"]; reEntity3.StartTime = Request["txtStartTime3"]; reEntity3.Mode = Request["txtMode3"]; reEntity3.Diploma = Request["txtDiploma3"]; reEntityList.Add(reEntity3); } #endregion if (bll.EditResumeInfo(rEntity, reEntityList)) { return(Content("{\"msg\":\"修改成功!\",\"success\":true}")); } else { return(Content("{\"msg\":\"修改失败!\",\"success\":true}")); } } catch (Exception ex) { return(Content("{\"msg\":\"修改失败," + ex.Message + "\",\"success\":false}")); } }