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