public static Status GetStatusByStastusID(int StastusID)
{
Status status = new Status();
SqlStatusProvider sqlStatusProvider = new SqlStatusProvider();
status = sqlStatusProvider.GetStatusByStastusID(StastusID);
return status;
}
public static DataSet GetDropDownListAllStatus()
{
DataSet statuss = new DataSet();
SqlStatusProvider sqlStatusProvider = new SqlStatusProvider();
statuss = sqlStatusProvider.GetDropDownLisAllStatus();
return statuss;
}
public static Status GetStatusByStastusID(int StastusID)
{
Status status = new Status();
SqlStatusProvider sqlStatusProvider = new SqlStatusProvider();
status = sqlStatusProvider.GetStatusByStastusID(StastusID);
return(status);
}
public static DataSet GetDropDownListAllStatus()
{
DataSet statuss = new DataSet();
SqlStatusProvider sqlStatusProvider = new SqlStatusProvider();
statuss = sqlStatusProvider.GetDropDownLisAllStatus();
return(statuss);
}
public static void LoadStatusPage(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);
SqlStatusProvider sqlStatusProvider = new SqlStatusProvider();
DataSet ds = sqlStatusProvider.GetStatusPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
statussPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static void LoadStatusPage(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);
SqlStatusProvider sqlStatusProvider = new SqlStatusProvider();
DataSet ds = sqlStatusProvider.GetStatusPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
statussPaggination(rptPager, recordCount, pageIndex, PageSize);
}
public static bool DeleteStatus(int statusID)
{
SqlStatusProvider sqlStatusProvider = new SqlStatusProvider();
return(sqlStatusProvider.DeleteStatus(statusID));
}
public static bool UpdateStatus(Status status)
{
SqlStatusProvider sqlStatusProvider = new SqlStatusProvider();
return(sqlStatusProvider.UpdateStatus(status));
}
public static int InsertStatus(Status status)
{
SqlStatusProvider sqlStatusProvider = new SqlStatusProvider();
return(sqlStatusProvider.InsertStatus(status));
}
public static bool UpdateStatus(Status status)
{
SqlStatusProvider sqlStatusProvider = new SqlStatusProvider();
return sqlStatusProvider.UpdateStatus(status);
}
public static int InsertStatus(Status status)
{
SqlStatusProvider sqlStatusProvider = new SqlStatusProvider();
return sqlStatusProvider.InsertStatus(status);
}
public static bool DeleteStatus(int statusID)
{
SqlStatusProvider sqlStatusProvider = new SqlStatusProvider();
return sqlStatusProvider.DeleteStatus(statusID);
}
