public List <OrganizationDistDivisionInfo> GetOrganizationDetail(int a, int b)
{
List <OrganizationDistDivisionInfo> bldOrganizationInfos = null;
string query = "SELECT b.OrganizationName,b.Address,b.Mobile,b.Email,d.DistrictName,div.DivisionName FROM BldOrganizationInfo b JOIN DistrictInfo d ON d.Id=b.DistrictInfoId JOIN DivisionInfo div ON div.Id=b.DivisionInfoId WHERE d.Id='" + b + "' AND div.Id='" + a + "'";
Connection.Open();
Command = new SqlCommand(query, Connection);
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
bldOrganizationInfos = new List <OrganizationDistDivisionInfo>();
while (Reader.Read())
{
OrganizationDistDivisionInfo bldOrganizationInfo = new OrganizationDistDivisionInfo
{
OrganizationName = Reader["OrganizationName"].ToString(),
Address = Reader["Address"].ToString(),
Mobile = Reader["Mobile"].ToString(),
Email = Reader["Email"].ToString(),
DistrictName = Reader["DistrictName"].ToString(),
DivisionName = Reader["DivisionName"].ToString()
};
bldOrganizationInfos.Add(bldOrganizationInfo);
}
Reader.Close();
}
Connection.Close();
return(bldOrganizationInfos);
}
public List <OrganizationDistDivisionInfo> GetOrganizationDetail()
{
List <OrganizationDistDivisionInfo> bldOrganizationInfos = null;
string query = "SELECT b.Id,b.OrganizationName,b.Address,b.Mobile,b.Email,d.DistrictName,div.DivisionName,b.CreatedAt FROM BldOrganizationInfo b JOIN DistrictInfo d ON d.Id=b.DistrictInfoId JOIN DivisionInfo div ON div.Id=b.DivisionInfoId";
Connection.Open();
Command = new SqlCommand(query, Connection);
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
bldOrganizationInfos = new List <OrganizationDistDivisionInfo>();
while (Reader.Read())
{
OrganizationDistDivisionInfo bldOrganizationInfo = new OrganizationDistDivisionInfo
{
BldOrganizationInfoId = (int)Reader["Id"],
OrganizationName = Reader["OrganizationName"].ToString(),
Address = Reader["Address"].ToString(),
Mobile = Reader["Mobile"].ToString(),
Email = Reader["Email"].ToString(),
DistrictName = Reader["DistrictName"].ToString(),
DivisionName = Reader["DivisionName"].ToString(),
CreatedAt = (DateTime)Reader["CreatedAt"]
};
bldOrganizationInfos.Add(bldOrganizationInfo);
}
Reader.Close();
}
Connection.Close();
return(bldOrganizationInfos);
}
