public async Task <IActionResult> SummaryHarian()
{
Config.ConStr = _configuration.GetConnectionString("Db");
var model = new SummaryHarianModel();
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 SummaryHarianFilter();
Filter.TglTrxFrom = GF.GetDatetime().Left(10);
Filter.TglTrxUntil = GF.GetDatetime().Left(10);
model.Listdata = await s.SummaryHarian_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 <SummaryHarian> > SummaryHarian_GetSearch(SummaryHarianFilter Filter)
{
var res = new List <SummaryHarian>();
try
{
conn.ConnectionString = Config.ConStr;
using (var connection = conn)
{
connection.Open();
string sql = "exec SP_SummaryHarian_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 SummaryHarian();
d.NamaPenyewa = reader["NamaPenyewa"].ToString();
d.KasirTerimaUang = reader["KasirTerimaUang"].ToString();
d.NamaKasir = reader["NamaKasir"].ToString();
d.TanggalTransaksi = reader["TanggalTransaksi"].ToString();
d.TotalBuku = reader["TotalBuku"].ToString();
d.TotalSewa = reader["TotalSewa"].ToString();
d.UangKembalian = reader["UangKembalian"].ToString();
res.Add(d);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
public async Task <IActionResult> SummaryHarian_Search([Bind("TglTrxFrom,TglTrxUntil")] SummaryHarianFilter data)
{
var model = new SummaryHarianModel();
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.SummaryHarian_GetSearch(data);
return(await Task.Run(() => Json(new { isValid = true, html = Helper.RenderRazorViewToString(this, "SummaryHarian_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 })));
}
}