public static String checkCodeValueNotDuplicate(String tableName, String codeName, String codeValue, String codeHeader)
{
String err = "";
try
{
String mSQL = String.Format("select * from {0} where {1} = '{2}'", tableName, codeName, codeValue);
DataSet DSetMain = new DataSet();
SqlDataAdapter SQLAdaptor = new MTSQLServer().wAdapter(mSQL, null, false);
SQLAdaptor.Fill(DSetMain, tableName);
int rowNumber = DSetMain.Tables[tableName].Rows.Count;
if (rowNumber > 0)
{
return(Utils.ERR_DUPLICATE_VALUE_OF_FIELD(codeHeader));
}
}
catch (Exception e)
{
err = Utils.ERR_CONNECT_DB;
}
return(err);
}
