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