public void Insert(StokInModel stokIn)
{
var sSql = @"
INSERT INTO
StokIn (
StokInID, BrgID, TglMasuk, JamMasuk,
TrsMasukID, QtyIn, QtySaldo, Hpp,
StokControlID, TrsDOID)
VALUES (
@StokInID, @BrgID, @TglMasuk, @JamMasuk,
@TrsMasukID, @QtyIn, @QtySaldo, @Hpp,
@StokControlID, @TrsDOID) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@StokInID", stokIn.StokInID);
cmd.AddParam("@BrgID", stokIn.BrgID);
cmd.AddParam("@TglMasuk", stokIn.TglMasuk.ToTglYMD());
cmd.AddParam("@JamMasuk", stokIn.JamMasuk);
cmd.AddParam("@TrsMasukID", stokIn.TrsMasukID);
cmd.AddParam("@QtyIn", stokIn.QtyIn);
cmd.AddParam("@QtySaldo", stokIn.QtySaldo);
cmd.AddParam("@Hpp", stokIn.Hpp);
cmd.AddParam("@StokControlID", stokIn.StokControlID);
cmd.AddParam("@TrsDOID", stokIn.TrsDOID);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public IEnumerable <StokInModel> ListDataByStokControl(string stokControlID)
{
List <StokInModel> result = null;
var sSql = @"
SELECT
aa.StokInID, aa.BrgID, aa.TglMasuk, aa.JamMasuk,
aa.TrsMasukID,
aa.QtyIn, aa.QtySaldo, aa.Hpp,
aa.StokControlID, aa.TrsDOID,
ISNULL(bb.BrgName, '') BrgName
FROM
StokIn aa
LEFT JOIN Brg bb ON aa.BrgID = bb.BrgID
WHERE
aa.StokControlID = @StokControlID
AND aa.QtySaldo <> 0
ORDER BY
aa.StokInID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@StokControlID", stokControlID);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
result = new List <StokInModel>();
while (dr.Read())
{
var item = new StokInModel
{
StokInID = dr["StokInID"].ToString(),
BrgID = dr["BrgID"].ToString(),
BrgName = dr["BrgName"].ToString(),
TglMasuk = dr["TglMasuk"].ToString().ToTglDMY(),
JamMasuk = dr["JamMasuk"].ToString(),
TrsMasukID = dr["TrsMasukID"].ToString(),
QtyIn = Convert.ToInt64(dr["QtyIn"]),
QtySaldo = Convert.ToInt64(dr["QtySaldo"]),
Hpp = Convert.ToDouble(dr["Hpp"]),
StokControlID = dr["StokControlID"].ToString(),
TrsDOID = dr["TrsDOID"].ToString(),
};
result.Add(item);
}
}
}
}
return(result);
}
StokInModel StokInDataFactory2()
{
var result = new StokInModel
{
StokInID = "A2",
BrgID = "B1",
BrgName = "C2",
TglMasuk = "21-01-1990",
JamMasuk = "10:09:09",
TrsMasukID = "D2",
QtyIn = 20,
QtySaldo = 15,
Hpp = 25100,
StokControlID = "E2",
TrsDOID = "F2"
};
return(result);
}
StokInModel StokInDataFactory()
{
var result = new StokInModel
{
StokInID = "A1",
BrgID = "B1",
BrgName = "C1",
TglMasuk = "20-01-1990",
JamMasuk = "09:09:09",
TrsMasukID = "D1",
QtyIn = 30,
QtySaldo = 5,
Hpp = 25900,
StokControlID = "E1",
TrsDOID = "F1"
};
return(result);
}
public void Update(StokInModel stokIn)
{
var sSql = @"
UPDATE
StokIn
SET
BrgID = @BrgID,
TglMasuk = @TglMasuk,
JamMasuk = @JamMasuk,
TrsMasukID = @TrsMasukID,
QtyIn = @QtyIn,
QtySaldo = @QtySaldo,
Hpp = @Hpp,
StokControlID = @StokControlID,
TrsDOID = @TrsDOID
WHERE
StokControlID = @StokControlID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@StokInID", stokIn.StokInID);
cmd.AddParam("@BrgID", stokIn.BrgID);
cmd.AddParam("@TglMasuk", stokIn.TglMasuk.ToTglYMD());
cmd.AddParam("@JamMasuk", stokIn.JamMasuk);
cmd.AddParam("@TrsMasukID", stokIn.TrsMasukID);
cmd.AddParam("@QtyIn", stokIn.QtyIn);
cmd.AddParam("@QtySaldo", stokIn.QtySaldo);
cmd.AddParam("@Hpp", stokIn.Hpp);
cmd.AddParam("@StokControlID", stokIn.StokControlID);
cmd.AddParam("@TrsDOID", stokIn.TrsDOID);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void AddStok(string brgID, decimal qty, double hpp,
string tgl, string jam, string trsMasukID,
string trsDOID, string jenisMutasiID)
{
#region VALIDASI-INPUT
// validasi brg
var brg = _brgBL.GetData(brgID);
if (brg == null)
{
var errMsg = string.Format("BrgID invalid: {0}", brgID);
throw new ArgumentException(errMsg);
}
// cek jenis mutasi
var jenisMutasi = _jenisMutasiBL.GetData(jenisMutasiID);
if (jenisMutasi == null)
{
var errMsg = string.Format("JenisMutasiID invalid : {0}", jenisMutasiID);
throw new ArgumentException(errMsg);
}
if (!jenisMutasi.IsBrgMasuk)
{
var errMsg = string.Format("JenisMutasiID invalid bukan BrgMasuk: {0}", jenisMutasiID);
throw new ArgumentException(errMsg);
}
// validasi tgl
if (!tgl.IsValidTgl("dd-MM-yyyy"))
{
var errMsg = string.Format("Tgl invalid: {0}", tgl);
throw new ArgumentException(errMsg);
}
// validasi jam
if (!tgl.IsValidJam("HH:mm:ss"))
{
var errMsg = string.Format("Jam invalid: {0}", jam);
throw new ArgumentException(errMsg);
}
#endregion
#region PERSIAPAN-ID-TABLE
// contoh StokInID = SI.1901.00031
var prefixStokIn = PREFIX_STOK_IN + DateTime.Now.ToString(".yyMM.");
var stokInID = _paramNoBL.GenNewID(prefixStokIn, 12);
// contoh StokInOutID = SI.1901.00031.001
var prefixStokInOut = stokInID + ".";
var stokInOutID = _paramNoBL.GenNewID(prefixStokInOut, 16);
// contoh StokControlID = DO.1901.00021-B5431
var stokControlID = string.Format("{0}-{1}", trsDOID, brgID);
#endregion
#region PROSES-INSERT-DATA
using (var trans = TransHelper.NewScope())
{
var stokIn = new StokInModel
{
StokInID = stokInID,
BrgID = brgID,
TglMasuk = tgl,
JamMasuk = jam,
TrsMasukID = trsMasukID,
QtyIn = qty,
QtySaldo = qty,
Hpp = hpp,
StokControlID = stokControlID,
TrsDOID = trsDOID,
};
_stokInDal.Insert(stokIn);
var stokInOut = new StokInOutModel
{
StokInID = stokInID,
StokInOutID = stokInOutID,
TglTrs = tgl,
JamTrs = jam,
ReffTrsID = trsMasukID,
JenisMutasiID = jenisMutasiID,
QtyIn = qty,
QtyOut = 0,
Hpp = hpp,
HargaJual = 0
};
_stokInOutDal.Insert(stokInOut);
trans.Complete();
}
#endregion
}
