private void txtWarehouseRef_Leave(object sender, EventArgs e)
{
txtWarehouseRef.Text = clsWarehouse.ChangeCase(txtWarehouseRef.Text, 1);
clsShop warehouse = new clsShop()
{
ShopRef = txtWarehouseRef.Text.TrimEnd()
};
txtWarehouseName.Text = warehouse.GetShopName();
}
private void TxtToShopRef_Leave(object sender, EventArgs e)
{
TxtToShopRef.Text = clsShop.ChangeCase(TxtToShopRef.Text, 1);
clsShop Shop = new clsShop()
{
ShopRef = TxtToShopRef.Text.TrimEnd()
};
txtToShopName.Text = Shop.GetShopName();
}
private void TxtFromShopRef_Leave(object sender, EventArgs e)
{
TxtFromShopRef.Text = clsShop.ChangeCase(TxtFromShopRef.Text, 1);
clsShop Shop = new clsShop()
{
ShopRef = TxtFromShopRef.Text.TrimEnd()
};
txtFromShopName.Text = Shop.GetShopName();
LoadShopsIntoForm_ToBox();
}
private void txtShopRef_Leave(object sender, EventArgs e)
{
txtShopRef.Text = clsShop.ChangeCase(txtShopRef.Text, 1);
clsShop Shop = new clsShop()
{
ShopRef = txtShopRef.Text.TrimEnd()
};
lblShopName.Text = Shop.GetShopName();
LoadSalesGrid();
}
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 ShopTransferID = Convert.ToInt32(TxtTransferID.Text.TrimEnd());
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = clsUtils.GetConnString(1);
conn.Open();
DataTable ShopTransferHead = new DataTable();
SqlDataAdapter ShopTransferDataAdapter = new SqlDataAdapter();
using (SqlCommand SelectCmd = new SqlCommand())
{
SelectCmd.Connection = conn;
SelectCmd.CommandText = "SELECT * from tblShopTransfers WHERE ShopTransferID = @ShopTransferID";
SelectCmd.Parameters.AddWithValue("@ShopTransferID", ShopTransferID);
ShopTransferDataAdapter.SelectCommand = SelectCmd;
ShopTransferDataAdapter.Fill(ShopTransferHead);
}
TxtTFNote.Text = ShopTransferHead.Rows[0][1].ToString();
DtpDate.Value = Convert.ToDateTime(ShopTransferHead.Rows[0][2]);
olddate = DtpDate.Value;
TxtFromShopRef.Text = ShopTransferHead.Rows[0][3].ToString();
clsShop shop = new clsShop();
shop.ShopRef = TxtFromShopRef.Text.TrimEnd();
txtFromShopName.Text = shop.GetShopName();
TxtToShopRef.Text = ShopTransferHead.Rows[0][4].ToString();
shop.ShopRef = TxtToShopRef.Text.TrimEnd();
txtToShopName.Text = shop.GetShopName();
txtTotalTransferTo.Text = ShopTransferHead.Rows[0][6].ToString();
}
DgvRecords.Columns.Clear();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = clsUtils.GetConnString(1);
conn.Open();
DataTable ShopAdjustLine = new DataTable();
SqlDataAdapter ShopAdjustLineDataAdapter = new SqlDataAdapter();
using (SqlCommand SelectCmd = new SqlCommand())
{
SelectCmd.Connection = conn;
SelectCmd.CommandText = "SELECT StockCode,CurrentQty,Qty from tblShopTranferLines WHERE ShopTransferID = @ShopTransferID";
SelectCmd.Parameters.AddWithValue("@ShopTransferID", ShopTransferID);
ShopAdjustLineDataAdapter.SelectCommand = SelectCmd;
ShopAdjustLineDataAdapter.Fill(ShopAdjustLine);
DgvRecords.DataSource = ShopAdjustLine;
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()
{
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();
}
}