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();
}
}
