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