public string GenerateCode(string prefix)
{
var codeGenerating = _shoppingContext.CodeGeneratings.FirstOrDefault(x =>
x.Prefix.Equals(prefix, StringComparison.CurrentCultureIgnoreCase));
if (codeGenerating != null)
{
var currentDate = DateTime.Now.Date;
if (currentDate.Date.Equals(codeGenerating.LastGeneratedDateTime.Date))
{
codeGenerating.GeneratingNumber++;
}
else
{
codeGenerating.GeneratingNumber = 0;
codeGenerating.LastGeneratedDateTime = currentDate;
}
UpdateGenerateCode(codeGenerating);
}
else
{
codeGenerating = new CodeGenerating()
{
GeneratingNumber = 0,
LastGeneratedDateTime = DateTime.Now.Date,
Prefix = prefix
};
InsertGenerateCode(codeGenerating);
}
var res = prefix + codeGenerating.LastGeneratedDateTime.ToString("_yyyyMMdd_") + codeGenerating.GeneratingNumber.ToString();
return(res);
}
private void UpdateGenerateCode(CodeGenerating codeGenerating)
{
_shoppingContext.SaveChanges();
}
private void InsertGenerateCode(CodeGenerating codeGenerating)
{
_shoppingContext.CodeGeneratings.Add(codeGenerating);
_shoppingContext.SaveChanges();
}
