public void DokterBL_Save_Edit_Succeed_Test()
{
// arrange
var dokter = new DokterModel
{
Kode = "A",
Nama = "Data1",
KodeLayanan = "B",
NamaLayanan = "Data2",
PhotoFileName = "Data3"
};
_dokterDal.Stub(x => x.GetById("A")).Return(new DokterModel());
_layananBL.Stub(x => x.GetById("B")).Return(new LayananModel
{
Kode = "B",
Nama = "Data2"
});
// act
_dokterBL.Save(dokter);
// assert
_dokterDal.AssertWasCalled(x => x.Update(Arg <DokterModel> .Is.Anything));
}
public void Insert(DokterModel dokter)
{
string sSql = @"
INSERT INTO ta_dokter
(
fs_kd_dokter, fs_nm_dokter, fs_kd_layanan,
fs_photo_filename
)
VALUES
(
@KodeDokter, @NamaDokter, @KodeLayanan,
@PhotoFileName
)";
using (SqlConnection conn = new SqlConnection(_connString))
using (SqlCommand cmd = new SqlCommand(sSql, conn))
{
cmd.Parameters.AddWithValue("@KodeDokter", dokter.Kode);
cmd.Parameters.AddWithValue("@NamaDokter", dokter.Nama);
cmd.Parameters.AddWithValue("@KodeLayanan", dokter.KodeLayanan);
cmd.Parameters.AddWithValue("@PhotoFileName", dokter.PhotoFileName);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void DokterDal_ListData_Test1()
{
// arrange
DokterModel dokter = new DokterModel
{
Kode = "A",
Nama = "Data1",
KodeLayanan = "A",
PhotoFileName = "Photo.jpg"
};
dokterDal.Insert(dokter);
//
dokter = new DokterModel
{
Kode = "B",
Nama = "Data2",
KodeLayanan = "B",
PhotoFileName = "Photo2.jpg"
};
dokterDal.Insert(dokter);
// act
List <DokterModel> dummy = dokterDal.ListData("B");
}
public List <DokterModel> ListData(string kodeLayanan)
{
List <DokterModel> retVal = null;
string sSql = @"
SELECT aa.fs_kd_dokter, aa.fs_nm_dokter, aa.fs_kd_layanan,
aa.fs_photo_filename,
ISNULL(bb.fs_nm_layanan, ' ') fs_nm_layanan
FROM ta_dokter aa
LEFT JOIN ta_layanan bb ON aa.fs_kd_layanan = bb.fs_kd_layanan
WHERE aa.fs_kd_layanan = @KodeLayanan
ORDER BY fs_nm_dokter ";
using (SqlConnection conn = new SqlConnection(_connString))
using (SqlCommand cmd = new SqlCommand(sSql, conn))
{
cmd.Parameters.AddWithValue("@KodeLayanan", kodeLayanan);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
retVal = new List <DokterModel>();
while (dr.Read())
{
DokterModel item = new DokterModel();
item.Kode = dr["fs_kd_dokter"].ToString();
item.Nama = dr["fs_nm_dokter"].ToString();
item.KodeLayanan = dr["fs_kd_layanan"].ToString();
item.NamaLayanan = dr["fs_nm_layanan"].ToString();
item.PhotoFileName = dr["fs_photo_filename"].ToString();
retVal.Add(item);
}
}
}
return(retVal);
}
public DokterModel GetById(string id)
{
DokterModel retVal = null;
string sSql = @"
SELECT aa.fs_kd_dokter, aa.fs_nm_dokter, aa.fs_kd_layanan,
aa.fs_photo_filename,
ISNULL(bb.fs_nm_layanan, ' ') fs_nm_layanan
FROM ta_dokter aa
LEFT JOIN ta_layanan bb ON aa.fs_kd_layanan = bb.fs_kd_layanan
WHERE fs_kd_dokter = @Kode ";
using (SqlConnection conn = new SqlConnection(_connString))
using (SqlCommand cmd = new SqlCommand(sSql, conn))
{
cmd.Parameters.AddWithValue("@Kode", id);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
retVal = new DokterModel();
retVal.Kode = dr["fs_kd_dokter"].ToString();
retVal.Nama = dr["fs_nm_dokter"].ToString();
retVal.KodeLayanan = dr["fs_kd_layanan"].ToString();
retVal.NamaLayanan = dr["fs_nm_layanan"].ToString();
retVal.PhotoFileName = dr["fs_photo_filename"].ToString();
}
}
return(retVal);
}
public void DokterBL_Save_LayananInvalid_Test()
{
// arrange
var dokter = new DokterModel
{
Kode = "A",
Nama = "Data1",
KodeLayanan = "B",
NamaLayanan = "Data2",
PhotoFileName = "Data3"
};
_dokterDal.Stub(x => x.GetById("A")).Return(null);
_layananBL.Stub(x => x.GetById("B")).Return(null);
// act
string errMsg;
try
{
_dokterBL.Save(dokter);
errMsg = "";
}
catch (ArgumentException ex)
{
errMsg = ex.Message;
}
// assert
Assert.IsTrue(errMsg == "KODE LAYANAN invalid");
}
public void DokterBL_Save_NamaKosong_Test()
{
// arrange
var dokter = new DokterModel
{
Kode = "A",
Nama = "",
KodeLayanan = "B",
NamaLayanan = "Data2",
PhotoFileName = "Data3"
};
_dokterDal.Stub(x => x.GetById("A")).Return(null);
// act
string errMsg;
try
{
_dokterBL.Save(dokter);
errMsg = "";
}
catch (ArgumentException ex)
{
errMsg = ex.Message;
}
// assert
Assert.IsTrue(errMsg == "NAMA DOKTER kosong");
}
public IHttpActionResult Save(DokterModel layanan)
{
try
{
_dokterBL.Save(layanan);
return(Ok());
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public bool IsExist(string id)
{
DokterModel dummy = _dokterDal.GetById(id);
if (dummy == null)
{
return(false);
}
else
{
return(true);
}
}
public void DokterDal_Update_Succeed_Test()
{
// arrange
DokterModel dokter = new DokterModel
{
Kode = "A",
Nama = "Data1",
KodeLayanan = "B",
PhotoFileName = "File_.jpg"
};
// act
dokterDal.Update(dokter);
}
public void JadwalTglBL_ListData_Succeed_Test()
{
// arrange
var dokter = new DokterModel {
Kode = "A"
};
// act
var dummy = _jadwalTglBL.ListData(dokter, "01-01-2017");
// assert
_jadwalTglDal.AssertWasCalled(x => x.ListData(
Arg <string> .Is.Equal("01-01-2017"),
Arg <DokterModel> .Matches(y => y.Kode == "A")));
}
public void DokterDal_GetById_Test()
{
// arrange
DokterModel dokter = new DokterModel
{
Kode = "A",
Nama = "Data1",
KodeLayanan = "A",
PhotoFileName = "Photo.jpg"
};
dokterDal.Insert(dokter);
// act
dokterDal.Delete("A");
}
public List <JadwalTglModel> ListData(string tanggal, DokterModel dokter)
{
List <JadwalTglModel> retVal = null;
string sSql = @"
SELECT aa.fs_kd_dokter, aa.fs_jam, aa.fs_kd_layanan,
aa.fn_durasi, aa.fn_max, aa.fn_booked,
ISNULL(bb.fs_nm_dokter, ' ') fs_nm_dokter,
ISNULL(cc.fs_nm_layanan, ' ') fs_nm_layanan
FROM ta_jadwal_tgl aa
LEFT JOIN ta_dokter bb ON aa.fs_kd_dokter = bb.fs_kd_dokter
LEFT JOIN ta_layanan cc ON aa.fs_kd_layanan = cc.fs_kd_layanan
WHERE aa.fs_kd_dokter = @KodeDokter
AND aa.fd_tgl_jadwal = @TglJadwal ";
using (SqlConnection conn = new SqlConnection(_connString))
using (SqlCommand cmd = new SqlCommand(sSql, conn))
{
cmd.Parameters.AddWithValue("@KodeDokter", dokter.Kode);
cmd.Parameters.AddWithValue("@TglJadwal", tanggal);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
retVal = new List <JadwalTglModel>();
while (dr.Read())
{
var item = new JadwalTglModel();
item.KodeDokter = dr["fs_kd_dokter"].ToString();
item.KodeLayanan = dr["fs_kd_layanan"].ToString();
item.TglJadwal = tanggal;
item.Jam = dr["fs_jam"].ToString();
item.NamaDokter = dr["fs_nm_dokter"].ToString();
item.NamaLayanan = dr["fs_nm_layanan"].ToString();
item.Durasi = Convert.ToInt16(dr["fn_durasi"].ToString());
item.Max = Convert.ToInt16(dr["fn_max"].ToString());
item.Booked = Convert.ToInt16(dr["fn_booked"].ToString());
retVal.Add(item);
}
}
}
return(retVal);
}
public void Update(DokterModel dokter)
{
string sSql = @"
UPDATE ta_dokter
SET fs_nm_dokter = @NamaDokter,
fs_kd_layanan = @KodeLayanan,
fs_photo_filename = @PhotoFileName
WHERE fs_kd_dokter = @KodeDokter";
using (SqlConnection conn = new SqlConnection(_connString))
using (SqlCommand cmd = new SqlCommand(sSql, conn))
{
cmd.Parameters.AddWithValue("@KodeDokter", dokter.Kode);
cmd.Parameters.AddWithValue("@NamaDokter", dokter.Nama);
cmd.Parameters.AddWithValue("@KodeLayanan", dokter.KodeLayanan);
cmd.Parameters.AddWithValue("@PhotoFileName", dokter.PhotoFileName);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void DokterBL_Save_OptionalLayanan_Succeed_Test()
{
// arrange
var dokter = new DokterModel
{
Kode = "A",
Nama = "Data1",
KodeLayanan = "",
NamaLayanan = "",
PhotoFileName = "Data3"
};
_dokterDal.Stub(x => x.GetById("A")).Return(null);
// act
_dokterBL.Save(dokter);
// assert
_dokterDal.AssertWasCalled(x => x.Insert(Arg <DokterModel> .Is.Anything));
}
public List <JadwalHariModel> ListData(DokterModel dokter)
{
List <JadwalHariModel> retVal = null;
string sSql = @"
SELECT aa.fs_kd_dokter, aa.fs_kd_layanan, aa.fn_hari,
aa.fs_jam_mulai, aa.fs_jam_selesai,
ISNULL(bb.fs_nm_dokter, ' ') fs_nm_dokter,
ISNULL(cc.fs_nm_layanan, ' ') fs_nm_layanan
FROM ta_jadwal_hari aa
LEFT JOIN ta_dokter bb ON aa.fs_kd_dokter = bb.fs_kd_dokter
LEFT JOIN ta_layanan cc ON aa.fs_kd_layanan = cc.fs_kd_layanan
WHERE aa.fs_kd_dokter = @KodeDokter
ORDER BY cc.fs_nm_layanan, bb.fs_nm_dokter ";
using (SqlConnection conn = new SqlConnection(_connString))
using (SqlCommand cmd = new SqlCommand(sSql, conn))
{
cmd.Parameters.AddWithValue("@KodeDokter", dokter.Kode);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
retVal = new List <JadwalHariModel>();
while (dr.Read())
{
JadwalHariModel item = new JadwalHariModel();
item.KodeDokter = dr["fs_kd_dokter"].ToString();
item.NamaDokter = dr["fs_nm_dokter"].ToString();
item.KodeLayanan = dr["fs_kd_layanan"].ToString();
item.NamaLayanan = dr["fs_nm_layanan"].ToString();
item.Hari = Convert.ToInt16(dr["fn_hari"].ToString());
item.JamMulai = dr["fs_jam_mulai"].ToString();
item.JamSelesai = dr["fs_jam_selesai"].ToString();
retVal.Add(item);
}
}
}
return(retVal);
}
public void Save(DokterModel dokter)
{
// cek kode dokter
if (dokter.Kode.Trim() == "")
{
throw new ArgumentException("KODE DOKTER kosong");
}
// cek nama dokter
if (dokter.Nama.Trim() == "")
{
throw new ArgumentException("NAMA DOKTER kosong");
}
// composit: kode layanan
if (dokter.KodeLayanan.Trim() != "")
{
LayananModel layanan = _layananBL.GetById(dokter.KodeLayanan);
if (layanan == null)
{
throw new ArgumentException("KODE LAYANAN invalid");
}
else if (_layananBL.GetById(layanan.Kode).Nama.Trim() == "")
{
throw new ArgumentException("KODE LAYANAN invalid");
}
}
//--save data
if (!IsExist(dokter.Kode))
{
_dokterDal.Insert(dokter);
}
else
{
_dokterDal.Update(dokter);
}
}
public DokterModel GetById(string id)
{
DokterModel retVal = _dokterBL.GetById(id);
return(retVal);
}
public List <JadwalHariModel> ListData(DokterModel dokter)
{
return(_jadwalHariDal.ListData(dokter));
}
public List <JadwalTglModel> ListData(DokterModel dokter, string tanggal)
{
return(_jadwalTglDal.ListData(tanggal, dokter));
}
