public void Delete(MonthlySOIAdjustment Adjustment) { using (DbManager db = new DbManager()) { Accessor.Query.Delete(db, Adjustment); } }
public void Save(MonthlySOIAdjustment Adjustment) { using (DbManager db = new DbManager()) { if (Adjustment.RecordNumber != 0) { Accessor.Query.Update(db, Adjustment); } else { Accessor.Query.Insert(db, Adjustment); } } }
protected void btnYes_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtMiddleDateDeliveryTotal.Text)) { txtMiddleDateDeliveryTotal.Text = "0"; } if (string.IsNullOrEmpty(txtMiddleDateSales.Text)) { txtMiddleDateSales.Text = "0"; } if (string.IsNullOrEmpty(txtSalesFrom.Text)) { txtSalesFrom.Text = "0"; } if (string.IsNullOrEmpty(txtSalesTo.Text)) { txtSalesTo.Text = "0"; } if (string.IsNullOrEmpty(txtPullOut.Text)) { txtPullOut.Text = "0"; } if (string.IsNullOrEmpty(txtAdjustmentAdd.Text)) { txtAdjustmentAdd.Text = "0"; } if (string.IsNullOrEmpty(txtAdjustmentLess.Text)) { txtAdjustmentLess.Text = "0"; } if (string.IsNullOrEmpty(txtPhysicalCountAsOf.Text)) { lblErrorText.Text = "Invalid " + lblPhysicalCountAsOf.Text + "!"; hfCustomerNumber_ModalPopupExtender.Show(); return; } MonthlyStoreOutStandingInventory MonthlySOI = new MonthlyStoreOutStandingInventory { ActualPhysicalCount = long.Parse(txtActualPCountAsOf.Text), CustomerName = txtCustomer.Text, SOICode = CreateCode(20), DeliveryQtyFrom = long.Parse(txtDateDeliveriesFrom.Text), DeliveriesMiddle = long.Parse(txtMiddleDateDeliveryTotal.Text), DeliveryQtyTo = long.Parse(txtDateDeliveriesTo.Text), EndingInventory = long.Parse(txtEndingInventoryAsOf.Text), InventoryDate = DateTime.Parse(txtInventoryDate.Text), OverLacking = OverLacking(), PeriodFrom = DateTime.Parse(txtDateFrom.Text), PeriodTo = DateTime.Parse(txtDateTo.Text), PhysicalCount = long.Parse(txtPhysicalCountAsOf.Text), PullOut = long.Parse(txtPullOut.Text), AdjustmentAdd = long.Parse(txtAdjustmentAdd.Text), AdjustmentLess = long.Parse(txtAdjustmentLess.Text), SalesQtyFrom = long.Parse(txtSalesFrom.Text), SalesMiddle = long.Parse(txtMiddleDateSales.Text), SalesQtyTo = long.Parse(txtSalesTo.Text), CustomerNumber = int.Parse(hfCustomerNumber.Value), DateRecorded = DateTime.UtcNow }; MonthlySOIManager.Save(MonthlySOI); List <MonthlySOIAdjustment> ADD_ADJUSTMENTS = new List <MonthlySOIAdjustment>(); List <MonthlySOIAdjustment> LESS_ADJUSTMENTS = new List <MonthlySOIAdjustment>(); foreach (GridViewRow row in this.gvAdjustmentAdd.Rows) { MonthlySOIAdjustment adj = new MonthlySOIAdjustment { Type = "ADD", Quantity = long.Parse(row.Cells[1].Text), DateRecorded = DateTime.UtcNow, Particular = row.Cells[0].Text, SOICode = MonthlySOI.SOICode }; ADD_ADJUSTMENTS.Add(adj); } foreach (GridViewRow row in this.gvAdjustmentLess.Rows) { MonthlySOIAdjustment adj = new MonthlySOIAdjustment { Type = "LESS", Quantity = long.Parse(row.Cells[1].Text), DateRecorded = DateTime.UtcNow, Particular = row.Cells[0].Text, SOICode = MonthlySOI.SOICode }; LESS_ADJUSTMENTS.Add(adj); } MonthlySOIAdjustmentManager.Save(ADD_ADJUSTMENTS); MonthlySOIAdjustmentManager.Save(LESS_ADJUSTMENTS); #region log MonthlySOIManager.SaveTransactionLog(Permission.PERMITTED_USER, TransactionType.INSERT); #endregion Response.Redirect("~/Accounting/MonthlySOIPanel.aspx"); }