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