public IParamNoModel GetData(IParamNoKey key) { ParamNoModel result = null; var sql = @" SELECT ParamValue FROM OFTA_ParamNo WHERE ParamID = @ParamID "; using (var conn = new SqlConnection(ConnStringHelper.Get())) using (var cmd = new SqlCommand(sql, conn)) { cmd.AddParam("@ParamID", key.ParamID, SqlDbType.VarChar); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (!dr.HasRows) { return(null); } dr.Read(); result = new ParamNoModel() { ParamID = key.ParamID, ParamValue = dr["ParamValue"].ToString() }; } } return(result); }
private string GenNewID(IParamNoKey key) { /* Cek apakah paramkey sudah ada di database * Jika sudah ada, ambil nilai-nya, setu retVal, * dan tambahkan satu (hexa-desimal mode) */ var param = _paramNoDal.GetData(key); if (param == null) { param = new ParamNoModel { ParamID = key.ParamID, ParamValue = "0" } } ; var retVal = param.ParamValue; param.ParamValue = AddHexa(param.ParamValue, "1"); _paramNoDal.Delete(key); _paramNoDal.Insert(param); return(retVal); }
public void Delete(IParamNoKey key) { var sql = @" DELETE OFTA_ParamNo WHERE ParamID = @ParamID "; using (var conn = new SqlConnection(ConnStringHelper.Get())) using (var cmd = new SqlCommand(sql, conn)) { cmd.AddParam("@ParamID", key.ParamID, SqlDbType.VarChar); conn.Open(); cmd.ExecuteNonQuery(); } }