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