public async Task <IActionResult> DetailHarian()
{
Config.ConStr = _configuration.GetConnectionString("Db");
var model = new DetailHarianModel();
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 DetailHarianFilter();
Filter.TglTrxFrom = GF.GetDatetime().Left(10);
Filter.TglTrxUntil = GF.GetDatetime().Left(10);
model.Listdata = await s.DetailHarian_GetSearch(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 <List <DetailHarian> > DetailHarian_GetSearch(DetailHarianFilter Filter)
{
var res = new List <DetailHarian>();
try
{
conn.ConnectionString = Config.ConStr;
using (var connection = conn)
{
connection.Open();
string sql = "exec SP_DetailHarian_GetSearch " +
"@TglTrxFrom='" + Filter.TglTrxFrom + "'," +
"@TglTrxUntil='" + Filter.TglTrxUntil + "'" +
"";
using (var command = new SqlCommand(sql, connection))
{
command.CommandTimeout = 0;
using (var reader = await command.ExecuteReaderAsync())
{
while (reader.Read())
{
var d = new DetailHarian();
string SewaFrom = reader["SewaDari"].ToString();
string SewaUntil = reader["Sewasampai"].ToString();
d.JumlahHari = GF.GetDiffDays(SewaFrom, SewaUntil).ToString();
d.NamaPenyewa = reader["NamaPenyewa"].ToString();
d.JudulBuku = reader["JudulBuku"].ToString();
d.Pengarang = reader["Pengarang"].ToString();
d.JenisBuku = reader["JenisBuku"].ToString();
d.HargaPerHari = reader["HargaSewaPerHari"].ToString();
d.TanggalTransaksi = reader["TanggalTransaksi"].ToString();
d.TotalSewa = reader["TotalSewa"].ToString();
d.KasirTerimaUang = reader["KasirTerimaUang"].ToString();
d.UangKembalian = reader["UangKembalian"].ToString();
d.NamaKasir = reader["NamaKasir"].ToString();
d.TanggalPengembalian = reader["TanggalPengembalian"].ToString();
res.Add(d);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
public async Task <IActionResult> DetailHarian_Search([Bind("TglTrxFrom,TglTrxUntil")] DetailHarianFilter data)
{
var model = new DetailHarianModel();
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
{
model.Listdata = await s.DetailHarian_GetSearch(data);
return(await Task.Run(() => Json(new { isValid = true, html = Helper.RenderRazorViewToString(this, "DetailHarian_Table", model) })));
}
}
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;
return(await Task.Run(() => Json(new { isValid = false, message = r.MessageContent, title = r.MessageTitle })));
}
}
