public void Insert(BrgStokHargaModel model)
{
var sSql = @"
INSERT INTO
BrgStokHarga (
BrgID, Qty, Harga )
VALUES (
@BrgID, @Qty, @Harga) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@BrgID", model.BrgID);
cmd.AddParam("@Qty", model.Qty);
cmd.AddParam("@Harga", model.Harga);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(BrgStokHargaModel model)
{
var sSql = @"
UPDATE
BrgStokHarga
SET
Qty = @Qty
WHERE
BrgID = @BrgID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@BrgID", model.BrgID);
cmd.AddParam("@Qty", model.Qty);
cmd.AddParam("@Harga", model.Harga);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void UpdateHarga(string brgID)
{
var price = _brgPriceDal.ListData(brgID).FirstOrDefault();
var stokInfo = _brgStokHargaDal.GetData(brgID);
if (stokInfo == null)
{
stokInfo = new BrgStokHargaModel
{
BrgID = brgID,
Qty = 0,
Harga = Convert.ToDecimal(price.Harga),
};
_brgStokHargaDal.Insert(stokInfo);
}
else
{
stokInfo.Harga = Convert.ToDecimal(price.Harga);
_brgStokHargaDal.Update(stokInfo);
}
}
public void UpdateStok(string brgID)
{
var qtySisa = _brgStokHargaDal.ReCalcQty(brgID);
var stokInfo = _brgStokHargaDal.GetData(brgID);
if (stokInfo == null)
{
stokInfo = new BrgStokHargaModel
{
BrgID = brgID,
Qty = qtySisa,
Harga = 0,
};
_brgStokHargaDal.Insert(stokInfo);
}
else
{
stokInfo.Qty = qtySisa;
_brgStokHargaDal.Update(stokInfo);
}
}
public IEnumerable <BrgStokHargaModel> ListData()
{
List <BrgStokHargaModel> result = null;
var sSql = @"
SELECT
aa.BrgID, aa.Qty, aa.Harga,
ISNULL(bb.BrgName, '') BrgName
FROM
BrgStokHarga aa
LEFT JOIN Brg bb ON aa.BrgID = bb.BrgID
WHERE
bb.IsAktif = 1";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
result = new List <BrgStokHargaModel>();
while (dr.Read())
{
var item = new BrgStokHargaModel
{
BrgID = dr["BrgID"].ToString(),
BrgName = dr["BrgName"].ToString(),
Qty = Convert.ToDecimal(dr["Qty"]),
Harga = Convert.ToDecimal(dr["Harga"])
};
result.Add(item);
}
}
}
return(result);
}
public BrgStokHargaModel GetData(string id)
{
BrgStokHargaModel result = null;
var sSql = @"
SELECT
aa.Qty, aa.Harga,
ISNULL(bb.BrgName, '') BrgName
FROM
BrgStokHarga aa
LEFT JOIN Brg bb ON aa.BrgID = bb.BrgID
WHERE
aa.BrgID = @BrgID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@BrgID", id);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
dr.Read();
result = new BrgStokHargaModel
{
BrgID = id,
BrgName = dr["BrgName"].ToString(),
Qty = Convert.ToDecimal(dr["Qty"]),
Harga = Convert.ToDecimal(dr["Harga"])
};
}
}
return(result);
}
