public ActionResult DeleteConfirmed(int id)
{
Nilai nilai = db.Nilai.Find(id);
db.Nilai.Remove(nilai);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Nim,KodeMK,KodeSemester,NilaiAngka,NilaiHuruf")] Nilai nilai)
{
if (ModelState.IsValid)
{
db.Entry(nilai).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Nim = new SelectList(db.Mahasiswa, "Nim", "Nama", nilai.Nim);
ViewBag.KodeMK = new SelectList(db.MataKuliah, "KodeMK", "Nama", nilai.KodeMK);
ViewBag.KodeSemester = new SelectList(db.Semester, "KodeSemester", "NamaSemester", nilai.KodeSemester);
return(View(nilai));
}
// GET: Admin/Nilai/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Nilai nilai = db.Nilai.Find(id);
if (nilai == null)
{
return(HttpNotFound());
}
return(View(nilai));
}
// GET: Admin/Nilai/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Nilai nilai = db.Nilai.Find(id);
if (nilai == null)
{
return(HttpNotFound());
}
ViewBag.Nim = new SelectList(db.Mahasiswa, "Nim", "Nama", nilai.Nim);
ViewBag.KodeMK = new SelectList(db.MataKuliah, "KodeMK", "Nama", nilai.KodeMK);
ViewBag.KodeSemester = new SelectList(db.Semester, "KodeSemester", "NamaSemester", nilai.KodeSemester);
return(View(nilai));
}
public Nilai GetByNIS(string nis, string kode)
{
Nilai nilai = null;
try
{
var sql = @"select *
from nilai
where nis = @nis and kode = @kode";
nilai = _context.db.QuerySingleOrDefault <Nilai>(sql, new { nis, kode });
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(nilai);
}
public ActionResult GetLineChart(string id_perusahaan)
{
id_perusahaan = TempData["id_perusahaan"].ToString();
//var TargetNilai = db.hasils.Where(x => x.id_perusahaan.ToString() == id_perusahaan);
string nama_perusahaan = db.perusahaans.Find(Convert.ToInt64(id_perusahaan)).nama_perusahaan;
//var TempNilaiTarget = db.hasils.Find(Convert.ToInt64(id_perusahaan)).target_2;
var join = (from hasil in db.hasils
join perusahaan in db.perusahaans on hasil.id_perusahaan equals perusahaan.IDPerusahaan
join tahun in db.tahuns on hasil.id_tahun equals tahun.IDTahun
where hasil.id_perusahaan.ToString() == id_perusahaan
select new { hasil.IDHasil, perusahaan.nama_perusahaan, tahun.tahun1, hasil.target_2 });
//double[] NilaiTarget = Array.ConvertAll(TempNilaiTarget, double.Parse);
double[] NilaiTarget = new double[5];
int i = 0;
foreach (var temp in join)
{
NilaiTarget[i] = (double)temp.target_2 * 100;
i++;
}
Nilai nilai = new Nilai();
nilai.TargetTahun1 = NilaiTarget[0];
nilai.TargetTahun2 = NilaiTarget[1];
nilai.TargetTahun3 = NilaiTarget[2];
nilai.TargetTahun4 = NilaiTarget[3];
nilai.TargetTahun5 = NilaiTarget[4];
nilai.NamaPerusahaan = nama_perusahaan;
//ViewData["TargetData"] = TargetNilai;
//return View();
return(Json(nilai, JsonRequestBehavior.AllowGet));
}
public void cetakLaporan()
{
if ((int.Parse(dgDetailBank.SelectedCells[0].OwningRow.Cells["NPrint"].Value.ToString()) > 0) && (!SecurityManager.IsManager()))
{
if (!SecurityManager.AskPasswordManager())
{
return;
}
}
string Keterangan, NoBBK, TglBank, NoBGCH, NamaBank, TglRK, Nilai, Kasir, jnsTran, Tanggal;
string txtJudul, txtKeterangan, txtNamaBank, txtPenerima;
Guid _rowID = (Guid)dgDetailBank.SelectedCells[0].OwningRow.Cells["RowID"].Value;
Keterangan = dgDetailBank.SelectedCells[0].OwningRow.Cells["Keterangan"].Value.ToString().Trim();
NamaBank = dgHeaderBank.SelectedCells[0].OwningRow.Cells["NamaBank"].Value.ToString().Trim();
Tanggal = String.Format("{0:dd-MMM-yyyy}", (DateTime)dgDetailBank.SelectedCells[0].OwningRow.Cells["TglBank"].Value);
TglBank = String.Format("{0:dd-MMM-yyyy}", (DateTime)dgDetailBank.SelectedCells[0].OwningRow.Cells["TglBank"].Value);
NoBBK = dgDetailBank.SelectedCells[0].OwningRow.Cells["NoBBKD"].Value.ToString().Trim();
NoBGCH = dgDetailBank.SelectedCells[0].OwningRow.Cells["NoBGCH"].Value.ToString().Trim();
TglRK = String.Format("{0:dd-MMM-yyyy}", (DateTime)dgDetailBank.SelectedCells[0].OwningRow.Cells["TglRK"].Value);
jnsTran = dgDetailBank.SelectedCells[0].OwningRow.Cells["JnsTran"].Value.ToString().Trim();
Kasir = SecurityManager.UserID;
if (jnsTran == "BBM")
{
txtJudul = "BUKTI BANK MASUK";
txtKeterangan = "Diterima dari : ";
txtNamaBank = "Asal Transfer";
txtPenerima = "Penyetor";
Nilai = String.Format("{0:0,0}", Convert.ToDouble(dgDetailBank.SelectedCells[0].OwningRow.Cells["Debet"].Value));
}
else
{
txtJudul = "BUKTI BANK KELUAR";
txtKeterangan = "Dibayar kepada : ";
txtNamaBank = "Transfer Ke";
txtPenerima = "Penerima";
Nilai = String.Format("{0:0,0}", Convert.ToDouble(dgDetailBank.SelectedCells[0].OwningRow.Cells["Kredit"].Value));
}
try
{
BuildString lap = new BuildString();
lap.Initialize();
lap.PageLLine(33);
lap.LeftMargin(1);
lap.FontCPI(12);
lap.LineSpacing("1/6");
lap.DoubleWidth(true);
lap.PROW(true, 1, txtJudul);
lap.DoubleWidth(false);
lap.PROW(true, 1, lap.PrintTopLeftCorner() + lap.PrintHorizontalLine(41) + lap.PrintTTOp()
+ lap.PrintHorizontalLine(41) + lap.PrintTopRightCorner());
lap.PROW(true, 1, lap.PrintVerticalLine() + txtKeterangan.PadRight(41) +
lap.PrintVerticalLine() + ("Nomor : " + NoBBK).PadRight(41) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + Keterangan.PadRight(41).Substring(0, 41) + lap.PrintVerticalLine() + ("Tanggal : " +
Tanggal).PadRight(30) + "Hal : 1/1".PadRight(11) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(41) + lap.PrintTBottom()
+ lap.PrintHorizontalLine(41) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(15, "Nomor") + lap.PadCenter(16, txtNamaBank) + lap.SPACE(1) + lap.PadCenter(10, "Bank")
+ lap.PadCenter(13, "Tgl Bank") + lap.PadCenter(13, "Tgl Trf") + lap.PadCenter(15, "Nilai Transfer") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + NoBGCH.PadRight(15) + NamaBank.ToString().ToUpper().PadRight(16).Substring(0, 16) + lap.SPACE(1) + "".PadRight(10) +
lap.PadCenter(13, TglBank) + lap.PadCenter(13, TglRK)
+ Nilai.PadLeft(15) + lap.PrintVerticalLine());
for (int j = 0; j < 9; j++)
{
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.SPACE(83) + lap.PrintVerticalLine());
}
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + "Terbilang".PadRight(58) + "Jumlah Rp." +
Nilai.PadLeft(15) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(83) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + Tools.Terbilang(Convert.ToDouble(Nilai)).PadRight(83) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintTLeft() + lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTTOp()
+ lap.PrintHorizontalLine(20) + lap.PrintTTOp() + lap.PrintHorizontalLine(20) + lap.PrintTRight());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "Pembukuan") + lap.PrintVerticalLine() + lap.PadCenter(20, "Mengetahui")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "Kasir") + lap.PrintVerticalLine() + lap.PadCenter(20, txtPenerima) + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "")
+ lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine() + lap.PadCenter(20, "") + lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintVerticalLine() + "(" + lap.PadCenter(18, "") + ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, "")
+ ")" + lap.PrintVerticalLine() + "(" + lap.PadCenter(18, Kasir) + ")" + lap.PrintVerticalLine() + "(" + lap.SPACE(18) + ")" +
lap.PrintVerticalLine());
lap.PROW(true, 1, lap.PrintBottomLeftCorner() + lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintTBottom()
+ lap.PrintHorizontalLine(20) + lap.PrintTBottom() + lap.PrintHorizontalLine(20) + lap.PrintBottomRightCorner());
lap.PROW(true, 1, ":: " + String.Format("{0:yyyyMMddhh:mm:ss}", DateTime.Now) + " " + SecurityManager.UserName);
lap.Eject();
using (Database db = new Database(GlobalVar.DBFinance))
{
db.Commands.Add(db.CreateCommand("rsp_CetakBankDetail"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].ExecuteNonQuery();
}
DetailRefresh(_rowID);
DetailFindRow("RowID", _rowID.ToString());
lap.SendToPrinter("laporanPS.txt");
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
