private void TxtStockCode_Leave(object sender, EventArgs e)
{
TxtStockCode.Text = clsUtils.ChangeCase(TxtStockCode.Text.TrimEnd(), 1);
clsStock stock = new clsStock();
stock.StockCode = TxtStockCode.Text.TrimEnd();
if (stock.CheckStockCodeSave() != 0)
{
MessageBox.Show("Already StockCode in Database");
}
else
{
}
}
private void cmdOK_Click(object sender, EventArgs e)
{
clsPurchaseOrderHead orderHead = new clsPurchaseOrderHead(LoggedUser);
clsPurchaseOrderLine orderLine = new clsPurchaseOrderLine();
clsStock stock = new clsStock();
clsLogs logs = new clsLogs();
logs.StockCode = TxtOurRef.Text.TrimEnd();
logs.SupplierRef = TxtSupplierRef.Text.TrimEnd();
logs.LocationRef = TxtWarehouseRef.Text.TrimEnd();
logs.Qty = Convert.ToInt32(TxtTotalGarments.Text.TrimEnd());
logs.MovementDate = dateTimePicker1.Value;
logs.UserID = LoggedUser;
if (FormMode == "New")
{
logs.StringMovementType = "New Purchase Order";
logs.RecordType = "Add-New-Item-Start";
logs.Reference = "Add New Purchase Order";
}
else
{
logs.StringMovementType = "Update Purchase Order";
logs.RecordType = "Update-Item-Start";
logs.Reference = "Update Purchase Order";
}
logs.SaveToSysLogTable();
if (CheckBox1.Checked == true)
{
logs.LocationType = 2;
logs.MovementType = 3;
orderHead.DeliveryType = "Direct To Shop";
}
else
{
logs.LocationType = 1;
logs.MovementType = 1;
orderHead.DeliveryType = "Direct To Warehouse";
}
orderHead.OurRef = TxtOurRef.Text.TrimEnd();
orderHead.SupplierRef = TxtSupplierRef.Text.TrimEnd();
orderHead.WarehouseRef = TxtWarehouseRef.Text.TrimEnd();
orderHead.TotalHangers = Convert.ToInt32(TxtTotalLooseItems.Text.TrimEnd());
orderHead.TotalBoxes = Convert.ToInt32(TxtTotalBoxes.Text.TrimEnd());
orderHead.TotalGarments = Convert.ToInt32(TxtTotalGarments.Text.TrimEnd());
orderHead.NetAmount = Convert.ToDecimal(TxtTotalNet.Text.TrimEnd());
orderHead.Commission = Convert.ToDecimal(TxtCommission.Text.TrimEnd());
orderHead.DeliveryCharge = Convert.ToDecimal(TxtDeliveryCharges.Text.TrimEnd());
orderHead.VATAmount = Convert.ToDecimal(TxtVATAmount.Text.TrimEnd());
orderHead.TotalAmount = Convert.ToDecimal(TxtTotalOrderPrice.Text.TrimEnd());
orderHead.DeliveryDate = dateTimePicker1.Value;
orderHead.SupplierInvoice = TxtSuppliersInvoiceNumber.Text.TrimEnd();
orderHead.SeasonName = CboSeasonName.Text.TrimEnd();
orderHead.Notes = TxtNotes.Text.TrimEnd();
orderHead.Shipper = TxtShipperName.Text.TrimEnd();
orderHead.ShipperInvoice = TxtShipperInvoiceNumber.Text.TrimEnd();
orderHead.UserID = LoggedUser;
if (FormMode == "New")
{
orderHead.SaveToPurchaseOrderHeadtbl();
orderHead.PurchaseOrderID = orderHead.GetLastPurchaseOrderHead();
logs.TransferReference = orderHead.PurchaseOrderID;
orderLine.PurchaseOrderID = orderHead.PurchaseOrderID;
for (int i = 0; i < DgvItems.Rows.Count; i++)
{
orderLine.StockCode = DgvItems.Rows[i].Cells[0].Value.ToString();
orderLine.DeliveredQtyGarments = Convert.ToInt32(DgvItems.Rows[i].Cells[1].Value);
orderLine.DeliveredQtyBoxes = Convert.ToInt32(DgvItems.Rows[i].Cells[2].Value);
orderLine.DeliveredQtyHangers = Convert.ToInt32(DgvItems.Rows[i].Cells[3].Value);
orderLine.LineAmount = Convert.ToDecimal(DgvItems.Rows[i].Cells[4].Value);
logs.StockCode = DgvItems.Rows[i].Cells[0].Value.ToString();
logs.DeliveredQtyBoxes = Convert.ToInt32(DgvItems.Rows[i].Cells[2].Value.ToString());
logs.DeliveredQtyGarments = Convert.ToInt32(DgvItems.Rows[i].Cells[1].Value.ToString());
logs.DeliveredQtyHangers = Convert.ToInt32(DgvItems.Rows[i].Cells[3].Value.ToString());
logs.MovementValue = Convert.ToDecimal(DgvItems.Rows[i].Cells[4].Value);
logs.SaveToSysLogTable();
logs.SaveToStockMovementsTable();
if (orderLine.SaveToPurchaseOrderLinetbl() == true)
{
stock.StockCode = orderLine.StockCode;
if (stock.CheckStockCodeSave() == 0)
{
stock.StockCode = orderLine.StockCode;
stock.SupplierRef = orderHead.SupplierRef;
stock.SeasonName = orderHead.SeasonName;
stock.DeadCode = false;
stock.CostValue = orderLine.LineAmount;
stock.DeliveredQtyBoxes = orderLine.DeliveredQtyBoxes;
stock.DeliveredQtyGarments = orderLine.DeliveredQtyGarments;
stock.DeliveredQtyHangers = orderLine.DeliveredQtyHangers;
stock.AmountTaken = 0.00m;
stock.PCMarkUp = -1.00m;
stock.ZeroQty = false;
stock.UserID = LoggedUser;
stock.SaveStockCode();
}
}
else
{
}
}
}
else
{
orderHead.PurchaseOrderID = Convert.ToInt32(TxtOrderID.Text.TrimEnd());
logs.TransferReference = orderHead.PurchaseOrderID;
orderHead.UpdateToPurchaseOrderHeadtbl();
for (int i = 0; i < DgvItems.Rows.Count; i++)
{
orderLine.StockCode = DgvItems.Rows[i].Cells[0].Value.ToString();
orderLine.DeliveredQtyGarments = Convert.ToInt32(DgvItems.Rows[i].Cells[1].Value);
orderLine.DeliveredQtyBoxes = Convert.ToInt32(DgvItems.Rows[i].Cells[2].Value);
orderLine.DeliveredQtyHangers = Convert.ToInt32(DgvItems.Rows[i].Cells[3].Value);
orderLine.LineAmount = Convert.ToDecimal(DgvItems.Rows[i].Cells[4].Value);
orderLine.UpdateToPurchaseOrderLinetbl();
logs.StockCode = orderLine.StockCode;
logs.DeliveredQtyBoxes = orderLine.DeliveredQtyBoxes;
logs.DeliveredQtyGarments = orderLine.DeliveredQtyGarments;
logs.DeliveredQtyHangers = orderLine.DeliveredQtyHangers;
logs.MovementValue = orderLine.LineAmount;
logs.SaveToSysLogTable();
logs.SaveToStockMovementsTable();
}
}
logs.StockCode = TxtOurRef.Text.TrimEnd();
logs.SupplierRef = TxtSupplierRef.Text.TrimEnd();
logs.LocationRef = TxtWarehouseRef.Text.TrimEnd();
logs.Qty = Convert.ToInt32(TxtTotalGarments.Text.TrimEnd());
if (FormMode == "New")
{
logs.StringMovementType = "New Purchase Order";
logs.RecordType = "Add-New-Item-Start";
logs.Reference = "Add New Purchase Order";
}
else
{
logs.StringMovementType = "Update Purchase Order";
logs.RecordType = "Update-Item-Start";
logs.Reference = "Update Purchase Order";
}
logs.SaveToSysLogTable();
Close();
}
