private void btnNew_Click(object sender, RoutedEventArgs e) { var x = this.DataContext as Impeding; if (x.ID != null) { var oi = new Impeding(); oi.OrphanID = OrphanID; this.DataContext = oi; } }
public static List <Impeding> GetImpedingAllByOrphanID(int?id) { var ois = new List <Impeding>(); SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString); SqlCommand com = new SqlCommand("sp_GetImpedingAllByOrphanID", con); com.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter pr = new SqlParameter("@OrphanID", id); com.Parameters.Add(pr); try { con.Open(); SqlDataReader rd = com.ExecuteReader(); while (rd.Read()) { Impeding x = new Impeding(); if (!(rd["ID"] is DBNull)) { x.ID = System.Int32.Parse(rd["ID"].ToString()); } x.impedingType = rd["impedingType"].ToString(); x.impedingDegree = rd["impedingDegree"].ToString(); x.impedingIdentityID = rd["impedingIdentityID"].ToString(); x.impedingIdentityImage = rd["impedingIdentityImage"].ToString(); x.RelatedAssociation = rd["RelatedAssociation"].ToString(); x.Notes = rd["Notes"].ToString(); if (!(rd["ImpedingDate"] is DBNull)) { x.ImpedingDate = DateTime.Parse(rd["ImpedingDate"].ToString()); } if (!(rd["OrphanID"] is DBNull)) { x.OrphanID = System.Int32.Parse(rd["OrphanID"].ToString()); } ois.Add(x); } rd.Close(); } catch { ois = new List <Impeding>(); } finally { con.Close(); } return(ois); }
public bool UpdateData() { impedingIdentityImage = BaseDataBase.CheckImageFile(impedingidentityimage, Impeding.GetImpedingByID(ID).impedingIdentityImage); return(BaseDataBase._StoredProcedure("sp_Updateimpeding" , new SqlParameter("@ID", ID) , new SqlParameter("@impedingType", impedingType) , new SqlParameter("@impedingDegree", impedingDegree) , new SqlParameter("@impedingIdentityID", impedingIdentityID) , new SqlParameter("@impedingIdentityImage", impedingIdentityImage) , new SqlParameter("@RelatedAssociation", RelatedAssociation) , new SqlParameter("@ImpedingDate", ImpedingDate) , new SqlParameter("@Notes", Notes) , new SqlParameter("@OrphanID", OrphanID))); }