public static Rencana_Jadwal GetByID(int ID)
{
Rencana_Jadwal rencana = new Rencana_Jadwal();
using (DataContext db = new DataContext())
{
rencana = db.Rencana_Jadwal.Where(d => d.id == ID).First();
return(rencana);
}
}
public ActionResult Delete(int ID, Rencana_Jadwal RJmdl)
{
RJmdl.deleted_by = Convert.ToInt64(Session["foo"]);
if (RencanaJadwalRepo.Deleterencana(ID, RJmdl)) //non static if ( KeahlianRepo.Deletekeahlian(ID))
{
return(Json(new { Hapus = "Berhasil" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Hapus = "Gagal" }, JsonRequestBehavior.AllowGet));
}
}
public static Boolean Deleterencana(int ID, Rencana_Jadwal RJmdl)
{
try
{
Rencana_Jadwal dep;
using (DataContext db = new DataContext())
{
dep = db.Rencana_Jadwal.Where(d => d.id == ID).First();
dep.is_delete = true;
dep.deleted_by = RJmdl.deleted_by;
dep.deleted_on = DateTime.Now;
db.Entry(dep).State = System.Data.Entity.EntityState.Modified;
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);
}
}
