public static FamilyProperty GetFamilyPropertyByID(int id)
{
FamilyProperty x = new FamilyProperty();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_GetFamilyPropertyByID", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pr = new SqlParameter("@FamilyPropertyID", id);
com.Parameters.Add(pr);
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
if (rd.Read())
{
if (!(rd["FamilyPropertyID"] is DBNull))
{
x.FamilyPropertyID = System.Int32.Parse(rd["FamilyPropertyID"].ToString());
}
if (!(rd["FamilyID"] is DBNull))
{
x.FamilyID = System.Int32.Parse(rd["FamilyID"].ToString());
}
x.PropertyType = rd["PropertyType"].ToString();
if (!(rd["InvestmentValue"] is DBNull))
{
x.InvestmentValue = System.Single.Parse(rd["InvestmentValue"].ToString());
}
x.InvestmentCurrency = rd["InvestmentCurrency"].ToString();
if (!(rd["RealValue"] is DBNull))
{
x.RealValue = System.Single.Parse(rd["RealValue"].ToString());
}
x.ValueCurrency = rd["ValueCurrency"].ToString();
x.Evaluation = rd["Evaluation"].ToString();
if (!(rd["Date"] is DBNull))
{
x.Date = System.DateTime.Parse(rd["Date"].ToString());
}
if (!(rd["IsExist"] is DBNull))
{
x.IsExist = System.Boolean.Parse(rd["IsExist"].ToString());
}
x.Notes = rd["Notes"].ToString();
}
rd.Close();
}
catch
{
x = null;
}
finally
{
con.Close();
}
return(x);
}
private void btnNew_Click(object sender, RoutedEventArgs e)
{
var x = this.DataContext as FamilyProperty;
if (x.FamilyPropertyID != null)
{
var fn = new FamilyProperty();
fn.FamilyID = FamilyID;
this.DataContext = fn;
}
}
