public async Task <IActionResult> KonfirmasiTransaksi()
{
Config.ConStr = _configuration.GetConnectionString("Db");
var model = new LogConfirmationModel();
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 logConfirmation();
Filter.IdPenyewa = HttpContext.Session.GetString("_UserId").ToInt();
model.ListData = await s.KonfirmasiTransaksi_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 <IActionResult> KonfirmasiTransaksi_Bayar([Bind("IdTrx,CreateDate,IdPenyewa," +
"Qty,TotalSewa,StatusConfirm,NamaPenyewa,KasirTerimaUang,UangKembalian")] logConfirmation 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.IdKasir = HttpContext.Session.GetString("_UserId").ToInt();
r = await s.KonfirmasiTransaksi_Bayar(data);
if (r.MessageStatus == "success")
{
return(await Task.Run(() => Json(new { isValid = true, message = r.MessageContent, title = r.MessageTitle })));
}
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 })));
}
}
}
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 })));
}
}
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 })));
}
}
public async Task <IActionResult> KonfirmasiTransaksi_Search([Bind("IdTrx,NamaPenyewa")] logConfirmation data)
{
var model = new LogConfirmationModel();
var r = new ErrorViewModel();
try
{
model.ListData = await s.KonfirmasiTransaksi_GetSearch(data);
return(await Task.Run(() => Json(new { isValid = true, html = Helper.RenderRazorViewToString(this, "KonfirmasiTransaksi_Table", model) })));
}
catch (Exception ex)
{
r.MessageContent = ex.ToString();
r.MessageTitle = "Error ";
r.RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier;
model.Error = r;
return(await Task.Run(() => Json(new
{
isValid = false,
message = r.MessageContent,
title = r.MessageTitle,
html = Helper.RenderRazorViewToString(this, "KonfirmasiTransaksi_Table", model)
})));
}
//if (ModelState.IsValid)
//{
//}
//else
//{
// r.MessageContent = "State Model tidak valid";
// r.MessageTitle = "Error ";
// r.RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier;
// model.Error = r;
// return await Task.Run(() => Json(new
// {
// isValid = false,
// message = r.MessageContent,
// title = r.MessageTitle,
// html = Helper.RenderRazorViewToString(this, "KonfirmasiTransaksi_Table", model)
// }));
//}
}
public async Task <List <logConfirmation> > KonfirmasiTransaksi_GetSearch(logConfirmation Data)
{
var res = new List <logConfirmation>();
try
{
conn.ConnectionString = Config.ConStr;
using (var connection = conn)
{
connection.Open();
string sql = "exec SP_KonfirmasiTransaksi_GetSearch " +
"@IdTrx='" + Data.IdTrx + "'," +
"@NamaPenyewa='" + Data.NamaPenyewa + "'" +
"";
using (var command = new SqlCommand(sql, connection))
{
command.CommandTimeout = 0;
using (var reader = await command.ExecuteReaderAsync())
{
while (reader.Read())
{
var d = new logConfirmation();
d.IdTrx = reader["IdTrx"].ToString().ToInt();
d.CreateDate = reader["CreateDate"].ToString();
d.IdPenyewa = reader["IdPenyewa"].ToString().ToInt();
d.NamaPenyewa = reader["NamaPenyewa"].ToString();
d.Qty = reader["Qty"].ToString().ToInt();
d.StatusConfirm = reader["StatusConfirm"].ToString().ToInt();
d.TotalSewa = reader["TotalSewa"].ToString().toNumber();
res.Add(d);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
public async Task <logConfirmation> KonfirmasiTransaksi_GetById(int Id)
{
var res = new logConfirmation();
try
{
conn.ConnectionString = Config.ConStr;
using (var connection = conn)
{
connection.Open();
string sql = "exec SP_KonfirmasiTransaksi_GetById @Id=" + Id + "" +
"";
using (var command = new SqlCommand(sql, connection))
{
command.CommandTimeout = 0;
using (var reader = await command.ExecuteReaderAsync())
{
while (reader.Read())
{
res.CreateDate = reader["CreateDate"].ToString();
res.IdPenyewa = reader["IdPenyewa"].ToString().ToInt();
res.IdTrx = reader["IdTrx"].ToString().ToInt();
res.NamaPenyewa = reader["NamaPenyewa"].ToString();
res.Qty = reader["Qty"].ToString().ToInt();
res.StatusConfirm = reader["StatusConfirm"].ToString().ToInt();
res.TotalSewa = reader["TotalSewa"].ToString();
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(res);
}
public async Task <ErrorViewModel> KonfirmasiTransaksi_Bayar(logConfirmation Data)
{
var res = new ErrorViewModel();
try
{
Data.TotalSewa = Data.TotalSewa.toDecimal().ToString();
Data.KasirTerimaUang = Data.KasirTerimaUang.toDecimal().ToString();
Data.UangKembalian = Data.UangKembalian.toDecimal().ToString();
conn.ConnectionString = Config.ConStr;
using (var connection = conn)
{
connection.Open();
string sql = "exec SP_KonfirmasiTransaksi_Bayar ";
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);
}
