public static Church getCurentPastorChurch(Pastor p)
{
Church church = new Church();
string req = "SELECT * FROM fgm_church WHERE stationCode in( SELECT codeStationTransfer FROM fgm_pastor_transfer WHERE mleTransferedPastor = '" + p.getCode() + "' and statusTransfert = 'Encours')";
cmd = new MySqlCommand(req, DBConnection.con);
dr = cmd.ExecuteReader();
if (dr.Read())
{
church.setCode(dr["stationCode"].ToString());
church.setName(dr["stationName"].ToString());
church.setDistrict(getDistrictByCode(dr["districtParentReff"].ToString()));
church.setSlogang(dr["stationSlogang"].ToString());
church.setIsDelete(Convert.ToInt32(dr["isBaseArea"]));
}
dr.Close();
return(church);
}
