public List <viewUpazila> GetUpazilaInfo(Upazila upazila)
{
string sql = string.Format(@"SELECT [UpazilaCode],[UpazilaNameBangla] FROM [dbo].[viewUpazila] WHERE [DistrictCode]='{0}'", upazila.DistrictCode);
var result = _unitOfWork.context.Database.SqlQuery <viewUpazila>(sql).ToList();
return(result);
}
public List <Upazila> GetUpazilaByDistrictCode(Upazila query)
{
List <Upazila> result = new List <Upazila>();
string sql = string.Format(@"SELECT DISTINCT s.DistrictCode,u.UpazilaCode ,u.UpazilaName,u.UpazilaNameBangla
FROM dbo.TPDGeoLocation s
inner join GeoLocation.dbo.Upazila u on u.DistrictCode=s.DistrictCode where s.DistrictCode='{0}' and u.UpazilaName like '%{1}%'", query.DistrictCode, query.UpazilaName);
result = _unitOfWork.context.Database.SqlQuery <Upazila>(sql).ToList();
return(result);
}