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}"));
}
}
