public Situs ReturnSitusInfo(string propertyId)
{
Situs retVal = new Situs();
Dal dal = new Dal();
try
{
dal.ConnectionString = ReturnConnString();
dal.Connect();
DataSet ds = dal.ReturnDatasetFromStoredProcByPropID("ReturnSitusByPropID", propertyId);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
retVal.Property = propertyId;
retVal.MapTaxLot = String.IsNullOrEmpty(dr["MapTaxLot"].ToString())
? string.Empty: dr["MapTaxLot"].ToString();
retVal.Stat = String.IsNullOrEmpty(dr["Stat"].ToString())
? string.Empty : dr["Stat"].ToString();
retVal.SitusNum = String.IsNullOrEmpty(dr["SitusNum"].ToString())
? string.Empty : dr["SitusNum"].ToString();
retVal.SitusStreet = String.IsNullOrEmpty(dr["SitusStreet"].ToString())
? string.Empty : dr["SitusStreet"].ToString();
retVal.SitSufx1 = String.IsNullOrEmpty(dr["SitSufx1"].ToString())
? string.Empty : dr["SitSufx1"].ToString();
retVal.SitSufx2 = String.IsNullOrEmpty(dr["SitSufx2"].ToString())
? string.Empty : dr["SitSufx2"].ToString();
retVal.SitusPrefix = String.IsNullOrEmpty(dr["SitusPrefix"].ToString())
? string.Empty : dr["SitusPrefix"].ToString();
retVal.SitusCity = String.IsNullOrEmpty(dr["SitusCity"].ToString())
? string.Empty : dr["SitusCity"].ToString();
retVal.SitusState = String.IsNullOrEmpty(dr["SitusState"].ToString())
? string.Empty : dr["SitusState"].ToString();
retVal.SitusZip = String.IsNullOrEmpty(dr["SitusZip"].ToString())
? string.Empty : dr["SitusZip"].ToString();
retVal.CodeArea = String.IsNullOrEmpty(dr["CodeArea"].ToString())
? string.Empty : dr["CodeArea"].ToString();
retVal.Pclass = String.IsNullOrEmpty(dr["Pclass"].ToString())
? string.Empty : dr["Pclass"].ToString();
retVal.OwnerName = String.IsNullOrEmpty(dr["OwnerName"].ToString())
? string.Empty : dr["OwnerName"].ToString();
retVal.NameAddress = String.IsNullOrEmpty(dr["NameAddress"].ToString())
? string.Empty : dr["NameAddress"].ToString();
retVal.NameAddress15 = String.IsNullOrEmpty(dr["NameAddress15"].ToString())
? string.Empty : dr["NameAddress15"].ToString();
retVal.City = String.IsNullOrEmpty(dr["City"].ToString())
? string.Empty : dr["City"].ToString();
retVal.St = String.IsNullOrEmpty(dr["St"].ToString())
? string.Empty : dr["St"].ToString();
retVal.Zip = String.IsNullOrEmpty(dr["Zip"].ToString())
? string.Empty : dr["Zip"].ToString();
}
dal.Disconnect();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(retVal);
}
public List <DeedHistory> ReturnDeedHistory(string propertyId)
{
List <DeedHistory> retVal = new List <DeedHistory>();
Dal dal = new Dal();
try
{
dal.ConnectionString = ReturnConnString();
dal.Connect();
DataSet ds = dal.ReturnDatasetFromStoredProcByPropID("ReturnDeedHistoryByPropID", propertyId);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
DeedHistory dh = new DeedHistory();
dh.PropId = propertyId;
dh.Maplot = String.IsNullOrEmpty(dr["MapTaxLot"].ToString())
? string.Empty : dr["MapTaxLot"].ToString();
dh.Deeddate = String.IsNullOrEmpty(dr["Deeddate"].ToString())
? string.Empty : dr["deeddate"].ToString();
dh.SellerName = String.IsNullOrEmpty(dr["SellerName"].ToString())
? string.Empty : dr["SellerName"].ToString();
dh.BuyerName = String.IsNullOrEmpty(dr["BuyerName"].ToString())
? string.Empty : dr["BuyerName"].ToString();
dh.Deedtype = String.IsNullOrEmpty(dr["Deedtype"].ToString())
? string.Empty : dr["Deedtype"].ToString();
dh.SalePrice = String.IsNullOrEmpty(dr["SalePrice"].ToString())
? string.Empty : dr["SalePrice"].ToString();
dh.SaleYn = String.IsNullOrEmpty(dr["SaleYn"].ToString())
? string.Empty : dr["SaleYn"].ToString();
dh.SalesDate = String.IsNullOrEmpty(dr["SalesDate"].ToString())
? string.Empty : dr["SalesDate"].ToString();
dh.Bookid = String.IsNullOrEmpty(dr["Bookid"].ToString())
? string.Empty : dr["Bookid"].ToString();
dh.InstNum = String.IsNullOrEmpty(dr["InstNum"].ToString())
? string.Empty : dr["InstNum"].ToString();
dh.Instrumentnum = String.IsNullOrEmpty(dr["Instrumentnum"].ToString())
? string.Empty : dr["Instrumentnum"].ToString();
dh.PropIds = String.IsNullOrEmpty(dr["PropIds"].ToString())
? string.Empty : dr["PropIds"].ToString();
dh.Comment = String.IsNullOrEmpty(dr["Comment"].ToString())
? string.Empty : dr["Comment"].ToString();
retVal.Add(dh);
}
dal.Disconnect();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(retVal);
}
public List <OwnerHistory> ReturnOwnerHistory(string propertyId)
{
List <OwnerHistory> retVal = new List <OwnerHistory>();
Dal dal = new Dal();
try
{
dal.ConnectionString = ReturnConnString();
dal.Connect();
DataSet ds = dal.ReturnDatasetFromStoredProcByPropID("ReturnOwnerHistoryByPropID", propertyId);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
OwnerHistory oh = new OwnerHistory();
oh.PropertyId = propertyId;
oh.Maplot = String.IsNullOrEmpty(dr["MapTaxLot"].ToString())
? string.Empty : dr["MapTaxLot"].ToString();
oh.PropertyIds = String.IsNullOrEmpty(dr["Propertyids"].ToString())
? string.Empty : dr["Propertyids"].ToString();
oh.SaleID = String.IsNullOrEmpty(dr["SaleId"].ToString())
? string.Empty : dr["SaleId"].ToString();
oh.Year = String.IsNullOrEmpty(dr["Year"].ToString())
? string.Empty : dr["Year"].ToString();
oh.DeedDate = String.IsNullOrEmpty(dr["DeedDt"].ToString())
? string.Empty : dr["DeedDt"].ToString();
oh.InstNo = String.IsNullOrEmpty(dr["InstNo"].ToString())
? string.Empty : dr["InstNo"].ToString();
oh.SellerName = String.IsNullOrEmpty(dr["SellerName"].ToString())
? string.Empty : dr["SellerName"].ToString();
oh.BuyerName = String.IsNullOrEmpty(dr["BuyerName"].ToString())
? string.Empty : dr["BuyerName"].ToString();
oh.AcctStatus = String.IsNullOrEmpty(dr["AcctStatus"].ToString())
? string.Empty : dr["AcctStatus"].ToString();
oh.DeedType = String.IsNullOrEmpty(dr["DeedType"].ToString())
? string.Empty : dr["DeedType"].ToString();
oh.Saleprice = String.IsNullOrEmpty(dr["Saleprice"].ToString())
? string.Empty : dr["Saleprice"].ToString();
oh.Infocomment = String.IsNullOrEmpty(dr["Infocomment"].ToString())
? string.Empty : dr["Infocomment"].ToString();
retVal.Add(oh);
}
dal.Disconnect();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(retVal);
}
public List <Assessment> ReturnOwnerByName(string ownerName)
{
List <Assessment> retVal = new List <Assessment>();
Dal dal = new Dal();
try
{
dal.ConnectionString = ReturnConnString();
dal.Connect();
DataSet ds = dal.ReturnDatasetFromStoredProcByOwner("ReturnAssessmentByOwner ", ownerName);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
Assessment assmt = new Assessment();
assmt.PropertyId = String.IsNullOrEmpty(dr["Property"].ToString())
? string.Empty
: dr["Property"].ToString();
assmt.Maplot = String.IsNullOrEmpty(dr["MapTaxLot"].ToString())
? string.Empty
: dr["MapTaxLot"].ToString();
assmt.OwnerName = ownerName;
assmt.Address1 = String.IsNullOrEmpty(dr["Address1"].ToString())
? string.Empty
: dr["Address1"].ToString();
assmt.Address2 = String.IsNullOrEmpty(dr["Address2"].ToString())
? string.Empty
: dr["Address2"].ToString();
assmt.Address3 = String.IsNullOrEmpty(dr["Address3"].ToString())
? string.Empty
: dr["Address3"].ToString();
assmt.CityStateZip = String.IsNullOrEmpty(dr["CityStateZip"].ToString())
? string.Empty
: dr["CityStateZip"].ToString();
assmt.AddNames = String.IsNullOrEmpty(dr["AddNames"].ToString())
? string.Empty
: dr["AddNames"].ToString();
assmt.Pclass = String.IsNullOrEmpty(dr["Pclass"].ToString())
? string.Empty
: dr["Pclass"].ToString();
assmt.CoPropCls = String.IsNullOrEmpty(dr["CoPropCls"].ToString())
? string.Empty
: dr["CoPropCls"].ToString();
assmt.Situsaddr = String.IsNullOrEmpty(dr["Situsaddr"].ToString())
? string.Empty
: dr["Situsaddr"].ToString();
assmt.Situscsz = String.IsNullOrEmpty(dr["Situscsz"].ToString())
? string.Empty
: dr["Situscsz"].ToString();
assmt.RollLandMkt = String.IsNullOrEmpty(dr["RollLandMkt"].ToString())
? string.Empty
: dr["RollLandMkt"].ToString();
assmt.RollTotalImp = String.IsNullOrEmpty(dr["RollTotalImp"].ToString())
? string.Empty
: dr["RollTotalImp"].ToString();
assmt.RollRmvValue = String.IsNullOrEmpty(dr["RollRmvValue"].ToString())
? string.Empty
: dr["RollRmvValue"].ToString();
assmt.RollUseValue = String.IsNullOrEmpty(dr["RollUseValue"].ToString())
? string.Empty
: dr["RollUseValue"].ToString();
assmt.RollAssdVal = String.IsNullOrEmpty(dr["RollAssdVal"].ToString())
? string.Empty
: dr["RollAssdVal"].ToString();
assmt.Yrblt = String.IsNullOrEmpty(dr["Yrblt"].ToString())
? string.Empty
: dr["Yrblt"].ToString();
assmt.LivingArea = String.IsNullOrEmpty(dr["LivingArea"].ToString())
? string.Empty
: dr["LivingArea"].ToString();
assmt.Acreage = String.IsNullOrEmpty(dr["Acreage"].ToString())
? string.Empty
: dr["Acreage"].ToString();
assmt.PropCode = String.IsNullOrEmpty(dr["PropCode"].ToString())
? string.Empty
: dr["PropCode"].ToString();
assmt.CurrentLevy = String.IsNullOrEmpty(dr["CurrentLevy"].ToString())
? string.Empty
: dr["CurrentLevy"].ToString();
retVal.Add(assmt);
}
dal.Disconnect();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(retVal);
}