private void releaseObject(object obj) { try { System.Runtime.InteropServices.Marshal.FinalReleaseComObject(obj); obj = null; } catch (Exception ex) { obj = null; Console.WriteLine("Exception Occurred while releasing object " + ex.ToString()); } finally { GC.Collect(); } }
private void getItems() { textBox1.Text = vanNo; textBox2.Text = category; wmsdb obj = new wmsdb(); var itemlist = (from c in obj.WMS_MSTR_DVMR join s in obj.WMS_MSTR_INVTY on c.invty_id equals s.invty_id where c.dvmr_cvan == vanNo && c.dvmr_category == category group c by new { c.invty_id, s.invty_desc, c.dvmr_category } into z select new { z.Key.invty_id, z.Key.invty_desc, z.Key.dvmr_category, tqty = z.Sum(d => d.dvmr_qty) }).OrderBy(c => new { c.invty_desc }).ToList(); dataGridView4.Rows.Clear(); int tcases = 0; if (itemlist.Count != 0) { dataGridView4.ColumnHeadersVisible = true; foreach (var row in itemlist) { tcases = tcases + row.tqty; dataGridView4.Rows.Add(row.invty_id, row.invty_desc, row.dvmr_category, row.tqty); } } else { dataGridView4.ColumnHeadersVisible = false; } textBox3.Text = tcases.ToString(); dataGridView4.ClearSelection(); }
public Incoming_Shipment() { obj = new wmsdb(); InitializeComponent(); }
public Receiving_Plan() { obj = new wmsdb(); InitializeComponent(); }
private void button1_Click(object sender, EventArgs e) { if (textBox2.Text.Trim() == "" || textBox3.Text.Trim() == "") { if (textBox2.Text.Trim() == "" && textBox3.Text.Trim() == "") { MessageBox.Show("Please provide username.", "", MessageBoxButtons.OK, MessageBoxIcon.Information); textBox2.Focus(); } else if (textBox2.Text.Trim() == "" && textBox3.Text.Trim() != "") { MessageBox.Show("Please provide username.", "", MessageBoxButtons.OK, MessageBoxIcon.Information); textBox2.Focus(); } else if (textBox2.Text.Trim() != "" && textBox3.Text.Trim() == "") { MessageBox.Show("Please provide password.", "", MessageBoxButtons.OK, MessageBoxIcon.Information); textBox3.Focus(); } } else { wmsdb obj = new wmsdb(); var cc = (from c in obj.WMS_USRS_VIEW where c.usr_username == textBox2.Text.Trim() select c.usr_username).FirstOrDefault(); if (cc != null) { var dd = (from c in obj.WMS_USRS_VIEW where c.usr_username == textBox2.Text.Trim() select new { c.usr_id, c.usr_username, c.usr_password, c.usr_fname, c.usr_lname, c.usr_type_id, c.usr_type_name }).FirstOrDefault(); if (textBox3.Text.Trim() == dd.usr_password) { loggedin_user.userId = dd.usr_id; loggedin_user.userName = dd.usr_username; loggedin_user.fistName = dd.usr_fname; loggedin_user.lastName = dd.usr_lname; loggedin_user.userTypeId = dd.usr_type_id; loggedin_user.userTypeName = dd.usr_type_name; label1.Focus(); Thread.Sleep(1); this.Hide(); textBox2.Text = ""; textBox3.Text = ""; Form xmf = Application.OpenForms["Main_Form"]; if (xmf != null) { Main_Form.GetInstance().Show(); } else { Main_Form.GetInstance().Show(); } } else { MessageBox.Show("You have entered invalid password.", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("You are not registered, Please contact administrator.", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }