public SubJenisBrgModel GetData(string id)
{
SubJenisBrgModel result = null;
var sSql = @"
SELECT
aa.SubJenisBrgName, aa.JenisBrgID,
ISNULL(bb.JenisBrgID, '') JenisBrgName
FROM
SubJenisBrg aa
LEFT JOIN JenisBrg bb ON aa.JenisBrgID = bb.JenisBrgID
WHERE
aa.SubJenisBrgID = @SubJenisBrgID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@SubJenisBrgID", id);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
dr.Read();
result = new SubJenisBrgModel
{
SubJenisBrgID = id,
SubJenisBrgName = dr["SubJenisBrgName"].ToString(),
JenisBrgID = dr["JenisBrgID"].ToString(),
JenisBrgName = dr["JenisBrgName"].ToString(),
};
}
}
}
return(result);
}
public SubJenisBrgModel TryValidate(SubJenisBrgModel subJenisBrg)
{
var result = subJenisBrg;
if (subJenisBrg == null)
{
throw new ArgumentNullException(nameof(subJenisBrg));
}
if (subJenisBrg.SubJenisBrgID.Trim() == "")
{
throw new ArgumentException("SubJenisBrgID empty");
}
if (subJenisBrg.SubJenisBrgName.Trim() == "")
{
throw new ArgumentException("SubJenisBrgName empty");
}
var jenisBrg = _jenisBrgBL.GetData(subJenisBrg.JenisBrgID);
if (jenisBrg == null)
{
throw new ArgumentException("JenisBrgID invalid");
}
else
{
subJenisBrg.JenisBrgName = jenisBrg.JenisBrgName;
}
return(result);
}
SubJenisBrgModel SubJenisBrg2DataFactory()
{
var result = new SubJenisBrgModel
{
SubJenisBrgID = "A2",
SubJenisBrgName = "B2",
JenisBrgID = "C2"
};
return(result);
}
SubJenisBrgModel SubJenisBrgDataFactory()
{
var result = new SubJenisBrgModel
{
SubJenisBrgID = "A1",
SubJenisBrgName = "B1",
JenisBrgID = "C1"
};
return(result);
}
private void OKButton_Click(object sender, EventArgs e)
{
var model = new SubJenisBrgModel
{
SubJenisBrgID = SubJenisBrgIDTextBox.Text,
SubJenisBrgName = SubJenisBrgNameTextBox.Text,
JenisBrgID = JenisBrgIDTextBox.Text
};
var resultSave = _subJenisBrgBL.Save(model);
DialogResult = DialogResult.OK;
}
SubJenisBrgModel SubJenisBrgDataFactory2()
{
var result = new SubJenisBrgModel
{
SubJenisBrgID = "A2",
SubJenisBrgName = "B2",
JenisBrgID = "C2",
JenisBrgName = "D2"
};
_jenisBrgBL.Setup(x => x.GetData(It.IsAny <string>())).Returns(new JenisBrgModel());
return(result);
}
public void Update(SubJenisBrgModel subJenisBrg)
{
var sSql = @"
UPDATE
SubJenisBrg
SET
SubJenisBrgName = @SubJenisBrgName,
JenisBrgID = @JenisBrgID
WHERE
SubJenisBrgID = @SubJenisBrgID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@SubJenisBrgID", subJenisBrg.SubJenisBrgID);
cmd.AddParam("@SubJenisBrgName", subJenisBrg.SubJenisBrgName);
cmd.AddParam("@JenisBrgID", subJenisBrg.JenisBrgID);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Insert(SubJenisBrgModel subJenisBrg)
{
var sSql = @"
INSERT INTO
SubJenisBrg (
SubJenisBrgID, SubJenisBrgName,
JenisBrgID)
VALUES (
@SubJenisBrgID, @SubJenisBrgName,
@JenisBrgID) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@SubJenisBrgID", subJenisBrg.SubJenisBrgID);
cmd.AddParam("@SubJenisBrgName", subJenisBrg.SubJenisBrgName);
cmd.AddParam("@JenisBrgID", subJenisBrg.JenisBrgID);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public SubJenisBrgModel Save(SubJenisBrgModel subJenisBrg)
{
// validasi
var result = subJenisBrg;
result = TryValidate(subJenisBrg);
// save
var dummySubJenisBrg = _subJenisBrgDal.GetData(subJenisBrg.SubJenisBrgID);
if (dummySubJenisBrg == null)
{
_subJenisBrgDal.Insert(result);
}
else
{
_subJenisBrgDal.Update(result);
}
return(result);
}
public IEnumerable <SubJenisBrgModel> ListData(string jenisBrgID)
{
List <SubJenisBrgModel> result = null;
var sSql = @"
SELECT
aa.SubJenisBrgID, aa.SubJenisBrgName,
aa.JenisBrgID,
ISNULL(bb.JenisBrgName, '') JenisBrgName
FROM
SubJenisBrg 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 <SubJenisBrgModel>();
while (dr.Read())
{
var item = new SubJenisBrgModel
{
SubJenisBrgID = dr["SubJenisBrgID"].ToString(),
SubJenisBrgName = dr["SubJenisBrgName"].ToString(),
JenisBrgID = dr["JenisBrgID"].ToString(),
JenisBrgName = dr["JenisBrgName"].ToString()
};
result.Add(item);
}
}
}
}
return(result);
}
void LoadBrgGrid(string subJenisBrgID)
{
BarangGrid.Rows.Clear();
var subJenisBrg = new SubJenisBrgModel
{
SubJenisBrgID = subJenisBrgID
};
var listBrg = _brgBL.ListData(subJenisBrg);
if (listBrg == null)
{
return;
}
PrgBar.Value = 0;
PrgBar.Maximum = listBrg.Count();
foreach (var item in listBrg.OrderBy(x => x.BrgName))
{
PrgBar.Value++;
object[] rowData = { item.BrgID, item.BrgName, item.JenisBrgName,
item.SubJenisBrgName, item.MerkName, item.Kemasan,
item.ColorID };
BarangGrid.Rows.Add(rowData);
if (item.ColorID.Trim() != "")
{
var color = _colorBL.GetData(item.ColorID);
if (color != null)
{
BarangGrid.Rows[PrgBar.Value - 1].Cells["ColorID"].Style.BackColor = _colorBL.GetFromRGB(color);
if (color.IsWhiteForeColor)
{
BarangGrid.Rows[PrgBar.Value - 1].Cells["ColorID"].Style.ForeColor = Color.White;
}
}
}
}
PrgBar.Value = 0;
ClearDetilBrg();
}
public IEnumerable <BrgModel> ListData(SubJenisBrgModel subJenisBrg)
{
return(ListData(TipeListDataEnum.SubJenisBrg, subJenisBrg.SubJenisBrgID));
}
public IEnumerable <BrgModel> ListData(SubJenisBrgModel subJenisBrg)
{
return(_brgDal.ListData(subJenisBrg));
}
