private void ViewTON_Load(object sender, EventArgs e)
{
TransferOutNote ton = new TransferOutNote();
dt = ton.getTON();
dataGridView1.DataSource = dt;
}
private void IssueTON_Load(object sender, EventArgs e)
{
ton = new TransferOutNote();
//Get Date
txtDate.Text = DateTime.Now.ToString();
db = new Database();
db.inserUpdateDelete("delete from tonTemp");
//Get TON ID
string id;
id = ton.getMaxId();
if (string.IsNullOrEmpty(id))
{
txtTONNo.Text = "1";
}
else
{
txtTONNo.Text = (Convert.ToInt32(id) + 1).ToString();
}
db1 = new Database();
//Fill Combo
Item item = new Item();
dt1 = item.getItemDetails();
cmbItemCode.ValueMember = "itemID";
cmbItemCode.DisplayMember = "itemCode";
cmbItemCode.DataSource = dt1;
dt2 = db1.select("select * from warehouses");
cmbDestination.DataSource = dt2;
cmbDestination.ValueMember = "location";
}
private void btnIssue_Click(object sender, EventArgs e)
{
ton = new TransferOutNote();
ton.FromLocation = txtFromLocation.Text;
ton.Destination = cmbDestination.Text;
ton.Id = Convert.ToInt32(txtTONNo.Text);
ton.addTON();
MessageBox.Show("TON added successfully!");
this.Close();
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.CurrentRow != null)
{
int selectedId = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
TransferOutNote ton = new TransferOutNote();
dt1 = ton.getTON(selectedId);
dataGridView2.DataSource = dt1;
}
}
private void ViewTON_Load(object sender, EventArgs e)
{
ton = new TransferOutNote();
dt = ton.getTON();
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].Width = 50;
dataGridView1.Columns[1].Width = 150;
dataGridView1.Columns[2].Width = 150;
dataGridView1.Columns[3].Width = 150;
dataGridView1.Columns[4].Width = 50;
}
private void btnSearch_Click(object sender, EventArgs e)
{
TransferOutNote ton = new TransferOutNote();
dt = new DataTable();
dt = ton.searchTON(txtName.Text);
if (dt.Rows.Count == 0)
{
MessageBox.Show("No data found!");
}
else
{
TONview.DataSource = dt;
}
}
private void btnRemoveTON_Click(object sender, EventArgs e)
{
TransferOutNote ton = new TransferOutNote();
int selectedTONId = Convert.ToInt32(TONview.CurrentRow.Cells[0].Value);
DialogResult dr = MessageBox.Show("Are You Sure?", "Warning!", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
ton.removeTON(selectedTONId);
MessageBox.Show("TON deleted");
dt = new DataTable();
dt = ton.getTON();
TONview.DataSource = dt;
}
txtName.Clear();
}
private void RemoveTON_Load(object sender, EventArgs e)
{
TransferOutNote ton = new TransferOutNote();
dt = new DataTable();
dt = ton.getTON();
if (dt.Rows.Count == 0)
{
MessageBox.Show("There are no Good Issue Notes Currently!");
this.Close();
}
else
{
TONview.DataSource = dt;
}
}
