private void buttonBuat_Click(object sender, EventArgs e) { try { int indexSPK = comboBoxSPK.SelectedIndex; Spk op = listhasildata[indexSPK]; Jadwal J = new Jadwal(textBoXid.Text, op, dateTimePickerTanggalMulai.Value, dateTimePickerTanggalSelesai.Value, textBoxkET.Text); string hasilTambah = Jadwal.TambahData(J); if (hasilTambah == "1") { MessageBox.Show("Jadwal telah tersimpan.", "Informasi"); buttonKosongi_Click(sender, e); frmDaftar.FormDaftarJadwal_Load(sender, e); } else { MessageBox.Show("Gagal menambah Jadwal. Pesan kesalahan: " + hasilTambah); } } catch (Exception exc) { MessageBox.Show("Data telah tersimpan silahkan Refresh"); } }
public static void ImportJadwalKotaToFile(Jadwal obj) { string LogFolder = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + "\\TextData"; if (!Directory.Exists(LogFolder)) { Directory.CreateDirectory(LogFolder); } String LogFileName = $"Jadwal-{obj.kota}.txt"; LogFileName = LogFolder + @"\" + LogFileName; _readWriteLock.EnterWriteLock(); try { // Append text to the file using (StreamWriter sw = File.AppendText(LogFileName)) { sw.WriteLine($"{obj.kota};{obj.ashar};{obj.dhuha};{obj.dzuhur};{obj.imsak};{obj.isya};{obj.maghrib};{obj.subuh};{obj.tanggal};{obj.terbit}"); sw.Close(); } } finally { // Release lock _readWriteLock.ExitWriteLock(); } }
private void textBoxCari_TextChanged(object sender, EventArgs e) { string kriteria = ""; if (comboBoxCari.Text == "No SPK") { kriteria = "s.nomor"; } else if (comboBoxCari.Text == "Keterangan") { kriteria = "p.keterangan"; } // Kosongi isi list listhasildata.Clear(); // Tampilkan data kategori sesuai kriteria string hasilBaca = Jadwal.BacaData(kriteria, textBoxCari.Text, listhasildata); if (hasilBaca == "1") { dataGridViewJadwal.DataSource = null; dataGridViewJadwal.DataSource = listhasildata; } }
public AbsenViewModel(Jadwal data) { Model = new BeritaAcara(); this.Data = data; this.Dosen = Helper.Dosen; SaveCommand = new Command(SaveAction); }
public void FormDaftarJadwal_Load(object sender, EventArgs e) { FormatDataGrid(); listhasildata.Clear(); string hasilbaca = Jadwal.BacaData("", "", listhasildata); if (hasilbaca == "1") { string no = ""; string divider = ""; for (int i = 0; i < listhasildata.Count; i++) { if (divider != listhasildata[i].NoSPK.NoSPK) { divider = listhasildata[i].NoSPK.NoSPK; no = listhasildata[i].NoSPK.NoSPK; } else { no = ""; } dataGridViewJadwal.Rows.Add(no, listhasildata[i].Id, listhasildata[i].TglMulai, listhasildata[i].TglSelesai, listhasildata[i].Keterangan); } } else { dataGridViewJadwal.DataSource = null; } }
public async Task <IActionResult> Edit(int id, [Bind("Id,LapanganId,PegawaiId,WaktuAwal,WaktuAkhir,Catatan")] Jadwal jadwal) { if (id != jadwal.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(jadwal); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!JadwalExists(jadwal.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["LapanganId"] = new SelectList(_context.Lapangan, "Id", "Id", jadwal.LapanganId); ViewData["PegawaiId"] = new SelectList(_context.Pegawai, "Id", "Id", jadwal.PegawaiId); return(View(jadwal)); }
public AbsenViewModel(Jadwal data, BeritaAcara model) { this.Model = model; this.Data = data; this.Dosen = Helper.Dosen; SaveCommand = new Command(SaveAction); }
public IActionResult Post([FromBody] Jadwal value) { JadwalRepo jadwal = new JadwalRepo(); var feedback = jadwal.insert(value); return(Ok(feedback)); }
private void buttonBuat_Click(object sender, EventArgs e) { try { int indexDipilihUser = comboBoxSPK.SelectedIndex; Spk spk = hasildataspk[indexDipilihUser]; Jadwal J = new Jadwal(textBoXid.Text, spk, dateTimePickerTanggalMulai.Value, dateTimePickerTanggalSelesai.Value, textBoxkET.Text); string hasilUbah = Jadwal.UbahData(J); if (hasilUbah == "1") { MessageBox.Show("Data Jadwal telah terubah", "Informasi"); frmdaftar.FormDaftarJadwal_Load(sender, e); } else { MessageBox.Show("Gagal mengubah data Jadwal. Pesan kesalahan: " + hasilUbah); } } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void FormTambahJadwal_Load(object sender, EventArgs e) { string codebaru; string hasilgen = Jadwal.GenerateCode(out codebaru); if (hasilgen == "1") { textBoXid.Text = codebaru; textBoXid.Enabled = false; } else { MessageBox.Show("Gagal melakukan generate code. Pesan kesalahan: " + hasilgen); } listhasildata.Clear(); string hasilBaca1 = Spk.BacaData("", "", listhasildata); if (hasilBaca1 == "1") { comboBoxSPK.Items.Clear(); for (int i = 0; i < listhasildata.Count; i++) { comboBoxSPK.Items.Add(listhasildata[i].NoSPK); } } else { MessageBox.Show("Data SPK gagal ditampilkan. Pesan kesalahan: " + hasilBaca1); } }
public HistoryViewModel(Jadwal jadwal) { Jadwal = jadwal; Items = new ObservableCollection <BeritaAcara>(); Dosen = Helper.Dosen; LoadItemsCommand = new Command(async() => await ExecuteLoadItemsCommand()); LoadItemsCommand.Execute(null); }
private void ViewJadwal(Jadwal jadwal) { if (jadwal != null) { lblImsakTime.Text = jadwal.imsak; lblSubuhTime.Text = jadwal.subuh; lblZuhurTime.Text = jadwal.dzuhur; lblAshartime.Text = jadwal.ashar; lblMagribtime.Text = jadwal.maghrib; lblIsyaTime.Text = jadwal.isya; } }
public async Task <IActionResult> Create([Bind("Id,LapanganId,PegawaiId,WaktuAwal,WaktuAkhir,Catatan")] Jadwal jadwal) { if (ModelState.IsValid) { _context.Add(jadwal); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["LapanganId"] = new SelectList(_context.Lapangan, "Id", "Id", jadwal.LapanganId); ViewData["PegawaiId"] = new SelectList(_context.Pegawai, "Id", "Id", jadwal.PegawaiId); return(View(jadwal)); }
public IActionResult EditPost(Jadwal data) { try { _jdw.Update(data); TempData["pesan"] = Helpers.Message.GetPesan("success", "sukses mengubah data jadwal"); } catch (Exception x) { TempData["pesan"] = Helpers.Message.GetPesan("danger", x.Message); } return(RedirectToAction("Index")); }
public void Update(Jadwal mhs) { using (SqlConnection conn = new SqlConnection(GetConnStr())) { var strsql = @"update Jadwal_Perwalian set Periode=@periode, Prodi=@prodi, Angkatan=@angkatan, Waktu=@waktu where Kode_jadwal=" + mhs.Kode_jadwal; var param = new { periode = mhs.Periode, prodi = mhs.Prodi, angkatan = mhs.Angkatan, waktu = mhs.Waktu }; try { conn.Execute(strsql, param); } catch (SqlException x) { throw new Exception($"error : {x.Message}"); }; } }
public void Insert(Jadwal mhs) { using (SqlConnection conn = new SqlConnection(GetConnStr())) { var strsql = @"insert into Jadwal_Perwalian (Periode,Prodi,Angkatan,Waktu) values(@periode, @prodi, @angkatan, @waktu)"; var param = new { periode = mhs.Periode, prodi = mhs.Prodi, angkatan = mhs.Angkatan, waktu = mhs.Waktu }; try { conn.Execute(strsql, param); } catch (SqlException x) { throw new Exception($"error : {x.Message}"); }; } }
public IActionResult CreatePost(Jadwal jdw) { // if (HttpContext.Session.GetString("role") == "dosen") // { // jdw.Angkatan = HttpContext.Session.GetString("id"); // } try { _jdw.Insert(jdw); TempData["pesan"] = Helpers.Message.GetPesan("success", "sukses menambah data jadwal"); } catch (Exception x) { TempData["pesan"] = Helpers.Message.GetPesan("danger", x.Message); } return(Redirect("Index")); }
public IActionResult Put([FromBody] Jadwal value) { JadwalRepo jadwal = new JadwalRepo(); if (jadwal.update(value) == true) { return(Ok(value)); } else { var response = new ContentResult() { StatusCode = StatusCodes.Status404NotFound, }; return(response); } }
private void button1_Click(object sender, EventArgs e) { string hasil = Jadwal.HapusData(comboBoxID.Text); if (hasil == "1") { MessageBox.Show("Jadwal telah dihapus"); FormDaftarJadwal frm = (FormDaftarJadwal)this.Owner; frm.FormDaftarJadwal_Load(sender, e); this.Close(); } else { MessageBox.Show("Error. Pesan : " + hasil); } }
private void FormHapusJadwal_Load(object sender, EventArgs e) { listdatajadwal.Clear(); string baca = Jadwal.BacaData("", "", listdatajadwal); if (baca == "1") { for (int i = 0; i < listdatajadwal.Count; i++) { comboBoxID.Items.Add(listdatajadwal[i].Id); } } else { MessageBox.Show("Data Error Tidak Ditemukan"); } }
public IActionResult Delete(int id) { JadwalRepo jadwal = new JadwalRepo(); Jadwal jad = new Jadwal(); jad.Id = id; if (jadwal.delete(jad) == true) { return(Ok(jad)); } else { var response = new ContentResult() { StatusCode = StatusCodes.Status404NotFound, }; return(response); } }
private void loadAllData() { Settings settingResult; Jadwal jadwalResult = null; using (IDapperContext dapperContext = new DapperContext()) { IUnitOfWork uow = new UnitOfWork(dapperContext); uow.BeginTransaction(); settingResult = uow.settingService.GetTop1(); if (settingResult != null) { jadwalResult = uow.jadwalService.GetTodayJadwal(settingResult.NamaKota, DateTime.Now.ToString("dddd, dd MMM yyyy")); } uow.Commit(); } ViewMasjidData(settingResult); ViewJadwal(jadwalResult); countDownSholat(); }
private void textBoXid_TextChanged(object sender, EventArgs e) { if (textBoXid.Text.Length == textBoXid.MaxLength) { hasildatajadwal.Clear(); string hasilBaca = Jadwal.BacaData("p.id", textBoXid.Text, hasildatajadwal); if (hasilBaca == "1") { if (hasildatajadwal.Count > 0) { textBoxkET.Text = hasildatajadwal[0].Keterangan; dateTimePickerTanggalMulai.Value = hasildatajadwal[0].TglMulai; dateTimePickerTanggalSelesai.Value = hasildatajadwal[0].TglSelesai; comboBoxSPK.Text = hasildatajadwal[0].NoSPK.NoSPK; } } else { MessageBox.Show("Data Tidak ditemukan"); } } }
public HistoryView(Jadwal item) { InitializeComponent(); this.BindingContext = new HistoryViewModel(item); }
public void Delete(Jadwal obj) { throw new NotImplementedException(); }
public void Insert(Jadwal obj) { throw new NotImplementedException(); }
public static void ExportJadwalKotaToDB() { string strFolder = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + "\\TextData"; string[] filePaths = Directory.GetFiles(strFolder); foreach (var path in filePaths) { if (Path.GetFileName(path) == "DaftarKota.txt") { continue; } var source = File.ReadLines(path).Select(line => line.Split(';')); var intCount = source.Count(); var intSkip = 0; var intBatch = 50; var isLoop = true; string query = ""; var bloop = true; do { var lst = new List <Jadwal>(); if (intSkip == 0) { source = File.ReadLines(path).Select(line => line.Split(';')).Take(intBatch); } else { source = File.ReadLines(path).Select(line => line.Split(';')).Skip(intSkip).Take(intBatch); } foreach (var itm in source) { var obj = new Jadwal(); obj.kota = itm[0]; obj.ashar = itm[1]; obj.dhuha = itm[2]; obj.dzuhur = itm[3]; obj.imsak = itm[4]; obj.isya = itm[5]; obj.maghrib = itm[6]; obj.subuh = itm[7]; obj.tanggal = itm[8]; obj.terbit = itm[9]; lst.Add(obj); } try { using (IDapperContext dapperContext = new DapperContext()) { IUnitOfWork uow = new UnitOfWork(dapperContext); uow.BeginTransaction(); uow.jadwalService.InsertAll(lst); uow.Commit(); } } catch (Exception e) { Log.WriteLog(CurrentProjectName, $"Error ExportJadwalKotaToDB: {e.Message}"); } intSkip += intBatch; if (intSkip > intCount) { bloop = false; } } while (bloop); } }
public IHttpActionResult GetJadwalLayanan(string id) { var jadwalLayanan = db.JadwalLayanans.Where(b => b.IdLayananRS == id); if (jadwalLayanan.Count() == 0) { var responseMessage = "Tidak ada jadwal di layanan ini"; return(ResponseMessage(Request.CreateResponse(HttpStatusCode.BadRequest, new Exception(responseMessage)))); } List <JadwalLayanans> jd = jadwalLayanan.Select(b => new JadwalLayanans { Hari = b.Hari, IdJadwal = b.IdJadwal, JamMulai = b.JamMulai, JamSelesai = b.JamSelesai, Dokter = db.Dokters.Where(st => st.NPA == b.IdDokter).Select(st => new Dokters { NPA = st.NPA, Nama = st.Nama, JenisKelamin = st.JenisKelamin, Spesiali = db.Spesialis.Where(s => s.IdSpesialis == st.IdSpesialis).Select(s => new Spesialis { IdSpesialis = s.IdSpesialis, NamaSpesialis = s.NamaSpesialis, Gelar = s.Gelar }).FirstOrDefault() }).FirstOrDefault() }).ToList(); var jadwal = new List <Jadwal>(); List <JadwalLayanans> jadwal1 = new List <JadwalLayanans>(); var jad = new Jadwal(); for (var i = 0; i < jd.Count; i++) { if (jd[i].Hari == "Senin") { jad.Hari = jd[i].Hari; jadwal1.Add(jd[i]); } } jad.JadwalLayanan = jadwal1; if (jad.Hari != null) { jadwal.Add(jad); } jadwal1 = new List <JadwalLayanans>(); jad = new Jadwal(); for (var i = 0; i < jd.Count; i++) { if (jd[i].Hari == "Selasa") { jad.Hari = jd[i].Hari; jadwal1.Add(jd[i]); } } jad.JadwalLayanan = jadwal1; if (jad.Hari != null) { jadwal.Add(jad); } jadwal1 = new List <JadwalLayanans>(); jad = new Jadwal(); for (var i = 0; i < jd.Count; i++) { if (jd[i].Hari == "Rabu") { jad.Hari = jd[i].Hari; jadwal1.Add(jd[i]); } } jad.JadwalLayanan = jadwal1; if (jad.Hari != null) { jadwal.Add(jad); } jadwal1 = new List <JadwalLayanans>(); jad = new Jadwal(); for (var i = 0; i < jd.Count; i++) { if (jd[i].Hari == "Kamis") { jad.Hari = jd[i].Hari; jadwal1.Add(jd[i]); } } jad.JadwalLayanan = jadwal1; if (jad.Hari != null) { jadwal.Add(jad); } jadwal1 = new List <JadwalLayanans>(); jad = new Jadwal(); for (var i = 0; i < jd.Count; i++) { if (jd[i].Hari == "Jumat") { jad.Hari = jd[i].Hari; jadwal1.Add(jd[i]); } } jad.JadwalLayanan = jadwal1; if (jad.Hari != null) { jadwal.Add(jad); } jadwal1 = new List <JadwalLayanans>(); jad = new Jadwal(); for (var i = 0; i < jd.Count; i++) { if (jd[i].Hari == "Sabtu") { jad.Hari = jd[i].Hari; jadwal1.Add(jd[i]); } } jad.JadwalLayanan = jadwal1; if (jad.Hari != null) { jadwal.Add(jad); } jadwal1 = new List <JadwalLayanans>(); jad = new Jadwal(); for (var i = 0; i < jd.Count; i++) { if (jd[i].Hari == "Minggu") { jad.Hari = jd[i].Hari; jadwal1.Add(jd[i]); } } jad.JadwalLayanan = jadwal1; if (jad.Hari != null) { jadwal.Add(jad); } return(Ok(jadwal)); }