MasterPulsa SetData(byte status) { MasterPulsa myModel = new MasterPulsa(); switch (status) { case (1): { myModel.IdMasterPulsa = MasterPulsa.GenerateId(); myModel.IdProvider = Convert.ToInt32(cmbProvider.SelectedValue); myModel.KodeMasterPulsa = txtKode.Text; myModel.Keterangan = txtKeterangan.Text; myModel.Harga = Convert.ToInt32(txtHarga.Text); myModel.IsActive = rdAktif.Checked == true ? true : false; break; } case (2): { myModel.IdMasterPulsa = myID; myModel.IdProvider = Convert.ToInt32(cmbProvider.SelectedValue); myModel.KodeMasterPulsa = txtKode.Text; myModel.Keterangan = txtKeterangan.Text; myModel.Harga = Convert.ToInt32(txtHarga.Text); myModel.IsActive = rdAktif.Checked == true ? true : false; break; } } return(myModel); }
private void btnSimpan_Click(object sender, EventArgs e) { try { if (Helpers.GetValidate(panel1) == true) { if (statusDisplay == 1) { if (MasterPulsa.InsertData(SetData(1)) == true) { Helpers.MsgBoxSave(); } } else if (statusDisplay == 2) { if (MasterPulsa.UpdateDate(SetData(2)) == true) { Helpers.MsgBoxSave(); } } PreCreateDisplay(); } } catch (Exception ex) { Helpers.MsgBoxError(ex.Message); } }
public static Boolean InsertData(MasterPulsa masterPulsa) { string sql = "Insert into MasterPulsa values('" + masterPulsa.IdMasterPulsa + "','" + masterPulsa.IdProvider + "','" + masterPulsa.KodeMasterPulsa + "'" + ",'" + masterPulsa.Keterangan + "','" + masterPulsa.Harga + "','" + masterPulsa.IsActive + "')"; try { DataAccess.ExecuteNonQuery(sql); return(true); } catch (Exception ex) { return(false); throw ex; } }
public static Boolean UpdateDate(MasterPulsa masterPulsa) { string sql = "Update MasterPulsa set IdProvider = '" + masterPulsa.IdProvider + "',KodeMasterPulsa = '" + masterPulsa.KodeMasterPulsa + "'" + ",Keterangan = '" + masterPulsa.Keterangan + "',Harga = '" + masterPulsa.Harga + "',IsActive = " + masterPulsa.IsActive + " Where IdMasterPulsa= " + masterPulsa.IdProvider + ""; try { DataAccess.ExecuteNonQuery(sql); return(true); } catch (Exception ex) { return(false); throw ex; } }
void ListDataBySearch() { dgv.DataSource = MasterPulsa.GetListMasterPulsaByNama(txtCari.Text, cmbCari.Text); dgv.ReadOnly = true; HeaderGrid(); }
void ListData() { dgv.DataSource = MasterPulsa.GetListMasterPulsa(1); dgv.ReadOnly = true; HeaderGrid(); }