Comments by Mizanur Rahman (Top 6 by date)

internal string GenerateNewCode()
{
try
{
DateTime Today = DateTime.Today;
var Year = DateTime.Now.ToString("yyyy");
var Month = DateTime.Now.Month;
var Day = DateTime.Now.Day;

string InvoiceCode = null;
InvoiceCode = "SVR" + Year + "" + Month + "" + Day + 0 + GetCountTRNo(Today);
return InvoiceCode;
}
catch (Exception ex)
{
throw ex;
}
}

private string GetCountTRNo(DateTime Today)
{
try
{
string conn = ConfigurationManager.ConnectionStrings["ConnectionStrings"].ConnectionString;

DataAccessEX ado = new DataAccessEX();
int maxid = 0;
maxid = Int32.Parse(ado.AggRetrive("select COUNT(distinct Column) from DataTable where Data = '" + Today + "'", conn).ToString());
return (maxid + 1).ToString();
}
catch (Exception ex)
{
throw ex;
}
}