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