public bool GetAll(token getDate)
{
List <TambahPelamarInitializer> dataPelamar = new List <TambahPelamarInitializer>();
TambahPelamarInitializer updateToken = new TambahPelamarInitializer();
try
{
long waktuToken = getDate.dateToken.Ticks;
long waktuSekarang = DateTime.Now.Ticks;
Random randomNumber = new Random();
long getRandomNumber = randomNumber.Next(1, 99999);
Random randomString = new Random();
char ch;
StringBuilder builder = new StringBuilder();
string outRandomString = "";
for (int i = 0; i < 5; i++)
{
ch = Convert.ToChar(Convert.ToInt16(Math.Floor(26 * randomString.NextDouble() + 65)));
builder.Append(ch);
}
outRandomString = builder.ToString();
using (DataContext context = new DataContext())
{
dataPelamar = context.tambahPelamar.ToList();
}
foreach (var item in dataPelamar)
{
if (item.id == getDate.id)
{
updateToken.id = item.id;
updateToken.created_by = item.created_by;
updateToken.created_on = item.created_on;
updateToken.is_deleted = item.is_deleted;
updateToken.fullname = item.fullname;
updateToken.nick_name = item.nick_name;
updateToken.pob = item.pob;
updateToken.dob = item.dob;
updateToken.gender = item.gender;
updateToken.religion_id = item.religion_id;
updateToken.high = item.high;
updateToken.weight = item.weight;
updateToken.nationality = item.nationality;
updateToken.ethnic = item.ethnic;
updateToken.hobby = item.hobby;
updateToken.identity_type_id = item.identity_type_id;
updateToken.identity_no = item.identity_no;
updateToken.email = item.email;
updateToken.phone_number1 = item.phone_number1;
updateToken.phone_number2 = item.phone_number2;
updateToken.parent_phone_number = item.parent_phone_number;
updateToken.child_sequence = item.child_sequence;
updateToken.how_many_brothers = item.how_many_brothers;
updateToken.marital_status_id = item.marital_status_id;
updateToken.company_id = item.company_id;
updateToken.marriage_year = item.marriage_year;
updateToken.token = getRandomNumber + outRandomString;
updateToken.expired_token = getDate.dateToken;
using (DataContext context = new DataContext())
{
context.Entry(updateToken).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
}
string email = dataPelamar.Find(f => f.id == getDate.id).email;
MailMessage message = new MailMessage();
SmtpClient smtp = new SmtpClient();
message.From = new MailAddress("*****@*****.**");
message.To.Add(new MailAddress(email));
message.Subject = "Token Anda";
message.IsBodyHtml = true; //to make message body as html
message.Body = "Token Anda adalah " + getRandomNumber + outRandomString;
smtp.Port = 587;
smtp.Host = "smtp.mail.yahoo.com"; //for gmail host
smtp.EnableSsl = true;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new NetworkCredential("*****@*****.**", "oranglaptop_mizan");
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.Send(message);
//string tokenDate = dataPelamar.Find(f => f.token == ).token;
return(true);
}
catch (Exception)
{
return(false);
}
}
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);
}
}
