/// <summary>
/// Method to Get AutoNumber
/// </summary>
/// <param name="Description">Description as Input</param>
/// <returns>Returns AutoNumber</returns>
public string GetAutoNumber(string Description)
{
string AutoNo = "";
int CurNo = 0;
int NoDigit = 0;
int AutoCode = 0;
int i = 0;
string SqlStr;
SqlStr = "select * from SAS_AutoNumber where SAAN_Des='" + Description + "'";
try
{
Microsoft.Practices.EnterpriseLibrary.Data.Database loDbAut = DatabaseFactory.CreateDatabase(csConnectionStr);
DbCommand cmd = loDbAut.GetSqlStringCommand(SqlStr);
IDataReader loReader = loDbAut.ExecuteReader(cmd);
if (loReader.Read())
{
AutoCode = Convert.ToInt32(loReader["SAAN_Code"]);
CurNo = Convert.ToInt32(loReader["SAAN_CurNo"]) + 1;
NoDigit = Convert.ToInt32(loReader["SAAN_NoDigit"]);
AutoNo = Convert.ToString(loReader["SAAN_Prefix"]);
if (CurNo.ToString().Length < NoDigit)
{
while (i < NoDigit - CurNo.ToString().Length)
{
AutoNo = AutoNo + "0";
i = i + 1;
}
AutoNo = AutoNo + CurNo;
}
loReader.Close();
}
AutoNumberEn loItem = new AutoNumberEn();
loItem.SAAN_Code = AutoCode;
AutoNumberDAL cods = new AutoNumberDAL();
cods.GetItem(loItem);
loItem.SAAN_Code = Convert.ToInt32(AutoCode);
loItem.SAAN_CurNo = CurNo;
loItem.SAAN_AutoNo = AutoNo;
cods.Update(loItem);
return(AutoNo);
}
catch (Exception ex)
{
Console.Write("Error in connection : " + ex.Message);
return(ex.ToString());
}
}
/// <summary>
/// Method to Get AutoNumber
/// </summary>
/// <param name="Description">Description as Input</param>
/// <returns>Returns AutoNumber</returns>
public string GetAutoNumber(string Description)
{
string AutoNo = "";
int CurNo = 0;
int NoDigit = 0;
int AutoCode = 0;
int i = 0;
string SqlStr;
SqlStr = "select * from SAS_AutoNumber where SAAN_Des='" + Description + "'";
try
{
IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, SqlStr).CreateDataReader();
if (loReader.Read())
{
AutoCode = Convert.ToInt32(loReader["SAAN_Code"]);
CurNo = Convert.ToInt32(loReader["SAAN_CurNo"]) + 1;
NoDigit = Convert.ToInt32(loReader["SAAN_NoDigit"]);
AutoNo = Convert.ToString(loReader["SAAN_Prefix"]);
if (CurNo.ToString().Length < NoDigit)
{
while (i < NoDigit - CurNo.ToString().Length)
{
AutoNo = AutoNo + "0";
i = i + 1;
}
AutoNo = AutoNo + CurNo;
}
loReader.Close();
}
AutoNumberEn loItem = new AutoNumberEn();
loItem.SAAN_Code = AutoCode;
AutoNumberDAL cods = new AutoNumberDAL();
cods.GetItem(loItem);
loItem.SAAN_Code = Convert.ToInt32(AutoCode);
loItem.SAAN_CurNo = CurNo;
loItem.SAAN_AutoNo = AutoNo;
cods.Update(loItem);
return(AutoNo);
}
catch (Exception ex)
{
Console.Write("Error in connection : " + ex.Message);
return(ex.ToString());
}
}
