public RMConfirmDN(ViewDeliveryNoteMenu m, String DNId, String status)
{
InitializeComponent();
this.m = m;
this.DNId = DNId;
this.status = status;
cnn.Open();
MySqlDataAdapter sda = new MySqlDataAdapter("SELECT DN.ItemID, ItemName, ItemDescription, Quantity, Quantity as Arrived FROM DeliveryNote DN, Item I WHERE DN.ItemID=I.ItemID and DeliveryID = '" + DNId + "';", cnn);
if (status.Equals("COM") || status.Equals("DNC"))
{
btnGen.Enabled = false;
sda = new MySqlDataAdapter("SELECT DN.ItemID, ItemName, ItemDescription, Quantity, ArrivedQty as Arrived FROM DeliveryNote DN, Item I WHERE DN.ItemID=I.ItemID and DeliveryID = '" + DNId + "';", cnn);
}
DataTable dt = new DataTable();
sda.Fill(dt);
dGVItem.DataSource = dt;
MySqlDataAdapter getDNInfo = new MySqlDataAdapter("SELECT DeliveryID, dn.RequestNo, DesID, dn.CreationDate, DeliveryDate From DeliveryNote dn, PurchaseRequest pr Where dn.RequestNo=pr.RequestNo and DeliveryID = '" + DNId + "';", cnn);
DataTable DNInfo = new DataTable();
getDNInfo.Fill(DNInfo);
cnn.Close();
lbDID.Text = DNInfo.Rows[0][0].ToString();
lbRNo.Text = DNInfo.Rows[0][1].ToString();
lbDesId.Text = DNInfo.Rows[0][2].ToString();
lbCreationDate.Text = Convert.ToDateTime(DNInfo.Rows[0][3]).ToString("dd-MM-yyyy");
lbDeliveryDate.Text = Convert.ToDateTime(DNInfo.Rows[0][4]).ToString("dd-MM-yyyy");
lbStatus.Text = status;
rno = lbRNo.Text;
btnUpdate.Enabled = false;
}
public WHUpdateDN(ViewDeliveryNoteMenu m, String DNId, String status)
{
InitializeComponent();
this.m = m;
this.DNId = DNId;
this.status = status;
cnn.Open();
MySqlDataAdapter sda = new MySqlDataAdapter("SELECT DN.ItemID, ItemName, ItemDescription, Quantity as quantity, ArrivedQty as arrived FROM DeliveryNote DN, Item I WHERE DN.ItemID=I.ItemID and DeliveryID = '" + DNId + "';", cnn);
DataTable dt = new DataTable();
sda.Fill(dt);
dGVItem.DataSource = dt;
MySqlDataAdapter getDNInfo = new MySqlDataAdapter("SELECT DeliveryID, RequestNo, DesID, CreationDate From DeliveryNote Where DeliveryID = '" + DNId + "';", cnn);
DataTable DNInfo = new DataTable();
getDNInfo.Fill(DNInfo);
cnn.Close();
lbDID.Text = DNInfo.Rows[0][0].ToString();
lbRNo.Text = DNInfo.Rows[0][1].ToString();
lbDesId.Text = DNInfo.Rows[0][2].ToString();
lbCreationDate.Text = DNInfo.Rows[0][3].ToString();
lbStatus.Text = status;
rno = lbRNo.Text;
btnUpdate.Enabled = false;
Dictionary <String, String> comboSource = new Dictionary <String, String>();
comboSource.Add("1", "DLI");
comboSource.Add("2", "COM");
comboSource.Add("3", "DNC");
comboSource.Add("4", "CAN");
cbStatus.DataSource = new BindingSource(comboSource, null);
cbStatus.DisplayMember = "Value";
cbStatus.ValueMember = "Key";
MySqlDataAdapter getRest = new MySqlDataAdapter("Select RestName, RestAddress From PurchaseRequest pr, Restaurant r where RequestNo = '" + rno + "' and pr.restNo=r.restNo;", cnn);
DataTable restInfo = new DataTable();
getRest.Fill(restInfo);
lbRName.Text = restInfo.Rows[0][0].ToString();
lbAddress.AppendText(restInfo.Rows[0][1].ToString());
}
private void btn2_Click(object sender, EventArgs e)
{
switch (deptCode)
{
case "PM":
this.Hide();
PRMapping prm = new PRMapping(this);
prm.Show();
break;
case "RM":
this.Hide();
ViewDeliveryNoteMenu vDN = new ViewDeliveryNoteMenu(this, "RM", restNo);
vDN.Show();
break;
case "AD":
case "WC":
this.Hide();
ViewDeliveryNoteMenu WHvDN = new ViewDeliveryNoteMenu(this, "WC");
WHvDN.Show();
break;
case "AM":
this.Hide();
EditMenu em = new EditMenu(this, 1);
em.Show();
break;
case "CM":
this.Hide();
Item itm = new Item(this);
itm.Show();
break;
}
}