private void setReleaseId()
{
try
{
string curr_date = DateTime.Today.ToString("yyyy/MM/dd").Replace("/", "");
int prefix = MANAGEDB.getIdPrefix("stockReleaseId");
string newId = string.Concat(curr_date, prefix.ToString(), "0001");
//get max item Id
long maxId = MANAGEDB.getMaxId("releaseId", "tbl_stockrelease");
//if there are no any id in db
if (maxId <= 1)
{
//set the start Id
txt_releaseId.Text = newId;
}
else
{
string tmp = maxId.ToString().Substring(0, 8);
//same day stock entry
if (string.Equals(curr_date, tmp))
{
txt_releaseId.Text = maxId.ToString();
}
//different day stock entry
else
{
txt_releaseId.Text = newId;
}
}
}
catch (Exception ex)
{
throw ex;
}
}