private void InitializeData()
{
MonthlyStoreOutStandingInventory SOI = MSOIManager.GetMonthlySOIByKey(long.Parse(Request.QueryString["SOINumber"]));
lblCustomer.Text = SOI.CustomerName;
lblDateFrom.Text = SOI.PeriodFrom.ToString("MMMM dd, yyyy");
lblDateTo.Text = SOI.PeriodTo.ToString("MMMM dd, yyyy");
lblInventoryDate.Text = SOI.InventoryDate.ToString("MMMM dd, yyyy");
lblActualPCount.Text = SOI.ActualPhysicalCount.ToString("###,###");
lblDateDeliveriesFromQty.Text = SOI.DeliveryQtyFrom.ToString("###,###");
lblDateDeliveriesToQty.Text = SOI.DeliveryQtyTo.ToString("###,###");
lblTotalDeliveries.Text = (SOI.DeliveryQtyFrom + SOI.DeliveryQtyTo + SOI.DeliveriesMiddle).ToString("###,###");
lblSalesFromQty.Text = SOI.SalesQtyFrom.ToString("###,###");
lblSalesToQty.Text = SOI.SalesQtyTo.ToString("###,###");
lblTotalSales.Text = (SOI.SalesQtyFrom + SOI.SalesQtyTo + SOI.SalesMiddle).ToString("(###,###)");
if (SOI.DeliveriesMiddle != 0)
{
DateTime date_f = new DateTime(SOI.PeriodFrom.Year, SOI.PeriodFrom.AddMonths(1).Month, 1);
DateTime date_t = new DateTime(date_f.Year, date_f.Month, DateTime.DaysInMonth(date_f.Year, date_f.Month));
hpLinkMiddleDateDelivery.Text = date_f.ToString("MMMM dd") + "-" + date_t.ToString("dd yyyy");
lblMiddleDateSales.Text = hpLinkMiddleDateDelivery.Text;
hpLinkMiddleDateDelivery.Visible = true;
lblMiddleDateDeliveryQty.Visible = true;
lblMiddleDateDeliveryQty.Text = SOI.DeliveriesMiddle.ToString();
lblMiddleDateSalesQty.Text = SOI.SalesMiddle.ToString();
lblMiddleDateSalesQty.Visible = true;
lblMiddleDateSales.Visible = true;
}
lblPullOut.Text = SOI.PullOut.ToString("(###,###)");
if (lblPullOut.Text == "()")
{
lblPullOut.Text = "0";
}
lblAdjustmentAdd.Text = SOI.AdjustmentAdd.ToString("###,###");
lblAdjustmentLess.Text = SOI.AdjustmentLess.ToString("(###,###)");
if (lblAdjustmentLess.Text == "()")
{
lblAdjustmentLess.Text = "0";
pnlLESSAdjustment.Visible = false;
}
lblEndingInventoryAsOfQty.Text = SOI.EndingInventory.ToString("###,###");
lblPhysicalCountAsOfQty.Text = SOI.PhysicalCount.ToString("###,###");
lblOverLacking.Text = OverLackingString(SOI.OverLacking);
if (lblOverLacking.Text == "()")
{
lblOverLacking.Text = "0";
}
lblEndingInventoryAsOf.Text = "ENDING INVENTORY as of " + lblDateTo.Text;
lblPhysicalCountAsOf.Text = "PHYSICAL COUNT as of " + lblInventoryDate.Text;
DateTime PeriodFrom = DateTime.Parse(lblDateFrom.Text);
DateTime PeriodTo = DateTime.Parse(lblDateTo.Text);
DateTime PeriodFromParameter_TO = new DateTime(PeriodFrom.Year, PeriodFrom.Month, DateTime.DaysInMonth(PeriodFrom.Year, PeriodFrom.Month));
DateTime PeriodTo_FROM = new DateTime(PeriodTo.Year, PeriodTo.Month, 1);
lblActulaPCountAsOf.Text = "ACTUAL P.COUNT as of " + lblDateFrom.Text;
if ((SOI.PeriodTo.Month - SOI.PeriodFrom.Month) == 0)
{
lblDateDeliveriesFrom.Text = SOI.PeriodFrom.ToString("MMMM dd") + "-" + SOI.PeriodTo.ToString("dd yyyy");
lblDateDeliveriesTo.Visible = false;
lblDateDeliveriesToQty.Visible = false;
lblSalesTo.Visible = false;
lblSalesToQty.Visible = false;
}
else
{
lblDateDeliveriesFrom.Text = PeriodFrom.ToString("MMMM dd") + "-" +
DateTime.DaysInMonth(PeriodFrom.Year, PeriodFrom.Month).ToString()
+ "," + PeriodFrom.Year;
}
lblSalesFrom.Text = lblDateDeliveriesFrom.Text;
lblDateDeliveriesTo.Text = new DateTime(PeriodTo.Year, PeriodTo.Month, 1).ToString("MMMM dd") + "-" +
PeriodTo.Day + "," + PeriodTo.Year;
lblSalesTo.Text = lblDateDeliveriesTo.Text;
if (string.IsNullOrEmpty(lblDateDeliveriesToQty.Text))
{
lblDateDeliveriesToQty.Text = "0";
}
if (string.IsNullOrEmpty(lblDateDeliveriesFromQty.Text))
{
lblDateDeliveriesFromQty.Text = "0";
}
if (string.IsNullOrEmpty(lblSalesFromQty.Text))
{
lblSalesFromQty.Text = "0";
}
if (string.IsNullOrEmpty(lblSalesToQty.Text))
{
lblSalesToQty.Text = "0";
}
if (string.IsNullOrEmpty(lblAdjustmentAdd.Text))
{
lblAdjustmentAdd.Text = "0";
pnlADDAdjustment.Visible = false;
}
gvAdjustmentAdd.DataSource = MSOIAdjustmentmanger.GetMonthlySOIAdjustmentByCode(SOI.SOICode)[0];
gvAdjustmentAdd.DataBind();
gvAdjustmentLess.DataSource = MSOIAdjustmentmanger.GetMonthlySOIAdjustmentByCode(SOI.SOICode)[1];
gvAdjustmentLess.DataBind();
}
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");
}
