public static Relationship GetRelationshipByRelationshipID(int RelationshipID)
{
Relationship relationship = new Relationship();
SqlRelationshipProvider sqlRelationshipProvider = new SqlRelationshipProvider();
relationship = sqlRelationshipProvider.GetRelationshipByRelationshipID(RelationshipID);
return(relationship);
}
public static DataSet GetDropDownListAllRelationship()
{
DataSet relationships = new DataSet();
SqlRelationshipProvider sqlRelationshipProvider = new SqlRelationshipProvider();
relationships = sqlRelationshipProvider.GetDropDownLisAllRelationship();
return(relationships);
}
public static void LoadRelationshipPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount = 0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlRelationshipProvider sqlRelationshipProvider = new SqlRelationshipProvider();
DataSet ds = sqlRelationshipProvider.GetRelationshipPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
relationshipsPaggination(rptPager, recordCount, pageIndex, PageSize);
}
public static bool DeleteRelationship(int relationshipID)
{
SqlRelationshipProvider sqlRelationshipProvider = new SqlRelationshipProvider();
return(sqlRelationshipProvider.DeleteRelationship(relationshipID));
}
public static bool UpdateRelationship(Relationship relationship)
{
SqlRelationshipProvider sqlRelationshipProvider = new SqlRelationshipProvider();
return(sqlRelationshipProvider.UpdateRelationship(relationship));
}
public static int InsertRelationship(Relationship relationship)
{
SqlRelationshipProvider sqlRelationshipProvider = new SqlRelationshipProvider();
return(sqlRelationshipProvider.InsertRelationship(relationship));
}
