public int PurchaseInvoiceHeaderExists(int purchaseOrderID)
{
PurchaseInvoiceHeaderData data = new PurchaseInvoiceHeaderData();
PurchaseInvoiceHeaderCollection col = new PurchaseInvoiceHeaderCollection();
string where = "[PurchaseOrderID]=" + purchaseOrderID;
string orderBy = String.Empty;
try
{
col = data.GetAllPurchaseInvoiceHeaderDynamicCollection(where, orderBy);
if (col.Count > 0)
{
return(col[0].InvoiceID);
}
else
{
return(0);
}
}
catch
{
return(0);
}
}
public PurchaseInvoiceHeaderCollection GetPurchaseInvoiceHeaders(string where, string orderBy)
{
PurchaseInvoiceHeaderData data = new PurchaseInvoiceHeaderData();
PurchaseInvoiceHeaderCollection col = new PurchaseInvoiceHeaderCollection();
try
{
col = data.GetAllPurchaseInvoiceHeaderDynamicCollection(where, orderBy);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
data = null;
}
return(col);
}
public DataSet GetPurchaseInvoiceHeaderDataSet(string where, string orderBy)
{
PurchaseInvoiceHeaderData data = new PurchaseInvoiceHeaderData();
DataSet ds = new DataSet();
try
{
ds = data.GetPurchaseInvoiceHeaderDynamicDataSet(where, orderBy);
}
catch (Exception ex)
{
log.Write(ex.Message, "GetPurchaseInvoiceHeaderDataSet");
throw (ex);
}
finally
{
data = null;
}
return(ds);
}
public PurchaseInvoiceHeader GetPurchaseInvoiceHeader(int purchaseInvoiceHeaderID)
{
PurchaseInvoiceHeaderData data = new PurchaseInvoiceHeaderData();
PurchaseInvoiceHeader pih = new PurchaseInvoiceHeader();
try
{
pih = data.GetPurchaseInvoiceHeader(purchaseInvoiceHeaderID);
}
catch (Exception ex)
{
log.Write(ex.Message, "GetPurchaseInvoiceHeader");
throw (ex);
}
finally
{
data = null;
}
return(pih);
}
public bool UpdatePurchaseInvoiceHeader(PurchaseInvoiceHeader purchaseinvoiceheader)
{
PurchaseInvoiceHeaderData data = new PurchaseInvoiceHeaderData();
bool ret = false;
try
{
ret = data.UpdatePurchaseInvoiceHeader(purchaseinvoiceheader);
}
catch (Exception ex)
{
log.Write(ex.Message, "UpdatePurchaseInvoiceHeader");
throw (ex);
}
finally
{
data = null;
}
return(ret);
}
public bool RemovePurchaseInvoiceHeader(int purchaseinvoiceheaderID)
{
PurchaseInvoiceHeaderData data = new PurchaseInvoiceHeaderData();
bool ret = false;
try
{
ret = data.DeletePurchaseInvoiceHeader(purchaseinvoiceheaderID);
}
catch (Exception ex)
{
log.Write(ex.Message, "RemovePurchaseInvoiceHeader");
throw (ex);
}
finally
{
data = null;
}
return(ret);
}
public int AddPurchaseInvoiceHeader(PurchaseInvoiceHeader purchaseinvoiceheader)
{
PurchaseInvoiceHeaderData data = new PurchaseInvoiceHeaderData();
int purchaseInoviceHeaderID = 0;
try
{
purchaseInoviceHeaderID = data.AddPurchaseInvoiceHeader(purchaseinvoiceheader);
}
catch (Exception ex)
{
log.Write(ex.Message, "AddPurchaseInvoiceHeader");
throw (ex);
}
finally
{
data = null;
}
return(purchaseInoviceHeaderID);
}
