private void TxtToWarehouseRef_Leave(object sender, EventArgs e) { TxtToWarehouseRef.Text = clsShop.ChangeCase(TxtToWarehouseRef.Text, 1); clsWarehouse warehouse = new clsWarehouse(0) { WarehouseRef = TxtToWarehouseRef.Text.TrimEnd() }; txtToShopName.Text = warehouse.GetWarehouseName(); }
private void txtWarehouseRef_Leave(object sender, EventArgs e) { txtWarehouseRef.Text = clsWarehouse.ChangeCase(txtWarehouseRef.Text, 1); clsWarehouse warehouse = new clsWarehouse(0) { WarehouseRef = txtWarehouseRef.Text.TrimEnd() }; txtWarehouseName.Text = warehouse.GetWarehouseName(); }
private void TxtFromWarehouseRef_Leave(object sender, EventArgs e) { TxtFromWarehouseRef.Text = clsShop.ChangeCase(TxtFromWarehouseRef.Text, 1); clsWarehouse warehouse = new clsWarehouse(0) { WarehouseRef = TxtFromWarehouseRef.Text.TrimEnd() }; txtFromShopName.Text = warehouse.GetWarehouseName(); LoadWarehouseIntoForm_ToBox(); }
private void TxtWarehouseRef_Leave(object sender, EventArgs e) { TxtWarehouseRef.Text = clsUtils.ChangeCase(TxtWarehouseRef.Text, 1); if (CheckBox1.Checked != true) { clsWarehouse warehouse = new clsWarehouse(0) { WarehouseRef = TxtWarehouseRef.Text }; TxtWarehouseName.Text = warehouse.GetWarehouseName(); } else { clsShop shop = new clsShop { ShopRef = TxtWarehouseRef.Text }; TxtWarehouseName.Text = shop.GetShopName(); } }
private void LoadData() { int ShopReturnID = Convert.ToInt32(txtReturnID.Text.TrimEnd()); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = clsUtils.GetConnString(1); conn.Open(); DataTable ShopReturnHead = new DataTable(); SqlDataAdapter ShopReturnDataAdapter = new SqlDataAdapter(); using (SqlCommand SelectCmd = new SqlCommand()) { SelectCmd.Connection = conn; SelectCmd.CommandText = "SELECT * from tblShopReturns WHERE ShopReturnsID = @ShopReturnsID"; SelectCmd.Parameters.AddWithValue("@ShopReturnsID", ShopReturnID); ShopReturnDataAdapter.SelectCommand = SelectCmd; ShopReturnDataAdapter.Fill(ShopReturnHead); } txtShopRef.Text = ShopReturnHead.Rows[0][1].ToString(); clsShop Shop = new clsShop(); Shop.ShopRef = txtShopRef.Text; txtShopName.Text = Shop.GetShopName(); txtWarehouseRef.Text = ShopReturnHead.Rows[0][2].ToString(); clsWarehouse warehouse = new clsWarehouse(0); warehouse.WarehouseRef = txtWarehouseRef.Text.TrimEnd(); txtWarehouseName.Text = warehouse.GetWarehouseName(); txtReference.Text = ShopReturnHead.Rows[0][3].ToString(); txtTotalItems.Text = ShopReturnHead.Rows[0][4].ToString(); DtpDate.Value = Convert.ToDateTime(ShopReturnHead.Rows[0][5]); oldDate = DtpDate.Value; } DgvRecords.Columns.Clear(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = clsUtils.GetConnString(1); conn.Open(); DataTable ShopReturnLine = new DataTable(); SqlDataAdapter ShopReturnLineDataAdapter = new SqlDataAdapter(); using (SqlCommand SelectCmd = new SqlCommand()) { SelectCmd.Connection = conn; SelectCmd.CommandText = "SELECT StockCode,Qty from tblShopReturnLines WHERE ShopReturnID = @ShopReturnID"; SelectCmd.Parameters.AddWithValue("@ShopReturnID", ShopReturnID); ShopReturnLineDataAdapter.SelectCommand = SelectCmd; ShopReturnLineDataAdapter.Fill(ShopReturnLine); DgvRecords.DataSource = ShopReturnLine; DgvRecords.AutoGenerateColumns = true; DgvRecords.CellBorderStyle = DataGridViewCellBorderStyle.None; DgvRecords.BackgroundColor = Color.LightCoral; DgvRecords.DefaultCellStyle.SelectionBackColor = Color.Red; DgvRecords.DefaultCellStyle.SelectionForeColor = Color.Yellow; DgvRecords.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; DgvRecords.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; DgvRecords.DefaultCellStyle.WrapMode = DataGridViewTriState.True; DgvRecords.SelectionMode = DataGridViewSelectionMode.FullRowSelect; DgvRecords.AllowUserToResizeColumns = false; DgvRecords.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; DgvRecords.RowsDefaultCellStyle.BackColor = Color.LightSkyBlue; DgvRecords.AlternatingRowsDefaultCellStyle.BackColor = Color.LightYellow; DgvRecords.Columns[0].HeaderText = "Stock Code"; DgvRecords.Columns[1].HeaderText = "Qty"; } Totals(); } }
private void LoadData() { int WarehouseAdjustID = Convert.ToInt32(TxtRecordID.Text.TrimEnd()); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = clsUtils.GetConnString(1); conn.Open(); DataTable WarehouseAdjustHead = new DataTable(); SqlDataAdapter WarehouseAdjustDataAdapter = new SqlDataAdapter(); using (SqlCommand SelectCmd = new SqlCommand()) { SelectCmd.Connection = conn; SelectCmd.CommandText = "SELECT * from tblWarehouseAdjustments WHERE WarehouseAdjustmentID = @WarehouseAdjustmentID"; SelectCmd.Parameters.AddWithValue("@WarehouseAdjustmentID", WarehouseAdjustID); WarehouseAdjustDataAdapter.SelectCommand = SelectCmd; WarehouseAdjustDataAdapter.Fill(WarehouseAdjustHead); } TxtWarehouseRef.Text = WarehouseAdjustHead.Rows[0][1].ToString(); clsWarehouse warehouse = new clsWarehouse(0); warehouse.WarehouseRef = TxtWarehouseRef.Text.TrimEnd(); TxtWarehouseName.Text = warehouse.GetWarehouseName(); TxtReference.Text = WarehouseAdjustHead.Rows[0][2].ToString(); TxtTotalGain.Text = WarehouseAdjustHead.Rows[0][4].ToString(); TxtTotalLoss.Text = WarehouseAdjustHead.Rows[0][3].ToString(); DateTimePicker1.Value = Convert.ToDateTime(WarehouseAdjustHead.Rows[0][5]); olddate = DateTimePicker1.Value; } dgvItems.Columns.Clear(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = clsUtils.GetConnString(1); conn.Open(); DataTable WarehouseAdjustLine = new DataTable(); SqlDataAdapter WarehouseAdjustLineDataAdapter = new SqlDataAdapter(); using (SqlCommand SelectCmd = new SqlCommand()) { SelectCmd.Connection = conn; SelectCmd.CommandText = "SELECT StockCode,MovementType,Qty from tblWarehouseAdjustmentsLines WHERE WarehouseAdjustmentID = @WarehouseAdjustmentID"; SelectCmd.Parameters.AddWithValue("@WarehouseAdjustmentID", WarehouseAdjustID); WarehouseAdjustLineDataAdapter.SelectCommand = SelectCmd; WarehouseAdjustLineDataAdapter.Fill(WarehouseAdjustLine); dgvItems.DataSource = WarehouseAdjustLine; dgvItems.AutoGenerateColumns = true; dgvItems.CellBorderStyle = DataGridViewCellBorderStyle.None; dgvItems.BackgroundColor = Color.LightCoral; dgvItems.DefaultCellStyle.SelectionBackColor = Color.Red; dgvItems.DefaultCellStyle.SelectionForeColor = Color.Yellow; dgvItems.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; dgvItems.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dgvItems.DefaultCellStyle.WrapMode = DataGridViewTriState.True; dgvItems.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dgvItems.AllowUserToResizeColumns = false; dgvItems.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgvItems.RowsDefaultCellStyle.BackColor = Color.LightSkyBlue; dgvItems.AlternatingRowsDefaultCellStyle.BackColor = Color.LightYellow; dgvItems.Columns[0].HeaderText = "Stock Code"; dgvItems.Columns[1].HeaderText = "Movement Type"; dgvItems.Columns[2].HeaderText = "Qty"; } } }
private void LoadData() { int WarehouseTransferID = Convert.ToInt32(TxtTransferID.Text.TrimEnd()); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = clsUtils.GetConnString(1); conn.Open(); DataTable WarehouseTransferHead = new DataTable(); SqlDataAdapter WarehouseTransferDataAdapter = new SqlDataAdapter(); using (SqlCommand SelectCmd = new SqlCommand()) { SelectCmd.Connection = conn; SelectCmd.CommandText = "SELECT * from tblWarehouseTransfers WHERE WarehouseTransferID = @WarehouseTransferID"; SelectCmd.Parameters.AddWithValue("@WarehouseTransferID", WarehouseTransferID); WarehouseTransferDataAdapter.SelectCommand = SelectCmd; WarehouseTransferDataAdapter.Fill(WarehouseTransferHead); } TxtTFNote.Text = WarehouseTransferHead.Rows[0][1].ToString(); DtpDate.Value = Convert.ToDateTime(WarehouseTransferHead.Rows[0][2]); oldDate = DtpDate.Value; TxtFromWarehouseRef.Text = WarehouseTransferHead.Rows[0][3].ToString(); clsWarehouse warehouse = new clsWarehouse(0); warehouse.WarehouseRef = TxtFromWarehouseRef.Text.TrimEnd(); txtFromShopName.Text = warehouse.GetWarehouseName(); TxtToWarehouseRef.Text = WarehouseTransferHead.Rows[0][4].ToString(); warehouse.WarehouseRef = TxtToWarehouseRef.Text.TrimEnd(); txtToShopName.Text = warehouse.GetWarehouseName(); txtTotalTransferTo.Text = WarehouseTransferHead.Rows[0][6].ToString(); } DgvRecords.Columns.Clear(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = clsUtils.GetConnString(1); conn.Open(); DataTable WarehouseAdjustLine = new DataTable(); SqlDataAdapter WarehouseAdjustLineDataAdapter = new SqlDataAdapter(); using (SqlCommand SelectCmd = new SqlCommand()) { SelectCmd.Connection = conn; SelectCmd.CommandText = "SELECT StockCode,CurrentQty,TOQty from tblWarehouseTransferLines WHERE WarehouseTransferID = @WarehouseTransferID"; SelectCmd.Parameters.AddWithValue("@WarehouseTransferID", WarehouseTransferID); WarehouseAdjustLineDataAdapter.SelectCommand = SelectCmd; WarehouseAdjustLineDataAdapter.Fill(WarehouseAdjustLine); DgvRecords.DataSource = WarehouseAdjustLine; DgvRecords.AutoGenerateColumns = true; DgvRecords.CellBorderStyle = DataGridViewCellBorderStyle.None; DgvRecords.BackgroundColor = Color.LightCoral; DgvRecords.DefaultCellStyle.SelectionBackColor = Color.Red; DgvRecords.DefaultCellStyle.SelectionForeColor = Color.Yellow; DgvRecords.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; DgvRecords.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; DgvRecords.DefaultCellStyle.WrapMode = DataGridViewTriState.True; DgvRecords.SelectionMode = DataGridViewSelectionMode.FullRowSelect; DgvRecords.AllowUserToResizeColumns = false; DgvRecords.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; DgvRecords.RowsDefaultCellStyle.BackColor = Color.LightSkyBlue; DgvRecords.AlternatingRowsDefaultCellStyle.BackColor = Color.LightYellow; DgvRecords.Columns[0].HeaderText = "Stock Code"; DgvRecords.Columns[1].HeaderText = "Current Qty"; DgvRecords.Columns[2].HeaderText = "Transfer Qty"; } } }
private void LoadData() { TxtTotalNet.Clear(); TxtCommission.Clear(); TxtDeliveryCharges.Clear(); TxtTotalOrderPrice.Clear(); DgvItems.Columns.Clear(); int PurchaseID; PurchaseID = Convert.ToInt32(TxtOrderID.Text.TrimEnd()); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = clsUtils.GetConnString(1); conn.Open(); DataTable PurchaseHead = new DataTable(); SqlDataAdapter PurchaseDataAdapter = new SqlDataAdapter(); using (SqlCommand SelectCmd = new SqlCommand()) { SelectCmd.Connection = conn; SelectCmd.CommandText = "SELECT * from tblPurchaseOrders WHERE PurchaseOrderID = @PurchaseOrderID"; SelectCmd.Parameters.AddWithValue("@PurchaseOrderID", PurchaseID); PurchaseDataAdapter.SelectCommand = SelectCmd; PurchaseDataAdapter.Fill(PurchaseHead); } TxtOurRef.Text = PurchaseHead.Rows[0][1].ToString(); TxtSupplierRef.Text = PurchaseHead.Rows[0][2].ToString(); clsSupplier supplier = new clsSupplier(); supplier.SupplierRef = TxtSupplierRef.Text; TxtSupplierName.Text = supplier.GetSupplierName(); clsWarehouse warehouse = new clsWarehouse(LoggedUser); TxtWarehouseRef.Text = PurchaseHead.Rows[0][3].ToString(); warehouse.WarehouseRef = TxtWarehouseRef.Text; TxtWarehouseName.Text = warehouse.GetWarehouseName(); CboSeasonName.Text = PurchaseHead.Rows[0][4].ToString(); TxtTotalGarments.Text = PurchaseHead.Rows[0][5].ToString(); TxtTotalBoxes.Text = PurchaseHead.Rows[0][6].ToString(); TxtTotalLooseItems.Text = PurchaseHead.Rows[0][7].ToString(); TxtTotalNet.Text = PurchaseHead.Rows[0][8].ToString(); TxtDeliveryCharges.Text = PurchaseHead.Rows[0][9].ToString(); TxtCommission.Text = PurchaseHead.Rows[0][10].ToString(); TxtVATAmount.Text = PurchaseHead.Rows[0][11].ToString(); TxtTotalOrderPrice.Text = PurchaseHead.Rows[0][12].ToString(); dateTimePicker1.Value = Convert.ToDateTime(PurchaseHead.Rows[0][13].ToString()); //deliveryType not on form [14] TxtNotes.Text = PurchaseHead.Rows[0][15].ToString(); TxtSuppliersInvoiceNumber.Text = PurchaseHead.Rows[0][16].ToString(); TxtShipperName.Text = PurchaseHead.Rows[0][17].ToString(); TxtShipperInvoiceNumber.Text = PurchaseHead.Rows[0][18].ToString(); } using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = clsUtils.GetConnString(1); conn.Open(); DataTable PurchaseLines = new DataTable(); SqlDataAdapter PurchaseLinesDA = new SqlDataAdapter(); using (SqlCommand SelectCmd = new SqlCommand()) { SelectCmd.Connection = conn; SelectCmd.CommandText = "SELECT StockCode,DeliveredQtyGarments,DeliveredQtyBoxes,DeliveredQtyHangers,LineAmount FROM tblPurchaseOrderLines WHERE PurchaseOrderID = @PurchaseOrderID"; SelectCmd.Parameters.AddWithValue("@PurchaseOrderID", PurchaseID); PurchaseLinesDA.SelectCommand = SelectCmd; PurchaseLinesDA.Fill(PurchaseLines); } DgvItems.DataSource = PurchaseLines; DgvItems.AutoGenerateColumns = true; DgvItems.CellBorderStyle = DataGridViewCellBorderStyle.None; DgvItems.BackgroundColor = Color.LightCoral; DgvItems.DefaultCellStyle.SelectionBackColor = Color.Red; DgvItems.DefaultCellStyle.SelectionForeColor = Color.Yellow; DgvItems.ColumnHeadersDefaultCellStyle.BackColor = Color.Black; DgvItems.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; DgvItems.DefaultCellStyle.WrapMode = DataGridViewTriState.True; DgvItems.SelectionMode = DataGridViewSelectionMode.FullRowSelect; DgvItems.AllowUserToResizeColumns = false; DgvItems.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; DgvItems.RowsDefaultCellStyle.BackColor = Color.LightSkyBlue; DgvItems.AlternatingRowsDefaultCellStyle.BackColor = Color.LightYellow; DgvItems.Columns[0].HeaderText = "Stock Code"; DgvItems.Columns[1].HeaderText = "Garments"; DgvItems.Columns[2].HeaderText = "Boxes"; DgvItems.Columns[3].HeaderText = "Hangers"; DgvItems.Columns[4].HeaderText = "Value"; DgvItems.Columns[4].DefaultCellStyle.Format = "C2"; } }