private void btnNew_Click(object sender, RoutedEventArgs e)
{
var x = this.DataContext as FamilyNeed;
if (x.FamilyNeedID != null)
{
var fn = new FamilyNeed();
fn.FamilyID = FamilyID;
this.DataContext = fn;
}
}
public static FamilyNeed GetFamilyNeedByID(int id)
{
FamilyNeed x = new FamilyNeed();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_GetFamilyNeedByID", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pr = new SqlParameter("@FamilyNeedID", id);
com.Parameters.Add(pr);
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
if (rd.Read())
{
if (!(rd["FamilyNeedID"] is DBNull))
{
x.FamilyNeedID = System.Int32.Parse(rd["FamilyNeedID"].ToString());
}
if (!(rd["FamilyID"] is DBNull))
{
x.FamilyID = System.Int32.Parse(rd["FamilyID"].ToString());
}
x.NeedType = rd["NeedType"].ToString();
x.NeedName = rd["NeedName"].ToString();
x.Value = rd["Value"].ToString();
x.AskedBy = rd["AskedBy"].ToString();
if (!(rd["Date"] is DBNull))
{
x.Date = System.DateTime.Parse(rd["Date"].ToString());
}
if (!(rd["IsEnsured"] is DBNull))
{
x.IsEnsured = System.Boolean.Parse(rd["IsEnsured"].ToString());
}
x.EnsuredSupport = rd["EnsuredSupport"].ToString();
x.Notes = rd["Notes"].ToString();
}
rd.Close();
}
catch
{
x = null;
}
finally
{
con.Close();
}
return(x);
}
