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 CmdOK_Click(object sender, EventArgs e)
{
// Saving the record to the database tblWarehouses and tblSysLog tables
// New form = Save
// old form = update
clsWarehouse objWarehouse = new clsWarehouse(UserIDs);
clsLogs logs = new clsLogs();
logs.StockCode = "NULL";
logs.SupplierRef = "NULL";
logs.LocationRef = TxtWarehouseRef.Text.TrimEnd();
logs.Qty = 0;
logs.MovementDate = DateTime.Today;
logs.UserID = UserIDs;
if (Modeform == "New")
{
logs.StringMovementType = "New Warehouse";
logs.RecordType = "New Warehouse Record";
logs.Reference = "New Waerhouse Record";
}
else
{
logs.StringMovementType = "Update Warehouse";
logs.RecordType = "Update-Item-Warehouse";
logs.Reference = "Update Warehouse Record";
}
if (Modeform == "New")
{
objWarehouse.WarehouseRef = TxtWarehouseRef.Text.TrimEnd();
objWarehouse.WarehouseName = TxtWarehouseName.Text.TrimEnd();
objWarehouse.AddressLine1 = TxtAddress1.Text.TrimEnd();
objWarehouse.AddressLine2 = TxtAddress2.Text.TrimEnd();
objWarehouse.AddressLine3 = TxtAddress3.Text.TrimEnd();
objWarehouse.AddressLine4 = TxtAddress4.Text.TrimEnd();
objWarehouse.PostCode = TxtPostCode.Text.TrimEnd();
objWarehouse.Telephone = TxtTelephone1.Text.TrimEnd();
objWarehouse.ContactName = TxtContactName.Text.TrimEnd();
objWarehouse.eMail = TxteMail.Text.TrimEnd();
objWarehouse.Fax = TxtFax.Text.TrimEnd();
objWarehouse.Memo = TxtMemo.Text.TrimEnd();
objWarehouse.WarehouseType = cboWType.Text.TrimEnd();
objWarehouse.WebsiteAddress = TxtWebsite.Text.TrimEnd();
objWarehouse.SaveWarehouseToDB();
}
else
{
objWarehouse.WarehouseRef = TxtWarehouseRef.Text.TrimEnd();
objWarehouse.WarehouseName = TxtWarehouseName.Text.TrimEnd();
objWarehouse.AddressLine1 = TxtAddress1.Text.TrimEnd();
objWarehouse.AddressLine2 = TxtAddress2.Text.TrimEnd();
objWarehouse.AddressLine3 = TxtAddress3.Text.TrimEnd();
objWarehouse.AddressLine4 = TxtAddress4.Text.TrimEnd();
objWarehouse.PostCode = TxtPostCode.Text.TrimEnd();
objWarehouse.Telephone = TxtTelephone1.Text.TrimEnd();
objWarehouse.ContactName = TxtContactName.Text.TrimEnd();
objWarehouse.eMail = TxteMail.Text.TrimEnd();
objWarehouse.Fax = TxtFax.Text.TrimEnd();
objWarehouse.Memo = TxtMemo.Text.TrimEnd();
objWarehouse.WarehouseType = cboWType.Text.TrimEnd();
objWarehouse.WebsiteAddress = TxtWebsite.Text.TrimEnd();
objWarehouse.UpdateWarehouseToDB();
}
logs.SaveToSysLogTable();
this.Close();
}
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";
}
}
