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