public static Boolean Editrencana(RencanaJadwalViewModel editrj)
{
try
{
Rencana_Jadwal dep;
using (DataContext db = new DataContext())
{
dep = db.Rencana_Jadwal.Where(d => d.id == editrj.id).First();
dep.modified_by = editrj.modified_by;
dep.modified_on = DateTime.Now;
dep.schedule_date = editrj.schedule_date;
dep.time = editrj.time;
dep.ro = editrj.ro;
dep.tro = editrj.tro;
dep.schedule_type_id = editrj.schedule_type_id;
dep.location = editrj.location;
dep.notes = editrj.notes;
dep.is_automatic_mail = editrj.is_automatic_mail;
dep.sent_date = editrj.sent_date;
db.Entry(dep).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
//Rencana_Jadwal_Detail rens;
List <Rencana_Jadwal_Detail> hpsrencana2 = new List <Rencana_Jadwal_Detail>();
hpsrencana2 = db.Rencana_Jadwal_Detail.Where(d => d.rencana_jadwal_id == editrj.id && d.is_delete == false).ToList();
foreach (var ren in hpsrencana2)
{
//rens = db.Rencana_Jadwal_Detail.Where(d => d.rencana_jadwal_id == ren.rencana_jadwal_id).First();
ren.modified_by = editrj.modified_by;
ren.modified_on = DateTime.Now;
ren.deleted_by = editrj.deleted_by;
ren.deleted_on = DateTime.Now;
ren.is_delete = true;
db.Entry(ren).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
Rencana_Jadwal_Detail rencanadetail = new Rencana_Jadwal_Detail();
var a = editrj.biodata_id;
string[] bio = a.Split(',');
foreach (var item in bio)
{
rencanadetail.created_by = editrj.created_by;
rencanadetail.created_on = DateTime.Now;
rencanadetail.rencana_jadwal_id = editrj.id;
rencanadetail.biodata_id = Convert.ToInt16(item);
db.Rencana_Jadwal_Detail.Add(rencanadetail);
db.SaveChanges();
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public static Boolean CreateRJ(RencanaJadwalViewModel RJmdl)
{
try
{
Rencana_Jadwal rencana = new Rencana_Jadwal();
using (DataContext db = new DataContext())
{
var d = true;
if (RJmdl.is_automatic_mail == null)
{
d = false;
}
rencana.created_by = RJmdl.created_by;
rencana.created_on = DateTime.Now;
rencana.schedule_code = ("JDW000000000" + RJmdl.id_auto);
rencana.schedule_date = RJmdl.schedule_date;
rencana.time = RJmdl.time;
rencana.ro = RJmdl.ro;
rencana.tro = RJmdl.tro;
rencana.schedule_type_id = RJmdl.schedule_type_id;
rencana.location = RJmdl.location;
rencana.other_ro_tro = RJmdl.other_ro_tro;
rencana.notes = RJmdl.notes;
rencana.is_automatic_mail = d;
rencana.sent_date = RJmdl.sent_date;
rencana.status = RJmdl.status;
db.Rencana_Jadwal.Add(rencana);
db.SaveChanges();
Rencana_Jadwal_Detail rencanadetail = new Rencana_Jadwal_Detail();
var a = RJmdl.biodata_id;
string[] bio = a.Split(',');
int[] bio22 = Array.ConvertAll(bio, Element => int.Parse(Element));
foreach (var item in bio)
{
rencanadetail.created_by = RJmdl.created_by;
rencanadetail.created_on = DateTime.Now;
rencanadetail.rencana_jadwal_id = RJmdl.id_auto;
rencanadetail.biodata_id = Convert.ToInt16(item);
db.Rencana_Jadwal_Detail.Add(rencanadetail);
db.SaveChanges();
}
if (RJmdl.is_automatic_mail == null)
{
using (DataContext dbbio = new DataContext())
{
foreach (var ambl in bio22)
{
List <Biodata> biodata = new List <Biodata>();
biodata = dbbio.Biodata.Where(dbio => dbio.id == ambl && dbio.is_delete == false).ToList();
foreach (var kirime in biodata)
{
var z = kirime.email;
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
mail.From = new MailAddress("*****@*****.**");
mail.To.Add(z);
mail.Subject = "Undangan PT. Xsis Mitra Utama";
mail.IsBodyHtml = true;
string date = RJmdl.schedule_date.ToString();
string htmlStr =
"<tr>" +
"Helo " + kirime.fullname + " , " +
"</tr>" +
"<tr>" +
"Terima kasih atas antusias anda untuk bergabung dengan kami." +
"</tr>" +
"<tr>" +
"HRD PT. Xsis Mitra Utama mengundang anda untuk hadir pada :" +
"</tr>" +
"<tr>" +
"Tanggal : " + date.Substring(0, 10) + "" +
"</tr>" +
"<tr>" +
"Jam : " + RJmdl.time + "" +
"</tr>" +
"<tr>" +
"Dimohon Hadir tepat waktu dengan mengenakan pakaian rapih dan bersepatu" +
"</tr>";
mail.Body = htmlStr;
SmtpServer.Port = 587;
SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Irfan2@@");
SmtpServer.EnableSsl = true;
SmtpServer.Send(mail);
}
}
}
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
