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