public ActionResult inputDataPelamar(TambahPelamarSplitter inputingDataPelamar)
{
PelamarRepositories inputDataPelamarNow = new PelamarRepositories();
foreach (var item in inputingDataPelamar.biodataPelamar)
{
if (item.phone_number1 == inputDataPelamarNow.GetAll().Find(f => f.phone_number1 == item.phone_number1).phone_number1&& item.email == inputDataPelamarNow.GetAll().Find(f => f.email == item.email).email&& item.identity_type_id == inputDataPelamarNow.GetAll().Find(f => f.identity_type_id == item.identity_type_id).identity_type_id&& item.identity_no == inputDataPelamarNow.GetAll().Find(f => f.identity_no == item.identity_no).identity_no)
{
return(Json(new { status = "tidak_boleh_sama_semua" }, JsonRequestBehavior.AllowGet));
}
else if (item.phone_number1 == inputDataPelamarNow.GetAll().Find(f => f.phone_number1 == item.phone_number1).phone_number1)
{
return(Json(new { status = "nomor_telepon_sama" }, JsonRequestBehavior.AllowGet));
}
else if (item.email == inputDataPelamarNow.GetAll().Find(f => f.email == item.email).email)
{
return(Json(new { status = "email_sama" }, JsonRequestBehavior.AllowGet));
}
else if (item.identity_type_id == inputDataPelamarNow.GetAll().Find(f => f.identity_type_id == item.identity_type_id).identity_type_id&& item.identity_no == inputDataPelamarNow.GetAll().Find(f => f.identity_no == item.identity_no).identity_no)
{
return(Json(new { status = "identitas_sama" }, JsonRequestBehavior.AllowGet));
}
else
{
if (inputDataPelamarNow.InputDataToDatabase(inputingDataPelamar))
{
return(Json(new { status = "berhasil" }, JsonRequestBehavior.AllowGet));
}
}
}
return(Json(new { status = "gagal" }, JsonRequestBehavior.AllowGet));
}
public bool InputDataToDatabase(TambahPelamarSplitter inputDataPelamar)
{
try
{
List <TambahPelamarInitializer> resultgetID = new List <TambahPelamarInitializer>();
TambahPelamarInitializer biodataPelamar = new TambahPelamarInitializer();
TambahAlamatPelamarInitializer alamatPelamar = new TambahAlamatPelamarInitializer();
long getTheId = 0;
foreach (var item in inputDataPelamar.biodataPelamar)
{
biodataPelamar.created_by = 1;
biodataPelamar.created_on = DateTime.Now;
biodataPelamar.is_deleted = false;
biodataPelamar.company_id = 1;
biodataPelamar.fullname = item.fullname;
biodataPelamar.nick_name = item.nick_name;
biodataPelamar.pob = item.pob;
biodataPelamar.dob = item.dob;
biodataPelamar.gender = item.gender;
biodataPelamar.religion_id = item.religion_id;
biodataPelamar.identity_type_id = item.identity_type_id;
biodataPelamar.identity_no = item.identity_no;
biodataPelamar.email = item.email;
biodataPelamar.phone_number1 = item.phone_number1;
biodataPelamar.parent_phone_number = item.parent_phone_number;
biodataPelamar.marital_status_id = item.marital_status_id;
biodataPelamar.high = item.high;
biodataPelamar.weight = item.weight;
biodataPelamar.nationality = item.nationality;
biodataPelamar.ethnic = item.ethnic;
biodataPelamar.hobby = item.hobby;
biodataPelamar.phone_number2 = item.phone_number2;
biodataPelamar.child_sequence = item.child_sequence;
biodataPelamar.how_many_brothers = item.how_many_brothers;
biodataPelamar.addrbook_id = item.addrbook_id;
biodataPelamar.marriage_year = item.marriage_year;
biodataPelamar.token = item.token;
biodataPelamar.expired_token = item.expired_token;
}
using (DataContext context = new DataContext())
{
var getDataForValidation = context.tambahPelamar
.Where(filt =>
filt.email.Contains(biodataPelamar.email) ||
filt.phone_number1.Contains(biodataPelamar.phone_number1) ||
filt.identity_no.Contains(biodataPelamar.identity_no)
)
.ToList();
if (getDataForValidation == null || getDataForValidation.Count() == 0)
{
context.tambahPelamar.Add(biodataPelamar);
context.SaveChanges();
}
else
{
return(false);
}
}
using (DataContext context = new DataContext())
{
resultgetID = (from outdata in context.tambahPelamar
where outdata.fullname == biodataPelamar.fullname && outdata.nick_name == biodataPelamar.nick_name
select outdata).ToList();
}
foreach (var item in resultgetID)
{
getTheId = item.id;
}
foreach (var item in inputDataPelamar.alamatPelamar)
{
using (DataContext context = new DataContext())
{
alamatPelamar.created_by = 1;
alamatPelamar.created_on = DateTime.Now;
alamatPelamar.is_deleted = false;
alamatPelamar.biodata_id = getTheId;
alamatPelamar.address1 = item.address1;
alamatPelamar.address2 = item.address2;
alamatPelamar.rt1 = item.rt1;
alamatPelamar.rt2 = item.rt2;
alamatPelamar.rw1 = item.rw1;
alamatPelamar.rw2 = item.rw2;
alamatPelamar.kecamatan1 = item.kecamatan1;
alamatPelamar.kecamatan2 = item.kecamatan2;
alamatPelamar.kelurahan1 = item.kelurahan1;
alamatPelamar.kelurahan2 = item.kelurahan2;
alamatPelamar.region1 = item.region1;
alamatPelamar.region2 = item.region2;
context.tambahAlamatPelamar.Add(alamatPelamar);
context.SaveChanges();
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}