public static DataTable GetOMSIncoming()
{
Utils.SetConnectionDetails();
dbConnectionSettings = Utils.DBConnection;
DataSupport oms_dh = new DataSupport("Initial Catalog=" + Utils.DBConnection["OMS"]["DBNAME"] + ";Data Source=" + Utils.DBConnection["OMS"]["SERVER"] + ";User Id = " + Utils.DBConnection["OMS"]["USERNAME"] + "; Password = "******"OMS"]["PASSWORD"]);
DataSet set = oms_dh.ExecuteDataSet(@"SELECT * FROM IncomingShipmentRequests WHERE status = 'FOR RECEIVING' AND warehouse = '" + DataSupport.GetWarehouseCode() + "' ;");
return(set.Tables[0]);
}