public static ReferralSource GetReferralSourceByReferralSourceID(int ReferralSourceID)
{
ReferralSource referralSource = new ReferralSource();
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
referralSource = sqlReferralSourceProvider.GetReferralSourceByReferralSourceID(ReferralSourceID);
return referralSource;
}
public static DataSet GetDropDownListAllReferralSource()
{
DataSet referralSources = new DataSet();
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
referralSources = sqlReferralSourceProvider.GetDropDownLisAllReferralSource();
return referralSources;
}
public static ReferralSource GetHRMetroLocationByMetroLocationID(int MetroLocationID)
{
ReferralSource referralSource = new ReferralSource();
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
referralSource = sqlReferralSourceProvider.GetReferralSourceByMetroLocationID(MetroLocationID);
return referralSource;
}
public static DataSet GetAllReferralSourcesWithRelation()
{
DataSet referralSources = new DataSet();
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
referralSources = sqlReferralSourceProvider.GetAllReferralSources();
return referralSources;
}
public static DataSet GetDropDownLisAllReferralSourceByMetroLocationID(int MetroLocationID)
{
DataSet referralSources = new DataSet();
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
referralSources = sqlReferralSourceProvider.GetDropDownLisAllReferralSourceByMetroLocationID(MetroLocationID);
return referralSources;
}
public static ReferralSource GetReferralSourceByReferralSourceID(int ReferralSourceID)
{
ReferralSource referralSource = new ReferralSource();
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
referralSource = sqlReferralSourceProvider.GetReferralSourceByReferralSourceID(ReferralSourceID);
return(referralSource);
}
public static DataSet GetAllReferralSourcesWithRelation()
{
DataSet referralSources = new DataSet();
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
referralSources = sqlReferralSourceProvider.GetAllReferralSources();
return(referralSources);
}
public static ReferralSource GetHRMetroLocationByMetroLocationID(int MetroLocationID)
{
ReferralSource referralSource = new ReferralSource();
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
referralSource = sqlReferralSourceProvider.GetReferralSourceByMetroLocationID(MetroLocationID);
return(referralSource);
}
public static DataSet GetDropDownLisAllReferralSourceByMetroLocationID(int MetroLocationID)
{
DataSet referralSources = new DataSet();
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
referralSources = sqlReferralSourceProvider.GetDropDownLisAllReferralSourceByMetroLocationID(MetroLocationID);
return(referralSources);
}
public static DataSet GetDropDownListAllReferralSource()
{
DataSet referralSources = new DataSet();
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
referralSources = sqlReferralSourceProvider.GetDropDownLisAllReferralSource();
return(referralSources);
}
public static void LoadReferralSourcePage(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);
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
DataSet ds = sqlReferralSourceProvider.GetReferralSourcePageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
referralSourcesPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static void LoadReferralSourcePage(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);
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
DataSet ds = sqlReferralSourceProvider.GetReferralSourcePageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
referralSourcesPaggination(rptPager, recordCount, pageIndex, PageSize);
}
public static bool DeleteReferralSource(int referralSourceID)
{
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
return sqlReferralSourceProvider.DeleteReferralSource(referralSourceID);
}
public static bool DeleteReferralSource(int referralSourceID)
{
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
return(sqlReferralSourceProvider.DeleteReferralSource(referralSourceID));
}
public static int InsertReferralSource(ReferralSource referralSource)
{
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
return(sqlReferralSourceProvider.InsertReferralSource(referralSource));
}
public static int InsertReferralSource(ReferralSource referralSource)
{
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
return sqlReferralSourceProvider.InsertReferralSource(referralSource);
}
public static bool UpdateReferralSource(ReferralSource referralSource)
{
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
return sqlReferralSourceProvider.UpdateReferralSource(referralSource);
}
public static bool UpdateReferralSource(ReferralSource referralSource)
{
SqlReferralSourceProvider sqlReferralSourceProvider = new SqlReferralSourceProvider();
return(sqlReferralSourceProvider.UpdateReferralSource(referralSource));
}