protected void ButtonSendEmail_Click(object sender, EventArgs e)
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
var PenerimaPesan = db.TBPenggunas.FirstOrDefault(item => item.IDPengguna == DropDownListPegawai.SelectedItem.Value.ToInt());
TBPengirimanEmail PengirimanEmail = new TBPengirimanEmail
{
//IDPengirimanEmail
TanggalKirim = DateTime.Now,
Tujuan = PenerimaPesan.Email,
Judul = "Jadwal Kerja " + PenerimaPesan.NamaLengkap,
//Isi
};
PengirimanEmail.Isi = "<table><tr><th>Hari</th><th>Jam Masuk</th><th>Jam Keluar</th><tr>";
foreach (RepeaterItem item in RepeaterScheduleTetap.Items)
{
TextBox TextBoxJamMasuk = (TextBox)item.FindControl("TextBoxJamMasuk");
TextBox TextBoxJamKeluar = (TextBox)item.FindControl("TextBoxJamKeluar");
TextBox TextBoxKeterangan = (TextBox)item.FindControl("TextBoxKeterangan");
Label LabelHiddenTanggal = (Label)item.FindControl("LabelHiddenTanggal");
Label LabelNamaHari = (Label)item.FindControl("LabelNamaHari");
PengirimanEmail.Isi += "<tr><td>" + LabelNamaHari.Text + "</td>" + "<td>" + TextBoxJamMasuk.Text + "</td>" + "<td>" + TextBoxJamKeluar.Text + "</td></tr>";
}
PengirimanEmail.Isi += "</table>";
db.TBPengirimanEmails.InsertOnSubmit(PengirimanEmail);
db.SubmitChanges();
}
}
public TBPengirimanEmail Kirim(DateTime TanggalKirim, string Tujuan, string Judul, string Isi)
{
var PengirimanEmail = new TBPengirimanEmail
{
//IDPengirimanEmail
TanggalKirim = TanggalKirim,
Tujuan = Tujuan,
Judul = Judul,
Isi = Isi
};
db.TBPengirimanEmails.InsertOnSubmit(PengirimanEmail);
return(PengirimanEmail);
}
