Пример #1
0
        public static List <ListerGroup> GetListerGroupsByOrphanID(int?OrphanID)
        {
            List <ListerGroup> lgs = new List <ListerGroup>();
            SqlConnection      con = new SqlConnection(BaseDataBase.ConnectionString);
            SqlCommand         com = new SqlCommand("sp_GetListerGroupsByOrphanID", con);

            com.CommandType = System.Data.CommandType.StoredProcedure;
            SqlParameter pr = new SqlParameter("@OrphanID", OrphanID);

            com.Parameters.Add(pr);
            try
            {
                con.Open();
                SqlDataReader rd = com.ExecuteReader();
                while (rd.Read())
                {
                    ListerGroup x = ListerGroup.GetListerGroupByID(rd.GetInt32(0));
                    lgs.Add(x);
                }
                rd.Close();
            }
            catch
            {
                lgs = new List <ListerGroup>();
            }
            finally
            {
                con.Close();
            }
            return(lgs);
        }
Пример #2
0
        public static ListerGroup GetListerGroupByID(int?id)
        {
            ListerGroup   x   = new ListerGroup();
            SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
            SqlCommand    com = new SqlCommand("sp_GetListerGroupByID", con);

            com.CommandType = System.Data.CommandType.StoredProcedure;
            SqlParameter pr = new SqlParameter("@GroupID", id);

            com.Parameters.Add(pr);
            try
            {
                con.Open();
                SqlDataReader rd = com.ExecuteReader();
                if (rd.Read())
                {
                    if (!(rd["GroupID"] is DBNull))
                    {
                        x.GroupID = System.Int32.Parse(rd["GroupID"].ToString());
                    }
                    if (!(rd["OrphanID"] is DBNull))
                    {
                        x.OrphanID = System.Int32.Parse(rd["OrphanID"].ToString());
                    }
                    if (!(rd["Date"] is DBNull))
                    {
                        x.Date = System.DateTime.Parse(rd["Date"].ToString());
                    }
                    x.Evaluation   = rd["Evaluation"].ToString();
                    x.Notes        = rd["Notes"].ToString();
                    x.CreatePerson = rd["CreatePerson"].ToString();
                    if (!(rd["CreateDate"] is DBNull))
                    {
                        x.CreateDate = System.DateTime.Parse(rd["CreateDate"].ToString());
                    }
                    x.LastModifiedPerson = rd["LastModifiedPerson"].ToString();
                    x.Notes = rd["Notes"].ToString();
                    if (!(rd["FamilyID"] is DBNull))
                    {
                        x.FamilyID = System.Int32.Parse(rd["FamilyID"].ToString());
                    }

                    x.Listers     = ListerGroup.GetListersAllByGroupID(x.GroupID);
                    x.FamilyNeeds = FamilyNeed_ListerGroup.GetFamilyNeed_ListerGroupByListerGroupID(x.GroupID.Value);
                }
                rd.Close();
            }
            catch
            {
                x = new ListerGroup();
            }
            finally
            {
                con.Close();
            }
            return(x);
        }
Пример #3
0
        private void btnNew_Click(object sender, RoutedEventArgs e)
        {
            var x = this.DataContext as ListerGroup;

            if (x.GroupID != null)
            {
                var lg = new ListerGroup();
                if (FamilyID == null)
                {
                    lg.OrphanID = OrphanID;
                }
                else
                {
                    lg.FamilyID = FamilyID;
                }
                this.DataContext = lg;
            }
        }
Пример #4
0
        //Done :)
        public static List <ListerGroup> GetListerGroupsByFamilyID(int?FamilyID)
        {
            List <ListerGroup> lgs = new List <ListerGroup>();
            SqlConnection      con = new SqlConnection(BaseDataBase.ConnectionString);
            SqlCommand         com = new SqlCommand("sp_Get_All_ListerGroups_ByFamilyID", con);

            com.CommandType = System.Data.CommandType.StoredProcedure;
            SqlParameter pr = new SqlParameter("@FamilyID", FamilyID);

            com.Parameters.Add(pr);
            try
            {
                con.Open();
                SqlDataReader rd = com.ExecuteReader();
                ListerGroup   lg = null;
                while (rd.Read())
                {
                    if (lg == null || (int)rd["ListerGroupID"] != lg.GroupID.Value)
                    {
                        lg         = new ListerGroup();
                        lg.GroupID = (int)rd["ListerGroupID"];
                        if (!(rd["OrphanID"] is DBNull))
                        {
                            lg.OrphanID = System.Int32.Parse(rd["OrphanID"].ToString());
                        }
                        if (!(rd["Date"] is DBNull))
                        {
                            lg.Date = System.DateTime.Parse(rd["Date"].ToString());
                        }
                        lg.Evaluation   = rd["Evaluation"].ToString();
                        lg.Notes        = rd["ListerGroupNotes"].ToString();
                        lg.CreatePerson = rd["CreatePerson"].ToString();
                        if (!(rd["CreateDate"] is DBNull))
                        {
                            lg.CreateDate = System.DateTime.Parse(rd["CreateDate"].ToString());
                        }
                        lg.LastModifiedPerson = rd["LastModifiedPerson"].ToString();
                        lg.Notes = rd["ListerGroupNotes"].ToString();
                        if (!(rd["FamilyID"] is DBNull))
                        {
                            lg.FamilyID = System.Int32.Parse(rd["FamilyID"].ToString());
                        }

                        lgs.Add(lg);
                    }
                    Lister l = new Lister();
                    l.ListerID   = System.Int32.Parse(rd["ListerListerID"].ToString());
                    l.FirstName  = rd["FirstName"].ToString();
                    l.LastName   = rd["LastName"].ToString();
                    l.Gender     = rd["Gender"].ToString();
                    l.BirthPlace = rd["BirthPlace"].ToString();
                    if (!(rd["DOB"] is DBNull))
                    {
                        l.DOB = System.DateTime.Parse(rd["DOB"].ToString());
                    }
                    l.Job           = rd["Job"].ToString();
                    l.Phone         = rd["Phone"].ToString();
                    l.Mobile        = rd["Mobile"].ToString();
                    l.Email         = rd["Email"].ToString();
                    l.MaritalStatus = rd["MaritalStatus"].ToString();
                    if (!(rd["ChildCount"] is DBNull))
                    {
                        l.ChildCount = System.Int32.Parse(rd["ChildCount"].ToString());
                    }
                    l.PlaceAddress        = rd["PlaceAddress"].ToString();
                    l.ScientificQualifier = rd["ScientificQualifier"].ToString();
                    l.IdentityImage       = rd["IdentityImage"].ToString();
                    l.Notes = rd["ListerNotes"].ToString();

                    lg.Listers.Add(l);
                    // lg.FamilyNeeds = FamilyNeed_ListerGroup.GetFamilyNeed_ListerGroupByListerGroupID(lg.GroupID.Value);
                }
                rd.Close();
            }
            catch
            {
                lgs = new List <ListerGroup>();
            }
            finally
            {
                con.Close();
            }
            return(lgs);
        }