public static List <Sponsorship> GetAllSponsorship()
{
List <Sponsorship> xx = new List <Sponsorship>();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_Get_All_Sponsorship", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
while (rd.Read())
{
Sponsorship x = new Sponsorship();
if (!(rd["ID"] is DBNull))
{
x.ID = int.Parse(rd["ID"].ToString());
}
if (!(rd["OrphanID"] is DBNull))
{
x.OrphanID = int.Parse(rd["OrphanID"].ToString());
}
if (!(rd["StartDate"] is DBNull))
{
x.StartDate = DateTime.Parse(rd["StartDate"].ToString());
}
if (!(rd["EndDate"] is DBNull))
{
x.EndDate = DateTime.Parse(rd["EndDate"].ToString());
}
x.Notes = rd["Notes"].ToString();
if (!(rd["LastUserID"] is DBNull))
{
x.LastUserID = int.Parse(rd["LastUserID"].ToString());
}
if (!(rd["AvailableSponsorshipID"] is DBNull))
{
x.AvailableSponsorship = AvailableSponsorship.GetAvailableSponsorshipByID(int.Parse(rd["AvailableSponsorshipID"].ToString()));
}
x.IsDouble = (bool)rd["IsDouble"];
xx.Add(x);
}
rd.Close();
}
catch
{
xx = null;
}
finally
{
con.Close();
}
return(xx);
}
public static Sponsorship GetCurrentSponsorshipByOrphanID(int OrphanId)
{
Sponsorship x = new Sponsorship();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_Get_Current_Sponsorship", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter pr = new SqlParameter("@OrphanId", OrphanId);
com.Parameters.Add(pr);
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
if (rd.Read())
{
if (!(rd["ID"] is DBNull))
{
x.ID = int.Parse(rd["ID"].ToString());
}
if (!(rd["OrphanID"] is DBNull))
{
x.OrphanID = int.Parse(rd["OrphanID"].ToString());
}
if (!(rd["StartDate"] is DBNull))
{
x.StartDate = DateTime.Parse(rd["StartDate"].ToString());
}
if (!(rd["EndDate"] is DBNull))
{
x.EndDate = DateTime.Parse(rd["EndDate"].ToString());
}
x.Notes = rd["Notes"].ToString();
if (!(rd["LastUserID"] is DBNull))
{
x.LastUserID = int.Parse(rd["LastUserID"].ToString());
}
if (!(rd["AvailableSponsorshipID"] is DBNull))
{
x.AvailableSponsorship = AvailableSponsorship.GetAvailableSponsorshipByID(int.Parse(rd["AvailableSponsorshipID"].ToString()));
}
x.IsDouble = (bool)rd["IsDouble"];
}
rd.Close();
}
catch
{
x = null;
}
finally
{
con.Close();
}
return(x);
}
public static bool UpdateData(Sponsorship x)
{
return(BaseDataBase._StoredProcedure("sp_Update_Sponsorship"
, new SqlParameter("@ID", x.ID)
, new SqlParameter("@OrphanID", x.OrphanID)
, new SqlParameter("@StartDate", x.StartDate)
, new SqlParameter("@EndDate", x.EndDate)
, new SqlParameter("@Notes", x.Notes)
, new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID)
, new SqlParameter("@IsDouble", x.IsDouble)
, new SqlParameter("@AvailableSponsorshipID", x.AvailableSponsorship.ID)));
}
public static bool InsertData(Sponsorship x)
{
x.ID = BaseDataBase._StoredProcedureReturnable("sp_Add_Sponsorship"
, new SqlParameter("@ID", System.Data.SqlDbType.Int)
, new SqlParameter("@OrphanID", x.OrphanID)
, new SqlParameter("@StartDate", x.StartDate)
, new SqlParameter("@EndDate", x.EndDate)
, new SqlParameter("@Notes", x.Notes)
, new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID)
, new SqlParameter("@IsDouble", x.IsDouble)
, new SqlParameter("@AvailableSponsorshipID", x.AvailableSponsorship.ID));
return(x.ID.HasValue);
}
public static List <Sponsorship> GetSponsorshipAllByOrphanID(int OrphanID)
{
List <Sponsorship> xx = new List <Sponsorship>();
SqlConnection con = new SqlConnection(BaseDataBase.ConnectionString);
SqlCommand com = new SqlCommand("sp_Get_OrphanID_Sponsorship", con);
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.Add(new SqlParameter("@OrphanID", OrphanID));
try
{
con.Open();
SqlDataReader rd = com.ExecuteReader();
while (rd.Read())
{
Sponsorship x = new Sponsorship();
if (!(rd["SponsorshipID"] is DBNull))
{
x.ID = int.Parse(rd["SponsorshipID"].ToString());
}
if (!(rd["OrphanID"] is DBNull))
{
x.OrphanID = int.Parse(rd["OrphanID"].ToString());
}
if (!(rd["StartDate"] is DBNull))
{
x.StartDate = DateTime.Parse(rd["StartDate"].ToString());
}
if (!(rd["EndDate"] is DBNull))
{
x.EndDate = DateTime.Parse(rd["EndDate"].ToString());
}
x.Notes = rd["SponsorshipNotes"].ToString();
if (!(rd["SponsorshipLastUserID"] is DBNull))
{
x.LastUserID = int.Parse(rd["SponsorshipLastUserID"].ToString());
}
x.IsDouble = (bool)rd["IsDouble"];
x.AvailableSponsorship = new AvailableSponsorship();
if (!(rd["SponsorID"] is DBNull))
{
x.AvailableSponsorship.RelatedSponsor = new Sponsor()
{
SponsorID = int.Parse(rd["SponsorID"].ToString()), Name = rd["SponsorName"].ToString()
}
}
;
if (!(rd["AvailableSponsorshipID"] is DBNull))
{
x.AvailableSponsorship.ID = int.Parse(rd["AvailableSponsorshipID"].ToString());
}
if (!(rd["NOB"] is DBNull))
{
x.AvailableSponsorship.NOB = int.Parse(rd["NOB"].ToString());
}
if (!(rd["Duration"] is DBNull))
{
x.AvailableSponsorship.Duration = double.Parse(rd["Duration"].ToString());
}
if (!(rd["SponsorshipValue"] is DBNull))
{
x.AvailableSponsorship.SponsorshipValue = double.Parse(rd["SponsorshipValue"].ToString());
}
x.AvailableSponsorship.SponsorType = rd["SponsorType"].ToString();
x.AvailableSponsorship.SponsorshipType = rd["SponsorshipType"].ToString();
x.AvailableSponsorship.IsCompensated = (bool)rd["IsCompensated"];
x.AvailableSponsorship.Notes = rd["AvailableSponsorshipNotes"].ToString();
if (!(rd["AvailableSponsorshipLastUserID"] is DBNull))
{
x.AvailableSponsorship.LastUserID = int.Parse(rd["AvailableSponsorshipLastUserID"].ToString());
}
xx.Add(x);
}
rd.Close();
}
catch
{
xx = null;
}
finally
{
con.Close();
}
return(xx);
}
public static bool DeleteData(Sponsorship x)
{
return(BaseDataBase._StoredProcedure("sp_Delete_Sponsorship"
, new SqlParameter("@ID", x.ID)));
}