private static void SubmitBranchIssues(int hcmisOrderID) { var tsvc = new ServiceOrderClient(); var issuedList = new Collection <Issuance>(); BLL.OrderDetail hcmisOrderDetail = new OrderDetail(); hcmisOrderDetail.LoadOrderDetailsWithIssueAndPicklistForPLITS(hcmisOrderID); while (!hcmisOrderDetail.EOF) { var issuance = new Issuance { DateIssued = Convert.ToDateTime(hcmisOrderDetail.GetColumn("EurDate")), ApprovedOrderDetailId = Convert.ToInt32(hcmisOrderDetail.GetColumn("HACTOrderDetailID")), QuantityIssued = Convert.ToInt32(hcmisOrderDetail.GetColumn("NoOfPack")) }; issuedList.Add(issuance); hcmisOrderDetail.MoveNext(); } var validationmessage = tsvc.SubmitBranchIssues(issuedList, PlitsUserName, PlitsPassword); XtraMessageBox.Show(validationmessage[0].Message, "Issuance", MessageBoxButtons.OK); }
/// <summary> /// This function gives the previous order from the one specified in the parameter /// </summary> /// <param name="orderId">The order that gets returned is going to be the one just previous to this order.</param> /// <param name="facilityId">The facility ID</param> /// <returns></returns> public DataTable GetLastOrderDetailByFacility(int orderId, int facilityId) { var query = HCMIS.Repository.Queries.OrderDetail.SelectLastOrderDetailByFacility(orderId, facilityId); this.LoadFromRawSql(query); this.AddColumn("LastApprovedQuantity", typeof(decimal)); this.AddColumn("LastRequestedQuantity", typeof(decimal)); this.AddColumn("LastRequestedDate", typeof(DateTime)); while (!this.EOF) { var oDetail = new OrderDetail(); var querylastdetails = HCMIS.Repository.Queries.OrderDetail.SelectQueryLastDetails(this.ItemID, this.UnitID, (int)this.GetColumn("RequestedBy")); oDetail.LoadFromRawSql(querylastdetails); if (oDetail.RowCount > 0) { this.SetColumn("LastApprovedQuantity", oDetail.GetColumn("LastApprovedQuantity")); this.SetColumn("LastRequestedQuantity", oDetail.GetColumn("LastRequestedQuantity")); this.SetColumn("LastRequestedDate", oDetail.GetColumn("LastRequestedDate")); } this.MoveNext(); } return(this.DataTable); }
private bool IsApprovalValid() { //Let's see if there are rows with identical preferrence BLL.OrderDetail validatedOrder = new OrderDetail(); validatedOrder.ValidateOrderDetailForIdenticalPreference(_orderID); if (validatedOrder.RowCount > 0) { XtraMessageBox.Show( string.Format( "The item {0} has a split entries with the same preference. Please correct that to approve the order.", validatedOrder.GetColumn("FullItemName").ToString())); return(false); } return(true); }
private bool IsApprovalValid() { //Let's see if there are rows with identical preferrence BLL.OrderDetail validatedOrder = new OrderDetail(); validatedOrder.ValidateOrderDetailForIdenticalPreference(_orderID); if (validatedOrder.RowCount > 0) { XtraMessageBox.Show( string.Format( "The item {0} has a split entries with the same preference. Please correct that to approve the order.", validatedOrder.GetColumn("FullItemName").ToString())); return false; } return true; }
// Submit Branch and Facility Issues private static void SubmitFacilityIssues(int hcmisOrderID) { var tsvc = new ServiceOrderClient(); var issuedList = new Collection<Issuance>(); BLL.OrderDetail hcmisOrderDetail = new OrderDetail(); hcmisOrderDetail.LoadOrderDetailsWithIssueAndPicklistForPLITS(hcmisOrderID); while (!hcmisOrderDetail.EOF) { var issuance = new Issuance { DateIssued = Convert.ToDateTime(hcmisOrderDetail.GetColumn("EurDate")), ApprovedOrderDetailId = Convert.ToInt32(hcmisOrderDetail.GetColumn("HACTOrderDetailID")), QuantityIssued = Convert.ToInt32(hcmisOrderDetail.GetColumn("NoOfPack")) }; issuedList.Add(issuance); hcmisOrderDetail.MoveNext(); } var validationmessage = tsvc.SubmitFacilityIssues(GetBranchID(), issuedList, PlitsUserName, PlitsPassword); XtraMessageBox.Show(validationmessage[0].Message, "Issuance", MessageBoxButtons.OK); }