public void Insert(StokAdjustment2Model stokAdjustment2)
{
var sSql = @"
INSERT INTO
StokAdjustment2 (
StokAdjustmentID, StokAdjustmentID2, NoUrut, BrgID,
QtyAwal, QtyAdjust, QtyAkhir, HppAdjust)
VALUES (
@StokAdjustmentID, @StokAdjustmentID2, @NoUrut, @BrgID,
@QtyAwal, @QtyAdjust, @QtyAkhir, @HppAdjust) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@StokAdjustmentID", stokAdjustment2.StokAdjustmentID);
cmd.AddParam("@StokAdjustmentID2", stokAdjustment2.StokAdjustmentID2);
cmd.AddParam("@NoUrut", stokAdjustment2.NoUrut);
cmd.AddParam("@BrgID", stokAdjustment2.BrgID);
cmd.AddParam("@QtyAwal", stokAdjustment2.QtyAwal);
cmd.AddParam("@QtyAdjust", stokAdjustment2.QtyAdjust);
cmd.AddParam("@QtyAkhir", stokAdjustment2.QtyAkhir);
cmd.AddParam("@HppAdjust", stokAdjustment2.HppAdjust);
conn.Open();
cmd.ExecuteNonQuery();
}
}
private StokAdjustment2Model StokAdjustmentDetilDataFactory()
{
var result = new StokAdjustment2Model
{
BrgID = "B1",
QtyAdjust = 5,
HppAdjust = 2000
};
return(result);
}
public IEnumerable <StokAdjustment2Model> ListData(string stokAdjustmentID)
{
List <StokAdjustment2Model> result = null;
var sSql = @"
SELECT
aa.StokAdjustmentID, aa.StokAdjustmentID2,
aa.NoUrut, aa.BrgID,
aa.QtyAwal, aa.QtyAdjust,
aa.QtyAkhir, aa.HppAdjust,
ISNULL(bb.BrgName, '') BrgName
FROM
StokAdjustment2 aa
LEFT JOIN Brg bb ON aa.BrgID = bb.BrgID
WHERE
aa.StokAdjustmentID = @StokAdjustmentID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@StokAdjustmentID", stokAdjustmentID);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
result = new List <StokAdjustment2Model>();
while (dr.Read())
{
var item = new StokAdjustment2Model
{
StokAdjustmentID = dr["StokAdjustmentID"].ToString(),
StokAdjustmentID2 = dr["StokAdjustmentID2"].ToString(),
NoUrut = Convert.ToInt16(dr["NoUrut"]),
BrgID = dr["BrgID"].ToString(),
BrgName = dr["BrgName"].ToString(),
QtyAwal = Convert.ToDecimal(dr["QtyAwal"]),
QtyAdjust = Convert.ToDecimal(dr["QtyAdjust"]),
QtyAkhir = Convert.ToDecimal(dr["QtyAkhir"]),
HppAdjust = Convert.ToDecimal(dr["HppAdjust"])
};
result.Add(item);
}
}
}
}
return(result);
}
StokAdjustment2Model StokAdjustment22DataFactory()
{
var result = new StokAdjustment2Model
{
StokAdjustmentID = "A1",
StokAdjustmentID2 = "A12",
NoUrut = 2,
BrgID = "B2",
BrgName = "",
QtyAwal = 11,
QtyAdjust = -3,
QtyAkhir = 9,
HppAdjust = 11000
};
return(result);
}
StokAdjustment2Model StokAdjustment2DataFactory()
{
var result = new StokAdjustment2Model
{
StokAdjustmentID = "A1",
StokAdjustmentID2 = "A11",
NoUrut = 1,
BrgID = "B1",
BrgName = "",
QtyAwal = 10,
QtyAdjust = -2,
QtyAkhir = 8,
HppAdjust = 10000
};
return(result);
}
private void SaveTransaksi()
{
var kodeTrs = NoTrsTextBox.Text;
var tglTrs = TanggalDateTime.Value.ToString("dd-MM-yyyy");
var jamTrs = JamTextBox.Text;
var keterangan = KeteranganTextBox.Text;
var dtlTrs = new List <StokAdjustment2Model>();
var noUrut = 0;
List <StokAdjustment2Model> listDetilAdj = null;
foreach (DataRow dr in DetilAdjTable.Rows)
{
if (listDetilAdj == null)
{
listDetilAdj = new List <StokAdjustment2Model>();
}
if (dr["BrgID"].ToString().Trim() == "")
{
continue;
}
var dtlAdj = new StokAdjustment2Model()
{
NoUrut = noUrut,
BrgID = dr["BrgID"].ToString(),
BrgName = "",
QtyAwal = Convert.ToDecimal(dr["QtyAwal"]),
QtyAdjust = Convert.ToDecimal(dr["QtyAdjust"]),
QtyAkhir = Convert.ToDecimal(dr["QtyAkhir"]),
HppAdjust = Convert.ToDecimal(dr["Hpp"])
};
listDetilAdj.Add(dtlAdj);
noUrut++;
}
var stokAdj = new StokAdjustmentModel
{
StokAdjustmentID = kodeTrs,
TglTrs = tglTrs,
JamTrs = jamTrs,
Keterangan = keterangan,
TglVoid = "3000-01-01",
JamVoid = "00:00:00",
UserrID = "",
UserrIDVoid = "",
ListBrg = listDetilAdj
};
StokAdjustmentModel result = null;
using (var trans = TransHelper.NewScope())
{
result = _stokAdjustmentBL.Save(stokAdj);
var resultGenStok = _bpStokBL.Generate(result);
trans.Complete();
}
if (result != null)
{
LastIDLabel.Text = result.StokAdjustmentID;
}
}
