public int GetBackDays()
{
var con = new SQLiteConnection(cs);
con.Open();
var cmd = new SQLiteCommand(con)
{
CommandText = $"select * from CR_Serial"
};
var rdr = cmd.ExecuteReader();
var crSerial = new CRSerial();
while (rdr.Read())
{
crSerial.BackDays = rdr.GetInt32(2);
}
cmd.Dispose();
con.Close();
con.Dispose();
return(crSerial.BackDays != 0 ? crSerial.BackDays : 1);
}
private CRSerial GetCrSerial()
{
var con = new SQLiteConnection(cs);
con.Open();
var cmd = new SQLiteCommand(con)
{
CommandText = $"select * from CR_Serial"
};
var rdr = cmd.ExecuteReader();
var crSerial = new CRSerial();
while (rdr.Read())
{
crSerial.Date = DateTime.Parse(rdr.GetString(0));
crSerial.SerialNumber = rdr.GetInt64(1);
crSerial.BackDays = rdr.GetInt32(2);
}
cmd.Dispose();
con.Close();
con.Dispose();
return(crSerial);
}
private CRSerial GetSerial()
{
string connectionString = ConfigurationManager.ConnectionStrings["reportconnection"].ConnectionString;
var connection = new SqlConnection(connectionString);
connection.Open();
var sqlQuery = "select * from Settings";
var sqlCommand = new SqlCommand(sqlQuery, connection);
var dataReader = sqlCommand.ExecuteReader();
var crSerial = new CRSerial();
while (dataReader.Read())
{
crSerial.Date = DateTime.Parse(dataReader.GetValue(1).ToString());
crSerial.SerialNumber = long.Parse(dataReader.GetValue(2).ToString());
crSerial.BackDays = int.Parse(dataReader.GetValue(3).ToString());
}
dataReader.Close();
sqlCommand.Dispose();
connection.Close();
return(crSerial);
}
