public static DataSet GetDropDownListAllDocument()
{
DataSet documents = new DataSet();
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
documents = sqlDocumentProvider.GetDropDownLisAllDocument();
return documents;
}
public static DataSet GetDocumentByClientID(int ClientID)
{
DataSet documents = new DataSet();
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
documents = sqlDocumentProvider.GetDocumentByClientID(ClientID);
return documents;
}
public static Document GetDocumentByDocumentID(int DocumentID)
{
Document document = new Document();
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
document = sqlDocumentProvider.GetDocumentByDocumentID(DocumentID);
return document;
}
public static DataSet GetAllDocumentsWithRelation()
{
DataSet documents = new DataSet();
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
documents = sqlDocumentProvider.GetAllDocuments();
return documents;
}
public static Document GetDocumentByDocumentID(int DocumentID)
{
Document document = new Document();
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
document = sqlDocumentProvider.GetDocumentByDocumentID(DocumentID);
return(document);
}
public static DataSet GetDocumentByClientID(int ClientID)
{
DataSet documents = new DataSet();
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
documents = sqlDocumentProvider.GetDocumentByClientID(ClientID);
return(documents);
}
public static DataSet GetAllDocumentsWithRelation()
{
DataSet documents = new DataSet();
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
documents = sqlDocumentProvider.GetAllDocuments();
return(documents);
}
public static DataSet GetDropDownListAllDocument()
{
DataSet documents = new DataSet();
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
documents = sqlDocumentProvider.GetDropDownLisAllDocument();
return(documents);
}
public static void LoadDocumentPage(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);
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
DataSet ds = sqlDocumentProvider.GetDocumentPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
documentsPaggination(rptPager, recordCount, pageIndex, PageSize);
}
public static void LoadDocumentPage(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);
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
DataSet ds = sqlDocumentProvider.GetDocumentPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
documentsPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static int InsertDocument(Document document)
{
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
return sqlDocumentProvider.InsertDocument(document);
}
public static bool DeleteDocument(int documentID)
{
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
return sqlDocumentProvider.DeleteDocument(documentID);
}
public static bool UpdateDocument(Document document)
{
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
return sqlDocumentProvider.UpdateDocument(document);
}
public static bool UpdateDocument(Document document)
{
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
return(sqlDocumentProvider.UpdateDocument(document));
}
public static int InsertDocument(Document document)
{
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
return(sqlDocumentProvider.InsertDocument(document));
}
public static bool DeleteDocument(int documentID)
{
SqlDocumentProvider sqlDocumentProvider = new SqlDocumentProvider();
return(sqlDocumentProvider.DeleteDocument(documentID));
}
