/// <summary> /// Gets the detail items. /// </summary> /// <param name="STVLogID">The STV log ID.</param> /// <returns></returns> public static DataTable GetDetailItems(int STVLogID) { var query = HCMIS.Repository.Queries.Issue.SelectGetDetailItems(STVLogID); Issue log = new Issue(); log.LoadFromRawSql(query); return log.DataTable; }
public static int GetConfirmedInvoices() { var query = HCMIS.Repository.Queries.Issue.SelectGetConfirmedInvoices(); var iss = new Issue(); iss.LoadFromRawSql(query); return Convert.ToInt32(iss.GetColumn("Value")); }
/// <summary> /// Gets the last printed ID. /// </summary> /// <param name="storeID">The store ID.</param> /// <param name="paymentTypeID">The payment type ID.</param> /// <returns></returns> public static int GetLastPrintedIDByPaymentTypeID(int activityId, int?paymentTypeId) { Issue s = new Issue(); string query = ""; query = HCMIS.Repository.Queries.Issue.SelectGetLastPrintedIDByPaymentTypeID(activityId, paymentTypeId); s.LoadFromRawSql(query); int calculatedId; try { calculatedId = int.Parse(s.GetColumn("IDPrinted").ToString()); } catch { calculatedId = 0; } int startingPointID = 0;// A provision in case the STV or invoice number is required to start from a certain number. if (calculatedId <= startingPointID && calculatedId != 0) { return(startingPointID); } else { return(calculatedId); } }
/// <summary> /// What this fixes: The code for the STVLog had put the PickLitDetailID in the table instead of the PicklistID /// </summary> public static void FixInconsistencies() { var query = HCMIS.Repository.Queries.Issue.UpdateFixInconsistencies(); BLL.Issue s = new Issue(); s.LoadFromRawSql(query); }
/// <summary> /// Gets the issue details. /// </summary> /// <param name="_stvID">The _STV ID.</param> /// <returns></returns> public static object GetIssueDetails(int _stvID) { var query = HCMIS.Repository.Queries.Issue.SelectGetIssueDetails(_stvID); BLL.Issue s = new Issue(); s.LoadFromRawSql(query); return(s.DefaultView); }
public Issue GetIssueByOrderID(int orderid) { var query = HCMIS.Repository.Queries.Issue.SelectIssueByOrderID(orderid); var iss = new Issue(); iss.LoadFromRawSql(query); return(iss); }
/// <summary> /// Gets the log for facility. /// </summary> /// <param name="storeID">The store ID.</param> /// <param name="facilityID">The facility ID.</param> /// <returns></returns> public static DataTable GetLogForFacility(int storeID, int facilityID) { var query = HCMIS.Repository.Queries.Issue.SelectGetLogForFacility(storeID, facilityID); BLL.Issue s = new Issue(); s.LoadFromRawSql(query); return(s.DataTable); }
/// <summary> /// Gets the delivery notes to be converted. /// </summary> /// <param name="storeId">The store id.</param> /// <returns></returns> public static DataTable GetDeliveryNotesToBeConverted(int storeId) { // Now ... Consider the user's previlages var query = HCMIS.Repository.Queries.Issue.SelectGetDeliveryNotesToBeConverted(storeId); Issue stvLog = new Issue(); stvLog.LoadFromRawSql(query); return stvLog.DataTable; }
public static DataRow GetVisitHistoryForFacility(string facilityname) { var query = HCMIS.Repository.Queries.Issue.SelectGetVisitHistoryForFacility(facilityname); BLL.Issue s = new Issue(); s.LoadFromRawSql(query); return(s.DataTable.Rows.Count > 0 ? s.DataTable.Rows[0] : null); }
/// <summary> /// Gets the detail items. /// </summary> /// <param name="STVLogID">The STV log ID.</param> /// <returns></returns> public static DataTable GetDetailItems(int STVLogID) { var query = HCMIS.Repository.Queries.Issue.SelectGetDetailItems(STVLogID); Issue log = new Issue(); log.LoadFromRawSql(query); return(log.DataTable); }
public static DataView GetIssueDetailByFacility(int accountId, DateTime fromdate, DateTime toDate, int facilityID) { var query = HCMIS.Repository.Queries.Issue.SelectGetIssueDetailByFacility(accountId, fromdate, toDate, facilityID); var iss = new Issue(); iss.LoadFromRawSql(query); return(iss.DefaultView); }
public static int GetConfirmedInvoices() { var query = HCMIS.Repository.Queries.Issue.SelectGetConfirmedInvoices(); var iss = new Issue(); iss.LoadFromRawSql(query); return(Convert.ToInt32(iss.GetColumn("Value"))); }
/// <summary> /// Gets the delivery notes to be converted. /// </summary> /// <param name="storeId">The store id.</param> /// <returns></returns> public static DataTable GetDeliveryNotesToBeConverted(int storeId) { // Now ... Consider the user's previlages var query = HCMIS.Repository.Queries.Issue.SelectGetDeliveryNotesToBeConverted(storeId); Issue stvLog = new Issue(); stvLog.LoadFromRawSql(query); return(stvLog.DataTable); }
public static DataTable Search(string searchString, string type) { int paymentType = (type == "Cash") ? PaymentType.Constants.CASH : (type == "Credit") ? PaymentType.Constants.CREDIT : PaymentType.Constants.STV; var query = HCMIS.Repository.Queries.Issue.SelectSearch(searchString, type, paymentType); Issue log = new Issue(); log.LoadFromRawSql(query); return(log.DataTable); }
/// <summary> /// Marks as dispatched. /// </summary> /// <param name="userID">The user ID.</param> /// <param name="prePrintedSTV">The pre printed STV.</param> /// <returns></returns> public bool MarkAsDispatched(int userID, int?prePrintedSTV) { if (!this.IsColumnNull("VoidRequest")) { if ((this.VoidRequest && this.IsColumnNull("VoidApprovedByUserID"))) //If the approver hasn't acted on the void request. { return(false); } } //Mark the NoOfPackIssued equal to the NoOfPack. Discrepancies are supposed to be saved after this function has finished running. var query = HCMIS.Repository.Queries.Issue.UpdateMarkAsDispatched(userID, this.ID); var queryConfirmIssue = HCMIS.Repository.Queries.Issue.UpdateMarkAsDispatched(this.ID); if (prePrintedSTV.HasValue) { this.PrePrintedInvoiceNo = prePrintedSTV.Value; this.Save(); } BLL.Issue s = new Issue(); s.LoadFromRawSql(query); s.LoadFromRawSql(queryConfirmIssue); BLL.IssueDoc isDoc = new IssueDoc(); isDoc.Where.STVID.Value = this.ID; isDoc.Query.Load(); if (isDoc.RowCount > 0) { int orderID = isDoc.OrderID; BLL.Order ord = new Order(); ord.LoadByPrimaryKey(orderID); if (ord.RowCount > 0) { ord.ChangeStatus(OrderStatus.Constant.DISPATCH_CONFIRMED, CurrentContext.UserId); ord.Save(); } } return(true); }
/// <summary> /// Gets the log for /// </summary> /// <param name="refNo">The ref no.</param> /// <returns></returns> public static string GetLogFor(string refNo) { Issue log = new Issue(); log.LoadFromRawSql(HCMIS.Repository.Queries.Issue.SelectGetLogFor(refNo)); if (log.RowCount == 0) { // Indicate that this is a number from the old Pick list numbering logic return("O-" + refNo); } return(log.ID.ToString("00000")); }
//public void GetTotalPrintedIssues public void SaveInvoiceChecked() { this.Rewind(); while (!this.EOF) { if (Convert.ToBoolean(this.GetColumn("IsChanged"))) { var query = HCMIS.Repository.Queries.Issue.UpdateSaveInvoiceChecked(this.IsChecked, this.ID); BLL.Issue iss = new Issue(); iss.LoadFromRawSql(query); } this.MoveNext(); } }
/// <summary> /// Gets the log for /// </summary> /// <param name="refNo">The ref no.</param> /// <returns></returns> public static string GetLogFor(string refNo) { Issue log = new Issue(); log.LoadFromRawSql(HCMIS.Repository.Queries.Issue.SelectGetLogFor(refNo)); if (log.RowCount == 0) { // Indicate that this is a number from the old Pick list numbering logic return "O-" + refNo; } return log.ID.ToString("00000"); }
/// <summary> /// What this fixes: The code for the STVLog had put the PickLitDetailID in the table instead of the PicklistID /// </summary> public static void FixInconsistencies() { var query = HCMIS.Repository.Queries.Issue.UpdateFixInconsistencies(); BLL.Issue s = new Issue(); s.LoadFromRawSql(query); }
public static DataRow GetVisitHistoryForFacility(string facilityname) { var query = HCMIS.Repository.Queries.Issue.SelectGetVisitHistoryForFacility(facilityname); BLL.Issue s = new Issue(); s.LoadFromRawSql(query); return s.DataTable.Rows.Count > 0 ? s.DataTable.Rows[0] : null; }
/// <summary> /// Gets the log for facility. /// </summary> /// <param name="storeID">The store ID.</param> /// <param name="facilityID">The facility ID.</param> /// <returns></returns> public static DataTable GetLogForFacility(int storeID, int facilityID) { var query = HCMIS.Repository.Queries.Issue.SelectGetLogForFacility(storeID, facilityID); BLL.Issue s = new Issue(); s.LoadFromRawSql(query); return s.DataTable; }
public static DataView GetIssueDetailByFacility(int accountId,DateTime fromdate,DateTime toDate,int facilityID) { var query = HCMIS.Repository.Queries.Issue.SelectGetIssueDetailByFacility(accountId, fromdate, toDate, facilityID); var iss = new Issue(); iss.LoadFromRawSql(query); return iss.DefaultView; }
//public void GetTotalPrintedIssues public void SaveInvoiceChecked() { this.Rewind(); while (!this.EOF) { if (Convert.ToBoolean(this.GetColumn("IsChanged"))) { var query = HCMIS.Repository.Queries.Issue.UpdateSaveInvoiceChecked(this.IsChecked, this.ID); BLL.Issue iss = new Issue(); iss.LoadFromRawSql(query); } this.MoveNext(); } }
/// <summary> /// Gets the last printed ID. /// </summary> /// <param name="storeID">The store ID.</param> /// <param name="paymentTypeID">The payment type ID.</param> /// <returns></returns> public static int GetLastPrintedIDByPaymentTypeID(int activityId, int? paymentTypeId) { Issue s = new Issue(); string query = ""; query = HCMIS.Repository.Queries.Issue.SelectGetLastPrintedIDByPaymentTypeID(activityId, paymentTypeId); s.LoadFromRawSql(query); int calculatedId; try { calculatedId = int.Parse(s.GetColumn("IDPrinted").ToString()); } catch { calculatedId = 0; } int startingPointID = 0;// A provision in case the STV or invoice number is required to start from a certain number. if (calculatedId <= startingPointID && calculatedId != 0) return startingPointID; else return calculatedId; }
public Issue GetIssueByOrderID(int orderid) { var query = HCMIS.Repository.Queries.Issue.SelectIssueByOrderID(orderid); var iss = new Issue(); iss.LoadFromRawSql(query); return iss; }
/// <summary> /// Marks as dispatched. /// </summary> /// <param name="userID">The user ID.</param> /// <param name="prePrintedSTV">The pre printed STV.</param> /// <returns></returns> public bool MarkAsDispatched(int userID, int? prePrintedSTV) { if (!this.IsColumnNull("VoidRequest")) { if ((this.VoidRequest && this.IsColumnNull("VoidApprovedByUserID"))) //If the approver hasn't acted on the void request. { return false; } } //Mark the NoOfPackIssued equal to the NoOfPack. Discrepancies are supposed to be saved after this function has finished running. var query = HCMIS.Repository.Queries.Issue.UpdateMarkAsDispatched(userID, this.ID); var queryConfirmIssue = HCMIS.Repository.Queries.Issue.UpdateMarkAsDispatched(this.ID); if (prePrintedSTV.HasValue) { this.PrePrintedInvoiceNo = prePrintedSTV.Value; this.Save(); } BLL.Issue s = new Issue(); s.LoadFromRawSql(query); s.LoadFromRawSql(queryConfirmIssue); BLL.IssueDoc isDoc = new IssueDoc(); isDoc.Where.STVID.Value = this.ID; isDoc.Query.Load(); if (isDoc.RowCount > 0) { int orderID = isDoc.OrderID; BLL.Order ord = new Order(); ord.LoadByPrimaryKey(orderID); if (ord.RowCount > 0) { ord.ChangeStatus(OrderStatus.Constant.DISPATCH_CONFIRMED,CurrentContext.UserId); ord.Save(); } } return true; }
/// <summary> /// Gets the issue details. /// </summary> /// <param name="_stvID">The _STV ID.</param> /// <returns></returns> public static object GetIssueDetails(int _stvID) { var query = HCMIS.Repository.Queries.Issue.SelectGetIssueDetails(_stvID); BLL.Issue s = new Issue(); s.LoadFromRawSql(query); return s.DefaultView; }
public static DataTable Search(string searchString, string type) { int paymentType = (type == "Cash") ? PaymentType.Constants.CASH : (type == "Credit") ? PaymentType.Constants.CREDIT : PaymentType.Constants.STV; var query = HCMIS.Repository.Queries.Issue.SelectSearch(searchString, type, paymentType); Issue log = new Issue(); log.LoadFromRawSql(query); return log.DataTable; }