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); }