public CRLocation GetLocation(short oid) { var con = new SQLiteConnection(cs); con.Open(); var cmd = new SQLiteCommand(con) { CommandText = $"select * from CR_Location where [Locat_Cd] = {oid} limit 1" }; var rdr = cmd.ExecuteReader(); var crLocation = new CRLocation(); while (rdr.Read()) { crLocation.LocatCd = rdr.GetInt16(0); crLocation.NameEn = rdr.GetString(1); crLocation.NameAr = rdr.GetString(2); crLocation.ShortNameEn = rdr.GetString(3); crLocation.ShortNameAr = rdr.GetString(4); crLocation.Pin = rdr.GetInt32(5); } cmd.Dispose(); con.Close(); con.Dispose(); return(crLocation); }
private CRLocation GetLocation(short oid) { try { var cs = @ConfigurationManager.ConnectionStrings["slconnection"].ConnectionString; var con = new SQLiteConnection(cs); con.Open(); var cmd = new SQLiteCommand(con) { CommandText = $"select * from CR_Location where [Locat_Cd] = {oid} limit 1" }; var rdr = cmd.ExecuteReader(); var crLocation = new CRLocation(); while (rdr.Read()) { crLocation.LocatCd = rdr.GetInt16(0); crLocation.NameEn = rdr.GetString(1); crLocation.NameAr = rdr.GetString(2); crLocation.ShortNameEn = rdr.GetString(3); crLocation.ShortNameAr = rdr.GetString(4); crLocation.Pin = rdr.GetInt32(5); } cmd.Dispose(); con.Close(); con.Dispose(); return(crLocation); } catch (Exception ex) { Console.WriteLine(ex); throw; } }