public int InsertPoLineLocation(POLineLocationModel model) { model.CreationDate = DateTime.Now; model.LastUpdateDate = DateTime.Now; return(factory.POLineLocationDao.Insert(model)); }
public void Delete(POLineLocationModel model) { string sql = @"DELETE FROM po_line_locations_all WHERE line_location_id = @line_location_id"; object[] parms = { "@line_location_id", model.LineLocationId }; db.Update(sql, parms); }
private void GeneratePOLocation(IEnumerable <POReceiptLineModel> lines) { //POReceiptHeaderModel recHead = _view.headSeleted; IEnumerable <POReceiptLineModel> resultLines = lines; if (_view.headSeleted.ReceiptMethod == "RETURN") { resultLines = lines.Where(x => x.QuantityShipped < 0).ToList(); } foreach (var recLine in resultLines) { POLineLocationModel loc = new POLineLocationModel(); loc.PoHeaderId = recLine.PoHeaderId; loc.PoLineId = recLine.PoLineId; loc.Quantity = recLine.QuantityShipped; loc.QuantityReceived = recLine.QuantityShipped; loc.UnitMeasLookupCode = recLine.UnitOfMeasure; loc.InspectionRequiredFlag = recLine.QcRequireInspcFlag; loc.ReceiptHeaderId = recLine.ReceiptHeaderId; loc.ReceiptLineId = recLine.ReceiptLineId; loc.ConfirmFlag = "N"; int id = _repoPurchase.InsertPoLineLocation(loc); } //Get PO Lines to Update PO Status ***Not support multi PO in same Receive. int poId = lines.FirstOrDefault().PoHeaderId; List <POLineModel> poLines = _repoPurchase.GetPOLineByPOID(poId); var result = poLines.GroupBy(x => x.ReceivedStatus) .Select(group => new { ReceivedStatus = group.Key, Items = group.ToList() }) .ToList(); POHeaderModel po = _repoPurchase.GetPOByID(poId); if (result.Count() == 1) { if (result.FirstOrDefault().ReceivedStatus == "Fill") { po.StatusCode = "FINALLY CLOSED"; po.ReceivedFlag = true; } else { po.StatusCode = "OPEN"; po.ReceivedFlag = false; } } else { po.StatusCode = "OPEN"; po.ReceivedFlag = false; } _repoPurchase.UpdatePO(po); }
private void ConfirmPOLocation(IEnumerable <POReceiptLineModel> lines) { //POReceiptHeaderModel recHead = _view.headSeleted; foreach (var recLine in lines) { POLineLocationModel loc = _repoPurchase.GetLineLocationByPOLineID(recLine.PoLineId).Where(x => x.ReceiptLineId == recLine.ReceiptLineId).FirstOrDefault(); loc.ConfirmFlag = "Y"; _repoPurchase.UpdatePoLineLocation(loc); } }
private object[] Take(POLineLocationModel model) { return(new object[] { "@line_location_id", model.LineLocationId, "@last_update_date", model.LastUpdateDate, "@last_updated_by", model.LastUpdatedBy, "@po_header_id", model.PoHeaderId, "@po_line_id", model.PoLineId, "@creation_date", model.CreationDate, "@created_by", model.CreatedBy, "@quantity", model.Quantity, "@quantity_received", model.QuantityReceived, "@quantity_accepted", model.QuantityAccepted, "@quantity_rejected", model.QuantityRejected, "@quantity_billed", model.QuantityBilled, "@quantity_cancelled", model.QuantityCancelled, "@unit_meas_lookup_code", model.UnitMeasLookupCode, "@po_release_id", model.PoReleaseId, "@ship_to_location_id", model.ShipToLocationId, "@ship_via_lookup_code", model.ShipViaLookupCode, "@need_by_date", model.NeedByDate, "@promised_date", model.PromisedDate, "@last_accept_date", model.LastAcceptDate, "@price_override", model.PriceOverride, "@encumbered_flag", (model.EncumberedFlag) ? "Y" : "N", "@encumbered_date", model.EncumberedDate, "@unencumbered_quantity", model.UnencumberedQuantity, "@fob_lookup_code", model.FobLookupCode, "@freight_terms_lookup_code", model.FreightTermsLookupCode, "@taxable_flag", (model.TaxableFlag) ? "Y" : "N", "@tax_name", model.TaxName, "@estimated_tax_amount", model.EstimatedTaxAmount, "@inspection_required_flag", (model.InspectionRequiredFlag) ? "Y" : "N", "@receipt_required_flag", (model.ReceiptRequiredFlag) ? "Y" : "N", "@shipment_num", model.ShipmentNum, "@receipt_header_id", model.ReceiptHeaderId, "@receipt_line_id", model.ReceiptLineId, "@org_id", model.OrgId, "@tax_code_id", model.TaxCodeId, "@calculate_tax_flag", (model.CalculateTaxFlag) ? "Y" : "N", "@note_to_receiver", model.NoteToReceiver, "@amount", model.Amount, "@amount_received", model.AmountReceived, "@amount_billed", model.AmountBilled, "@amount_cancelled", model.AmountCancelled, "@amount_rejected", model.AmountRejected, "@amount_accepted", model.AmountAccepted, "@confirm_flag", model.ConfirmFlag }); }
public void Update(POLineLocationModel model) { string sql = @"UPDATE po_line_locations_all SET last_update_date = GETDATE() ,last_updated_by = @last_updated_by ,po_header_id = @po_header_id ,po_line_id = @po_line_id ,quantity = @quantity ,quantity_received = @quantity_received ,quantity_accepted = @quantity_accepted ,quantity_rejected = @quantity_rejected ,quantity_billed = @quantity_billed ,quantity_cancelled = @quantity_cancelled ,unit_meas_lookup_code = @unit_meas_lookup_code ,po_release_id = @po_release_id ,ship_to_location_id = @ship_to_location_id ,ship_via_lookup_code = @ship_via_lookup_code ,need_by_date = @need_by_date ,promised_date = @promised_date ,last_accept_date = @last_accept_date ,price_override = @price_override ,encumbered_flag = @encumbered_flag ,encumbered_date = @encumbered_date ,unencumbered_quantity = @unencumbered_quantity ,fob_lookup_code = @fob_lookup_code ,freight_terms_lookup_code = @freight_terms_lookup_code ,taxable_flag = @taxable_flag ,tax_name = @tax_name ,estimated_tax_amount = @estimated_tax_amount ,inspection_required_flag = @inspection_required_flag ,receipt_required_flag = @receipt_required_flag ,shipment_num = @shipment_num ,receipt_header_id = @receipt_header_id ,receipt_line_id = @receipt_line_id ,org_id = @org_id ,tax_code_id = @tax_code_id ,calculate_tax_flag = @calculate_tax_flag ,note_to_receiver = @note_to_receiver ,amount = @amount ,amount_received = @amount_received ,amount_billed = @amount_billed ,amount_cancelled = @amount_cancelled ,amount_rejected = @amount_rejected ,amount_accepted = @amount_accepted ,confirm_flag = @confirm_flag WHERE line_location_id = @line_location_id"; db.Update(sql, Take(model)); }
public int Insert(POLineLocationModel model) { string sql = @"INSERT INTO po_line_locations_all (last_update_date, last_updated_by, po_header_id , po_line_id, creation_date, created_by , quantity, quantity_received, quantity_accepted , quantity_rejected, quantity_billed, quantity_cancelled , unit_meas_lookup_code, po_release_id, ship_to_location_id , ship_via_lookup_code, need_by_date, promised_date , last_accept_date, price_override, encumbered_flag , encumbered_date, unencumbered_quantity, fob_lookup_code , freight_terms_lookup_code, taxable_flag, tax_name , estimated_tax_amount, inspection_required_flag, receipt_required_flag , shipment_num, receipt_header_id, receipt_line_id , org_id, tax_code_id, calculate_tax_flag , note_to_receiver, amount, amount_received , amount_billed, amount_cancelled, amount_rejected , amount_accepted, confirm_flag) VALUES (GETDATE(), @last_updated_by, @po_header_id , @po_line_id, GETDATE(), @created_by , @quantity, @quantity_received, @quantity_accepted , @quantity_rejected, @quantity_billed, @quantity_cancelled , @unit_meas_lookup_code, @po_release_id, @ship_to_location_id , @ship_via_lookup_code, @need_by_date, @promised_date , @last_accept_date, @price_override, @encumbered_flag , @encumbered_date, @unencumbered_quantity, @fob_lookup_code , @freight_terms_lookup_code, @taxable_flag, @tax_name , @estimated_tax_amount, @inspection_required_flag, @receipt_required_flag , @shipment_num, @receipt_header_id, @receipt_line_id , @org_id, @tax_code_id, @calculate_tax_flag , @note_to_receiver, @amount, @amount_received , @amount_billed, @amount_cancelled, @amount_rejected , @amount_accepted, @confirm_flag)" ; return(db.Insert(sql, Take(model))); }
public void DeletePoLineLocation(POLineLocationModel model) { factory.POLineLocationDao.Delete(model); }
public void UpdatePoLineLocation(POLineLocationModel model) { model.LastUpdateDate = DateTime.Now; factory.POLineLocationDao.Update(model); }