public string GenNewID(string prefix, int length)
{
var result = prefix;
var newParamNo = _parameterNoDal.GetData(prefix);
long newNo;
if (newParamNo == null)
{
newParamNo = new ParameterNoModel
{
Prefix = prefix,
Value = 2
};
newNo = 1;
_parameterNoDal.Insert(newParamNo);
}
else
{
newNo = newParamNo.Value;
newParamNo.Value++;
_parameterNoDal.Update(newParamNo);
}
string newNoString = newNo.ToString().PadLeft(length - prefix.Length, '0');
result = prefix + newNoString;
return(result);
}
public ParameterNoModel GetData(string id)
{
ParameterNoModel result = null;
var sSql = @"
SELECT
aa.Value
FROM
ParameterNo aa
WHERE
aa.Prefix = @Prefix ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@Prefix", id);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
dr.Read();
result = new ParameterNoModel
{
Prefix = id,
Value = Convert.ToInt64(dr["Value"])
};
}
}
}
return(result);
}
public IEnumerable <ParameterNoModel> ListData()
{
List <ParameterNoModel> result = null;
var sSql = @"
SELECT
aa.Prefix, aa.Value
FROM
ParameterNo aa ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
result = new List <ParameterNoModel>();
while (dr.Read())
{
var item = new ParameterNoModel
{
Prefix = dr["Prefix"].ToString(),
Value = Convert.ToInt64(dr["Value"])
};
result.Add(item);
}
}
}
}
return(result);
}
ParameterNoModel ParameterNo2DataFactory()
{
var result = new ParameterNoModel
{
Prefix = "A2",
Value = 2
};
return(result);
}
public void Insert(ParameterNoModel parameterNo)
{
var sSql = @"
INSERT INTO
ParameterNo (
Prefix, Value)
VALUES (
@Prefix, @Value) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@Prefix", parameterNo.Prefix);
cmd.AddParam("@Value", parameterNo.Value);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(ParameterNoModel parameterNo)
{
var sSql = @"
UPDATE
ParameterNo
SET
Value = @Value
WHERE
Prefix = @Prefix ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@Prefix", parameterNo.Prefix);
cmd.AddParam("@Value", parameterNo.Value);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public ParameterNoModel TryValidate(ParameterNoModel parameterNo)
{
var result = parameterNo;
if (parameterNo == null)
{
throw new ArgumentNullException(nameof(parameterNo));
}
if (parameterNo.Prefix.Trim() == "")
{
throw new ArgumentException("Prefix empty");
}
if (parameterNo.Value == 0)
{
throw new ArgumentException("Value empty");
}
return(result);
}
public ParameterNoModel Save(ParameterNoModel parameterNo)
{
// validasi
var result = parameterNo;
result = TryValidate(parameterNo);
// save
var dummyParameterNo = _parameterNoDal.GetData(parameterNo.Prefix);
if (dummyParameterNo == null)
{
_parameterNoDal.Insert(result);
}
else
{
_parameterNoDal.Update(result);
}
return(result);
}