public string getthanaNamebythanaId(int ias) { thana_tb aTb = new thana_tb(); string name = ""; var highScores = from oTb in db.thana_tb where oTb.thanaID == ias select oTb; if (highScores.Count() == 1) { foreach (var VAR1 in highScores) { name = VAR1.thanaName; } } return(name); }
public List <thana_tb> get_thanadata() { List <thana_tb> aTbs = new List <thana_tb>(); var highScores = db.thana_tb; foreach (var VAR1 in highScores) { thana_tb aTb = new thana_tb(); aTb.thanaID = VAR1.thanaID; aTb.thanaName = VAR1.thanaName; aTb.districtID = VAR1.districtID; aTb.districtName = VAR1.districtName; aTbs.Add(aTb); } return(aTbs); }