public static DataSet GetINV_IssueBySerachString(string searchSQLString)
{
DataSet iNV_Issues = new DataSet();
SqlINV_IssueProvider sqlINV_IssueProvider = new SqlINV_IssueProvider();
iNV_Issues = sqlINV_IssueProvider.GetINV_IssueBySerachString(searchSQLString);
return iNV_Issues;
}
public static INV_Issue GetINV_IssueMasterByIssueMasterID(int IssueMasterID)
{
INV_Issue iNV_Issue = new INV_Issue();
SqlINV_IssueProvider sqlINV_IssueProvider = new SqlINV_IssueProvider();
iNV_Issue = sqlINV_IssueProvider.GetINV_IssueByIssueMasterID(IssueMasterID);
return iNV_Issue;
}
public static DataSet GetAllINV_IssuesWithRelation()
{
DataSet iNV_Issues = new DataSet();
SqlINV_IssueProvider sqlINV_IssueProvider = new SqlINV_IssueProvider();
iNV_Issues = sqlINV_IssueProvider.GetAllINV_Issues();
return iNV_Issues;
}
public static DataSet GetDropDownListAllINV_Issue()
{
DataSet iNV_Issues = new DataSet();
SqlINV_IssueProvider sqlINV_IssueProvider = new SqlINV_IssueProvider();
iNV_Issues = sqlINV_IssueProvider.GetDropDownListAllINV_Issue();
return iNV_Issues;
}
/// <summary>
/// GetAllINV_IssuesCheckAvlqty
/// </summary>
/// <returns></returns>
public static DataSet GetAllINV_IssuesCheckAvlqty(int ItemID,int CampusID,int StoreID)
{
DataSet iNV_Issues = new DataSet();
SqlINV_IssueProvider sqlINV_IssueProvider = new SqlINV_IssueProvider();
iNV_Issues = sqlINV_IssueProvider.GetAllINV_IssuesCheckAvlqty(ItemID, CampusID, StoreID);
return iNV_Issues;
}
public static INV_Issue GetSTD_CampusByCampusID(int CampusID)
{
INV_Issue iNV_Issue = new INV_Issue();
SqlINV_IssueProvider sqlINV_IssueProvider = new SqlINV_IssueProvider();
iNV_Issue = sqlINV_IssueProvider.GetINV_IssueByCampusID(CampusID);
return iNV_Issue;
}
public static INV_Issue GetINV_StoreByStoreID(int StoreID)
{
INV_Issue iNV_Issue = new INV_Issue();
SqlINV_IssueProvider sqlINV_IssueProvider = new SqlINV_IssueProvider();
iNV_Issue = sqlINV_IssueProvider.GetINV_IssueByStoreID(StoreID);
return iNV_Issue;
}
public static bool DeleteINV_Issue(int iNV_IssueID)
{
SqlINV_IssueProvider sqlINV_IssueProvider = new SqlINV_IssueProvider();
return sqlINV_IssueProvider.DeleteINV_Issue(iNV_IssueID);
}
public static bool UpdateINV_Issue(INV_Issue iNV_Issue)
{
SqlINV_IssueProvider sqlINV_IssueProvider = new SqlINV_IssueProvider();
return sqlINV_IssueProvider.UpdateINV_Issue(iNV_Issue);
}
public static void LoadINV_IssuePage(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);
SqlINV_IssueProvider sqlINV_IssueProvider = new SqlINV_IssueProvider();
DataSet ds = sqlINV_IssueProvider.GetINV_IssuePageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
iNV_IssuesPaggination(rptPager,recordCount, pageIndex, PageSize);
}
public static int InsertINV_Issue(INV_Issue iNV_Issue)
{
SqlINV_IssueProvider sqlINV_IssueProvider = new SqlINV_IssueProvider();
return sqlINV_IssueProvider.InsertINV_Issue(iNV_Issue);
}
