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