public anggotaModels GetInfoAnggota(string kdPelanggan) { var item = new anggotaModels(); string SqlString = @"Select b.id,b.NoAng, b.Nama,b.alamat, b.kota, b.sektor as kantor, b.tgl_registrasi, b.simwajib,b.simpanan as simpanan_tmk from anggota as b where b.noang = ? "; string ConnStr = ManageString.GetConnStr(); try { using (OleDbConnection conn = new OleDbConnection(ConnStr)) { conn.Open(); using (OleDbCommand cmd = new OleDbCommand(SqlString, conn)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("noang", kdPelanggan); using (OleDbDataReader aa = cmd.ExecuteReader()) { if (aa.HasRows) { //Log.Debug(DateTime.Now + " GetPelangganREPO ====>>>>>> Jumlah Data : " + aa.Cast<object>().Count()); while (aa.Read()) { // Log.Debug(DateTime.Now + "GetInfoAnggota Repo, Nama : " + aa["nama"].ToString()); item.id = aa.GetInt32(0); item.no_anggota = aa.GetString(1); item.nama_anggota = aa.GetString(2); item.alamat = aa.GetString(3); item.kota = aa.GetString(4); item.kantor = aa.GetString(5); item.tgl_registrasi = aa.GetDateTime(6); item.simpanan_wajib = Math.Round(Convert.ToDecimal(aa.GetDouble(7)), 2); item.simpanan_tmk = Math.Round(Convert.ToDecimal(aa.GetDouble(8)), 2); } //Log.Debug(DateTime.Now + " GetPelangganREPO ====>>>>>> Jumlah LIST : " + dList.Count()); } } } } } catch (Exception ex) { Log.Debug(DateTime.Now + " GetInfoAnggota ERROR ====>>>> No Anggota : " + kdPelanggan, ex); } return(item); }
public anggotaModels GetInfoAnggota(string kdPelanggan) { var infoAng = new anggotaModels(); try { infoAng = _repoPelanggan.GetInfoAnggota(kdPelanggan); } catch (Exception ex) { Log.Error(DateTime.Now + " GetInfoAnggota ====>>>>>> No Anggota : " + kdPelanggan, ex); } return(infoAng); }
public ActionResult Index() { //Log.Debug(DateTime.Now + " ====>>>Index, MASUK CONTROLLER"); var vHasil = new anggotaModels(); var kdPelanggan = ConfigModels.GetNoAnggota(); vHasil = _pelangganService.GetInfoAnggota(kdPelanggan); //Log.Debug(DateTime.Now + " ====>>> Index, Jml Record Hasil : " + vHasil.nama_anggota); return(View(vHasil)); }
public ActionResult ListPerCompany() { //Log.Debug(DateTime.Now + " ====>>>Index, MASUK CONTROLLER"); var vHasil = new anggotaModels(); var kdPelanggan = ConfigModels.GetNoAnggota(); Log.Debug(DateTime.Now + " ====>>> No Anggota : " + kdPelanggan + " As Admin " + ConfigModels.GetAsAdmin()); if (ConfigModels.GetAsAdmin() == 0) { Response.Redirect("~/error_page.html"); } return(View()); }