private void txtAgama_ChoiceSelected(object sender, SelectedItemChangedEventArgs e)
{
var picker = (MaterialTextField)sender;
Agama agama = (Agama)picker.SelectedChoice;
newPatient2.vc_k_agm = agama.vc_kode;
}
private void button1_Click(object sender, EventArgs e)
{
for (int row = 0; row < dataGridView1.Rows.Count; row++)
{
for (int col = 0; col < dataGridView1.Columns.Count; col++)
{
if (dataGridView1.Rows[row].Cells[col].Value != null &&
dataGridView1.Rows[row].Cells[col].Value.Equals(textBox1.Text))
{
MessageBox.Show("Maaf ! Duplicate Data");
return;
}
}
}
if (textBox1.Text == "")
{
MessageBox.Show("------MOHON MENGISIKAN DATA-------");
}
else
{
Agama itemAgama = new Agama();
itemAgama.Keterangan = textBox1.Text;
DaftarAgama.Add(itemAgama);
dataGridView1.Rows.Add(textBox1.Text);
}
}
public int inserAgama(Agama agg)
{
SqlCommand query = new SqlCommand();
query.CommandType = CommandType.Text;
query.CommandText = "INSERT INTO agama VALUES('" + agg.Keterangan + "')";
return(db.ExeNonQuery(query));
}
private void button1_Click(object sender, EventArgs e)
{
Agama itemAgama = new Agama();
itemAgama.Keterangan = textBox1.Text;
DaftarAgama.Add(itemAgama);
dataGridView1.Rows.Add(textBox1.Text);
}
public int delAgama(Agama agg)
{
SqlCommand del = new SqlCommand();
del.CommandType = CommandType.Text;
del.CommandText = "DELETE FROM agama WHERE id = '" + agg.Id + "'";
return(db.ExeNonQuery(del));
}
public DataTable viewAgama(Agama agg)
{
SqlCommand view = new SqlCommand();
view.CommandType = CommandType.Text;
view.CommandText = "SELECT * FROM agama";
return(db.ExeReader(view));
}
public int updateAgama(Agama agg)
{
SqlCommand query = new SqlCommand();
query.CommandType = CommandType.Text;
query.CommandText = "UPDATE agama SET keterangan='" + agg.Keterangan + "' where id='" + agg.Id + "'";
return(db.ExeNonQuery(query));
}
public int viewById(Agama agg)
{
SqlCommand s = new SqlCommand();
s.CommandType = CommandType.Text;
s.CommandText = "SELECT keterangan FROM agama order by id ASC";
return(db.ExeNonQuery(s));
}
private Agama MappingRowToObject(NpgsqlDataReader dtr)
{
Agama ag = new Agama();
ag.Id_Agama = dtr["id_agama"] is DBNull ? 0 : (int)dtr["id_agama"];
//ag.Id_Agama = dtr["id_agama"] is DBNull ? string.Empty : dtr["id_agama"].ToString();
ag.Nama_Agama = dtr["nama_agama"] is DBNull ? string.Empty : dtr["nama_agama"].ToString();
return(ag);
}
public int Update(Agama ag)
{
strSql = "UPDATE agama SET nama_agama = @1 WHERE id_agama = @2";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", ag.Nama_Agama);
cmd.Parameters.AddWithValue("@2", ag.Id_Agama);
return(cmd.ExecuteNonQuery());
}
}
public bool cekRecordIdAg(int idAg)
{
Agama ag = GetByIdAgama(idAg);
if (ag != null) //Jika record sudah ada, maka kembalikan nilai true
{
return(true);
}
else
{
return(false);
}
}
public bool cekRecordNmAg(string nmAg)
{
Agama ag = GetByNamaAgama(nmAg);
if (ag != null)
{
return(true);
}
else
{
return(false);
}
}
public int SaveAutoID(Agama ag)
{
strSql = "INSERT INTO agama (id_agama, nama_agama) VALUES (DEFAULT, @2)";
//strSql = "INSERT INTO agama (nama_agama) VALUES (@2)";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
//cmd.Parameters.AddWithValue("@1", Ag.Id_Agama);
//cmd.Parameters.AddWithValue("@1", DEFAULT);
cmd.Parameters.AddWithValue("@2", ag.Nama_Agama);
return(cmd.ExecuteNonQuery());
}
}
public Agama GetByIdAgama(int idAg)
{
Agama ag = null;
strSql = "SELECT * FROM agama WHERE id_agama = @1";
using (NpgsqlCommand cmd = new NpgsqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", idAg);
using (NpgsqlDataReader dtr = cmd.ExecuteReader())
{
if (dtr.Read())
{
ag = MappingRowToObject(dtr);
}
}
}
return(ag);
}
protected override async void OnAppearing()
{
base.OnAppearing();
setStatusError(false);
using (await MaterialDialog.Instance.LoadingDialogAsync(message: "Load Data"))
{
ListAgamas = await patientServices.GetAgamaServices();
ListPekerjaans = await patientServices.GetPekerjaanServices();
ListPendidikans = await patientServices.GetPendidikanServices();
txtAgama.Choices = ListAgamas;
txtPekerjaan.Choices = ListPekerjaans;
txtPendidikan.Choices = ListPendidikans;
if (!(newPatient2.vc_k_agm is null))
{
Agama agamaSelected = ListAgamas.Find(config => config.vc_kode == (newPatient2.vc_k_agm));
txtAgama.SelectedChoice = agamaSelected;
}
if (!(newPatient2.vc_k_pend is null))
{
Pendidikan pendidikanSelected = ListPendidikans.Find(config => config.vc_kode == (newPatient2.vc_k_pend));
txtPendidikan.SelectedChoice = pendidikanSelected;
}
if (!(newPatient2.vc_k_pek is null))
{
Pekerjaan pekejeraanSelected = ListPekerjaans.Find(config => config.vc_kode == (newPatient2.vc_k_pek));
txtPekerjaan.SelectedChoice = pekejeraanSelected;
}
if (!(newPatient2.VC_jenis_k is null))
{
JenisKelamin jenisKelaminSelected = ListJenisKelamins.Find(config => config.vc_kodeKelamin == (newPatient2.VC_jenis_k));
txtJenisKel.SelectedChoice = jenisKelaminSelected;
}
}
}
private void metroButton1_Click(object sender, EventArgs e)
{
//btn simpan
jk.Nama = txtFullName.Text;
jk.Email = txtPassword.Text;
jk.Alamat = txtAlamat.Text;
int idAgama = (int)metroComboBox1.SelectedValue;
String ketAgama = metroComboBox1.DisplayMember;
Agama agamaSelected = new Agama(idAgama, ketAgama);
jk.Agamas = agamaSelected;
if (radLakik.Checked == true)
{
jk.JK = radLakik.Text;
}
else if (radPer.Checked == true)
{
jk.JK = radPer.Text;
}
else
{
}
jk.Username = txtUsername.Text;
jk.Password = txtPassword.Text;
int row = opJek.insert(jk);
if (row > 0)
{
MetroMessageBox.Show(this, "Alert", "Tambah Data Berhasil", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MetroMessageBox.Show(this, "Alert", "Data Gagal Disimpan", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
Rpt.Judul(x, comp, judul);
if (StatusA != "")
{
Rpt.SubJudul(x, "Status : " + StatusA);
}
else if (StatusI != "")
{
Rpt.SubJudul(x, "Status : " + StatusI);
}
else
{
Rpt.SubJudul(x, "Status : " + StatusS);
}
string sifat = "";
if (nSifat == "sifatALL")
{
sifat = "SEMUA";
}
else if (nSifat == "sifatSUDAH")
{
sifat = "sifatSUDAH";
}
else if (nSifat == "sifatBELUM")
{
sifat = "BELUM BELI";
}
Rpt.SubJudul(x
, "Sifat : " + sifat
);
Rpt.SubJudul(x
, "Nama : " + Nama.Replace("-", ",").TrimEnd(',')
);
Rpt.SubJudul(x
, "Agama : " + Agama.Replace("-", ",").TrimEnd(',')
);
Rpt.SubJudul(x
, "Sumber Data : " + SumberData.Replace("-", ",").TrimEnd(',')
);
Rpt.SubJudul(x
, "Periode Input : " + Input
);
Rpt.SubJudul(x
, "Bulan Lahir : " + nLahir
);
Rpt.SubJudul(x
, "Sales Account : " + nAgentInput
);
Rpt.SubJudul(x
, "Project : " + Project
);
//Rpt.Header(rpt, x);
string legend = "* * = Inaktif";
Rpt.HeaderReport(headReport, legend, x);
}
private void btnSimpan_Click(object sender, EventArgs e)
{
try
{
Agama ag = null;
if (txtNamaAgama.Text == "")
{
statusStripAgPanel1("Field Agama tidak boleh kosong !!!", Color.Yellow);
}
else if (txtId.Text == "Auto")
{
ag = new Agama();
//ag.Id_Agama = int.Parse(txtId.Text);
ag.Nama_Agama = txtNamaAgama.Text;
resultBool = agDAO.cekRecordNmAg(ag.Nama_Agama);
if (resultBool == false) //Data Lokasi Kerja masih kosong jadi bisa disimpan
{
result = agDAO.SaveAutoID(ag);
if (result > 0)
{
statusStripAgPanel1("Data berhasil disimpan.", Color.Green);
loadDataAgama();
clearTextBox();
txtNamaAgama.Focus();
}
else
{
statusStripAgPanel1("Data gagal disimpan.", Color.Red);
}
}
else
{
statusStripAgPanel1("Nama Agama sudah ada di daftar.", Color.Red);
}
/*
* else
* {
* Agama ag = new Agama();
* ag.Id_Agama = int.Parse(txtId.Text);
* ag.Nama_Agama = txtNamaAgama.Text;
*
* resultBool = agDAO.cekRecordNmAg(ag.Nama_Agama);
*
* if (resultBool == false) //Data Lokasi Kerja masih kosong jadi bisa disimpan
* {
* result = agDAO.Save(ag);
*
* if (result > 0)
* {
* statusStripAgPanel1("Data berhasil disimpan.", Color.Green);
* clearTextBox();
* txtNamaAgama.Focus();
*
* loadDataAgama();
* }
* else
* {
* statusStripAgPanel1("Data gagal disimpan.", Color.Red);
* }
* }
* */
/*
*
* */
}
else if (txtId.Text != "Auto")
{
ag = new Agama();
ag.Id_Agama = int.Parse(txtId.Text);
ag.Nama_Agama = txtNamaAgama.Text;
//msgBoxWarning("Belum lewat agDAO.cekRecordIdAg(ag.Id_Agama). resultBool = " + resultBool.ToString());
resultBool = agDAO.cekRecordIdAg(ag.Id_Agama);
//msgBoxWarning("Sudah lewat agDAO.cekRecordIdAg(ag.Id_Agama). resultBool = " + resultBool.ToString());
if (resultBool == true) //Meng-update data lokasi kerja
{
if (msgBoxWarning("Anda yakin akan mengubah data Agama dengan Id = " + txtId.Text + " ?") == true)
{
result = agDAO.Update(ag);
if (result > 0)
{
statusStripAgPanel1("Data berhasil diubah.", Color.Green);
loadDataAgama();
clearTextBox();
txtNamaAgama.Focus();
}
else
{
statusStripAgPanel1("Data gagal diubah.", Color.Red);
}
}
else
{
clearTextBox();
}
}
}
}
catch (Exception ex)
{
errorDBox(ex.Message.ToString(), "btnSimpan_Click");
}
}
private void Fill()
{
string order = "Nama, NoCustomer";
string nStatus = "";
if (StatusA != "")
{
nStatus = " AND Status = 'A'";
}
if (StatusI != "")
{
nStatus = " AND Status = 'I'";
}
string Sifat = "";
if (nSifat == "sifatSUDAH")
{
Sifat = " AND (SELECT COUNT(*) FROM MS_KONTRAK WHERE NoCustomer = MS_CUSTOMER.NoCustomer) <> 0";
}
if (nSifat == "sifatBELUM")
{
Sifat = " AND (SELECT COUNT(*) FROM MS_KONTRAK WHERE NoCustomer = MS_CUSTOMER.NoCustomer) = 0";
}
//change parameter
string str = String.Empty;
str = Nama.Replace("-", "").ToLower();
char[] characters = str.ToCharArray();
string str2 = "";
foreach (var t in characters)
{
str2 += "'" + t + "',";
}
str2 = str2.TrimEnd(',');
//change parameter
string stragama = String.Empty;
stragama = Agama.Replace("-", "").ToLower();
string aq = "";
if (Nama != "")
{
aq = aq + " AND LEFT(Nama,1) IN (" + str2 + ")";
}
string nInput = "";
if (Input != "SEMUA")
{
string[] z = Input.Split('-');
nInput = " AND YEAR(TglInput) = " + z[0]
+ " AND MONTH(TglInput) = " + z[1];
}
string Lahir = "";
if (nLahir != "SEMUA")
{
order = " DAY(TglLahir), Nama";
Lahir = " AND MONTH(TglLahir) = " + nLahir;
}
string AgentInput = "";
if (nAgentInput != "SEMUA")
{
AgentInput = " AND AgentInput = '" + nAgentInput + "'";
}
string nProject = "";
if (Project != "SEMUA")
{
nProject = " AND Project IN ('" + Project.Replace(",", "','") + "')";
}
string strdata = String.Empty;
string [] str3 = SumberData.Split('-');
for (int i = 0; i < str3.Length; i++)
{
if (i == str3.Length - 1)
{
strdata += "'" + str3[i] + "'";
}
else
{
strdata += "'" + str3[i] + "',";
}
}
//nSumberData = nSumberData.TrimEnd('-');
//nSumberData = nSumberData.Replace("-", "','");
//nSumberData = "'" + nSumberData;
//string nSumberData2 = nSumberData;
//nSumberData2 = nSumberData + "'";
string stringAgama = Agama;
stringAgama = stringAgama.TrimEnd('-');
stringAgama = stringAgama.Replace("-", "','");
stringAgama = "'" + stringAgama;
string agama = stringAgama;
agama = stringAgama + "'";
string strSql = "SELECT *"
+ ",CASE (SELECT COUNT(*) FROM MS_KONTRAK WHERE NoCustomer = MS_CUSTOMER.NoCustomer)"
+ " WHEN 0 THEN 'BELUM BELI'"
+ " ElSE 'SUDAH BELI'"
+ " END AS Sifat"
+ " FROM MS_CUSTOMER"
+ " WHERE "
+ " SumberData IN (" + strdata + ")"
//+ " AND Agama IN (" + agama + ")"
+ nProject
+ nStatus
+ aq
+ nInput
+ Lahir
+ AgentInput
+ Sifat
+ " ORDER BY " + order
;
DataTable rs = Db.Rs(strSql);
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
r.VerticalAlign = VerticalAlign.Top;
r.Attributes["ondblclick"] = "popEditCustomer('" + rs.Rows[i]["NoCustomer"] + "')";
r.VerticalAlign = VerticalAlign.Top;
r.Attributes["ondblclick"] = "popEditCustomer('" + rs.Rows[i]["NoCustomer"] + "')";
c = new TableCell();
c.Text = (i + 1).ToString() + ".";
c.HorizontalAlign = HorizontalAlign.Left;
r.Cells.Add(c);
string inaktif = "";
if (rs.Rows[i]["Status"].ToString() == "I")
{
inaktif = " **";
}
c = new TableCell();
c.Text = rs.Rows[i]["Nama"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["TipeCs"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["SumberData"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
string unit = "SELECT NoUnit FROM MS_KONTRAK WHERE NoCustomer = '" + rs.Rows[i]["NoCustomer"].ToString() + "'";
DataTable rsUnit = Db.Rs(unit);
string addUnit = "";
for (int j = 0; j < rsUnit.Rows.Count; j++)
{
addUnit = rsUnit.Rows[j]["NoUnit"] + ", ";
}
if (addUnit != "")
{
addUnit = addUnit.Substring(0, addUnit.Length - 2);
}
c.Text = addUnit;
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["AgentInput"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NamaBisnis"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["JenisBisnis"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["MerekBisnis"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Agama"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["TglLahir"]);
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NoTelp"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NoHP"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NoKantor"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NoFax"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Email"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NoKTP"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Alamat1"] + " "
+ rs.Rows[i]["Alamat2"] + " "
+ rs.Rows[i]["Alamat3"] + " "
;
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["KTP1"] + " "
+ rs.Rows[i]["KTP2"] + " "
+ rs.Rows[i]["KTP3"] + " "
+ rs.Rows[i]["KTP4"] + " "
;
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NPWP"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NPWPAlamat1"] + " "
+ rs.Rows[i]["NPWPAlamat2"] + " "
+ rs.Rows[i]["NPWPAlamat3"] + " "
;
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Sifat"].ToString();
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
if (rs.Rows[i]["Sifat"].ToString() == "SUDAH BELI")
{
PrintSales((int)rs.Rows[i]["NoCustomer"], r);
}
else
{
c = new TableCell();
c.Text = "";
c.ColumnSpan = 5;
c.Wrap = false;
r.Cells.Add(c);
}
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["TglInput"]);
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["TglTransaksi"]);
c.HorizontalAlign = HorizontalAlign.Left;
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = Db.SingleString("SELECT Nama FROM " + Mi.DbPrefix + "SECURITY..REF_PROJECT WHERE Project = '" + rs.Rows[i]["Project"].ToString() + "'");
c.HorizontalAlign = HorizontalAlign.Left;
c.VerticalAlign = VerticalAlign.Top;
r.Cells.Add(c);
rpt.Rows.Add(r);
}
}
