public JenisBrgModel GetData(string id)
{
JenisBrgModel result = null;
var sSql = @"
SELECT
aa.JenisBrgName
FROM
JenisBrg aa
WHERE
aa.JenisBrgID = @JenisBrgID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisBrgID", id);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
dr.Read();
result = new JenisBrgModel
{
JenisBrgID = id,
JenisBrgName = dr["JenisBrgName"].ToString()
};
}
}
}
return(result);
}
public IEnumerable <JenisBrgModel> ListData()
{
List <JenisBrgModel> result = null;
var sSql = @"
SELECT
aa.JenisBrgID, aa.JenisBrgName
FROM
JenisBrg aa ";
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 <JenisBrgModel>();
while (dr.Read())
{
var item = new JenisBrgModel
{
JenisBrgID = dr["JenisBrgID"].ToString(),
JenisBrgName = dr["JenisBrgName"].ToString()
};
result.Add(item);
}
}
}
}
return(result);
}
JenisBrgModel JenisBrg2DataFactory()
{
var result = new JenisBrgModel
{
JenisBrgID = "A2",
JenisBrgName = "B2"
};
return(result);
}
JenisBrgModel JenisBrgDataFactory()
{
var result = new JenisBrgModel
{
JenisBrgID = "A1",
JenisBrgName = "B1",
};
return(result);
}
private void OKButton_Click(object sender, EventArgs e)
{
var jenisBrg = new JenisBrgModel
{
JenisBrgID = JenisBrgIDTextBox.Text,
JenisBrgName = JenisBrgNameTextBox.Text
};
var result = _jenisBrgBL.Save(jenisBrg);
DialogResult = DialogResult.OK;
}
public void Insert(JenisBrgModel jenisBrg)
{
var sSql = @"
INSERT INTO
JenisBrg (
JenisBrgID, JenisBrgName)
VALUES (
@JenisBrgID, @JenisBrgName) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisBrgID", jenisBrg.JenisBrgID);
cmd.AddParam("@JenisBrgName", jenisBrg.JenisBrgName);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(JenisBrgModel jenisBrg)
{
var sSql = @"
UPDATE
JenisBrg
SET
JenisBrgName = @JenisBrgName
WHERE
JenisBrgID = @JenisBrgID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisBrgID", jenisBrg.JenisBrgID);
cmd.AddParam("@JenisBrgName", jenisBrg.JenisBrgName);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public JenisBrgModel TryValidate(JenisBrgModel jenisBrg)
{
var result = jenisBrg;
if (jenisBrg == null)
{
throw new ArgumentNullException(nameof(jenisBrg));
}
if (jenisBrg.JenisBrgID.Trim() == "")
{
throw new ArgumentException("JenisBrgID empty");
}
if (jenisBrg.JenisBrgName.Trim() == "")
{
throw new ArgumentException("JenisBrgName empty");
}
return(result);
}
public JenisBrgModel Save(JenisBrgModel jenisBrg)
{
// validasi
var result = jenisBrg;
result = TryValidate(jenisBrg);
// save
var dummyJenisBrg = _jenisBrgDal.GetData(jenisBrg.JenisBrgID);
if (dummyJenisBrg == null)
{
_jenisBrgDal.Insert(result);
}
else
{
_jenisBrgDal.Update(result);
}
return(result);
}
