private void btnNew_Click(object sender, RoutedEventArgs e) { var x = this.DataContext as Orphan_Health; if (x.ID != null) { var oh = new Orphan_Health(); oh.OrphanID = OrphanID; this.DataContext = oh; } }
public static Orphan_Health GetOrphanHealthByID(int id) { Orphan_Health x = new Orphan_Health(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_GetOrphanHealthByID", con); com.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter pr = new SqlParameter("@OrphanHealthID", id); com.Parameters.Add(pr); try { con.Open(); SqlDataReader rd = com.ExecuteReader(); if (rd.Read()) { if (!(rd["ID"] is DBNull)) { x.ID = System.Int32.Parse(rd["ID"].ToString()); } if (!(rd["OrphanID"] is DBNull)) { x.OrphanID = System.Int32.Parse(rd["OrphanID"].ToString()); } x.HealthSituation = rd["HealthSituation"].ToString(); if (!(rd["Date"] is DBNull)) { x.Date = System.DateTime.Parse(rd["Date"].ToString()); } x.DayNeeded = rd["DayNeeded"].ToString(); x.SpecialNeeded = rd["SpecialNeeded"].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); }