public static Sponsor GetSponsorByID(int id, bool bringDetails = false)
{
Sponsor x = new Sponsor();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_Get_ID_Sponsor", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pr = new SqlParameter("@SponsorID", id);
com.Parameters.Add(pr);
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
if (rd.Read())
{
if (!(rd["SponsorID"] is DBNull))
{
x.SponsorID = int.Parse(rd["SponsorID"].ToString());
}
x.Name = rd["Name"].ToString();
x.Nationality = rd["Nationality"].ToString();
if (!(rd["IsOrganazation"] is DBNull))
{
x.IsOrganazation = bool.Parse(rd["IsOrganazation"].ToString());
}
if (!(rd["DOB"] is DBNull))
{
x.DOB = DateTime.Parse(rd["DOB"].ToString());
}
x.Gender = rd["Gender"].ToString();
x.Phone = rd["Phone"].ToString();
x.Mobile = rd["Mobile"].ToString();
x.Email = rd["Email"].ToString();
x.Address = rd["Address"].ToString();
x.MainSponsorship = rd["MainSponsorship"].ToString();
x.MediatorName = rd["MediatorName"].ToString();
x.MediatorMobile = rd["MediatorMobile"].ToString();
x.Notes = rd["Notes"].ToString();
x.Status = rd["Status"].ToString();
if (bringDetails)
{
x.Account = Account.GetAccountByOwnerID(Account.AccountType.Sponsor, x.SponsorID.Value);
x.Sponsorships = Sponsorship.GetSponsorshipAllBySponsorID(x);
x.AvailableSponsorships = AvailableSponsorship.GetAllAvailableSponsorshipBySponsorID(x);
}
}
rd.Close();
}
catch
{
x = null;
}
finally
{
con.Close();
}
return(x);
}
