public JenisLunasModel GetData(string id)
{
JenisLunasModel result = null;
var sSql = @"
SELECT
aa.JenisLunasName, aa.JenisBiayaID,
ISNULL(bb.JenisBiayaName, '') JenisBiayaName
FROM
JenisLunas aa
LEFT JOIN JenisBiaya bb ON aa.JenisBiayaID = bb.JenisBiayaID
WHERE
aa.JenisLunasID = @JenisLunasID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisLunasID", id);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
dr.Read();
result = new JenisLunasModel
{
JenisLunasID = id,
JenisLunasName = dr["JenisLunasName"].ToString(),
JenisBiayaID = dr["JenisBiayaID"].ToString(),
JenisBiayaName = dr["JenisBiayaName"].ToString()
};
}
}
}
return(result);
}
public JenisLunasModel TryValidate(JenisLunasModel jenisLunas)
{
var result = jenisLunas;
if (jenisLunas == null)
{
throw new ArgumentNullException(nameof(jenisLunas));
}
if (jenisLunas.JenisLunasID.Trim() == "")
{
throw new ArgumentException("JenisLunasID empty");
}
if (jenisLunas.JenisLunasName.Trim() == "")
{
throw new ArgumentException("JenisLunasName empty");
}
if (jenisLunas.JenisBiayaID.Trim() != "")
{
var jenisBiaya = _jenisBiayaBL.GetData(jenisLunas.JenisBiayaID);
if (jenisBiaya == null)
{
throw new ArgumentException("JenisBiayaID invalid");
}
}
return(result);
}
JenisLunasModel JenisLunas2DataFactory()
{
var result = new JenisLunasModel
{
JenisLunasID = "A2",
JenisLunasName = "B2",
JenisBiayaID = "C2",
JenisBiayaName = ""
};
return(result);
}
public void Insert(JenisLunasModel jenisLunas)
{
var sSql = @"
INSERT INTO
JenisLunas (
JenisLunasID, JenisLunasName, JenisBiayaID )
VALUES (
@JenisLunasID, @JenisLunasName, @JenisBiayaID) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisLunasID", jenisLunas.JenisLunasID);
cmd.AddParam("@JenisLunasName", jenisLunas.JenisLunasName);
cmd.AddParam("@JenisBiayaID", jenisLunas.JenisBiayaID);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(JenisLunasModel jenisLunas)
{
var sSql = @"
UPDATE
JenisLunas
SET
JenisLunasName = @JenisLunasName,
JenisBiayaID = @JenisBiayaID
WHERE
JenisLunasID = @JenisLunasID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisLunasID", jenisLunas.JenisLunasID);
cmd.AddParam("@JenisLunasName", jenisLunas.JenisLunasName);
cmd.AddParam("@JenisBiayaID", jenisLunas.JenisBiayaID);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public JenisLunasModel Save(JenisLunasModel jenisLunas)
{
// validasi
var result = jenisLunas;
result = TryValidate(jenisLunas);
// save
var dummyJenisLunas = _jenisLunasDal.GetData(jenisLunas.JenisLunasID);
if (dummyJenisLunas == null)
{
_jenisLunasDal.Insert(result);
}
else
{
_jenisLunasDal.Update(result);
}
return(result);
}
public IEnumerable <JenisLunasModel> ListData()
{
List <JenisLunasModel> result = null;
var sSql = @"
SELECT
aa.JenisLunasID, aa.JenisLunasName, aa.JenisBiayaID,
ISNULL(bb.JenisBiayaName, '') JenisBiayaName
FROM
JenisLunas aa
LEFT JOIN JenisBiaya bb ON aa.JenisBiayaID = bb.JenisBiayaID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
result = new List <JenisLunasModel>();
while (dr.Read())
{
var item = new JenisLunasModel
{
JenisLunasID = dr["JenisLunasID"].ToString(),
JenisLunasName = dr["JenisLunasName"].ToString(),
JenisBiayaID = dr["JenisBiayaID"].ToString(),
JenisBiayaName = dr["JenisBiayaName"].ToString()
};
result.Add(item);
}
}
}
}
return(result);
}
