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 }