public DataTable GetRelatedReceives() { ReceiptInvoice invoice = new ReceiptInvoice(); var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectGetRelatedReceives(this.ID); invoice.LoadFromRawSql(query); return(invoice.DataTable); }
public bool CheckIfThisInvoiceHasBeenReceived() { var invoice = new ReceiptInvoice(); var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectIfThisInvoiceHasBeenReceived(ID); invoice.LoadFromRawSql(query); return(invoice.RowCount > 0); }
public static bool IsInvoiceEditable(int ID) { ReceiptInvoice invoice = new ReceiptInvoice(); var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectIsInvoiceEditable(ID, Settings.DisableInvoiceEditAfterStepNo); invoice.LoadFromRawSql(query); return(invoice.RowCount == 0); }
public static DataView GetIncompleteInvoicesForCenter(int userID, bool isDeliveryNote) { var invoice = new ReceiptInvoice(); if (BLL.Settings.IsCenter) // If Center, Get incomplete invoices including those with FOB = 0 { var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectGetIncompleteInvoicesForCenter(userID, isDeliveryNote); invoice.LoadFromRawSql(query); } return(invoice.DefaultView); }
public static decimal GetInvoiceQuantity(string invoiceNo, string itemId, string unitId, string manufacturerId) { ReceiptInvoice invoice = new ReceiptInvoice(); var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectGetInvoiceQuantity(invoiceNo, itemId, unitId, manufacturerId); invoice.LoadFromRawSql(query); if (invoice.RowCount == 0) { return(0); } return((decimal)invoice.GetColumn("Quantity")); }
public static bool IsInvoiceElectronic(string invoiceNo) { ReceiptInvoice invoice = new ReceiptInvoice(); var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectIsInvoiceElectronic(invoiceNo); invoice.LoadFromRawSql(query); if (invoice.RowCount == 0) { return(false); } return((bool)invoice.GetColumn("IsElectronic")); }
/// <summary> /// It will return all Invoice For Now /// </summary> /// <returns></returns> public static DataView GetIncompleteInvoices(int userID, int poTypeID, int documentTypeID) { SoftwareSettings softwareSetting = new SoftwareSettings(); ReceiptInvoice Invoice = new ReceiptInvoice(); var settingDT = softwareSetting.GetValue("IsElectronicReceiveOnly"); bool isNonElectronicReceiveOnly = true; if (settingDT.Rows.Count != 0) { isNonElectronicReceiveOnly = bool.Parse(settingDT.Rows[0].Field <string>("Value").ToLower()); } var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectGetIncompleteInvoices(userID, isNonElectronicReceiveOnly, poTypeID, documentTypeID); Invoice.LoadFromRawSql(query); return(Invoice.DefaultView); }
public DataTable GetRelatedReceives() { ReceiptInvoice invoice = new ReceiptInvoice(); var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectGetRelatedReceives(this.ID); invoice.LoadFromRawSql(query); return invoice.DataTable; }
public bool CheckIfThisInvoiceHasBeenReceived() { var invoice = new ReceiptInvoice(); var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectIfThisInvoiceHasBeenReceived(ID); invoice.LoadFromRawSql(query); return (invoice.RowCount > 0); }
public static bool IsInvoiceElectronic(string invoiceNo) { ReceiptInvoice invoice = new ReceiptInvoice(); var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectIsInvoiceElectronic(invoiceNo); invoice.LoadFromRawSql(query); if (invoice.RowCount == 0) return false; return (bool)invoice.GetColumn("IsElectronic"); }
public static bool IsInvoiceEditable(int ID) { ReceiptInvoice invoice = new ReceiptInvoice(); var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectIsInvoiceEditable(ID, Settings.DisableInvoiceEditAfterStepNo); invoice.LoadFromRawSql(query); return invoice.RowCount == 0; }
public static decimal GetInvoiceQuantity(string invoiceNo, string itemId, string unitId, string manufacturerId) { ReceiptInvoice invoice = new ReceiptInvoice(); var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectGetInvoiceQuantity(invoiceNo, itemId, unitId, manufacturerId); invoice.LoadFromRawSql(query); if (invoice.RowCount == 0) return 0; return (decimal)invoice.GetColumn("Quantity"); }
public static DataView GetIncompleteInvoicesForCenter(int userID, bool isDeliveryNote) { var invoice = new ReceiptInvoice(); if (BLL.Settings.IsCenter) // If Center, Get incomplete invoices including those with FOB = 0 { var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectGetIncompleteInvoicesForCenter(userID, isDeliveryNote); invoice.LoadFromRawSql(query); } return invoice.DefaultView; }
/// <summary> /// It will return all Invoice For Now /// </summary> /// <returns></returns> public static DataView GetIncompleteInvoices(int userID, int poTypeID, int documentTypeID) { SoftwareSettings softwareSetting = new SoftwareSettings(); ReceiptInvoice Invoice = new ReceiptInvoice(); var settingDT = softwareSetting.GetValue("IsElectronicReceiveOnly"); bool isNonElectronicReceiveOnly = true; if (settingDT.Rows.Count != 0) { isNonElectronicReceiveOnly = bool.Parse(settingDT.Rows[0].Field<string>("Value").ToLower()); } var query = HCMIS.Repository.Queries.ReceiptInvoice.SelectGetIncompleteInvoices(userID, isNonElectronicReceiveOnly,poTypeID,documentTypeID); Invoice.LoadFromRawSql(query); return Invoice.DefaultView; }