public int getMaxUserID() { int maxUserId = 1; try { string querry1 = "SELECT MAX(userId) from tbl_login;"; maxUserId = CONN.getMaxId(querry1); //create userId for the first time if (maxUserId <= 1) { //maxUserId += 1000; string querry2 = "SELECT prefixValue FROM tbl_prefix WHERE prefixName = 'userId';"; maxUserId = CONN.getPrefix(querry2); int tmp = Convert.ToInt32(string.Concat(maxUserId.ToString(), "0000")) + 1; maxUserId = tmp; } } catch (Exception e) { throw e; } return(maxUserId); }
public int getMaxItemId() { int maxItemId = 1; try { string querry = "SELECT MAX(itemId) from tbl_item;"; maxItemId = CONN.getMaxId(querry); //create ItemId for the first time if (maxItemId <= 1) { //maxId += 40000; string querry2 = "SELECT prefixValue FROM tbl_prefix WHERE prefixName = 'itemId';"; maxItemId = CONN.getPrefix(querry2); int tmp = Convert.ToInt32(string.Concat(maxItemId.ToString(), "0000")) + 1; maxItemId = tmp; } } catch (Exception ex) { throw ex; } return(maxItemId); }