protected void UpdateDataIntoDatabase(string _kodeRegistrasi)
{
string _jenisKelamin = rbtLaki.Checked ? rbtLaki.Attributes["Value"] : rbtPerempuan.Attributes["Value"];
VendorGatheringData.UpdatePerusahaan(ddlPerusahaan.SelectedValue, txtAlamat.Text, ddlKota.SelectedValue, ddlKota.SelectedItem.Text, txtKodePos.Text, txtEmailPerusahaan.Text, txtTelp.Text, txtFax.Text, _kodeRegistrasi);
VendorGatheringData.UpdatePeserta(_kodeRegistrasi, ddlPerusahaan.SelectedValue, txtNamaPeserta.Text,
_jenisKelamin, txtNamaJabatan.Text, txtEmail.Text, txtMobile.Text, string.Empty, txtNamaPeserta2.Text,
txtNamaJabatan2.Text, txtEmail2.Text, txtMobile2.Text, txtNotes.Text, _kodeRegistrasi);
}
protected String GenerateData()
{
StringBuilder _tableelement = new StringBuilder();
DataTable table = VendorGatheringData.GetPresensiPeserta(string.Empty);
bool isAny = true;
var rows = table.Select("Atten = 'True'");
if (rows.Any())
{
table = rows.CopyToDataTable();
}
else
{
isAny = false;
}
if (Session["groupFilter"] != null)
{
if (Session["groupFilter"].ToString() != "9")
{
rows = table.Select("StatsSKT = " + Session["groupFilter"].ToString());
if (rows.Any())
{
table = rows.CopyToDataTable();
}
else
{
isAny = false;
}
}
}
if (isAny)
{
for (int i = 0; i < table.Rows.Count; i++)
{
_tableelement.Append("<tr class=''>");
_tableelement.Append("<td>" + GetStatus(table.Rows[i]["StatsSKT"].ToString()) + "</td>");
_tableelement.Append("<td>" + table.Rows[i]["KodeRegistrasi"].ToString() + "</td>");
_tableelement.Append("<td>" + table.Rows[i]["NamaPeserta"].ToString() + "</td>");
_tableelement.Append("<td>" + table.Rows[i]["NamaJabatan"].ToString() + "</td>");
_tableelement.Append("<td>" + table.Rows[i]["EmailPeserta"].ToString() + "</td>");
_tableelement.Append("<td>" + table.Rows[i]["Phone"].ToString() + "</td>");
_tableelement.Append("<td>" + table.Rows[i]["NamaPerusahaan"].ToString() + "</td>");
_tableelement.Append("<td>" + table.Rows[i]["Email"].ToString() + "</td>");
_tableelement.Append("<td>" + table.Rows[i]["NamaKota"].ToString() + "</td>");
_tableelement.Append("<td width='15%' align='center'>" + GetAction(table.Rows[i]["KodeRegistrasi"].ToString(), table.Rows[i]["StatsSKT"].ToString()) + "</td>");
_tableelement.Append("</tr>");
}
}
return(_tableelement.ToString());
}
protected void SetPerusahaan()
{
ddlPerusahaan.Items.Clear();
DataTable data = VendorGatheringData.GetPerusahaan(string.Empty);
for (int i = 0; i < data.Rows.Count; i++)
{
ddlPerusahaan.Items.Add(new ListItem(data.Rows[i]["NamaPerusahaan"].ToString(), data.Rows[i]["KodePerusahaan"].ToString()));
}
}
protected string GenerateCode()
{
string regCode = Code.CreateVerificationCode(6);
while (Convert.ToInt16(VendorGatheringData.IsRegistrationCodeExist(regCode).Rows[0]["COUNT"]) > 0)
{
regCode = Code.CreateAlternateVerificationCode(6, 128);
}
Session["regCode"] = regCode;
return(regCode);
}
protected void SetDataToForm(string kodeRegistrasi)
{
DataTable peserta = VendorGatheringData.GetPeserta(kodeRegistrasi);
DataTable perusahaan = VendorGatheringData.GetPerusahaan(peserta.Rows[0]["KodePerusahaan"].ToString());
string jenisKelamin = peserta.Rows[0]["JenisKelamin"].ToString() == "1" ? "Laki-laki" : "Perempuan";
if (peserta.Rows.Count > 0)
{
ddlPerusahaan.SelectedValue = perusahaan.Rows[0]["KodePerusahaan"].ToString();
txtEmailPerusahaan.Text = perusahaan.Rows[0]["Email"].ToString();
txtAlamat.Text = perusahaan.Rows[0]["Alamat"].ToString();
ddlKota.SelectedValue = perusahaan.Rows[0]["KodeKota"].ToString();
txtTelp.Text = perusahaan.Rows[0]["Telpon"].ToString();
txtFax.Text = perusahaan.Rows[0]["Fax"].ToString();
txtKodePos.Text = perusahaan.Rows[0]["KodePos"].ToString();
txtStatusSKT.Text = perusahaan.Rows[0]["TypeSKT"].ToString() == "1" ? "Wajib" : "Tidak Wajib";
txtNamaPeserta.Text = peserta.Rows[0]["NamaPeserta"].ToString();
txtNamaJabatan.Text = peserta.Rows[0]["NamaJabatan"].ToString();
txtEmail.Text = peserta.Rows[0]["Email"].ToString();
txtMobile.Text = peserta.Rows[0]["Phone"].ToString();
txtNamaPeserta2.Text = peserta.Rows[0]["NamaPeserta2"].ToString();
txtNamaJabatan2.Text = peserta.Rows[0]["NamaJabatan2"].ToString();
txtEmail2.Text = peserta.Rows[0]["Email2"].ToString();
txtMobile2.Text = peserta.Rows[0]["Phone2"].ToString();
txtNotes.Text = peserta.Rows[0]["Catatan"].ToString();
if (peserta.Rows[0]["JenisKelamin"].ToString() == "1")
{
rbtLaki.Checked = true;
}
else
{
rbtPerempuan.Checked = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//SessionCreator();
if (Session["username"] == null && Session["password"] == null)
{
Response.Redirect("SignIn.aspx");
}
if (Session["username"].ToString() != "admin")
{
Response.Redirect("SignIn.aspx");
}
if (!IsPostBack)
{
SetFilterValue();
if (Request.QueryString["conf"] != null)
{
if (Request.QueryString["conf"] == "1")
{
CatalogFRVN.GenerateDataPresensiWgCs();
Session["info"] = "C1";
Response.Redirect("Peserta.aspx");
}
else if (Request.QueryString["conf"] == "2")
{
CatalogFRVN.ResetDoorprizePeserta();
VendorGatheringData.GenerateDataPresensi();
Session["info"] = "C2";
Response.Redirect("Peserta.aspx");
}
}
if (Request.QueryString["act"] != null)
{
if (Request.QueryString["act"] == "1")
{
string recordID = Cryptography.Blowfish.DecryptCBC(Request.QueryString["recid"]);
CatalogFRVN.DelimitPesertaFRVNByRecid(recordID, "admin");
Session["info"] = "A1";
Response.Redirect("Peserta.aspx");
}
else if (Request.QueryString["act"] == "3")
{
string kodeRegistrasi = Cryptography.Blowfish.DecryptCBC(Request.QueryString["regcd"]);
DataTable peserta = VendorGatheringData.GetPeserta(kodeRegistrasi);
DataTable perusahaan = VendorGatheringData.GetPerusahaan(peserta.Rows[0]["KodePerusahaan"].ToString());
string jenisKelamin = peserta.Rows[0]["JenisKelamin"].ToString() == "1" ? "Laki-laki" : "Perempuan";
//Deleting old ticket
FileManager.DeleteFile(Server.MapPath("../Gallery/Ticket/" + kodeRegistrasi + ".PNG"));
CreateImageFileWithBarcode(CreateTicketDesignWithBarcode(kodeRegistrasi, peserta.Rows[0]["NamaPeserta"].ToString(), perusahaan.Rows[0]["NamaPerusahaan"].ToString(), string.Empty, string.Empty), kodeRegistrasi, kodeRegistrasi);
//sending new ticket same code
try
{
string _namaPeserta2 = peserta.Rows[0]["NamaPeserta2"].ToString();
string _email2 = peserta.Rows[0]["Email2"].ToString();
string _namaJabatan2 = peserta.Rows[0]["NamaJabatan2"].ToString();
string _phone2 = peserta.Rows[0]["Phone2"].ToString();
FRLNBus.Notification.Email.SendRegistrationNotification(peserta.Rows[0]["Email"].ToString(), kodeRegistrasi, peserta.Rows[0]["NamaPeserta"].ToString(),
jenisKelamin, peserta.Rows[0]["NamaJabatan"].ToString(), peserta.Rows[0]["Email"].ToString(), peserta.Rows[0]["Phone"].ToString(),
peserta.Rows[0]["Catatan"].ToString(), perusahaan.Rows[0]["NamaPerusahaan"].ToString(), perusahaan.Rows[0]["Email"].ToString(),
perusahaan.Rows[0]["Alamat"].ToString(), perusahaan.Rows[0]["NamaKota"].ToString(), perusahaan.Rows[0]["KodePos"].ToString(),
perusahaan.Rows[0]["Telpon"].ToString(), perusahaan.Rows[0]["Fax"].ToString(), _namaPeserta2, _email2, _namaJabatan2,
_phone2, Server.MapPath("../Gallery/Ticket/" + kodeRegistrasi + ".PNG"));
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal({title: 'Terjadi kegagalan pengiriman email!', type: 'warning'});", true);
}
Session["info"] = "A6";
Response.Redirect("Peserta.aspx");
}
}
}
if (Session["info"] != null)
{
if (Session["info"].ToString() == "C2")
{
ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal({title: 'Update peserta ke sistem presensi berhasil!', type: 'success'});", true);
}
else if (Session["info"].ToString() == "A1")
{
ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal({title: 'Peserta berhasil dihapus dari sistem', type: 'warning'});", true);
}
else if (Session["info"].ToString() == "A3")
{
ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal({title: 'Update data peserta berhasil!', type: 'success'});", true);
}
else if (Session["info"].ToString() == "A6")
{
ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal({title: 'Pengiriman email notifikasi berhasil!', type: 'success'});", true);
}
else
{
}
Session["info"] = null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//SessionCreator();
if (Session["username"] == null && Session["password"] == null)
{
Response.Redirect("SignIn.aspx");
}
if (Session["username"].ToString() != "admin")
{
Response.Redirect("SignIn.aspx");
}
if (!IsPostBack)
{
SetFilterValue();
if (Request.QueryString["conf"] != null)
{
if (Request.QueryString["conf"] == "1")
{
CatalogFRVN.GenerateDataPresensiWgCs();
Session["info"] = "C1";
Response.Redirect("Certificate.aspx");
}
else if (Request.QueryString["conf"] == "2")
{
CatalogFRVN.ResetDoorprizePeserta();
VendorGatheringData.GenerateDataPresensi();
Session["info"] = "C2";
Response.Redirect("Certificate.aspx");
}
}
if (Request.QueryString["act"] != null)
{
if (Request.QueryString["act"] == "1")
{
string recordID = Cryptography.Blowfish.DecryptCBC(Request.QueryString["recid"]);
CatalogFRVN.DelimitPesertaFRVNByRecid(recordID, "admin");
Session["info"] = "A1";
Response.Redirect("Certificate.aspx");
}
else if (Request.QueryString["act"] == "3")
{
string regCode = Cryptography.Blowfish.DecryptCBC(Request.QueryString["regcd"]);
DataTable data = VendorGatheringData.GetPresensiPeserta(regCode);
string _namaPerusahaan = data.Rows[0]["NamaPerusahaan"].ToString();
string _alamat = data.Rows[0]["Alamat"].ToString();
string _email = data.Rows[0]["Email"].ToString();
try
{
//Delete last certificate
FileManager.DeleteFile(Server.MapPath("../Gallery/Certificate/" + regCode + ".PNG"));
//Create new certificate
CreateCertificate(CreateName(_namaPerusahaan, _alamat), regCode);
if (!VendorGatheringData.IsDownloadedSKT(Filtering.FilterValidSqlQuery(regCode)))
{
VendorGatheringData.InsertDownloadedSKT(regCode, "admin");
}
FRLNBus.Notification.Email.SendEmailAsAttachedCertificate(_email, _namaPerusahaan, Server.MapPath("../Gallery/Certificate/" + regCode + ".PNG"));
Session["info"] = "A6";
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal({title: 'Terjadi kegagalan pengiriman email!', type: 'warning'});", true);
}
Response.Redirect("Certificate.aspx");
}
}
}
if (Session["info"] != null)
{
if (Session["info"].ToString() == "C2")
{
ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal({title: 'Update peserta ke sistem presensi berhasil!', type: 'success'});", true);
}
else if (Session["info"].ToString() == "A1")
{
ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal({title: 'Peserta berhasil dihapus dari sistem', type: 'warning'});", true);
}
else if (Session["info"].ToString() == "A3")
{
ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal({title: 'Update data peserta berhasil!', type: 'success'});", true);
}
else if (Session["info"].ToString() == "A6")
{
ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal({title: 'Pengiriman email notifikasi unduh sertifikat berhasil!', type: 'success'});", true);
}
else if (Session["info"].ToString() == "A7")
{
ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal({title: 'Terjadi kegagalan pengiriman email!', type: 'warning'});", true);
}
Session["info"] = null;
}
}
