Ejemplo n.º 1
0
        public static List <Family> GetFamilyAll()
        {
            List <Family> fs  = new List <Family>();
            SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
            SqlCommand    com = new SqlCommand("sp_GetFamilyAll", con);

            com.CommandType = System.Data.CommandType.StoredProcedure;
            try
            {
                con.Open();
                SqlDataReader rd = com.ExecuteReader();
                while (rd.Read())
                {
                    Family x = new Family();
                    if (!(rd["FamilyID"] is DBNull))
                    {
                        x.FamilyID = System.Int32.Parse(rd["FamilyID"].ToString());
                    }
                    x.FamilyType = rd["FamilyType"].ToString();
                    x.FamilyCode = rd["FamilyCode"].ToString();
                    if (!(rd["SectorID"] is DBNull))
                    {
                        x.SectorID = System.Int32.Parse(rd["SectorID"].ToString());
                    }
                    x.FamilyName       = rd["FamilyName"].ToString();
                    x.FamilyStatus     = rd["FamilyStatus"].ToString();
                    x.FamilyIdentityID = rd["FamilyIdentityID"].ToString();
                    if (!(rd["ApplyDate"] is DBNull))
                    {
                        x.ApplyDate = System.DateTime.Parse(rd["ApplyDate"].ToString());
                    }
                    x.FamilyReportImage = rd["FamilyReportImage"].ToString();
                    if (!(rd["FamilySalary"] is DBNull))
                    {
                        x.FamilySalary = System.Single.Parse(rd["FamilySalary"].ToString());
                    }
                    x.SalarySupport      = rd["SalarySupport"].ToString();
                    x.SalaryCurrency     = rd["SalaryCurrency"].ToString();
                    x.DefinedPersonName  = rd["DefinedPersonName"].ToString();
                    x.DefinedPersonPhone = rd["DefinedPersonPhone"].ToString();
                    x.FamilyPersonCount  = rd["FamilyPersonCount"].ToString();
                    x.Evaluation         = rd["Evaluation"].ToString();
                    if (!(rd["IsRecorded"] is DBNull))
                    {
                        x.IsRecorded = System.Boolean.Parse(rd["IsRecorded"].ToString());
                    }
                    if (!(rd["HasCard"] is DBNull))
                    {
                        x.HasCard = System.Boolean.Parse(rd["HasCard"].ToString());
                    }
                    x.Notes = rd["Notes"].ToString();

                    x.FamilyFather = Father.GetFatherByFamilyID(x.FamilyID.Value);
                    x.FamilyMother = Mother.GetMotherByFamilyID(x.FamilyID.Value);

                    fs.Add(x);
                }
                rd.Close();
            }
            catch
            {
                fs = new List <Family>();
            }
            finally
            {
                con.Close();
            }
            return(fs);
        }
Ejemplo n.º 2
0
        public static Father GetFatherByFamilyID(int id)
        {
            Father        x   = new Father();
            SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
            SqlCommand    com = new SqlCommand("sp_GetFatherByFamilyID", con);

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

            com.Parameters.Add(pr);
            try
            {
                con.Open();
                SqlDataReader rd = com.ExecuteReader();
                if (rd.Read())
                {
                    if (!(rd["ParentrID"] is DBNull))
                    {
                        x.ParentrID = System.Int32.Parse(rd["ParentrID"].ToString());
                    }
                    if (!(rd["FamilyID"] is DBNull))
                    {
                        x.FamilyID = System.Int32.Parse(rd["FamilyID"].ToString());
                    }
                    x.FirstName   = rd["FirstName"].ToString();
                    x.LastName    = rd["LastName"].ToString();
                    x.Nickname    = rd["Nickname"].ToString();
                    x.Gender      = rd["Gender"].ToString();
                    x.FatherName  = rd["FatherName"].ToString();
                    x.MotherName  = rd["MotherName"].ToString();
                    x.Nationality = rd["Nationality"].ToString();
                    x.BirthPlace  = rd["BirthPlace"].ToString();
                    if (!(rd["DOB"] is DBNull))
                    {
                        x.DOB = System.DateTime.Parse(rd["DOB"].ToString());
                    }
                    x.Job = rd["Job"].ToString();
                    if (!(rd["IsWorking"] is DBNull))
                    {
                        x.IsWorking = System.Boolean.Parse(rd["IsWorking"].ToString());
                    }
                    if (!(rd["Salary"] is DBNull))
                    {
                        x.Salary = System.Single.Parse(rd["Salary"].ToString());
                    }
                    x.SalaryCurrency = rd["SalaryCurrency"].ToString();
                    x.JobAppointment = rd["JobAppointment"].ToString();
                    if (!(rd["IsImpeded"] is DBNull))
                    {
                        x.IsImpeded = System.Boolean.Parse(rd["IsImpeded"].ToString());
                    }
                    x.impededType = rd["impededType"].ToString();
                    x.ImpededKind = rd["ImpededKind"].ToString();
                    if (!(rd["impededDate"] is DBNull))
                    {
                        x.impededDate = System.DateTime.Parse(rd["impededDate"].ToString());
                    }
                    if (!(rd["IsLost"] is DBNull))
                    {
                        x.IsLost = System.Boolean.Parse(rd["IsLost"].ToString());
                    }
                    x.LostPlace = rd["LostPlace"].ToString();
                    if (!(rd["LostDate"] is DBNull))
                    {
                        x.LostDate = System.DateTime.Parse(rd["LostDate"].ToString());
                    }
                    x.BackDetailes = rd["BackDetailes"].ToString();
                    if (!(rd["BackDate"] is DBNull))
                    {
                        x.BackDate = System.DateTime.Parse(rd["BackDate"].ToString());
                    }
                    x.Phone  = rd["Phone"].ToString();
                    x.Mobile = rd["Mobile"].ToString();
                    x.Email  = rd["Email"].ToString();
                    x.PID    = rd["PID"].ToString();
                    if (!(rd["IsDead"] is DBNull))
                    {
                        x.IsDead = System.Boolean.Parse(rd["IsDead"].ToString());
                    }
                    if (!(rd["DeathDate"] is DBNull))
                    {
                        x.DeathDate = System.DateTime.Parse(rd["DeathDate"].ToString());
                    }
                    x.DeathReason   = rd["DeathReason"].ToString();
                    x.DeathReportID = rd["DeathReportID"].ToString();
                    if (!(rd["DeathReportDate"] is DBNull))
                    {
                        x.DeathReportDate = System.DateTime.Parse(rd["DeathReportDate"].ToString());
                    }
                    x.Status     = rd["Status"].ToString();
                    x.BondPlace  = rd["BondPlace"].ToString();
                    x.BondNumber = rd["BondNumber"].ToString();
                    x.IdentityID = rd["IdentityID"].ToString();
                    if (!(rd["IdentityGivinDate"] is DBNull))
                    {
                        x.IdentityGivinDate = System.DateTime.Parse(rd["IdentityGivinDate"].ToString());
                    }
                    x.IdentityImage = rd["IdentityImage"].ToString();
                    x.PersonalImage = rd["PersonalImage"].ToString();
                    if (!(rd["Tall"] is DBNull))
                    {
                        x.Tall = System.Int32.Parse(rd["Tall"].ToString());
                    }
                    if (!(rd["Weight"] is DBNull))
                    {
                        x.Weight = System.Int32.Parse(rd["Weight"].ToString());
                    }
                    if (!(rd["FeetSize"] is DBNull))
                    {
                        x.FeetSize = System.Int32.Parse(rd["FeetSize"].ToString());
                    }
                    if (!(rd["WaistSize"] is DBNull))
                    {
                        x.WaistSize = System.Int32.Parse(rd["WaistSize"].ToString());
                    }
                    x.GeneralWealthySituation = rd["GeneralWealthySituation"].ToString();
                    x.GeneralEthicalSituation = rd["GeneralEthicalSituation"].ToString();
                    x.BaseJob      = rd["BaseJob"].ToString();
                    x.FatherSalary = rd["FatherSalary"].ToString();
                    if (!(rd["IsFatherAlive"] is DBNull))
                    {
                        x.IsFatherAlive = System.Boolean.Parse(rd["IsFatherAlive"].ToString());
                    }
                    if (!(rd["IsMotherAlive"] is DBNull))
                    {
                        x.IsMotherAlive = System.Boolean.Parse(rd["IsMotherAlive"].ToString());
                    }
                    x.PsychicalSituation = rd["PsychicalSituation"].ToString();
                    x.Ethics             = rd["Ethics"].ToString();
                    x.HomePlace          = rd["HomePlace"].ToString();
                    x.MaritalStatus      = rd["MaritalStatus"].ToString();
                    x.HealthStatus       = rd["HealthStatus"].ToString();
                    x.StudyStatus        = rd["StudyStatus"].ToString();
                    if (!(rd["IsNursemaid"] is DBNull))
                    {
                        x.IsNursemaid = System.Boolean.Parse(rd["IsNursemaid"].ToString());
                    }
                    x.Notes = rd["Notes"].ToString();
                }
                rd.Close();
            }
            catch
            {
                x = new Father();
            }
            finally
            {
                con.Close();
            }
            return(x);
        }
Ejemplo n.º 3
0
        public static Family GetFamilyByID(int id)
        {
            Family        x   = new Family();
            SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
            SqlCommand    com = new SqlCommand("sp_GetFamilyByID", con);

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

            com.Parameters.Add(pr);
            try
            {
                con.Open();
                SqlDataReader rd = com.ExecuteReader();
                if (rd.Read())
                {
                    if (!(rd["FamilyID"] is DBNull))
                    {
                        x.FamilyID = System.Int32.Parse(rd["FamilyID"].ToString());
                    }
                    x.FamilyType = rd["FamilyType"].ToString();
                    x.FamilyCode = rd["FamilyCode"].ToString();
                    if (!(rd["SectorID"] is DBNull))
                    {
                        x.SectorID = System.Int32.Parse(rd["SectorID"].ToString());
                    }
                    x.FamilyName       = rd["FamilyName"].ToString();
                    x.FamilyStatus     = rd["FamilyStatus"].ToString();
                    x.FamilyIdentityID = rd["FamilyIdentityID"].ToString();
                    if (!(rd["ApplyDate"] is DBNull))
                    {
                        x.ApplyDate = System.DateTime.Parse(rd["ApplyDate"].ToString());
                    }
                    x.FamilyReportImage = rd["FamilyReportImage"].ToString();
                    if (!(rd["FamilySalary"] is DBNull))
                    {
                        x.FamilySalary = System.Single.Parse(rd["FamilySalary"].ToString());
                    }
                    x.SalarySupport      = rd["SalarySupport"].ToString();
                    x.SalaryCurrency     = rd["SalaryCurrency"].ToString();
                    x.DefinedPersonName  = rd["DefinedPersonName"].ToString();
                    x.DefinedPersonPhone = rd["DefinedPersonPhone"].ToString();
                    x.FamilyPersonCount  = rd["FamilyPersonCount"].ToString();
                    x.Evaluation         = rd["Evaluation"].ToString();
                    x.CreatePerson       = rd["CreatePerson"].ToString();
                    x.ModifiedPerson     = rd["LastModifiedPerson"].ToString();
                    if (!(rd["CreateDate"] is DBNull))
                    {
                        x.CreateDate = System.DateTime.Parse(rd["CreateDate"].ToString());
                    }
                    if (!(rd["LastModifiedDate"] is DBNull))
                    {
                        x.LastModifiedDate = System.DateTime.Parse(rd["LastModifiedDate"].ToString());
                    }
                    if (!(rd["IsRecorded"] is DBNull))
                    {
                        x.IsRecorded = System.Boolean.Parse(rd["IsRecorded"].ToString());
                    }
                    if (!(rd["HasCard"] is DBNull))
                    {
                        x.HasCard = System.Boolean.Parse(rd["HasCard"].ToString());
                    }
                    x.Notes = rd["Notes"].ToString();

                    x.FamilyFather = Father.GetFatherByFamilyID(id);
                    x.FamilyMother = Mother.GetMotherByFamilyID(id);
                }
                rd.Close();
            }
            catch
            {
                x = new Family();
            }
            finally
            {
                con.Close();
            }
            return(x);
        }