// TODO ->> duplicate with DocumentsDAL public int GetNextDocCounter(eCounterNo counterNo) { try { using (var connection = new OdbcConnection(this.ConnetionString)) { connection.Open(); var query = $@"SELECT Value FROM DocsCounters WHERE counterno={(int)counterNo}"; var command = new OdbcCommand(query); command.Connection = connection; var value = Convert.ToInt32(command.ExecuteScalar()); if (value == 0) { throw new Exception("No Counter Found!"); } return(value); } } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }
// TODO ->> duplicate with DocumentsDAL public bool SetNextDocCounter(eCounterNo counterNo) { using (var connection = new OdbcConnection(this.ConnetionString)) { connection.Open(); var command = new OdbcCommand(); command.Connection = connection; return(this.SetNextDocCounter(counterNo, command)); } }
// ----- // TODO ->> duplicate with DocumentsDAL private bool SetNextDocCounter(eCounterNo counterNo, OdbcCommand command) { try { var query = $@" UPDATE DocsCounters SET Value = (Value + 1) WHERE counterno={(int)counterNo} "; command.CommandText = query; command.ExecuteNonQuery(); return(true); } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } }