public async Task <IActionResult> CariBuku_UpdateCart([Bind("Id,IdBuku,SewaDari,Sewasampai,TotalSewa")] TransaksiTransaksiPeminjamanBuku data) { var r = new ErrorViewModel(); if (ModelState.IsValid) { try { if (string.IsNullOrEmpty(HttpContext.Session.GetString("_UserId"))) { var model2 = new alertLogin(); return(await Task.Run(() => RedirectToAction("SignIn", "Home", model2))); } else { data.IdUser_Penyewa = HttpContext.Session.GetString("_UserId").ToInt(); r = await s.CariBuku_UpdateCart(data); if (r.MessageStatus == "success") { return(await Task.Run(() => Json(new { isValid = true, message = r.MessageContent, title = r.MessageTitle }))); } else { return(await Task.Run(() => Json(new { isValid = false, message = r.MessageContent, title = r.MessageTitle }))); } } } catch (Exception ex) { r.MessageContent = ex.ToString(); r.MessageTitle = "Error "; r.RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier; return(await Task.Run(() => Json(new { isValid = false, message = r.MessageContent, title = r.MessageTitle }))); } } else { r.MessageContent = "State Model tidak valid"; r.MessageTitle = "Error "; r.RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier; //model.ListData = await f.BukuData_Get(); return(await Task.Run(() => Json(new { isValid = false, message = r.MessageContent, title = r.MessageTitle }))); } }
public async Task <IActionResult> PengembalianBuku() { Config.ConStr = _configuration.GetConnectionString("Db"); var model = new PengembalianBukuModel(); try { if (string.IsNullOrEmpty(HttpContext.Session.GetString("_UserId"))) { var model2 = new alertLogin(); return(await Task.Run(() => RedirectToAction("SignIn", "Home", model2))); } else { ViewBag.UserId = HttpContext.Session.GetString("_UserId"); var Filter = new TransaksiTransaksiPeminjamanBuku(); model.ListData = await s.PengembalianBuku_Search(Filter); return(await Task.Run(() => View(model))); } } catch (Exception ex) { var Error = new ErrorViewModel(); Error.MessageContent = ex.ToString(); Error.MessageTitle = "Error "; Error.RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier; model.Error = Error; return(await Task.Run(() => View(model))); } }
public async Task <IActionResult> TransaksiPeminjaman_Form(int id = 0) { var model = new TransaksiTransaksiPeminjamanBuku(); try { if (id == 0) { model.Id = id; return(await Task.Run(() => View(model))); } else { model = await s.TransaksiPeminjaman_GetById(id); if (model == null) { return(NotFound()); } return(await Task.Run(() => View(model))); } } catch (Exception ex) { var Error = new ErrorViewModel(); Error.MessageContent = ex.ToString(); Error.MessageTitle = "Error "; Error.RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier; model.Error = Error; return(await Task.Run(() => View(model))); } }
public async Task <ErrorViewModel> TransaksiPeminjaman_Save(TransaksiTransaksiPeminjamanBuku Data) { var res = new ErrorViewModel(); try { conn.ConnectionString = Config.ConStr; using (var connection = conn) { connection.Open(); string sql = "exec SP_TransaksiPeminjaman_Save "; Type type = Data.GetType(); PropertyInfo[] props = type.GetProperties(); foreach (var p in props) { if (null != p && p.CanWrite) { if (p.Name != "" && p.Name != "Error" && p.PropertyType.Name.ToString() != "IFormFile") { string param = ""; if (p.PropertyType.Name.ToString() == "String") { var val = p.GetValue(Data) ?? ""; param = "@" + p.Name + "='" + val.ToString() + "',"; } else { param = "@" + p.Name + "=" + p.GetValue(Data).ToString() + ","; } sql = sql + param; } } } sql = sql.RemoveLast(","); using (var command = new SqlCommand(sql, connection)) { command.CommandTimeout = 0; using (var reader = await command.ExecuteReaderAsync()) { while (reader.Read()) { res.MessageTitle = reader["Title"].ToString(); res.MessageContent = reader["Message"].ToString(); res.MessageStatus = reader["Status"].ToString(); res.RequestId = reader["Id"].ToString(); } } } } } catch (Exception ex) { throw ex; } return(res); }
public async Task <List <TransaksiTransaksiPeminjamanBuku> > TransaksiPeminjaman_GetSearch(TransaksiTransaksiPeminjamanBuku Data) { var res = new List <TransaksiTransaksiPeminjamanBuku>(); try { conn.ConnectionString = Config.ConStr; using (var connection = conn) { connection.Open(); string sql = "exec SP_TransaksiTransaksiPeminjamanBuku_GetSearch " + "@JudulBuku='" + Data.JudulBuku + "'," + "@Pengarang='" + Data.Pengarang + "'," + "@JenisBuku='" + Data.JenisBuku + "'," + "@IdUser_Penyewa=" + Data.IdUser_Penyewa + "," + "@Status=" + Data.Status + "" + ""; using (var command = new SqlCommand(sql, connection)) { command.CommandTimeout = 0; using (var reader = await command.ExecuteReaderAsync()) { while (reader.Read()) { var d = new TransaksiTransaksiPeminjamanBuku(); d.Id = reader["Id"].ToString().ToInt(); d.IdBuku = reader["IdBuku"].ToString().ToInt(); d.SewaDari = reader["SewaDari"].ToString(); d.Sewasampai = reader["Sewasampai"].ToString(); d.TotalSewa = reader["TotalSewa"].ToString(); d.Status = reader["Status"].ToString().ToInt(); d.IdUser_Penyewa = reader["IdUser_Penyewa"].ToString().ToInt(); d.HargaSewaPerHari = reader["HargaSewaPerHari"].ToString(); d.Img = reader["Img"].ToString(); d.JenisBuku = reader["JenisBuku"].ToString(); d.JudulBuku = reader["JudulBuku"].ToString(); d.Pengarang = reader["Pengarang"].ToString(); d.Nama_Penyewa = reader["Nama_Penyewa"].ToString(); res.Add(d); } } } } } catch (Exception ex) { throw ex; } return(res); }
public async Task <TransaksiTransaksiPeminjamanBuku> TransaksiPeminjaman_GetById(int Id) { var res = new TransaksiTransaksiPeminjamanBuku(); try { conn.ConnectionString = Config.ConStr; using (var connection = conn) { connection.Open(); string sql = "exec SP_TransaksiPeminjaman_GetById @Id=" + Id + "" + ""; using (var command = new SqlCommand(sql, connection)) { command.CommandTimeout = 0; using (var reader = await command.ExecuteReaderAsync()) { while (reader.Read()) { Type type = res.GetType(); PropertyInfo[] props = type.GetProperties(); foreach (var p in props) { if (null != p && p.CanWrite) { if (p.Name != "" && p.Name != "Error" && p.PropertyType.Name.ToString() != "IFormFile") { if (p.PropertyType.Name.ToString() == "Int32") { int val = reader[p.Name].ToString().AsInt() ?? 0; p.SetValue(res, val, null); } else { p.SetValue(res, reader[p.Name].ToString(), null); } } } } } } } } } catch (Exception ex) { throw ex; } return(res); }
public async Task <IActionResult> TransaksiPeminjaman_Search([Bind("JudulBuku,Pengarang,JenisBuku,IdUser_Penyewa,Status")] TransaksiTransaksiPeminjamanBuku data) { var model = new TransaksiTransaksiPeminjamanBukuModel(); var r = new ErrorViewModel(); if (ModelState.IsValid) { try { if (string.IsNullOrEmpty(HttpContext.Session.GetString("_UserId"))) { var model2 = new alertLogin(); return(await Task.Run(() => RedirectToAction("SignIn", "Home", model2))); } else { data.IdUser_Penyewa = HttpContext.Session.GetString("_UserId").ToInt(); model.ListData = await s.TransaksiPeminjaman_GetSearch(data); model.StatusTrx = data.Status; return(await Task.Run(() => Json(new { isValid = true, html = Helper.RenderRazorViewToString(this, "TransaksiPeminjaman_Table", model) }))); } } catch (Exception ex) { r.MessageContent = ex.ToString(); r.MessageTitle = "Error "; r.RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier; model.Error = r; model.ListData = await s.TransaksiPeminjaman_Get(); return(await Task.Run(() => Json(new { isValid = false, message = r.MessageContent, title = r.MessageTitle, html = Helper.RenderRazorViewToString(this, "TransaksiPeminjaman_Table", data) }))); } } else { r.MessageContent = "State Model tidak valid"; r.MessageTitle = "Error "; r.RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier; model.Error = r; model.ListData = await s.TransaksiPeminjaman_Get(); return(await Task.Run(() => Json(new { isValid = false, message = r.MessageContent, title = r.MessageTitle, html = Helper.RenderRazorViewToString(this, "MenuData_Table", model) }))); } }
public async Task <IActionResult> TransaksiPeminjaman_Save([Bind("Id,IdBuku,SewaDari,Sewasampai,TotalSewa,Status,IdUser_Penyewa")] TransaksiTransaksiPeminjamanBuku data) { var r = new ErrorViewModel(); if (ModelState.IsValid) { try { r = await s.TransaksiPeminjaman_Save(data); if (r.MessageStatus == "success") { data.Id = r.RequestId.ToInt(); return(await Task.Run(() => Json(new { isValid = true }))); } else { var Error = new ErrorViewModel(); Error.MessageContent = r.MessageContent; Error.MessageTitle = r.MessageTitle; Error.RequestId = r.RequestId; data.Error = Error; return(await Task.Run(() => Json(new { isValid = false, message = r.MessageContent, title = r.MessageTitle, html = Helper.RenderRazorViewToString(this, "MenuData_Form", data) }))); } } catch (Exception ex) { var Error = new ErrorViewModel(); Error.MessageContent = ex.ToString(); Error.MessageTitle = "Error "; Error.RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier; return(await Task.Run(() => Json(new { isValid = false, message = Error.MessageContent, title = Error.MessageTitle, html = Helper.RenderRazorViewToString(this, "MenuData_Form", data) }))); } } else { var Error = new ErrorViewModel(); Error.MessageContent = "State Model tidak valid"; Error.MessageTitle = "Error "; Error.RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier; return(await Task.Run(() => Json(new { isValid = false, message = Error.MessageContent, title = Error.MessageTitle, html = Helper.RenderRazorViewToString(this, "MenuData_Form", data) }))); } }
public async Task <ErrorViewModel> CariBuku_UpdateCart(TransaksiTransaksiPeminjamanBuku Data) { var res = new ErrorViewModel(); try { conn.ConnectionString = Config.ConStr; using (var connection = conn) { connection.Open(); //string sql = "exec SP_CariBuku_AddCart " + string sql = "exec SP_CariBuku_UpdateCart " + "@Id=" + Data.Id + "," + "@IdBook=" + Data.IdBuku + "," + "@IdUser_Penyewa=" + Data.IdUser_Penyewa + "," + "@HargaSewaPerHari=" + Data.HargaSewaPerHari.toDecimal() + "," + "@SewaDari='" + Data.SewaDari + "'," + "@Sewasampai='" + Data.Sewasampai + "'," + "@TotalSewa=" + Data.TotalSewa.toDecimal() + "" + ""; using (var command = new SqlCommand(sql, connection)) { command.CommandTimeout = 0; using (var reader = await command.ExecuteReaderAsync()) { while (reader.Read()) { res.MessageTitle = reader["Title"].ToString(); res.MessageContent = reader["Message"].ToString(); res.MessageStatus = reader["Status"].ToString(); res.RequestId = reader["Id"].ToString(); } } } } } catch (Exception ex) { throw ex; } return(res); }