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); } }