public TipeBrgModel GetData(string id)
{
TipeBrgModel result = null;
var sSql = @"
SELECT
aa.TipeBrgName, aa.JenisBrgID,
ISNULL(bb.JenisBrgName, '') JenisBrgName
FROM
TipeBrg aa
LEFT JOIN JenisBrg bb ON aa.JenisBrgID = bb.JenisBrgID
WHERE
aa.TipeBrgID = @TipeBrgID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@TipeBrgID", id);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
dr.Read();
result = new TipeBrgModel
{
TipeBrgID = id,
TipeBrgName = dr["TipeBrgName"].ToString(),
JenisBrgID = dr["JenisBrgID"].ToString(),
JenisBrgName = dr["JenisBrgName"].ToString()
};
}
}
}
return(result);
}
private void OKButton_Click(object sender, EventArgs e)
{
var model = new TipeBrgModel
{
TipeBrgID = TipeBrgIDTextBox.Text,
TipeBrgName = TipeBrgNameTextBox.Text,
JenisBrgID = JenisBrgIDTextBox.Text
};
var resultSave = _tipeBrgBL.Save(model);
DialogResult = DialogResult.OK;
}
public void Insert(TipeBrgModel tipeBrg)
{
var sSql = @"
INSERT INTO
TipeBrg (
TipeBrgID, TipeBrgName, JenisBrgID)
VALUES (
@TipeBrgID, @TipeBrgName, @JenisBrgID) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@TipeBrgID", tipeBrg.TipeBrgID);
cmd.AddParam("@TipeBrgName", tipeBrg.TipeBrgName);
cmd.AddParam("@JenisBrgID", tipeBrg.JenisBrgID);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public TipeBrgModel TryValidate(TipeBrgModel tipeBrg)
{
var result = tipeBrg;
if (tipeBrg == null)
{
throw new ArgumentNullException(nameof(tipeBrg));
}
if (tipeBrg.TipeBrgID.Trim() == "")
{
throw new ArgumentException("TipeBrgID empty");
}
if (tipeBrg.TipeBrgName.Trim() == "")
{
throw new ArgumentException("TipeBrgName empty");
}
return(result);
}
public TipeBrgModel Save(TipeBrgModel tipeBrg)
{
// validasi
var result = tipeBrg;
result = TryValidate(tipeBrg);
// save
var dummyTipeBrg = _tipeBrgDal.GetData(tipeBrg.TipeBrgID);
if (dummyTipeBrg == null)
{
_tipeBrgDal.Insert(result);
}
else
{
_tipeBrgDal.Update(result);
}
return(result);
}
public void Update(TipeBrgModel tipeBrg)
{
var sSql = @"
UPDATE
TipeBrg
SET
TipeBrgName = @TipeBrgName,
JenisBrgID = @JenisBrgID
WHERE
TipeBrgID = @TipeBrgID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@TipeBrgID", tipeBrg.TipeBrgID);
cmd.AddParam("@TipeBrgName", tipeBrg.TipeBrgName);
cmd.AddParam("@JenisBrgID", tipeBrg.JenisBrgID);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public IEnumerable <TipeBrgModel> ListData(string jenisBrgID)
{
List <TipeBrgModel> result = null;
var sSql = @"
SELECT
aa.TipeBrgID, aa.TipeBrgName,
aa.JenisBrgID,
ISNULL(bb.JenisBrgName, '') JenisBrgName
FROM
TipeBrg aa
LEFT JOIN JenisBrg bb ON aa.JenisBrgID = bb.JenisBrgID
WHERE
aa.JenisBrgID = @JenisBrgID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisBrgID", jenisBrgID);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
result = new List <TipeBrgModel>();
while (dr.Read())
{
var item = new TipeBrgModel
{
TipeBrgID = dr["TipeBrgID"].ToString(),
TipeBrgName = dr["TipeBrgName"].ToString(),
JenisBrgID = dr["JenisBrgID"].ToString(),
JenisBrgName = dr["JenisBrgName"].ToString()
};
result.Add(item);
}
}
}
}
return(result);
}
