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());
}
