public ActionResult GetSign(ApplicantInfo model, HttpPostedFileBase file)
{
if (file != null && file.ContentLength > 0)
{
var storePath = IMSEnvProperties.ContractFileLocation;
var temp = Path.GetFileName(file.FileName);
var fileName = "" + model.TemplateId + "_" + model.Email + "_" + temp;
var path = Path.Combine(storePath, fileName);
try
{
file.SaveAs(path);
model.PassportFileLocation = path;
}
catch (Exception ex)
{
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
ViewBag.Message = "ERROR:" + ex.Message.ToString();
}
}
else
{
ViewBag.Message = "You have not specified a file.";
return(View("NullFile"));
}
return(View(model));
}
public ActionResult AddApplicantInfo([Bind(Include = "FirstName,LastName,PhoneNumber,Email")] ApplicantInfo applicantInfo)
{
if (ModelState.IsValid)
{
applicantInfo.UserAgent = HttpContext.Request.UserAgent;
applicantInfo.ContentType = HttpContext.Request.ContentType;
applicantInfo.IPAddress = HttpContext.Request.UserHostAddress;
var val = Session["id"];
if (val == null)
{
if (_applicantBusiness.AddApplicantBL(applicantInfo))
{
ApplicantInfo applicant = _applicantBusiness.GetRecentApplicantBL();
Session["id"] = applicant.ApplicantId;
}
}
else
{
_applicantBusiness.UpdateApplicantBL(applicantInfo);
}
return(RedirectToAction(Constants.AddressInfo, "Address"));
}
return(View(Constants.ApplicantInfo));
}
public void MergeTwoPDF(string file1Loc, string file2Loc, ApplicantInfo model)
{
String[] source_files = { file1Loc, file2Loc };
var storePath = IMSEnvProperties.ContractFileLocation;
String result = storePath + "\\" + model.TemplateId + "_" + model.Email + "_Contract_Passport.pdf";
//create Document object
Document document = new Document();
//create PdfCopy object
var fs = new FileStream(result, FileMode.Create);
PdfCopy copy = new PdfCopy(document, fs);
//open the document
document.Open();
//PdfReader variable
PdfReader reader;
for (int i = 0; i < source_files.Length; i++)
{
//create PdfReader object
reader = new PdfReader(source_files[i]);
//merge combine pages
for (int page = 1; page <= reader.NumberOfPages; page++)
{
copy.AddPage(copy.GetImportedPage(reader, page));
}
reader.Close();
}
//close the document object
document.Close();
fs.Close();
}
public List <ApplicantInfo> GetApplicantsDL()
{
try
{
List <ApplicantInfo> applicants = new List <ApplicantInfo>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
string query = "select * from tblApplicantInfo";
SqlCommand cmd = new SqlCommand(query, connection);
connection.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
ApplicantInfo applicantInfo = new ApplicantInfo();
applicantInfo.ApplicantId = Convert.ToInt32(dataReader["ApplicantId"]);
applicantInfo.FirstName = dataReader["FirstName"].ToString();
applicantInfo.LastName = dataReader["LastName"].ToString();
applicantInfo.Email = dataReader["Email"].ToString();
applicants.Add(applicantInfo);
}
}
return(applicants);
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteUploadedFile(ApplicantInfo model)
{
if (System.IO.File.Exists(model.PassportFileLocation))
{
System.IO.File.Delete(model.PassportFileLocation);
}
}
public ApplicantInfo GetApplicantByIdDA(int id)
{
try
{
ApplicantInfo applicantInfo = new ApplicantInfo();
using (SqlConnection connection = new SqlConnection(connectionString))
{
string query = "select * from tblApplicantInfo where ApplicantId=" + id;
SqlCommand cmd = new SqlCommand(query, connection);
connection.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
applicantInfo.ApplicantId = Convert.ToInt32(dataReader["ApplicantId"]);
applicantInfo.FirstName = dataReader["FirstName"].ToString();
applicantInfo.LastName = dataReader["LastName"].ToString();
applicantInfo.PhoneNumber = dataReader["PhoneNumber"].ToString();
applicantInfo.Email = dataReader["Email"].ToString();
applicantInfo.HighestCompletedStage = Convert.ToInt32(dataReader["HighestCompletedStage"]);
}
}
return(applicantInfo);
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateApplicantDL(ApplicantInfo applicantInfo)
{
try
{
int i;
using (SqlConnection connection = new SqlConnection(connectionString))
{
string query = string.Format("update tblApplicantInfo set FirstName='{0}', LastName='{1}',Email='{2}' where ApplicantId={3}", applicantInfo.FirstName, applicantInfo.LastName, applicantInfo.Email, applicantInfo.ApplicantId);
using (SqlCommand cmd = new SqlCommand(query, connection))
{
connection.Open();
i = cmd.ExecuteNonQuery();
connection.Close();
}
}
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddApplicantDL(ApplicantInfo applicantInfo)
{
try
{
int i;
using (SqlConnection connection = new SqlConnection(connectionString))
{
string query = string.Format("insert into tblApplicantInfo values('{0}','{1}','{2}')", applicantInfo.FirstName, applicantInfo.LastName, applicantInfo.Email);
using (SqlCommand cmd = new SqlCommand(query, connection))
{
connection.Open();
i = cmd.ExecuteNonQuery();
connection.Close();
}
}
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateApplicantDA(ApplicantInfo applicantInfo)
{
try
{
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("spUpdateApplicant", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ApplicantId", applicantInfo.ApplicantId);
cmd.Parameters.AddWithValue("@FirstName", applicantInfo.FirstName);
cmd.Parameters.AddWithValue("@LastName", applicantInfo.LastName);
cmd.Parameters.AddWithValue("@PhoneNumber", applicantInfo.PhoneNumber);
cmd.Parameters.AddWithValue("@Email", applicantInfo.Email);
cmd.Parameters.AddWithValue("@HighestCompletedStage", applicantInfo.HighestCompletedStage);
cmd.Parameters.AddWithValue("@UserAgent", applicantInfo.UserAgent);
cmd.Parameters.AddWithValue("@IPAddress", applicantInfo.IPAddress);
cmd.Parameters.AddWithValue("@ContentType", applicantInfo.ContentType);
connection.Open();
int i = cmd.ExecuteNonQuery();
connection.Close();
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void RefreshUI(ApplicantInfo applicationInfo)
{
this.applicationInfo = applicationInfo;
base.FindTransform("level").GetComponent <Text>().set_text(applicationInfo.lv.ToString());
base.FindTransform("name").GetComponent <Text>().set_text(applicationInfo.name.ToString());
base.FindTransform("fighting").GetComponent <Text>().set_text(applicationInfo.fighting.ToString());
base.FindTransform("vipLV").GetComponent <Text>().set_text(applicationInfo.vipLv.ToString());
ResourceManager.SetSprite(this.m_headIcon, UIUtils.GetRoleSmallIcon(applicationInfo.career));
}
public void OrderApply()
{
OrderApplyInputModel model = new OrderApplyInputModel();
model.transNo = UtilityHelper.CommonHelper.OrderNoOne();
//model.customkey = "bowangjishi";
model.caseCode = "0000052178002133";
model.insurantDateLimit = "365";
ApplicationData _applicationData = new ApplicationData();
_applicationData.applicationDate = "2017-09-07 13:00:00";
_applicationData.startDate = "2017-09-08";
_applicationData.endDate = "2018-09-08";
ApplicantInfo _applicantInfo = new ApplicantInfo();
_applicantInfo.cName = "倪成智";
_applicantInfo.eName = "nichengzhi";
_applicantInfo.cardType = 1;
_applicantInfo.cardCode = "210623199008092631";
_applicantInfo.sex = 1;
_applicantInfo.birthday = "1990-08-09";
_applicantInfo.mobile = "15841505041";
_applicantInfo.email = "*****@*****.**";
_applicantInfo.cardPeriod = "2020-10-01";
InsurantInfo _insurantInfo = new InsurantInfo();
_insurantInfo.cName = "倪成智";
_insurantInfo.eName = "nichengzhi";
_insurantInfo.cardType = 1;
_insurantInfo.cardCode = "210623199008092631";
_insurantInfo.sex = 1;
_insurantInfo.birthday = "1990-08-09";
_insurantInfo.mobile = "15841505041";
_insurantInfo.relationId = 1;
_insurantInfo.count = 1;
_insurantInfo.singlePrice = 12;
_insurantInfo.cardPeriod = "2020-10-01";
OtherInfo _otherInfo = new OtherInfo();
_otherInfo.provCityId = "510000-511800-511821";
_otherInfo.cardPeriod = "2020-10-01";
_otherInfo.notifyAnswerId = "";
_otherInfo.priceArgsId = "";
model.applicationdata = _applicationData;
model.applicantinfo = _applicantInfo;
model.insurantInfo = _insurantInfo;
model.otherInfo = _otherInfo;
BaoxianDataBLL baoxianDataBLL = new BaoxianDataBLL();
var res = baoxianDataBLL.OrderApply(model);
}
/// <summary>
/// 通过实体修改
/// </summary>
/// <param name="values"></param>
/// <returns></returns>
public bool Modify(ApplicantInfo values)
{
bool modify = false;
ApplicantInfo applicant = financeMapper.FindByApplicantId(values.ApplicantId.Value);
if (values == null)
{
return(false);
}
applicant.ApplicantId = values.ApplicantId;
applicant.FinanceId = values.FinanceId;
applicant.Name = values.Name;
applicant.Sex = values.Sex;
applicant.Age = values.Age;
applicant.Type = values.Type;
applicant.RelationWithMaster = values.RelationWithMaster;
applicant.Identity = values.Identity;
applicant.IdentityType = values.IdentityType;
applicant.Mobile = values.Mobile;
applicant.Phone = values.Phone;
applicant.MaritalStatus = values.MaritalStatus;
applicant.WifeName = values.WifeName;
applicant.Degree = values.Degree;
applicant.RegisteredAddress = values.RegisteredAddress;
applicant.OfficeName = values.OfficeName;
applicant.Department = values.Department;
applicant.IndustryType = values.IndustryType;
applicant.ProfessionType = values.ProfessionType;
applicant.OfficePhone = values.OfficePhone;
applicant.OfficeAddress = values.OfficeAddress;
applicant.LiveHouseType = values.LiveHouseType;
applicant.LiveHouseArea = values.LiveHouseArea;
applicant.LiveHouseAddress = values.LiveHouseAddress;
applicant.OwnHouseType = values.OwnHouseType;
applicant.OwnHouseAddress = values.OwnHouseAddress;
applicant.ContactAddress = values.ContactAddress;
applicant.ContactAddressType = values.ContactAddressType;
applicant.TotalMonthlyIncome = values.TotalMonthlyIncome;
applicant.HomeMonthlyIncome = values.HomeMonthlyIncome;
applicant.HomeMonthlyExpend = values.HomeMonthlyExpend;
applicant.OtherIncome = values.OtherIncome;
applicant.FamilyNumber = values.FamilyNumber;
applicant.EMail = values.EMail;
applicant.Fax = values.Fax;
applicant.Postcode = values.Postcode;
if (financeMapper.Update(applicant) > 0)
{
modify = true;
}
return(modify);
}
public bool UpdateApplicantBL(ApplicantInfo applicantInfo)
{
try
{
bool result = _applicantDL.UpdateApplicantDL(applicantInfo);
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public ApplicantInfo GetApplicantByIdBL(int id)
{
try
{
ApplicantInfo applicantInfo = _applicantDL.GetApplicantByIdDL(id);
return(applicantInfo);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 通过实体，增加一个申请人信息
/// </summary>
/// cais 16.03.31
/// <param name="applicant"></param>
/// <returns></returns>
public bool Add(ApplicantInfo applicant)
{
bool add = false;
financeMapper.Insert(applicant);
if (applicant.ApplicantId.Value > 0)
{
add = true;
}
return(add);
}
public ApplicantInfo GetRecentApplicantBL()
{
try
{
ApplicantInfo applicantInfo = _applicantDL.GetRecentApplicantDA();
return(applicantInfo);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ApplicantInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ApplicantInfo set ");
strSql.Append(" OrderApplyID = @OrderApplyID , ");
strSql.Append(" CName = @CName , ");
strSql.Append(" EName = @EName , ");
strSql.Append(" CardType = @CardType , ");
strSql.Append(" CardCode = @CardCode , ");
strSql.Append(" Sex = @Sex , ");
strSql.Append(" BirthDay = @BirthDay , ");
strSql.Append(" Mobile = @Mobile , ");
strSql.Append(" Email = @Email , ");
strSql.Append(" CardPeriod = @CardPeriod , ");
strSql.Append(" RecordUpdateUserID = @RecordUpdateUserID , ");
strSql.Append(" RecordUpdateTime = GetDate() ,");
strSql.Append(" Job = @Job");
strSql.Append(" where ApplicantInfoID=@ApplicantInfoID and RecordUpdateTime = @RecordUpdateTime");
SqlParameter[] parameters =
{
new SqlParameter("@ApplicantInfoID", model.ApplicantInfoID),
new SqlParameter("@OrderApplyID", model.OrderApplyID),
new SqlParameter("@CName", model.CName),
new SqlParameter("@EName", model.EName),
new SqlParameter("@CardType", model.CardType),
new SqlParameter("@CardCode", model.CardCode),
new SqlParameter("@Sex", model.Sex),
new SqlParameter("@BirthDay", model.BirthDay),
new SqlParameter("@Mobile", model.Mobile),
new SqlParameter("@Email", model.Email),
new SqlParameter("@CardPeriod", model.CardPeriod),
new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID),
new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime),
new SqlParameter("@Job", model.Job)
};
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Index(ApplicantInfo model)
{
using (var db = new ApplicationDbContext())
{
try
{
var invitation = db.Invitations.Where(x => x.InvitationCode == model.InvitationCode && x.RecruitStatusType.Code == (int)RecruitStatusCode.InvitationSent).Single();
return(View(model));
}
catch (Exception e)
{
return(View("InvitationCodeNotExistOrAlreadyUsed"));
}
}
}
public IActionResult GetApplicantById(int id)
{
try
{
ApplicantInfo applicantInfo = _applicantBusiness.GetApplicantByIdBL(id);
if (applicantInfo == null)
{
return(StatusCode(StatusCodes.Status404NotFound, "Applicant with Id " + id.ToString() + " not found"));
}
return(Ok(applicantInfo));
}
catch (Exception ex)
{
return(BadRequest(new { message = ex.Message }));
}
}
public ApiResult <ApplicantResp> GetApplicant(long activityId, long wizardId)
{
try
{
ApplicantInfo applicant = _applicantQueryService.Query(activityId, wizardId);
if (applicant == null)
{
return(new ApiResult <ApplicantResp>(ResultStatus.FAIL, "该报名者不存在"));
}
return(new ApiResult <ApplicantResp>(ResultStatus.SUCCESS, Mapper.Map <ApplicantInfo, ApplicantResp>(applicant)));
}
catch (Exception ex)
{
_logger.LogError("查询报名者异常", ex);
return(new ApiResult <ApplicantResp>(ResultStatus.EXCEPTION, ex.Message));
}
}
// GET: Contract
public ActionResult Index(string InvitationCode)
{
using (var db = new ApplicationDbContext())
{
try
{
var invitation = db.Invitations.Where(x => x.InvitationCode == InvitationCode && x.RecruitStatusType.Code == (int)RecruitStatusCode.InvitationSent).Single();
ApplicantInfo model = new ApplicantInfo();
model.Invitation = invitation;
model.Email = invitation.Email;
model.TemplateId = invitation.TemplateId;
model.InvitationCode = InvitationCode;
return(View(model));
}
catch (Exception e) {
return(View("InvitationCodeNotExistOrAlreadyUsed"));
}
}
}
public IActionResult UpdateApplicant([FromBody] ApplicantInfo applicantInfo)
{
try
{
bool res = _applicantBusiness.UpdateApplicantBL(applicantInfo);
if (res)
{
return(StatusCode(StatusCodes.Status201Created, "Applicant updated successfully"));
}
else
{
return(BadRequest(new { message = "couldnot updaye applicant" }));
}
}
catch (Exception ex)
{
return(BadRequest(new { message = ex.Message }));
}
}
public ActionResult ApplicantInfo()
{
try
{
if (Session["id"] == null)
{
return(View());
}
else
{
ApplicantInfo applicantInfo = _applicantBusiness.GetApplicantByIdBL((int)Session["id"]);
return(View(applicantInfo));
}
}
catch (Exception ex)
{
return(View(Constants.ErrorView));
}
}
public void OnActionExecuting(ActionExecutingContext filterContext)
{
if (filterContext.HttpContext.Session["id"] == null)
{
if (currentStage != (int)WorkflowStages.ApplicantInfo)
{
UrlHelper urlHelper = new UrlHelper(filterContext.RequestContext);
filterContext.Result = new RedirectResult(urlHelper.Action(Constants.ApplicantInfo, "Applicant"));
}
}
else
{
ApplicantInfo applicant = _applicantBusiness.GetApplicantByIdBL((int)filterContext.HttpContext.Session["id"]);
highestCompletedStage = applicant.HighestCompletedStage;
filterContext.HttpContext.Session["high"] = highestCompletedStage;
if (minRequiredStage == highestCompletedStage)
{
}
else if (minRequiredStage > highestCompletedStage)
{
UrlHelper urlHelper = new UrlHelper(filterContext.RequestContext);
switch (minRequiredStage)
{
case 10:
filterContext.Result = new RedirectResult(urlHelper.Action(Constants.ApplicantInfo, "Applicant"));
break;
case 20:
filterContext.Result = new RedirectResult(urlHelper.Action(Constants.AddressInfo, "Address"));
break;
case 30:
filterContext.Result = new RedirectResult(urlHelper.Action(Constants.EmploymentInfo, "Employment"));
break;
case 40:
filterContext.Result = new RedirectResult(urlHelper.Action(Constants.MembershipInfo, "Membership"));
break;
}
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ApplicantInfo model, SqlTransaction trans, SqlConnection conn)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ApplicantInfo(");
strSql.Append("OrderApplyID,CName,EName,CardType,CardCode,Sex,BirthDay,Mobile,Email,CardPeriod,CreatUserID,RecordUpdateUserID,RecordUpdateTime,RecordIsDelete,RecordCreateTime,Job");
strSql.Append(") values (");
strSql.Append("@OrderApplyID,@CName,@EName,@CardType,@CardCode,@Sex,@BirthDay,@Mobile,@Email,@CardPeriod,@CreatUserID,@RecordUpdateUserID,@RecordUpdateTime,@RecordIsDelete,@RecordCreateTime,@Job");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@OrderApplyID", model.OrderApplyID),
new SqlParameter("@CName", model.CName),
new SqlParameter("@EName", model.EName),
new SqlParameter("@CardType", model.CardType),
new SqlParameter("@CardCode", model.CardCode),
new SqlParameter("@Sex", model.Sex),
new SqlParameter("@BirthDay", model.BirthDay),
new SqlParameter("@Mobile", model.Mobile),
new SqlParameter("@Email", model.Email),
new SqlParameter("@CardPeriod", model.CardPeriod),
new SqlParameter("@CreatUserID", model.CreatUserID),
new SqlParameter("@RecordUpdateUserID", model.RecordUpdateUserID),
new SqlParameter("@RecordUpdateTime", model.RecordUpdateTime),
new SqlParameter("@RecordIsDelete", model.RecordIsDelete),
new SqlParameter("@RecordCreateTime", model.RecordCreateTime),
new SqlParameter("@Job", model.Job)
};
object obj = DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public bool Put(ApplicantInfo applicantInfo)
{
return(_finance.Modify(applicantInfo));
}
public bool POST([FromBody] ApplicantInfo applicantInfo)
{
return(_finance.Add(applicantInfo));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ApplicantInfo GetModel(int ApplicantInfoID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ApplicantInfoID, OrderApplyID, CName, EName, CardType, CardCode, Sex, BirthDay, Mobile, Email, CardPeriod, CreatUserID, RecordUpdateUserID, RecordUpdateTime, RecordIsDelete, RecordCreateTime ,Job ");
strSql.Append(" from ApplicantInfo ");
strSql.Append(" where ApplicantInfoID=@ApplicantInfoID");
SqlParameter[] parameters =
{
new SqlParameter("@ApplicantInfoID", SqlDbType.Int, 4)
};
parameters[0].Value = ApplicantInfoID;
ApplicantInfo model = new ApplicantInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ApplicantInfoID"].ToString() != "")
{
model.ApplicantInfoID = int.Parse(ds.Tables[0].Rows[0]["ApplicantInfoID"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderApplyID"].ToString() != "")
{
model.OrderApplyID = int.Parse(ds.Tables[0].Rows[0]["OrderApplyID"].ToString());
}
model.CName = ds.Tables[0].Rows[0]["CName"].ToString();
model.EName = ds.Tables[0].Rows[0]["EName"].ToString();
if (ds.Tables[0].Rows[0]["CardType"].ToString() != "")
{
model.CardType = int.Parse(ds.Tables[0].Rows[0]["CardType"].ToString());
}
model.CardCode = ds.Tables[0].Rows[0]["CardCode"].ToString();
if (ds.Tables[0].Rows[0]["Sex"].ToString() != "")
{
model.Sex = int.Parse(ds.Tables[0].Rows[0]["Sex"].ToString());
}
model.BirthDay = ds.Tables[0].Rows[0]["BirthDay"].ToString();
model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString();
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
model.CardPeriod = ds.Tables[0].Rows[0]["CardPeriod"].ToString();
if (ds.Tables[0].Rows[0]["CreatUserID"].ToString() != "")
{
model.CreatUserID = int.Parse(ds.Tables[0].Rows[0]["CreatUserID"].ToString());
}
if (ds.Tables[0].Rows[0]["RecordUpdateUserID"].ToString() != "")
{
model.RecordUpdateUserID = int.Parse(ds.Tables[0].Rows[0]["RecordUpdateUserID"].ToString());
}
if (ds.Tables[0].Rows[0]["RecordUpdateTime"].ToString() != "")
{
model.RecordUpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["RecordUpdateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["RecordIsDelete"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["RecordIsDelete"].ToString() == "1") || (ds.Tables[0].Rows[0]["RecordIsDelete"].ToString().ToLower() == "true"))
{
model.RecordIsDelete = true;
}
else
{
model.RecordIsDelete = false;
}
}
if (ds.Tables[0].Rows[0]["RecordCreateTime"].ToString() != "")
{
model.RecordCreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["RecordCreateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Job"].ToString() != "")
{
model.Job = ds.Tables[0].Rows[0]["Job"].ToString();
}
return(model);
}
else
{
return(null);
}
}
public string GetOverrideEmail(ref JobApplicationStatus status, ref ApplicantInfo applicantInfo, bool isSocialMedia = false)
{
string ovverideEmail = null;
if (SitefinityHelper.IsUserLoggedIn()) // User already logged in
{
var currUser = SitefinityHelper.GetUserById(ClaimsManager.GetCurrentIdentity().UserId);
if (currUser != null)
{
Log.Write("User is already logged In " + currUser.Email, ConfigurationPolicy.ErrorLog);
return(currUser.Email);
}
}
// User not looged in
if (!string.IsNullOrEmpty(applicantInfo.Email))
{
Telerik.Sitefinity.Security.Model.User existingUser = SitefinityHelper.GetUserByEmail(applicantInfo.Email);
if (existingUser != null)
{
#region Entered Email exists in Sitefinity User list
Log.Write("User is already exists in portal " + existingUser.Email, ConfigurationPolicy.ErrorLog);
ovverideEmail = existingUser.Email;
// check user exists in the JXT next DB
var memberResponse = _blConnector.GetMemberByEmail(applicantInfo.Email);
if (memberResponse.Member == null)
{
UserProfileManager userProfileManager = UserProfileManager.GetManager();
UserProfile profile = userProfileManager.GetUserProfile(existingUser.Id, typeof(SitefinityProfile).FullName);
var fName = Telerik.Sitefinity.Model.DataExtensions.GetValue(profile, "FirstName");
var lName = Telerik.Sitefinity.Model.DataExtensions.GetValue(profile, "LastName");
JXTNext_MemberRegister memberReg = new JXTNext_MemberRegister
{
Email = existingUser.Email,
FirstName = fName.ToString(),
LastName = lName.ToString(),
Password = existingUser.Password
};
if (_blConnector.MemberRegister(memberReg, out string errorMessage))
{
Log.Write("User created JXT next DB" + existingUser.Email, ConfigurationPolicy.ErrorLog);
}
}
return(ovverideEmail);
#endregion
}
else
{
#region Entered email does not exists in sitefinity User list
var membershipCreateStatus = SitefinityHelper.CreateUser(applicantInfo.Email, applicantInfo.Password, applicantInfo.FirstName, applicantInfo.LastName, applicantInfo.Email, applicantInfo.PhoneNumber,
null, null, true, true);
applicantInfo.IsNewUser = true;
if (membershipCreateStatus != MembershipCreateStatus.Success)
{
Log.Write("User is created in portal " + existingUser.Email, ConfigurationPolicy.ErrorLog);
status = JobApplicationStatus.NotAbleToCreateUser;
return(ovverideEmail);
}
else
{
//instantiate the Sitefinity user manager
//if you have multiple providers you have to pass the provider name as parameter in GetManager("ProviderName") in your case it will be the asp.net membership provider user
UserManager userManager = UserManager.GetManager();
if (userManager.ValidateUser(applicantInfo.Email, applicantInfo.Password))
{
//if you need to get the user instance use the out parameter
Telerik.Sitefinity.Security.Model.User userToAuthenticate = null;
SecurityManager.AuthenticateUser(userManager.Provider.Name, applicantInfo.Email, applicantInfo.Password, false, out userToAuthenticate);
if (userToAuthenticate == null)
{
status = JobApplicationStatus.NotAbleToLoginCreatedUser;
return(ovverideEmail);
}
else
{
ovverideEmail = userToAuthenticate.Email;
}
}
}
#endregion
}
}
return(ovverideEmail);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <ApplicantInfo> DataTableToList(DataTable dt)
{
List <ApplicantInfo> modelList = new List <ApplicantInfo>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
ApplicantInfo model;
for (int n = 0; n < rowsCount; n++)
{
model = new ApplicantInfo();
if (dt.Rows[n]["ApplicantInfoID"].ToString() != "")
{
model.ApplicantInfoID = int.Parse(dt.Rows[n]["ApplicantInfoID"].ToString());
}
if (dt.Rows[n]["OrderApplyID"].ToString() != "")
{
model.OrderApplyID = int.Parse(dt.Rows[n]["OrderApplyID"].ToString());
}
model.CName = dt.Rows[n]["CName"].ToString();
model.EName = dt.Rows[n]["EName"].ToString();
if (dt.Rows[n]["CardType"].ToString() != "")
{
model.CardType = int.Parse(dt.Rows[n]["CardType"].ToString());
}
model.CardCode = dt.Rows[n]["CardCode"].ToString();
if (dt.Rows[n]["Sex"].ToString() != "")
{
model.Sex = int.Parse(dt.Rows[n]["Sex"].ToString());
}
model.BirthDay = dt.Rows[n]["BirthDay"].ToString();
model.Mobile = dt.Rows[n]["Mobile"].ToString();
model.Email = dt.Rows[n]["Email"].ToString();
model.CardPeriod = dt.Rows[n]["CardPeriod"].ToString();
if (dt.Rows[n]["CreatUserID"].ToString() != "")
{
model.CreatUserID = int.Parse(dt.Rows[n]["CreatUserID"].ToString());
}
if (dt.Rows[n]["RecordUpdateUserID"].ToString() != "")
{
model.RecordUpdateUserID = int.Parse(dt.Rows[n]["RecordUpdateUserID"].ToString());
}
if (dt.Rows[n]["RecordUpdateTime"].ToString() != "")
{
model.RecordUpdateTime = DateTime.Parse(dt.Rows[n]["RecordUpdateTime"].ToString());
}
if (dt.Rows[n]["RecordIsDelete"].ToString() != "")
{
if ((dt.Rows[n]["RecordIsDelete"].ToString() == "1") || (dt.Rows[n]["RecordIsDelete"].ToString().ToLower() == "true"))
{
model.RecordIsDelete = true;
}
else
{
model.RecordIsDelete = false;
}
}
if (dt.Rows[n]["RecordCreateTime"].ToString() != "")
{
model.RecordCreateTime = DateTime.Parse(dt.Rows[n]["RecordCreateTime"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
