// 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;
}
}
