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);
}
}
}
