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