public ActionResult ManagementAcountEmployee()
{
if (Session["IdUser"] == null && Session["EmailUser"] == null)
{
return(RedirectToAction("LoginForm", "Login"));
}
var idAcount = int.Parse(Session["IdUser"].ToString());
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
var dataDist = (from data in db.Districts
join datatext in db.DistrictTexts on data.name_id equals datatext.id
where datatext.language_id == "vi"
select new GeoModel {
DistId = data.district_id, DistName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataDist.Insert(0, new GeoModel {
DistId = 0, DistName = "Chọn quận/huyện"
});
CaptCha cap = new CaptCha();
BDSNew BDSNew = new BDSNew();
var register = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.ToList(),
ListMarriea = db.BDSMarriages.ToList(),
ListSalary = db.BDSSalaries.ToList(),
ListDucation = db.BDSEducations.ToList(),
ListBDSCareer = db.BDSCareers.ToList(),
ListTimework = db.BDSTimeWorks.ToList(),
ListBDSLanguage = db.BDSLanguages.ToList(),
ListBDSNewsType = db.BDSNewsTypes.OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity.ToList(),
ListGeoDisModel = dataDist.ToList(),
tblCaptCha = cap,
tblBDSNew = BDSNew,
TblBDSEmployerInformation = db.BDSEmployerInformations.FirstOrDefault(x => x.IdAccount == idAcount),
TblBDSPersonalInformation = db.BDSPersonalInformations.FirstOrDefault(x => x.IdAccount == idAcount),
TblBdsAdcount = db.BDSAccounts.FirstOrDefault(x => x.ID == idAcount),
ListBDSEmper = db.BDSEmpers.ToList()
};
return(View(register));
}
public IActionResult RegisterInformationModel(RegisterInformationModel registerInformationModel)
{
User registerUser = JsonConvert.DeserializeObject <User>(TempData["RegisterUser"].ToString());
if (registerUser == null)
{
return(RedirectToAction(nameof(RegisterLoginModel)));
}
// Verifica se a data de aniversário é inválida
if (registerInformationModel.BirthData >= DateTime.Now)
{
ModelState.AddModelError("BirthData", "A data de nascimento é inválida");
}
if (ModelState.IsValid)
{
registerUser.BirthData = registerInformationModel.BirthData;
registerUser.Genre = registerInformationModel.Genre;
registerUser.PhoneNumber = registerInformationModel.PhoneNumber;
//Enviar e-mail pra confirmar email pra cadastro
SendEmail(registerUser.Email, "Confirmar o cadastro", "Você criou uma conta no sistema de login .NET CORE, clique no link para confirmar a criação da conta", "https://localhost:44332/Users/EndUserRegister?id=");
TempData["RegisterUser"] = JsonConvert.SerializeObject(registerUser);
TempData["EmailUser"] = registerUser.Email;
return(RedirectToAction(nameof(EmailConfirm)));
}
TempData["RegisterUser"] = JsonConvert.SerializeObject(registerUser);
return(View());
}
public ActionResult ForgerPass(string token)
{
var data = db.BDSAccounts.Where(x => x.Token == token).ToList();
if (data.Count > 0)
{
var UserId = data.FirstOrDefault().ID;
var Account_ = db.BDSAccounts.Find(UserId);
Account_.MailActive = 1;
db.Entry(Account_).State = EntityState.Modified;
db.SaveChanges();
var dataView = db.BDSAccounts.FirstOrDefault(x => x.Token == token);
var ShowData = new RegisterInformationModel
{
TblBdsAdcount = dataView, Status = true
};
return(View(ShowData));
}
else
{
var ShowData = new RegisterInformationModel
{
Status = false
};
return(View(ShowData));
}
}
public ActionResult DetailAdvertCompany(string idNew)
{
var id_ = int.Parse(idNew.Split('-').Last());
var cuurentINews = db.BDSPerNews.FirstOrDefault(T => T.ID == id_ && T.Active == 1);
var IdPersonalByIdNewPer = cuurentINews.PerId;
List <BDSPerNews_Degrees> ListPerNewDegrees = new List <BDSPerNews_Degrees>();
List <BDSPerNews_Experiences> ListPerNewExperiences = new List <BDSPerNews_Experiences>();
List <BDSPerNews_LangDegrees> ListPerNewLangDegrees = new List <BDSPerNews_LangDegrees>();
List <BDSPerNews_References> ListPerNewReferences = new List <BDSPerNews_References>();
List <BDSSalary> ListSalary = new List <BDSSalary>();
{
ListPerNewDegrees = db.BDSPerNews_Degrees.Where(T => T.ID_BDSPerNews == cuurentINews.ID && T.Active == 1).ToList();
ListPerNewExperiences = db.BDSPerNews_Experiences.Where(T => T.ID_BDSPerNews == cuurentINews.ID && T.Active == 1).ToList();
ListPerNewLangDegrees = db.BDSPerNews_LangDegrees.Where(T => T.ID_BDSPerNews == cuurentINews.ID && T.Active == 1).ToList();
ListPerNewReferences = db.BDSPerNews_References.Where(T => T.ID_BDSPerNews == cuurentINews.ID && T.Active == 1).ToList();
ListSalary = db.BDSSalaries.Where(T => T.Active == 1).ToList();
}
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
var registerModel = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.Where(T => T.Active == 1).ToList(),
ListMarriea = db.BDSMarriages.Where(T => T.Active == 1).ToList(),
ListSalary = db.BDSSalaries.Where(T => T.Active == 1).ToList(),
ListDucation = db.BDSEducations.Where(T => T.Active == 1).ToList(),
ListBDSCareer = db.BDSCareers.Where(T => T.Active == 1).ToList(),
ListTimework = db.BDSTimeWorks.Where(T => T.Active == 1).ToList(),
ListBDSLanguage = db.BDSLanguages.Where(T => T.Active == 1).ToList(),
ListBDSNewsType = db.BDSNewsTypes.Where(T => T.Active == 1).OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity,
ListBdsAdcount = db.BDSAccounts.Where(T => T.Active == 1).ToList(),
ListBDSEmper = db.BDSEmpers.Where(T => T.Active == 1).ToList(),
ListPerNewDegrees = ListPerNewDegrees,
ListPerNewExperiences = ListPerNewExperiences,
ListPerNewLangDegrees = ListPerNewLangDegrees,
ListPerNewReferences = ListPerNewReferences,
tblBDSPerNew = cuurentINews,
};
return(View(registerModel));
}
public ActionResult ManagerAcountPer()
{
if (Session["IdUser"] == null && Session["EmailUser"] == null)
{
return(RedirectToAction("LoginForm", "Login"));
}
var id = int.Parse(Session["IdUser"].ToString());
var tblAccount = db.BDSAccounts.FirstOrDefault(T => T.ID == id);
if (!db.BDSPersonalInformations.Select(x => x.IdAccount).ToList().Contains(id))
{
return(RedirectToAction("Warning", "AdvertCompany"));
}
var tblPer = db.BDSPersonalInformations.FirstOrDefault(T => T.IdAccount == tblAccount.ID);
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
var registerModel = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.Where(T => T.Active == 1).ToList(),
ListMarriea = db.BDSMarriages.Where(T => T.Active == 1).ToList(),
ListSalary = db.BDSSalaries.Where(T => T.Active == 1).ToList(),
ListDucation = db.BDSEducations.Where(T => T.Active == 1).ToList(),
ListBDSCareer = db.BDSCareers.Where(T => T.Active == 1).ToList(),
ListTimework = db.BDSTimeWorks.Where(T => T.Active == 1).ToList(),
ListBDSLanguage = db.BDSLanguages.Where(T => T.Active == 1).ToList(),
ListBDSNewsType = db.BDSNewsTypes.Where(T => T.Active == 1).OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity,
ListBdsAdcount = db.BDSAccounts.Where(T => T.Active == 1).ToList(),
ListBDSEmper = db.BDSEmpers.Where(T => T.Active == 1).ToList(),
TblBDSPersonalInformation = tblPer,
TblBdsAdcount = tblAccount
};
return(View(registerModel));
}
public ActionResult CheckCapcha(RegisterInformationModel create)
{
if (Session["Captcha"] == null || Session["Captcha"].ToString() != create.tblCaptCha.Captcha)
{
return(Json(new { error = 0 }));
}
else
{
return(Json(new { error = 1 }));
}
return(null);
}
//
// GET: /Register/
public ActionResult RegisterCompany()
{
CaptCha cap = new CaptCha();
BDSNew BDSNew = new BDSNew();
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
var dataDist = (from data in db.Districts
join datatext in db.DistrictTexts on data.name_id equals datatext.id
where datatext.language_id == "vi"
select new GeoModel {
DistId = data.district_id, DistName = datatext.text
}).ToList();
dataDist.Insert(0, new GeoModel {
DistId = 0, DistName = "Chọn quận/huyện"
});
var registerModel = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.Where(x => x.Active == 1).ToList(),
ListMarriea = db.BDSMarriages.Where(x => x.Active == 1).ToList(),
ListSalary = db.BDSSalaries.Where(x => x.Active == 1).ToList(),
ListDucation = db.BDSEducations.Where(x => x.Active == 1).ToList(),
ListBDSCareer = db.BDSCareers.Where(x => x.Active == 1).ToList(),
ListTimework = db.BDSTimeWorks.Where(x => x.Active == 1).ToList(),
ListBDSLanguage = db.BDSLanguages.Where(x => x.Active == 1).ToList(),
ListBDSNewsType = db.BDSNewsTypes.Where(x => x.Active == 1).OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity.ToList(),
ListGeoDisModel = dataDist.ToList(),
tblCaptCha = cap,
tblBDSNew = BDSNew,
ListBDSEmployerInformation = db.BDSEmployerInformations.ToList(),
ListBDSPersonalInformation = db.BDSPersonalInformations.ToList(),
ListBdsAdcount = db.BDSAccounts.ToList(),
ListBDSEmper = db.BDSEmpers.ToList()
};
return(View(registerModel));
}
public ActionResult ApplyArchive()
{
if (Session["IdUser"] == null && Session["EmailUser"] == null)
{
return(RedirectToAction("LoginForm", "Login"));
}
var idAcount = int.Parse(Session["IdUser"].ToString());
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
var IdYourSave = db.BDSApplies.Where(x => x.IdAccountEm == idAcount).Select(x => x.IdAccountPer).ToList();
var register = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.ToList(),
ListMarriea = db.BDSMarriages.ToList(),
ListSalary = db.BDSSalaries.ToList(),
ListDucation = db.BDSEducations.ToList(),
ListBDSCareer = db.BDSCareers.ToList(),
ListTimework = db.BDSTimeWorks.ToList(),
ListBDSLanguage = db.BDSLanguages.ToList(),
ListBDSNewsType = db.BDSNewsTypes.OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity.ToList(),
TblBDSEmployerInformation = db.BDSEmployerInformations.FirstOrDefault(x => x.IdAccount == idAcount),
ListBDSPersonalInformation = db.BDSPersonalInformations.Where(x => x.IdAccount == idAcount && x.Active == 1).ToList(),
TblBdsAdcount = db.BDSAccounts.FirstOrDefault(x => x.ID == idAcount),
ListBDSEmper = db.BDSEmpers.ToList(),
ListBDSApply = db.BDSApplies.Where(x => x.IdAccountEm == idAcount).ToList()
};
return(View(register));
}
public PartialViewResult References()
{
List <BDSPerNews_References> ListPerNewReferences = new List <BDSPerNews_References>();
ListPerNewReferences.Add(new BDSPerNews_References {
Active = 1
});
var registerModel = new RegisterInformationModel
{
ListSalary = db.BDSSalaries.Where(T => T.Active == 1).ToList(),
ListDucation = db.BDSEducations.Where(T => T.Active == 1).ToList(),
ListBDSCareer = db.BDSCareers.Where(T => T.Active == 1).ToList(),
ListTimework = db.BDSTimeWorks.Where(T => T.Active == 1).ToList(),
ListBDSLanguage = db.BDSLanguages.Where(T => T.Active == 1).ToList(),
ListPerNewReferences = ListPerNewReferences,
};
return(PartialView(registerModel));
}
public ActionResult SearchPersonal()
{
if (Session["IdUser"] == null && Session["EmailUser"] == null)
{
return(RedirectToAction("LoginForm", "Login"));
}
var idAcount = int.Parse(Session["IdUser"].ToString());
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
var dataDist = (from data in db.Districts
join datatext in db.DistrictTexts on data.name_id equals datatext.id
where datatext.language_id == "vi"
select new GeoModel {
DistId = data.district_id, DistName = datatext.text
}).ToList();
var register = new RegisterInformationModel
{
ListGeoModel = dataCity.ToList(),
ListGeoDisModel = dataDist.ToList(),
TblBDSEmployerInformation = db.BDSEmployerInformations.FirstOrDefault(x => x.IdAccount == idAcount),//!IdYourSave.Contains(x.ID)
TblBdsAdcount = db.BDSAccounts.FirstOrDefault(x => x.ID == idAcount),
ListBDSEmper = db.BDSEmpers.ToList()
};
return(View(register));
}
public ActionResult EditNews(string id)
{
var id_ = int.Parse(id.Split('-').Last());
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
CaptCha cap = new CaptCha();
BDSNew BDSNew = new BDSNew();
var registerModel = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.ToList(),
ListMarriea = db.BDSMarriages.ToList(),
ListSalary = db.BDSSalaries.ToList(),
ListDucation = db.BDSEducations.ToList(),
ListBDSCareer = db.BDSCareers.ToList(),
ListTimework = db.BDSTimeWorks.ToList(),
ListBDSLanguage = db.BDSLanguages.ToList(),
ListBDSNewsType = db.BDSNewsTypes.OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity.ToList(),
tblCaptCha = cap,
tblBDSNew = db.BDSNews.FirstOrDefault(x => x.ID == id_),
ListBDSEmployerInformation = db.BDSEmployerInformations.ToList(),
ListBdsAdcount = db.BDSAccounts.ToList(),
ListBDSEmper = db.BDSEmpers.ToList(),
ListBDSPicture = db.BDSPictures.Where(x => x.advert_id == id_).ToList()
};
return(View(registerModel));
}
public ActionResult RegisterPersonal(RegisterInformationModel bdsInformationModel)
{
bdsInformationModel.Status = false;
try
{
if (Session["Captcha"] == null || Session["Captcha"].ToString() != bdsInformationModel.tblCaptCha.Captcha)
{
CaptCha cap = new CaptCha();
BDSNew BDSNew = new BDSNew();
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
bdsInformationModel = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.ToList(),
ListMarriea = db.BDSMarriages.ToList(),
ListSalary = db.BDSSalaries.ToList(),
ListDucation = db.BDSEducations.ToList(),
ListBDSCareer = db.BDSCareers.ToList(),
ListTimework = db.BDSTimeWorks.ToList(),
ListBDSLanguage = db.BDSLanguages.ToList(),
ListBDSNewsType = db.BDSNewsTypes.OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity.ToList(),
tblCaptCha = cap,
tblBDSNew = BDSNew,
ListBDSEmployerInformation = db.BDSEmployerInformations.ToList(),
ListBDSPersonalInformation = db.BDSPersonalInformations.ToList(),
ListBdsAdcount = db.BDSAccounts.ToList(),
ListBDSEmper = db.BDSEmpers.ToList(),
Status = false,
Msg = "Mã an toàn không đúng. Vui lòng nhập lại !"
};
}
else
{
bdsInformationModel.TblBdsAdcount.CreateDate = DateTime.Now;
bdsInformationModel.TblBdsAdcount.CreateUser = 1;
bdsInformationModel.TblBdsAdcount.Active = 1;
bdsInformationModel.TblBdsAdcount.Money = 0;
bdsInformationModel.TblBdsAdcount.Point = 0;
bdsInformationModel.TblBdsAdcount.MailActive = 0;
bdsInformationModel.TblBdsAdcount.Token = Guid.NewGuid().ToString();
db.Entry(bdsInformationModel.TblBdsAdcount).State = EntityState.Added;
db.SaveChanges();
bdsInformationModel.TblBDSPersonalInformation.IdAccount = bdsInformationModel.TblBdsAdcount.ID;
bdsInformationModel.TblBDSPersonalInformation.Active = 1;
bdsInformationModel.TblBDSPersonalInformation.CreateDate = DateTime.Now;
bdsInformationModel.TblBDSPersonalInformation.ModifiedDate = DateTime.Now;
bdsInformationModel.TblBDSPersonalInformation.CreateUser = 1;
bdsInformationModel.TblBDSPersonalInformation.ModifiedUser = 1;
db.Entry(bdsInformationModel.TblBDSPersonalInformation).State = EntityState.Added;
db.SaveChanges();
bdsInformationModel.tblBDSPerNew.Status = 0;
bdsInformationModel.tblBDSPerNew.Active = 1;
bdsInformationModel.tblBDSPerNew.CreateDate = DateTime.Now;
bdsInformationModel.tblBDSPerNew.CreateUser = 1;
bdsInformationModel.tblBDSPerNew.CreateUser = 1;
bdsInformationModel.tblBDSPerNew.PerId = bdsInformationModel.TblBDSPersonalInformation.ID;
bdsInformationModel.tblBDSPerNew.ProvinceProfile =
bdsInformationModel.TblBDSPersonalInformation.Province;
db.Entry(bdsInformationModel.tblBDSPerNew).State = EntityState.Added;
db.SaveChanges();
bdsInformationModel.Status = true;
bdsInformationModel.Msg = "Tạo tài khoản thành công.Vui lòng kiểm tra email để kích hoạt tài khoản!";
SendTemplateEmail(bdsInformationModel.TblBdsAdcount.Email, bdsInformationModel.TblBdsAdcount.Email, bdsInformationModel.TblBdsAdcount.Token, "Email kích hoạt tài khoản", 1);
}
}
catch (Exception)
{
bdsInformationModel.Status = false;
bdsInformationModel.Msg = "Tạo tài khoản thất bại!";
}
return(Json(bdsInformationModel));
}
public ActionResult ManagementAcountPersonal(RegisterInformationModel register)
{
if (Session["IdUser"] == null && Session["EmailUser"] == null)
{
return(RedirectToAction("LoginForm", "Login"));
}
var idAcount = int.Parse(Session["IdUser"].ToString());
BDSAccount TblBdsAdcount = db.BDSAccounts.Find(idAcount);
TblBdsAdcount.Email = register.TblBdsAdcount.Email;
db.Entry(TblBdsAdcount).State = EntityState.Modified;
db.SaveChanges();
var idEmployee = db.BDSPersonalInformations.FirstOrDefault(x => x.IdAccount == idAcount);
if (idEmployee != null)
{
BDSPersonalInformation BDSPersonalInformation = db.BDSPersonalInformations.Find(idEmployee.ID);
BDSPersonalInformation.Name = register.TblBDSPersonalInformation.Name;
BDSPersonalInformation.TemporaryAddress = register.TblBDSPersonalInformation.TemporaryAddress;
BDSPersonalInformation.Province = register.TblBDSPersonalInformation.Province;
BDSPersonalInformation.PermanentAddress = register.TblBDSPersonalInformation.PermanentAddress;
BDSPersonalInformation.Phone = register.TblBDSPersonalInformation.Phone;
// BDSPersonalInformation.City = register.TblBDSPersonalInformation.City;
BDSPersonalInformation.Description = register.TblBDSPersonalInformation.Description;
BDSPersonalInformation.UrlImage = register.TblBDSPersonalInformation.UrlImage;
db.Entry(BDSPersonalInformation).State = EntityState.Modified;
db.SaveChanges();
}
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
CaptCha cap = new CaptCha();
BDSNew BDSNew = new BDSNew();
var register1 = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.ToList(),
ListMarriea = db.BDSMarriages.ToList(),
ListSalary = db.BDSSalaries.ToList(),
ListDucation = db.BDSEducations.ToList(),
ListBDSCareer = db.BDSCareers.ToList(),
ListTimework = db.BDSTimeWorks.ToList(),
ListBDSLanguage = db.BDSLanguages.ToList(),
ListBDSNewsType = db.BDSNewsTypes.OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity.ToList(),
tblCaptCha = cap,
tblBDSNew = BDSNew,
TblBDSPersonalInformation = db.BDSPersonalInformations.FirstOrDefault(x => x.IdAccount == idAcount),
TblBdsAdcount = db.BDSAccounts.FirstOrDefault(x => x.ID == idAcount),
ListBDSEmper = db.BDSEmpers.ToList()
};
return(View(register1));
}
public ActionResult AdvertCompany(RegisterInformationModel create, HttpPostedFileBase[] files)
{
create.Status = false;
if (Session["Captcha"] == null || Session["Captcha"].ToString() != create.tblCaptCha.Captcha)
{
ModelState.AddModelError("Captcha", "Wrong value of sum, please try again.");
create.Msg = "Capcha không chính xác!";
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
CaptCha cap = new CaptCha();
var registerModel = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.Where(T => T.Active == 1).ToList(),
ListMarriea = db.BDSMarriages.Where(T => T.Active == 1).ToList(),
ListSalary = db.BDSSalaries.Where(T => T.Active == 1).ToList(),
ListDucation = db.BDSEducations.Where(T => T.Active == 1).ToList(),
ListBDSCareer = db.BDSCareers.Where(T => T.Active == 1).ToList(),
ListTimework = db.BDSTimeWorks.Where(T => T.Active == 1).OrderBy(x => x.Type).ToList(),
ListBDSLanguage = db.BDSLanguages.Where(T => T.Active == 1).ToList(),
ListBDSNewsType = db.BDSNewsTypes.Where(T => T.Active == 1).OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity.ToList(),
tblCaptCha = cap,
Msg = "Capcha không chính xác!",
Status = false
};
return(Json(registerModel));
}
else
{
var checkMoney = false;
if (Session["IdUser"] != null)
{
int id = int.Parse(Session["IdUser"].ToString());
var model = db.BDSAccounts.FirstOrDefault(T => T.ID == id);
if (model != null)
{
if (model.Money >= create.tblBDSNew.TotalMoney)
{
checkMoney = true;
}
}
}
if (!checkMoney)
{
create.Msg = "Số tiền trong tài khoản không đủ!";
ModelState.AddModelError("TotalMoney", "Số tiền trong tài khoản không đủ!");
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
CaptCha cap = new CaptCha();
var registerModel = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.Where(T => T.Active == 1).ToList(),
ListMarriea = db.BDSMarriages.Where(T => T.Active == 1).ToList(),
ListSalary = db.BDSSalaries.Where(T => T.Active == 1).ToList(),
ListDucation = db.BDSEducations.Where(T => T.Active == 1).ToList(),
ListBDSCareer = db.BDSCareers.Where(T => T.Active == 1).ToList(),
ListTimework = db.BDSTimeWorks.Where(T => T.Active == 1).OrderBy(x => x.Type).ToList(),
ListBDSLanguage = db.BDSLanguages.Where(T => T.Active == 1).ToList(),
ListBDSNewsType = db.BDSNewsTypes.Where(T => T.Active == 1).OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity.ToList(),
tblCaptCha = cap,
};
return(Json(registerModel));
}
create.tblBDSNew.IdAcount = int.Parse(Session["IdUser"].ToString());
create.tblBDSNew.FromDeadline = DateTime.Now;
create.tblBDSNew.CreateDate = DateTime.Now;
create.tblBDSNew.Active = 1;
create.tblBDSNew.Status = 0;
create.tblBDSNew.CountReup = 0;
create.tblBDSNew.MaxReup = 0;
create.tblBDSNew.CreateUser = 1;
create.tblBDSNew.ShowEmail = 0;
create.tblBDSNew.Career = create.tblBDSNew.Career.Substring(create.tblBDSNew.Career.Length - 1) == "," ? create.tblBDSNew.Career.Substring(0, create.tblBDSNew.Career.Length - 1) : create.tblBDSNew.Career;
create.tblBDSNew.IdTypeNewsCuurent = create.tblBDSNew.IdTypeNews;
db.Entry(create.tblBDSNew).State = EntityState.Added;
db.SaveChanges();
if (files != null && files.Length > 0)
{
for (int i = 0; i < files.Length; i++)
{
if (files[i] != null)
{
byte[] binaryData;
binaryData = new Byte[files[i].InputStream.Length];
long bytesRead = files[i].InputStream.Read(binaryData, 0, (int)files[i].InputStream.Length);
files[i].InputStream.Close();
string base64String = System.Convert.ToBase64String(binaryData, 0, binaryData.Length);
SaveImg(new NewsPicture {
nameImg = files[i].FileName, idProducts = create.tblBDSNew.ID, isactive = 1, index = i, cfile = base64String
});
}
}
}
foreach (var item in create.tblBDSNew.Career.Split(','))
{
if (!String.IsNullOrEmpty(item))
{
BDSNews_Career i = new BDSNews_Career {
ID_News = create.tblBDSNew.ID, ID_Career = int.Parse(item)
};
db.Entry(i).State = EntityState.Added;
}
}
db.SaveChanges();
var type = db.BDSNewsTypes.First(T => T.ID == create.tblBDSNew.IdTypeNewsCuurent.Value);
String Fname = "Đăng tin '{A}' trong vòng '{B}' ngày tổng giá phải trả '{C}' VNĐ";
string name = Fname.Replace("{A}", type.Name).Replace("{B}", ((int)Math.Ceiling(create.tblBDSNew.ToCreateNews.Value.Subtract(create.tblBDSNew.FromCreateNews.Value).TotalDays)) + "").Replace("{C}", create.tblBDSNew.TotalMoney.Value.ToString("n2"));
BDSTransactionHistory tran = new BDSTransactionHistory()
{
Name = name,
Description = name,
KeySearch = name.NormalizeD(),
Active = 1,
CreateUser = 1,
CreateDate = DateTime.Now,
TypeTran = 2,
PointTran = 0,
MoneyTran = create.tblBDSNew.TotalMoney.Value,
DateTran = DateTime.Now,
Status = 0,
IdAccount = int.Parse(Session["IdUser"].ToString())
};
create.tblBDSNew = db.BDSNews.First(T => T.ID == create.tblBDSNew.ID);
db.BDSTransactionHistories.Add(tran);
db.SaveChanges();
create.tblBDSNew.RefTranHis = tran.ID;
db.Entry(create.tblBDSNew).State = EntityState.Modified;
db.SaveChanges();
var account = db.BDSAccounts.First(T => T.ID == create.tblBDSNew.IdAcount);
account.Money -= create.tblBDSNew.TotalMoney;
db.Entry(account).State = EntityState.Modified;
db.SaveChanges();
create.Msg = "Đăng tin thành công!";
create.Status = true;
return(Json(create));
}
return(null);
}
//
// GET: /AdvertCompany/
public ActionResult CreateAdvertCompany()
{
if (Session["IdUser"] == null && Session["EmailUser"] == null)
{
return(RedirectToAction("LoginForm", "Login"));
}
var id = int.Parse(Session["IdUser"].ToString());
var tblAccount = db.BDSAccounts.FirstOrDefault(T => T.ID == id);
if (!db.BDSPersonalInformations.Select(x => x.IdAccount).ToList().Contains(id))
{
return(RedirectToAction("Warning", "AdvertCompany"));
}
var tblPer = db.BDSPersonalInformations.FirstOrDefault(T => T.IdAccount == tblAccount.ID);
var cuurentINews = db.BDSPerNews.FirstOrDefault(T => T.PerId == tblPer.ID && T.Active == 1);
List <BDSPerNews_Degrees> ListPerNewDegrees = new List <BDSPerNews_Degrees>();
List <BDSPerNews_Experiences> ListPerNewExperiences = new List <BDSPerNews_Experiences>();
List <BDSPerNews_LangDegrees> ListPerNewLangDegrees = new List <BDSPerNews_LangDegrees>();
List <BDSPerNews_References> ListPerNewReferences = new List <BDSPerNews_References>();
if (cuurentINews == null)
{
cuurentINews = new BDSPerNew {
Active = 1, CreateDate = DateTime.Now, CreateUser = 1, PerId = tblPer.ID
};
db.Entry(cuurentINews).State = EntityState.Added;
db.SaveChanges();
ListPerNewDegrees.Add(new BDSPerNews_Degrees {
ID_BDSPerNews = cuurentINews.ID, Active = 1
});
ListPerNewExperiences.Add(new BDSPerNews_Experiences {
ID_BDSPerNews = cuurentINews.ID, Active = 1
});
ListPerNewLangDegrees.Add(new BDSPerNews_LangDegrees {
ID_BDSPerNews = cuurentINews.ID, Active = 1
});
ListPerNewReferences.Add(new BDSPerNews_References {
ID_BDSPerNews = cuurentINews.ID, Active = 1
});
}
else
{
ListPerNewDegrees = db.BDSPerNews_Degrees.Where(T => T.ID_BDSPerNews == cuurentINews.ID).ToList();
ListPerNewExperiences =
db.BDSPerNews_Experiences.Where(T => T.ID_BDSPerNews == cuurentINews.ID).ToList();
ListPerNewLangDegrees =
db.BDSPerNews_LangDegrees.Where(T => T.ID_BDSPerNews == cuurentINews.ID).ToList();
ListPerNewReferences = db.BDSPerNews_References.Where(T => T.ID_BDSPerNews == cuurentINews.ID).ToList();
if (ListPerNewDegrees.Count == 0)
{
ListPerNewDegrees.Add(new BDSPerNews_Degrees {
ID_BDSPerNews = cuurentINews.ID
});
}
if (ListPerNewExperiences.Count == 0)
{
ListPerNewExperiences.Add(new BDSPerNews_Experiences {
ID_BDSPerNews = cuurentINews.ID
});
}
if (ListPerNewLangDegrees.Count == 0)
{
ListPerNewLangDegrees.Add(new BDSPerNews_LangDegrees {
ID_BDSPerNews = cuurentINews.ID
});
}
if (ListPerNewReferences.Count == 0)
{
ListPerNewReferences.Add(new BDSPerNews_References {
ID_BDSPerNews = cuurentINews.ID
});
}
}
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
var registerModel = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.Where(T => T.Active == 1).ToList(),
ListMarriea = db.BDSMarriages.Where(T => T.Active == 1).ToList(),
ListSalary = db.BDSSalaries.Where(T => T.Active == 1).ToList(),
ListDucation = db.BDSEducations.Where(T => T.Active == 1).ToList(),
ListBDSCareer = db.BDSCareers.Where(T => T.Active == 1).ToList(),
ListTimework = db.BDSTimeWorks.Where(T => T.Active == 1).ToList(),
ListBDSLanguage = db.BDSLanguages.Where(T => T.Active == 1).ToList(),
ListBDSNewsType = db.BDSNewsTypes.Where(T => T.Active == 1).OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity,
ListBdsAdcount = db.BDSAccounts.Where(T => T.Active == 1).ToList(),
ListBDSEmper = db.BDSEmpers.Where(T => T.Active == 1).ToList(),
ListPerNewDegrees = ListPerNewDegrees,
ListPerNewExperiences = ListPerNewExperiences,
ListPerNewLangDegrees = ListPerNewLangDegrees,
ListPerNewReferences = ListPerNewReferences,
tblBDSPerNew = cuurentINews,
TblBDSPersonalInformation = tblPer,
TblBdsAdcount = tblAccount
};
return(View(registerModel));
}
//
// GET: /Adverts/
public ActionResult AdvertCompany()
{
if (Session["IdUser"] == null && Session["EmailUser"] == null)
{
return(RedirectToAction("LoginForm", "Login"));
}
int idAccount = (int)Session["IdUser"];
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
if (!db.BDSEmployerInformations.Select(x => x.IdAccount).ToList().Contains(idAccount))
{
return(RedirectToAction("Warning", "Adverts"));
}
var TblBDSEmployerInformation = db.BDSEmployerInformations.First(T => T.IdAccount == idAccount);
CaptCha cap = new CaptCha();
BDSNew BDSNew = new BDSNew {
CreateUser = 1,
Active = 1,
CreateDate = DateTime.Now,
DateReup = null,
IdLanguage = 1,
FromCreateNews = DateTime.Now,
ToCreateNews = DateTime.Now.AddDays(3),
FromDeadline = DateTime.Now,
ToDeadline = DateTime.Now.AddDays(30),
NameCompany = TblBDSEmployerInformation.Name,
AddressApply = TblBDSEmployerInformation.AddressContact,
NamesContact = TblBDSEmployerInformation.NameContact,
Email = TblBDSEmployerInformation.EmailContact,
WebSiteCompany = TblBDSEmployerInformation.WebSite
};
var registerModel = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.Where(T => T.Active == 1).ToList(),
ListMarriea = db.BDSMarriages.Where(T => T.Active == 1).ToList(),
ListSalary = db.BDSSalaries.Where(T => T.Active == 1).ToList(),
ListDucation = db.BDSEducations.Where(T => T.Active == 1).ToList(),
ListBDSCareer = db.BDSCareers.Where(T => T.Active == 1).ToList(),
ListTimework = db.BDSTimeWorks.Where(T => T.Active == 1).ToList(),
ListBDSLanguage = db.BDSLanguages.Where(T => T.Active == 1).ToList(),
ListBDSNewsType = db.BDSNewsTypes.Where(T => T.Active == 1).OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity.ToList(),
tblCaptCha = cap,
tblBDSNew = BDSNew,
TblBDSEmployerInformation = TblBDSEmployerInformation
};
return(View(registerModel));
}
public ActionResult EditNews(RegisterInformationModel create, HttpPostedFileBase[] files, int[] img_id)
{
if (Session["Captcha"] == null || Session["Captcha"].ToString() != create.tblCaptCha.Captcha)
{
ModelState.AddModelError("Captcha", "Wrong value of sum, please try again.");
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
CaptCha cap = new CaptCha();
BDSNew BDSNew = new BDSNew();
var registerModel = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.ToList(),
ListMarriea = db.BDSMarriages.ToList(),
ListSalary = db.BDSSalaries.ToList(),
ListDucation = db.BDSEducations.ToList(),
ListBDSCareer = db.BDSCareers.ToList(),
ListTimework = db.BDSTimeWorks.ToList(),
ListBDSLanguage = db.BDSLanguages.ToList(),
ListBDSNewsType = db.BDSNewsTypes.OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity.ToList(),
tblCaptCha = cap,
tblBDSNew = db.BDSNews.FirstOrDefault(x => x.ID == create.tblBDSNew.ID),
ListBDSEmployerInformation = db.BDSEmployerInformations.ToList(),
ListBdsAdcount = db.BDSAccounts.ToList(),
ListBDSEmper = db.BDSEmpers.ToList(),
ListBDSPicture = db.BDSPictures.Where(x => x.advert_id == create.tblBDSNew.ID).ToList()
};
return(View(registerModel));
}
else
{
BDSNew tblNews = db.BDSNews.Find(create.tblBDSNew.ID);
tblNews.Title = create.tblBDSNew.Title;
tblNews.AddressWork = create.tblBDSNew.AddressWork;
tblNews.FromSalary = create.tblBDSNew.FromSalary;
tblNews.ToSalary = create.tblBDSNew.ToSalary;
tblNews.Quantity = create.tblBDSNew.Quantity;
tblNews.Bonus = create.tblBDSNew.Bonus;
tblNews.Sex = create.tblBDSNew.Sex;
tblNews.IdTimeWork = create.tblBDSNew.IdTimeWork;
tblNews.IdEducation = create.tblBDSNew.IdEducation;
tblNews.Career = create.tblBDSNew.Career;
tblNews.DesCompany = create.tblBDSNew.DesCompany;
tblNews.DesWork = create.tblBDSNew.DesWork;
tblNews.Benefit = create.tblBDSNew.Benefit;
tblNews.FromAge = create.tblBDSNew.FromAge;
tblNews.ToAge = create.tblBDSNew.ToAge;
tblNews.TimeProbationary = create.tblBDSNew.TimeProbationary;
tblNews.NameCompany = create.tblBDSNew.NameCompany;
tblNews.AddressApply = create.tblBDSNew.AddressApply;
tblNews.NamesContact = create.tblBDSNew.NamesContact;
tblNews.PhoneContact = create.tblBDSNew.PhoneContact;
tblNews.Email = create.tblBDSNew.Email;
tblNews.FromDeadline = create.tblBDSNew.FromDeadline;
tblNews.ToDeadline = create.tblBDSNew.ToDeadline;
tblNews.IdLanguage = create.tblBDSNew.IdLanguage;
tblNews.WebSiteCompany = create.tblBDSNew.WebSiteCompany;
tblNews.UrlImage = create.tblBDSNew.UrlImage;
tblNews.Career = tblNews.Career.Substring(tblNews.Career.Length - 1) == "," ? tblNews.Career.Substring(0, tblNews.Career.Length - 1) : tblNews.Career;
db.Entry(tblNews).State = EntityState.Modified;
db.SaveChanges();
if (img_id != null && img_id.Length > 0)
{
var listPic = db.BDSPictures.Where(T => T.advert_id == tblNews.ID && !img_id.Contains(T.ID)).ToList();
foreach (var pic in listPic)
{
db.Entry(pic).State = EntityState.Deleted;
}
}
if (files != null && files.Length > 0)
{
for (int i = 0; i < files.Length; i++)
{
if (files[i] != null)
{
byte[] binaryData;
binaryData = new Byte[files[i].InputStream.Length];
long bytesRead = files[i].InputStream.Read(binaryData, 0, (int)files[i].InputStream.Length);
files[i].InputStream.Close();
string base64String = System.Convert.ToBase64String(binaryData, 0, binaryData.Length);
SaveImg(new NewsPicture {
nameImg = files[i].FileName, idProducts = create.tblBDSNew.ID, isactive = 1, index = i, cfile = base64String
});
}
}
}
db.SaveChanges();
var listMap = db.BDSNews_Career.Where(T => T.ID_News == tblNews.ID).ToList();
foreach (var item in listMap)
{
db.Entry(item).State = EntityState.Deleted;
}
db.SaveChanges();
foreach (var item in create.tblBDSNew.Career.Split(','))
{
if (!String.IsNullOrEmpty(item))
{
BDSNews_Career i = new BDSNews_Career {
ID_News = create.tblBDSNew.ID, ID_Career = int.Parse(item)
};
db.Entry(i).State = EntityState.Added;
}
}
db.SaveChanges();
return(RedirectToAction("ListNewOfUser", "Management"));
}
return(null);
}
public ActionResult RegisterCompany(RegisterInformationModel bdsInformationModel)
{
bdsInformationModel.Status = false;
try
{
bdsInformationModel.Status = false;
if (Session["Captcha"] == null || Session["Captcha"].ToString() != bdsInformationModel.tblCaptCha.Captcha)
{
CaptCha cap = new CaptCha();
BDSNew BDSNew = new BDSNew();
var dataCity = (from data in db.States
join datatext in db.StateTexts on data.name_id equals datatext.id
where datatext.language_id == "vi" && data.state_id != 59 && data.state_id != 28
select new GeoModel {
CityId = data.state_id, CityName = datatext.text
}).ToList();
dataCity.Insert(0, new GeoModel {
CityId = 0, CityName = "Chọn thành/phố"
});
dataCity.Insert(1, new GeoModel {
CityId = 59, CityName = "TP.Hồ Chí Minh"
});
dataCity.Insert(2, new GeoModel {
CityId = 28, CityName = "TP.Hà Nội"
});
var dataDist = (from data in db.Districts
join datatext in db.DistrictTexts on data.name_id equals datatext.id
where datatext.language_id == "vi"
select new GeoModel {
DistId = data.district_id, DistName = datatext.text
}).ToList();
dataDist.Insert(0, new GeoModel {
DistId = 0, DistName = "Chọn quận/huyện"
});
bdsInformationModel = new RegisterInformationModel
{
ListBDSScopes = db.BDSScopes.ToList(),
ListMarriea = db.BDSMarriages.ToList(),
ListSalary = db.BDSSalaries.ToList(),
ListDucation = db.BDSEducations.ToList(),
ListBDSCareer = db.BDSCareers.ToList(),
ListTimework = db.BDSTimeWorks.ToList(),
ListBDSLanguage = db.BDSLanguages.ToList(),
ListBDSNewsType = db.BDSNewsTypes.OrderBy(x => x.Order).ToList(),
ListGeoModel = dataCity.ToList(),
ListGeoDisModel = dataCity.ToList(),
tblCaptCha = cap,
tblBDSNew = BDSNew,
ListBDSEmployerInformation = db.BDSEmployerInformations.ToList(),
ListBDSPersonalInformation = db.BDSPersonalInformations.ToList(),
ListBdsAdcount = db.BDSAccounts.ToList(),
ListBDSEmper = db.BDSEmpers.ToList(),
Status = false,
Msg = "Mã an toàn không đúng. Vui lòng nhập lại !"
};
}
else
{
bdsInformationModel.TblBdsAdcount.CreateDate = DateTime.Now;
bdsInformationModel.TblBdsAdcount.CreateUser = 1;
bdsInformationModel.TblBdsAdcount.Active = 1;
bdsInformationModel.TblBdsAdcount.Money = 0;
bdsInformationModel.TblBdsAdcount.Point = 0;
bdsInformationModel.TblBdsAdcount.MailActive = 0;
bdsInformationModel.TblBdsAdcount.Token = Guid.NewGuid().ToString();
db.Entry(bdsInformationModel.TblBdsAdcount).State = EntityState.Added;
db.SaveChanges();
BDSEmployerInformation tblemployee = new BDSEmployerInformation();
bdsInformationModel.TblBDSEmployerInformation.IdAccount = bdsInformationModel.TblBdsAdcount.ID;
bdsInformationModel.TblBDSEmployerInformation.Active = 1;
bdsInformationModel.TblBDSEmployerInformation.CreateDate = DateTime.Now;
bdsInformationModel.TblBDSEmployerInformation.CreateUser = 1;
bdsInformationModel.TblBDSEmployerInformation.ModifiedDate = DateTime.Now;
bdsInformationModel.TblBDSEmployerInformation.ModifiedUser = 1;
bdsInformationModel.TblBDSEmployerInformation.Featured = 0;
bdsInformationModel.TblBDSEmployerInformation.PhoneContact = bdsInformationModel.TblBDSEmployerInformation.Phone;
bdsInformationModel.TblBDSEmployerInformation.DistrictContact = bdsInformationModel.TblBDSEmployerInformation.District;
bdsInformationModel.TblBDSEmployerInformation.City = bdsInformationModel.TblBDSEmployerInformation.City;
bdsInformationModel.TblBDSEmployerInformation.AddressContact = bdsInformationModel.TblBDSEmployerInformation.Address;
bdsInformationModel.TblBDSEmployerInformation.EmailContact = bdsInformationModel.TblBdsAdcount.Email;
bdsInformationModel.TblBDSEmployerInformation.TypeContact = 1;
bdsInformationModel.TblBDSEmployerInformation.IdAccount = bdsInformationModel.TblBdsAdcount.ID;
db.Entry(bdsInformationModel.TblBDSEmployerInformation).State = EntityState.Added;
db.SaveChanges();
bdsInformationModel.Status = true;
bdsInformationModel.Msg = "Tạo tài khoản thành công.Vui lòng kiểm tra email để kích hoạt tài khoản!";
SendTemplateEmail(bdsInformationModel.TblBdsAdcount.Email, bdsInformationModel.TblBdsAdcount.Email, bdsInformationModel.TblBdsAdcount.Token, "Email kích hoạt tài khoản", 1);
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in State \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
bdsInformationModel.Status = false;
bdsInformationModel.Msg = "Tạo tài khoản thất bại!";
}
return(Json(bdsInformationModel));
}
public ActionResult CreateAdvertCompany(RegisterInformationModel model, int?type)
{
model.Msg = "Cập nhật dữ liệu thành công!";
model.Status = true;
try
{
switch (type)
{
case 1:
String path = SaveFile(Request.Files["TblBDSPersonalInformation.File"]);
if (path != "")
{
model.TblBDSPersonalInformation.UrlImage = path;
}
var tblPer = db.BDSPersonalInformations.FirstOrDefault(T => T.ID == model.TblBDSPersonalInformation.ID);
tblPer.Sex = model.TblBDSPersonalInformation.Sex;
tblPer.Name = model.TblBDSPersonalInformation.Name;
tblPer.Phone = model.TblBDSPersonalInformation.Phone;
tblPer.Birthday = model.TblBDSPersonalInformation.Birthday;
tblPer.Province = model.TblBDSPersonalInformation.Province;
tblPer.TemporaryAddress = model.TblBDSPersonalInformation.TemporaryAddress;
tblPer.PermanentAddress = model.TblBDSPersonalInformation.PermanentAddress;
tblPer.UrlImageCheck = model.TblBDSPersonalInformation.UrlImageCheck;
tblPer.UrlImage = model.TblBDSPersonalInformation.UrlImage;
db.Entry(tblPer).State = EntityState.Modified;
db.SaveChanges();
model.TblBDSPersonalInformation = tblPer;
break;
case 2:
var cuurentINews = db.BDSPerNews.FirstOrDefault(T => T.ID == model.tblBDSPerNew.ID);
cuurentINews.TitleProfile = model.tblBDSPerNew.TitleProfile;
cuurentINews.CareerGoalProfile = model.tblBDSPerNew.CareerGoalProfile;
cuurentINews.CareerProfile = model.tblBDSPerNew.CareerProfile;
cuurentINews.EducationProfile = model.tblBDSPerNew.EducationProfile;
cuurentINews.ExperienceProfile = model.tblBDSPerNew.ExperienceProfile;
cuurentINews.LanguageProfile = model.tblBDSPerNew.LanguageProfile;
cuurentINews.LevelProfile = model.tblBDSPerNew.LevelProfile;
cuurentINews.ProvinceProfile = model.tblBDSPerNew.ProvinceProfile;
cuurentINews.ModifiedDate = DateTime.Now;
cuurentINews.ModifiedUser = 1;
db.Entry(cuurentINews).State = EntityState.Modified;
db.SaveChanges();
model.tblBDSPerNew = cuurentINews;
break;
case 3:
cuurentINews = db.BDSPerNews.FirstOrDefault(T => T.ID == model.tblBDSPerNew.ID);
cuurentINews.Skills = model.tblBDSPerNew.Skills;
cuurentINews.Hobby = model.tblBDSPerNew.Hobby;
cuurentINews.MSExcelOffice = model.tblBDSPerNew.MSExcelOffice;
cuurentINews.MSWordOffice = model.tblBDSPerNew.MSWordOffice;
cuurentINews.MSPowerPointOffice = model.tblBDSPerNew.MSPowerPointOffice;
cuurentINews.OutlookOffice = model.tblBDSPerNew.OutlookOffice;
cuurentINews.OrderOffice = model.tblBDSPerNew.OrderOffice;
cuurentINews.ModifiedDate = DateTime.Now;
cuurentINews.ModifiedUser = 1;
db.Entry(cuurentINews).State = EntityState.Modified;
db.SaveChanges();
model.tblBDSPerNew = cuurentINews;
for (int i = 0; i < model.ListPerNewDegrees.Count; i++)
{
var itemD = model.ListPerNewDegrees[i];
path = SaveFile(Request.Files["ListPerNewDegrees[" + i + "].File"]);
if (path != "")
{
itemD.ImageUrl = path;
}
var ccItem = db.BDSPerNews_Degrees.FirstOrDefault(T => T.ID == itemD.ID);
if (ccItem == null)
{
if (itemD.Active != 0)
{
ccItem = new BDSPerNews_Degrees {
Active = itemD.Active, CreateDate = DateTime.Now, CreateUser = 1, Name = itemD.Name, ID_BDSPerNews = cuurentINews.ID, Career = itemD.Career, FromYear = itemD.FromYear, ToYear = itemD.ToYear, ImageUrl = itemD.ImageUrl, Level = itemD.Level, Rating = itemD.Level
};
db.Entry(ccItem).State = EntityState.Added;
db.SaveChanges();
model.ListPerNewDegrees[i].ID = ccItem.ID;
}
}
else
{
ccItem.Level = itemD.Level;
ccItem.Name = itemD.Name;
ccItem.Career = itemD.Career;
ccItem.FromYear = itemD.FromYear;
ccItem.ToYear = itemD.ToYear;
ccItem.Rating = itemD.Rating;
ccItem.ImageUrl = itemD.ImageUrl;
ccItem.ModifiedDate = DateTime.Now;
ccItem.ModifiedUser = 1;
ccItem.Active = itemD.Active;
db.Entry(ccItem).State = EntityState.Modified;
db.SaveChanges();
}
}
for (int i = 0; i < model.ListPerNewLangDegrees.Count; i++)
{
var itemD = model.ListPerNewLangDegrees[i];
var ccItem = db.BDSPerNews_LangDegrees.FirstOrDefault(T => T.ID == itemD.ID);
if (ccItem == null)
{
if (itemD.Active != 0)
{
ccItem = new BDSPerNews_LangDegrees {
Active = itemD.Active, CreateUser = 1, CreateDate = DateTime.Now, ID_BDSPerNews = cuurentINews.ID, Language = itemD.Language, Name = itemD.Name, Listening = itemD.Listening, Reading = itemD.Reading, Speaking = itemD.Speaking, Writing = itemD.Writing, Decription = itemD.Decription
};
db.Entry(ccItem).State = EntityState.Added;
db.SaveChanges();
model.ListPerNewLangDegrees[i].ID = ccItem.ID;
}
}
else
{
ccItem.Language = itemD.Language;
ccItem.Name = itemD.Name;
ccItem.Listening = itemD.Listening;
ccItem.Speaking = itemD.Speaking;
ccItem.Reading = itemD.Reading;
ccItem.Writing = itemD.Writing;
ccItem.Decription = itemD.Decription;
ccItem.ModifiedDate = DateTime.Now;
ccItem.ModifiedUser = 1;
ccItem.Active = itemD.Active;
db.Entry(ccItem).State = EntityState.Modified;
db.SaveChanges();
}
}
break;
case 4:
for (int i = 0; i < model.ListPerNewExperiences.Count; i++)
{
var itemD = model.ListPerNewExperiences[i];
var ccItem = db.BDSPerNews_Experiences.FirstOrDefault(T => T.ID == itemD.ID);
if (ccItem == null)
{
if (itemD.Active != 0)
{
ccItem = new BDSPerNews_Experiences
{
Active = itemD.Active,
CreateUser = 1,
CreateDate = DateTime.Now,
ID_BDSPerNews = model.tblBDSPerNew.ID,
Name = itemD.Name,
Level = itemD.Level,
Decription = itemD.Decription,
Perfix = itemD.Perfix,
Salary = itemD.Salary,
FromDate = itemD.FromDate,
ToDate = itemD.ToDate,
};
db.Entry(ccItem).State = EntityState.Added;
db.SaveChanges();
model.ListPerNewExperiences[i].ID = ccItem.ID;
}
}
else
{
ccItem.Name = itemD.Name;
ccItem.Level = itemD.Level;
ccItem.Decription = itemD.Decription;
ccItem.Perfix = itemD.Perfix;
ccItem.Salary = itemD.Salary;
ccItem.FromDate = itemD.FromDate;
ccItem.ToDate = itemD.ToDate;
ccItem.ModifiedDate = DateTime.Now;
ccItem.ModifiedUser = 1;
ccItem.Active = itemD.Active;
db.Entry(ccItem).State = EntityState.Modified;
db.SaveChanges();
}
}
break;
case 5:
for (int i = 0; i < model.ListPerNewReferences.Count; i++)
{
var itemD = model.ListPerNewReferences[i];
var ccItem = db.BDSPerNews_References.FirstOrDefault(T => T.ID == itemD.ID);
if (ccItem == null)
{
if (itemD.Active != 0)
{
ccItem = new BDSPerNews_References
{
Active = itemD.Active,
CreateUser = 1,
CreateDate = DateTime.Now,
ID_BDSPerNews = model.tblBDSPerNew.ID,
Name = itemD.Name,
NameCompany = itemD.NameCompany,
Decription = itemD.Decription,
Phone = itemD.Phone,
};
db.Entry(ccItem).State = EntityState.Added;
db.SaveChanges();
model.ListPerNewReferences[i].ID = ccItem.ID;
}
}
else
{
ccItem.Name = itemD.Name;
ccItem.NameCompany = itemD.NameCompany;
ccItem.Decription = itemD.Decription;
ccItem.Phone = itemD.Phone;
ccItem.ModifiedDate = DateTime.Now;
ccItem.ModifiedUser = 1;
ccItem.Active = itemD.Active;
db.Entry(ccItem).State = EntityState.Modified;
db.SaveChanges();
}
}
break;
case 6:
cuurentINews = db.BDSPerNews.FirstOrDefault(T => T.ID == model.tblBDSPerNew.ID);
path = SaveFile(Request.Files["tblBDSPerNew.File"]);
if (path != "")
{
model.tblBDSPerNew.FileUrl = path;
}
cuurentINews.FileUrl = model.tblBDSPerNew.FileUrl;
cuurentINews.ModifiedDate = DateTime.Now;
cuurentINews.ModifiedUser = 1;
db.Entry(cuurentINews).State = EntityState.Modified;
db.SaveChanges();
break;
case 7:
cuurentINews = db.BDSPerNews.FirstOrDefault(T => T.ID == model.tblBDSPerNew.ID);
cuurentINews.Status = 1;
cuurentINews.SearchCheck = model.tblBDSPerNew.SearchCheck;
cuurentINews.ModifiedDate = DateTime.Now;
cuurentINews.ModifiedUser = 1;
db.Entry(cuurentINews).State = EntityState.Modified;
db.SaveChanges();
break;
}
}
catch (Exception)
{
model.Msg = "Cập nhật dữ liệu thất bại!";
model.Status = false;
}
return(Json(model));
}
